From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Sebastien Vauban" Subject: Re: [babel] Verbatim output from SQL command Date: Wed, 19 Oct 2011 19:34:45 +0200 Message-ID: <80lisganre.fsf@somewhere.org> References: <80mxcymo6a.fsf@somewhere.org> <20111019162955.GB27200@client199-154.wlan.hu-berlin.de> <26980.1319042842@alphaville.dokosmarshall.org> Mime-Version: 1.0 Content-Type: text/plain Return-path: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org To: emacs-orgmode-mXXj517/zsQ@public.gmane.org Hi Viktor and Nick, Nick Dokos wrote: > Viktor Rosenfeld wrote: >> Sebastien Vauban wrote: >> >> > #+BABEL: :engine msosql :cmdline -S -U -P -d -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