From mboxrd@z Thu Jan  1 00:00:00 1970
From: =?utf-8?Q?=C5=81ukasz?= Stelmach <lukasz.stelmach@iem.pw.edu.pl>
Subject: [BUG] ob-sqlite.el, -init doesn't work with some options
Date: Tue, 09 Nov 2010 20:22:46 +0100
Message-ID: <87zktigv3t.fsf@dasa3.iem.pw.edu.pl>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from [140.186.70.92] (port=54221 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1PFtmc-0004vq-7Z
	for emacs-orgmode@gnu.org; Tue, 09 Nov 2010 14:23:07 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1PFtma-0007VR-7R
	for emacs-orgmode@gnu.org; Tue, 09 Nov 2010 14:23:06 -0500
Received: from lo.gmane.org ([80.91.229.12]:43580)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1PFtma-0007V2-1S
	for emacs-orgmode@gnu.org; Tue, 09 Nov 2010 14:23:04 -0500
Received: from list by lo.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1PFtmU-0001fs-6E
	for emacs-orgmode@gnu.org; Tue, 09 Nov 2010 20:22:58 +0100
Received: from dasa3.iem.pw.edu.pl ([194.29.147.110])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Tue, 09 Nov 2010 20:22:58 +0100
Received: from lukasz.stelmach by dasa3.iem.pw.edu.pl with local (Gmexim 0.1
	(Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Tue, 09 Nov 2010 20:22:58 +0100
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/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: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

Hello.

ob-sqlite.el uses -init option to provide sqlite with a src block
content, however, this prevetns sevarl options' from taking an
effect. Particularly -header (and it's opposite), -csv and -header
Create a database, put a SELECT into a file and compare the effects of
the following commands

sqlite3 -init file.sql -header -separator ';' -csv db.sqlite

cat file.sql | sqlite3 -header -separator ';' -csv db.sqlite

A walkaround is to place desired configration commands (the onse
beginning with a dot in sqlite) in the src block, e.g:

#+BEGIN_SRC sqlite :db passwords.sqlite :results replace
.separator |
.mode csv
select * from myusers;
#+END_SRC


-- 
Miłego dnia,
Łukasz Stelmach