Re: [babel] Verbatim output from SQL command

["Sebastien Vauban" <wxhgmqzgwmuf-geNee64TY+gS+FvcfC7Uqw@public.gmane.org>]

Hi Viktor and Nick,

Nick Dokos wrote:
> Viktor Rosenfeld <listuser36-gM/Ye1E23mwN+BqQ9rBEUg@public.gmane.org> 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