A patch for Org Babel
Org-babel allows SQL snippets to be run on a database connection that
can be specified in the source block header using parameters such as
:dbhost
, :dbuser
, :dbpassword
and so forth.
This is very useful, but I'd also like to be able to use symbolic references to connections defined elsewhere, so that for example one does not have to specify the password every time, interactively or, worse, in the .org file itself.
I am also a user of sql.el, that provides a custom variable
sql-connection-alist
, where users can define a mapping between
connection names and connection details.
The patch I submitted extends the behavior of org-babel-execute:sql
so
that it's possible to specify a new param :dbconnection
containing a
connection name, used for looking up sql-connection-alist
.