From mboxrd@z Thu Jan 1 00:00:00 1970 From: Robert Klein Subject: Re: A strange problem with org-babel and SQLite Date: Sat, 1 Sep 2018 14:24:53 +0200 Message-ID: <20180901142453.312ef164@happy.intern.roklein.de> References: <20180831111725.3aeba880@lt70.mpip-mainz.mpg.de> <20180831132244.6ebcc9df@lt70.mpip-mainz.mpg.de> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:33380) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1fw56e-000699-4F for emacs-orgmode@gnu.org; Sat, 01 Sep 2018 08:34:27 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1fw4xd-0007nh-Ft for emacs-orgmode@gnu.org; Sat, 01 Sep 2018 08:25:08 -0400 Received: from mout.kundenserver.de ([212.227.126.187]:57253) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1fw4xd-0007nJ-6k for emacs-orgmode@gnu.org; Sat, 01 Sep 2018 08:25:05 -0400 Received: from happy.intern.roklein.de ([91.67.155.33]) by mrelayeu.kundenserver.de (mreue004 [212.227.15.167]) with ESMTPSA (Nemesis) id 0LkDhW-1fK0No2p3K-00c9ew for ; Sat, 01 Sep 2018 14:25:02 +0200 In-Reply-To: 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@gnu.org Sender: "Emacs-orgmode" To: emacs-orgmode@gnu.org Hi Cecil, On Sat, 1 Sep 2018 11:12:57 +0200 Cecil Westerhof wrote: > 2018-08-31 13:22 GMT+02:00 Robert Klein : >=20 > > On Fri, 31 Aug 2018 12:24:33 +0200 > > Cecil Westerhof wrote: > > =20 > > > 2018-08-31 11:17 GMT+02:00 Robert Klein : > > > =20 > > > > Hi Cecil, > > > > > > > > On Fri, 31 Aug 2018 10:47:50 +0200 > > > > Cecil Westerhof wrote: > > > > =20 > > > > > I have a strange problem with org-babel and SQLite. > > > > > > > > > > I have a database that is created with: > > > > > CREATE TABLE "quotes" ( > > > > > quoteID TEXT PRIMARY KEY, > > > > > quote TEXT NOT NULL UNIQUE, > > > > > lastUsed TEXT, > > > > > totalUsed INT DEFAULT 'unused' > > > > > ) > > > > > > > > > > When using: > > > > > #+BEGIN_SRC sqlite :db ~/Twitter/twitter.sqlite :colnames > > > > > yes SELECT lastUsed > > > > > , totalUsed > > > > > FROM quotes > > > > > ORDER BY lastused ASC > > > > > , totalUsed DESC > > > > > LIMIT 40 > > > > > #+END_SRC > > > > > > > > > > Everything is fine. But when I use (add the quote field in the > > > > > select): #+BEGIN_SRC sqlite :db > > > > > ~/Twitter/twitter.sqlite :colnames yes SELECT quote > > > > > , lastUsed > > > > > , totalUsed > > > > > FROM quotes > > > > > ORDER BY lastused ASC > > > > > , totalUsed DESC > > > > > LIMIT 40 > > > > > #+END_SRC > > > > > > > > > > I get: > > > > > executing Sqlite code block... > > > > > Wrote /tmp/babel-27920y_/ob-input-2792BTG > > > > > org-babel-read: End of file during parsing > > > > > > > > > > What could be the problem? > > > > > =20 > > > > > > > > does it work outside of org/babel/emacs, that is, when you use > > > > the query in a command line sqlite session, does it work? > > > > =E2=80=9Cquote=E2=80=9D is also a function in sqlite, so this might= be your > > > > issue.=20 > > > > > > Yes, in sqlite3 and sqlitebrowser it works without problems. > > > In org-babel even 'SELECT *' goes wrong. > > > =20 > > > > I can't reproduce the issue, it works for me. What are your > > org-mode and Emacs versions? > > =20 >=20 > GNU Emacs 25.1.1 (x86_64-pc-linux-gnu, GTK+ Version 3.22.11) of > 2017-09-15, modified by Debian > Org-mode version 8.2.10 (release_8.2.10 > @ /usr/share/emacs/25.1/lisp/org/) >=20 >=20 > > > > Can you provide an ECM (Example, complete, minimal) org-mode setup / > > Emacs initialization file? > > =20 >=20 > (add-hook 'org-babel-after-execute-hook 'bh/display-inline-images > 'append) >=20 > ; Make babel results blocks lowercase > (setq org-babel-results-keyword "results") >=20 > (defun bh/display-inline-images () > (condition-case nil > (org-display-inline-images) > (error nil))) >=20 > (org-babel-do-load-languages > (quote org-babel-load-languages) > (quote ((emacs-lisp . t) > (sqlite . t) > (dot . t) > (ditaa . t) > (R . t) > (python . t) > (ruby . t) > (gnuplot . t) > (clojure . t) > (sh . t) > (ledger . t) > (org . t) > (plantuml . t) > (latex . t)))) >=20 > ; Do not prompt to confirm evaluation > ; This may be dangerous - make sure you understand the consequences > ; of setting this -- see the docstring for details > (setq org-confirm-babel-evaluate nil) >=20 > ; Use fundamental mode when editing plantuml blocks with C-c ' > (add-to-list 'org-src-lang-modes (quote ("plantuml" . fundamental))) >=20 > Is this what you need, or do you need more? >=20 sorry, I still can't reproduce the issue, even using the same stock Emacs and org-mode from Debian 9 as you do. Could you _attach_ the emacs init file and the org-mode file which shows the issue? (so I can simply start =E2=80=9Cemacs -Q -l sqlite.emacs sqlite.org=E2=80=9D and then press C-c C-c inside the sqlite code to see the issue? Best regards Robert