emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From: Sebastien Vauban
Subject: Re: [O] [babel] Verbatim output from SQL command
Date: Wed, 19 Oct 2011 19:34:45 +0200
User-agent: Gnus/5.110018 (No Gnus v0.18) Emacs/23.3 (windows-nt)

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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]