From mboxrd@z Thu Jan  1 00:00:00 1970
From: Eric Schulte <schulte.eric@gmail.com>
Subject: Re: sqlite im-/export
Date: Sat, 18 May 2013 08:10:51 -0600
Message-ID: <87wqqwgyz8.fsf@gmail.com>
References: <87r4h6dfa9.fsf@kerstf.org> <87zjvuloz3.fsf@gmail.com>
	<87ip2id75m.fsf@kerstf.org> <87sj1mlkgd.fsf@gmail.com>
	<87a9nucgqf.fsf@kerstf.org> <87txm1k8ya.fsf@gmail.com>
	<874ne0x0y7.fsf@kerstf.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:50091)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <schulte.eric@gmail.com>) id 1Udhqr-0001cV-4N
	for emacs-orgmode@gnu.org; Sat, 18 May 2013 10:11:14 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <schulte.eric@gmail.com>) id 1Udhqp-0005OM-4q
	for emacs-orgmode@gnu.org; Sat, 18 May 2013 10:11:13 -0400
Received: from mail-pb0-x229.google.com ([2607:f8b0:400e:c01::229]:60256)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <schulte.eric@gmail.com>) id 1Udhqo-0005O6-Ty
	for emacs-orgmode@gnu.org; Sat, 18 May 2013 10:11:11 -0400
Received: by mail-pb0-f41.google.com with SMTP id xb12so4135532pbc.14
	for <emacs-orgmode@gnu.org>; Sat, 18 May 2013 07:11:09 -0700 (PDT)
In-Reply-To: <874ne0x0y7.fsf@kerstf.org> ("Oliver =?utf-8?B?VmXEjWVybsOt?=
	=?utf-8?B?ayIncw==?= message of "Sat, 18 May 2013 08:21:36 +0200")
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: Oliver =?utf-8?B?VmXEjWVybsOtaw==?= <ov@vecernik.at>
Cc: emacs-orgmode@gnu.org

Oliver Ve=C4=8Dern=C3=ADk <ov@vecernik.at> writes:

>> I may have missed you spelling this out in a previous email, but can you
>> not import Org tables directly into sqlite code blocks?
>>
>> Evaluate this again after evaluating the second block.
>> #+BEGIN_SRC sqlite :csv :db test.sqlite
>>   SELECT * from t1;
>> #+END_SRC
>
> This works like a charm, thanks again.
>
> But where is :csv or :db documented?  The info manual says to look at wor=
g, but
> there is no `ob-doc-sqlite' documentation link.  Are there any more
> specific arguments to sqlite?
>
> There is no `ob-doc-sh' either, but maybe there are no specific arguments
> for shell.

Sadly many of the languages are under documented.  That could be a good
thing, in that it generally takes less time to add a new language
specific header argument than it does to document one, but it is
obviously also a bad thing when header arguments aren't used because
no-one knows they exist.

In general browsing the source code of the lisp/ob-lang.el files (e.g.,
lisp/ob-sqlite.el) is the best way to find out what header arguments are
used.  For example at the top of ob-sqlite you'll find the following.

    (defvar org-babel-header-args:sqlite
      '((db        . :any)
        (header    . :any)
        (echo      . :any)
        (bail      . :any)
        (csv       . :any)
        (column    . :any)
        (html      . :any)
        (line      . :any)
        (list      . :any)
        (separator . :any)
        (nullvalue . :any))
      "Sqlite specific header args.")

In my opinion the source code of the language-specific files is
readable, but of course I'm not a good judge as I wrote most of it.  We
definitely need more volunteers to add documentation on worg.

--=20
Eric Schulte
http://cs.unm.edu/~eschulte