Re: [O] [babel] Verbatim output from SQL command

[Sebastien Vauban]

Hi Viktor and Nick,

Nick Dokos wrote:
> Viktor Rosenfeld <address@hidden> wrote:
>> Sebastien Vauban wrote:
>> 
>> > #+BABEL:   :engine msosql :cmdline -S <SERVER> -U <USER> -P <PASS> -d 
>> > <DATABASE> -n -w 700
>> 
>> Where is the :engine directive documented?
>
> The only place I know of is lisp/ob-sql.el - there is support for the 
> following engines currently:
>
>
> ,----
> |                     ...
> |                     ('msosql (format "osql %s -s \"\t\" -i %s -o %s"
> |                                      (or cmdline "")
> |                                      (org-babel-process-file-name in-file)
> |                                      (org-babel-process-file-name 
> out-file)))
> |                     ('mysql (format "mysql %s < %s > %s"
> |                                     (or cmdline "")
> |                                 (org-babel-process-file-name in-file)
> |                                 (org-babel-process-file-name out-file)))
> |                 ('postgresql (format
> |                               "psql -A -P footer=off -F \"\t\"  -f %s -o %s 
> %s"
> |                                 (org-babel-process-file-name in-file)
> |                                 (org-babel-process-file-name out-file)
> |                                 (or cmdline "")))
> |                     (t (error "no support for the %s sql engine" engine)))))
> |                 ...
> `----

Nothing to add. The `engine' directive is SQL-specific.

Note that I have in mind to add such an `engine' directive to Ledger as well:
being able to let the transactions be processed by `ledger', `hledger' or
`beancount' -- the ones I know of, and which are mostly compatible between
each other.

Best regards,
  Seb

-- 
Sebastien Vauban