[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: ob-sql is not finding psql when using direnv+guix
From: |
Cook, Malcolm |
Subject: |
RE: ob-sql is not finding psql when using direnv+guix |
Date: |
Wed, 12 May 2021 13:49:56 +0000 |
> > >I am using Guix with direnv.
> >
> > What is your shell?
> >
>
> My shell is bash, originally I was using zsh and I thought that was the
> problem, so I switched to bash and still not working.
>
> > How/When do you "hook direnv into your shell" (https://direnv.net/)?
> >
>
> In the .profile file, at login.
>
> > > In an specific folder I am installing and using psql and postgresql using
> > > direnv+guix as follows:
> > >use guix --manifest=cdpp-manifest.scm
> > >
> > >export PGUSER=food_user
> > >export PGPASSWORD=some_password
> > >export PGDATABASE=food
> > >
> > >layout postgres
> >
> > When are you doing this?
> >
> > a) in the "specific folder"'s .envrc file?
> > b) in an org-mode shell block that you execute prior to the sql block?
> > c) ??
>
> Option (a)
>
>
> > You seem to be following [Per\-project
> > Postgres](https://jamey.thesharps.us/2019/05/29/per-project-postgres/)
> > but with guix instead of nix. Nice.
> >
>
> Yep, great post. direnv + guix change the way I develop software, do data
> science and write lectures and papers.
>
> > If you enter the directory and then call emacs, earthing should just
> > work, no changes neede.
> >
>
> It works for almost everything (sql-buffers, python buffers, etc), except for
> org-babel sql blocks.
>
> I am using EXWM, so emacs is always on.
>
>
> > If you want to tell emacs to adopt the environment established by a
> > .direnv, you probably want [direnv integration for
> > emacs\.](https://github.com/wbolster/emacs-direnv)
> >
>
> emacs-direnv was my first choice, but then I changed to envrc
> (https://github.com/purcell/envrc) . In both I got the error.
>
I see. Envrc looks superior. Good to know.
You've covered all my bases. Shooting in the dark, I would confirm/check the
following:
How do you know that envrc is working otherwise?
When you switch to a direnv controlled buffer do you get any informative
diagnostics in *Messages*?
Do you get any more if you first `(setq envrc-debug t)`?
Is this buffer in the same directory as the .direnvrc file?
Presumably TRAMP is not in the mix in any way.
Variable sql-postgres-program is unchanged from default value of psql
What is result of
m-x shell-command
which psql
and does it change as expected/required depending on the current active
.direnvrc?
What happens if you eval (getenv 'psql) while in buffer governed by direnv, or
alternatively
m-x getenv
psql
If you `m-x shell`, does normal direnv work as expected in the created shell?
> > I've got to try this!
> >
> > Cheers
> >
>
> Please tell me how that works for you
Gotta get guix rolling again. Hope to do this RSN.
Cheers,
~Malcolm
>
> Thanks
>
> - A
>
>
> > >
> > >
> > >Where cdpp-manifest.scm contains the following:
> > >
> > >(specifications->manifest
> > >'("python"
> > > "python-pandas"
> > > "python-numpy"
> > > "python-flask"
> > > "python-graphene"
> > > "postgresql"
> > > "jupyter"))
> > >
> > >I am able to use sql-mode and run queries against the database, in order
> > >to achieve that I am using the following .dir-locals.el
> > >
> > >;;; Directory Local Variables
> > >;;; For more information see (info "(emacs) Directory Variables")
> > >
> > >
> > >((nil .
> > > ((projectile-project-test-cmd . "pytest --color=no --failed-first
> > >--maxfail=5")))
> > >(python-mode .
> > > ((python-shell-buffer-name . "Python [CDPP-Inspecciones]")))
> > >
> > >(org-mode . (
> > > (indent-tabs-mode . nil)
> > > (org-src-preserve-indentation . t)
> > > (org-footnote-auto-adjust . t)
> > > (org-footnote-auto-label . t)
> > > (ispell-local-dictionary . "spanish")
> > > (org-export-allow-bind-keywords . t)
> > > (org-footnote-define-inline . nil)
> > > (org-footnote-section . "Footnotes")))
> > >
> > >(sql-mode . ((sql-connection-alist . ((mydb
> > > (sql-product 'postgres)
> > > (sql-database "mydb")
> > > (sql-user "db_user")
> > > (sql-server (expand-file-name
> > >".direnv/postgres"))
> > > (sql-port 5432)
> > > )
> > > )))))
> > >
> > >But If I try to use an sql org-babel block
> > >
> > >#+begin_src sql
> > >select 1;
> > >#+end_src
> > >
> > >(I am setting the connection variables in a PROPERTY)
> > >
> > >I get the error: `psql is not found`
> > >
> > >
> > >I was reading about the variable sql-postgres-program, so if I set the
> > >following in dir-locals.el
> > >
> > >(sql-postgres-program .
> > >"/gnu/store/f2v92bkx2vfzmkl14qxj3hlmby4dy9x0-profile/bin/psql")
> > >
> > >It works (note that psql ONLY lives inside the profile defined by
> > >direnv+guix), but I don't like the idea of hardcode the path.
> > >
> > >Is there a better way?
> > >
> > >Ideally I will expect that the org block will read it from the
> > >environment, but is not working.
> > >
> > >Thanks in advance
> > >
> >
>