Ihor Radchenko writes:
> Andreas Gerler writes:
>
>> In the end you are still able to overwrite in your src block parameters via
>> :engine
>
> Sure, but wouldn't it be better to amend the patch adding aliases to the
> supported engine names in `sql-connection-alist'?
I considered merging and
Andreas Gerler writes:
> In the end you are still able to overwrite in your src block parameters via
> :engine
Sure, but wouldn't it be better to amend the patch adding aliases to the
supported engine names in `sql-connection-alist'?
--
Ihor Radchenko // yantar92,
Org mode contributor,
Learn
Hi Ihor,
I use only MySQL, PostgreSQL and Vertica.
However for me sql-product postgres in my sql-connection-alist works both in
ob-sql as well as SQLi.
In the end you are still able to overwrite in your src block parameters via
:engine
Andy
> On Feb 5, 2023, at 11:58 AM, Ihor Radchenko wrote:
Andreas Gerler writes:
> without the patch your org source block has to look like:
>
> #+begin_src sql :engine mysql :dbconnection mysqldb1
> SELECT * FROM nodes;
> #+end_src
>
> with that patch you can just type
>
> #+begin_src sql :dbconnection mysqldb1
> SELECT * FROM nodes;
> #+end_src
>
Hi!
and a new patch with proper commit message.
0002-lisp-ob-sql.el-sql-connection-alist-engine.patch
Description: Binary data
> On 28. Jan 2023, at 13:57, Andreas Gerler
> wrote:
>
> Hi!
>
> without the patch your org source block has to look like:
>
> #+begin_src sql :engine mysql :dbc
Hi!
without the patch your org source block has to look like:
#+begin_src sql :engine mysql :dbconnection mysqldb1
SELECT * FROM nodes;
#+end_src
with that patch you can just type
#+begin_src sql :dbconnection mysqldb1
SELECT * FROM nodes;
#+end_src
because your engine is mapped to sql-pro
Andreas Gerler writes:
> as I am still learning more elisp it took me some try and error but I can use
> the sql-product now within dbconnection.
> Using :engine still works as well.
> Still wondering if there is a more elegant way for the if clause.
Thanks for the patch!
Could you please expla
Hi!
as I am still learning more elisp it took me some try and error but I can use
the sql-product now within dbconnection.
Using :engine still works as well.
Still wondering if there is a more elegant way for the if clause.
ob-sql.el.diff
Description: Binary data
so long…
Andreas Gerler
—
