From mboxrd@z Thu Jan  1 00:00:00 1970
From: Nick Dokos <nicholas.dokos@hp.com>
Subject: Re: [babel] Verbatim output from SQL command
Date: Wed, 19 Oct 2011 12:47:22 -0400
Message-ID: <26980.1319042842@alphaville.dokosmarshall.org>
References: <80mxcymo6a.fsf@somewhere.org>
	<20111019162955.GB27200@client199-154.wlan.hu-berlin.de>
Reply-To: nicholas.dokos@hp.com
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([140.186.70.92]:36874)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <nick@dokosmarshall.org>) id 1RGZId-0005x1-IR
	for emacs-orgmode@gnu.org; Wed, 19 Oct 2011 12:47:28 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <nick@dokosmarshall.org>) id 1RGZIc-0007kh-Iy
	for emacs-orgmode@gnu.org; Wed, 19 Oct 2011 12:47:27 -0400
Received: from g1t0027.austin.hp.com ([15.216.28.34]:37144)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <nick@dokosmarshall.org>) id 1RGZIc-0007kQ-CV
	for emacs-orgmode@gnu.org; Wed, 19 Oct 2011 12:47:26 -0400
Received: from g1t0039.austin.hp.com (g1t0039.austin.hp.com [16.236.32.45])
	by g1t0027.austin.hp.com (Postfix) with ESMTP id 23A25380D7
	for <emacs-orgmode@gnu.org>; Wed, 19 Oct 2011 16:47:23 +0000 (UTC)
In-Reply-To: Message from Viktor Rosenfeld <listuser36@googlemail.com> of "Wed,
	19 Oct 2011 18:29:55 +0200."
	<20111019162955.GB27200@client199-154.wlan.hu-berlin.de>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org
Cc: nicholas.dokos@hp.com

Viktor Rosenfeld <listuser36@googlemail.com> wrote:

> Hi,
> 
> 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)))))
| 		    ...
`----

Nick