From mboxrd@z Thu Jan 1 00:00:00 1970 From: =?utf-8?Q?=C5=81ukasz?= Stelmach Subject: Re: [BUG] ob-sqlite.el, -init doesn't work with some options Date: Wed, 10 Nov 2010 20:45:10 +0100 Message-ID: <87y6917yk9.fsf@dasa3.iem.pw.edu.pl> References: <87zktigv3t.fsf@dasa3.iem.pw.edu.pl> <87eiaujl5k.fsf@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Return-path: Received: from [140.186.70.92] (port=34374 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1PGGbo-0004ph-LZ for emacs-orgmode@gnu.org; Wed, 10 Nov 2010 14:45:29 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1PGGbl-0005nV-Vj for emacs-orgmode@gnu.org; Wed, 10 Nov 2010 14:45:28 -0500 Received: from lo.gmane.org ([80.91.229.12]:54101) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1PGGbl-0005mx-OY for emacs-orgmode@gnu.org; Wed, 10 Nov 2010 14:45:25 -0500 Received: from list by lo.gmane.org with local (Exim 4.69) (envelope-from ) id 1PGGbj-0004zG-TX for emacs-orgmode@gnu.org; Wed, 10 Nov 2010 20:45:23 +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 ; Wed, 10 Nov 2010 20:45:23 +0100 Received: from lukasz.stelmach by dasa3.iem.pw.edu.pl with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 10 Nov 2010 20:45:23 +0100 List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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 "Eric Schulte" writes: > Łukasz Stelmach writes: > >> 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 [...] > Thanks for mentioning this issue and for posting a workaround. > > Would you suggest a different method of passing the body of a sqlite > code block to the sqlite command? The only other options which > immediately occurs to me would involve =cat='ing the body of the code > block through a pipe to the sqlite command (which would probably only > work on unix systems). I think this is the way we are supposed to do this from sqlite's point of view as -init is rather somthing like rc file that prepares the envioronment for further work. As far as cat(1) is concerned, please remember that windows is alergic and doesn't keep one, it holds =type=. IMHO the cleanest way of pushing commands to Emacs' child's stdin is =shell-command-on-region=, which should work on every OS Emacs works. -- Miłego dnia, Łukasz Stelmach