From: "Adolfo De Unanue" <email@example.com> To: firstname.lastname@example.org Cc: MEC@stowers.org Subject: Re: ob-sql is not finding psql when using direnv+guix Date: Tue, 11 May 2021 15:54:15 -0500 [thread overview] Message-ID: <email@example.com> (raw) In-Reply-To: <DM6PR20MB34104E23855EEEE916722E57BE549@DM6PR20MB3410.namprd20.prod.outlook.com> Dear Malcom On Mon, May 10, 2021, at 13:14, Cook, Malcolm wrote: > >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've got to try this! > > Cheers > Please tell me how that works for you 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 > > >
next prev parent reply other threads:[~2021-05-11 20:56 UTC|newest] Thread overview: 7+ messages / expand[flat|nested] mbox.gz Atom feed top 2021-05-09 8:07 Adolfo De Unanue 2021-05-10 18:14 ` Cook, Malcolm 2021-05-11 20:54 ` Adolfo De Unanue [this message] 2021-05-12 13:49 ` Cook, Malcolm 2021-05-13 17:12 ` org-babel not finding executables when using direnv [Was: Re: ob-sql is not finding psql when using direnv+guix] Adolfo De Unanue 2021-05-13 18:23 ` Cook, Malcolm 2021-05-13 22:54 ` Tim Cross
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox Avoid top-posting and favor interleaved quoting: https://en.wikipedia.org/wiki/Posting_style#Interleaved_style List information: https://www.orgmode.org/ * Reply using the --to, --cc, and --in-reply-to switches of git-send-email(1): git send-email \ --firstname.lastname@example.org \ --email@example.com \ --cc=MEC@stowers.org \ --firstname.lastname@example.org \ --subject='Re: ob-sql is not finding psql when using direnv+guix' \ /path/to/YOUR_REPLY https://kernel.org/pub/software/scm/git/docs/git-send-email.html * If your mail client supports setting the In-Reply-To header via mailto: links, try the mailto: link
Code repositories for project(s) associated with this inbox: https://git.savannah.gnu.org/cgit/emacs/org-mode.git This is a public inbox, see mirroring instructions for how to clone and mirror all data and code used for this inbox; as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).