From: Kaushal Modi <kaushal.modi@gmail.com>
To: emacs-org list <emacs-orgmode@gnu.org>, juneja.dushyant@gmail.com
Subject: Fwd: bug with org-babel/sqlite?
Date: Wed, 14 Sep 2016 19:00:26 +0000 [thread overview]
Message-ID: <CAFyQvY3OPxTaNa9Jyr73RSsALQLV5KfoCK=c6==Fbvs1Dz=QrQ@mail.gmail.com> (raw)
In-Reply-To: <CAJkb0UMZmHe=DJ565W-V-rSkJTgFi6B5RtcVfWK3O7oOXc8gCg@mail.gmail.com>
[-- Attachment #1.1: Type: text/plain, Size: 853 bytes --]
Hi Dushyant,
The folks following the org mailing list might be able to help you out on
this. So I am forwarding this email there.
I haven't tried recreating this as I do not use sqlite.
But when you say that in the case where you use the default :results sqlite
doesn't work, what doesn't work? Do you get an error?
---------- Forwarded message ---------
From: Dushyant Juneja <juneja.dushyant@gmail.com>
Date: Wed, Sep 14, 2016 at 10:08 AM
Subject: bug with org-babel/sqlite?
To: help-gnu-emacs@gnu.org <help-gnu-emacs@gnu.org>
Hi,
Looks like I stumbled upon a bug with org-babel and sqlite. I have the
following in my org file. PFA the bug description (bug.org). The essence is
that sqlite queries work with :results verbatim, but not otherwise. Any
ideas on how to get past this?
This is with emacs 24.5.2, RHEL6.
Dushyant
--
Kaushal Modi
[-- Attachment #1.2: Type: text/html, Size: 1404 bytes --]
[-- Attachment #2: bug.org --]
[-- Type: application/octet-stream, Size: 1623 bytes --]
#+TITLE: Bug report
#+PROPERTY: mkdirp yes
* Setup
Need to exec this first in order for sqlite src to be exec'ed.
#+BEGIN_SRC emacs-lisp :results silent
(org-babel-do-load-languages
'org-babel-load-languages
'((emacs-lisp . t)
(sh . t)
(sqlite . t)
(C . t)))
#+END_SRC
* CSV files
For a sample, I have the following CSV file:
#+BEGIN_SRC csv :tangle sample1.csv
Year,Make,Model,Description,Price
1997,Ford,E350,"ac, abs, moon",3000.00
1999,Chevy,"Venture ""Extended Edition""","",4900.00
1999,Chevy,"Venture ""Extended Edition, Very Large""",,5000.00
1996,Jeep,Grand Cherokee,"MUST SELL!
air, moon roof, loaded",4799.00
#+END_SRC
* Playing with SQL
Now stat playing with SQL.
The following snippet works fine:
#+BEGIN_SRC sqlite :db bug.db :exports results :results verbatim
DROP TABLE IF EXISTS cars;
CREATE TABLE cars (Year,Make,Model,Description,Price);
.mode csv
.separator ","
.import sample1.csv cars
SELECT * FROM cars;
#+END_SRC
#+RESULTS:
: Year,Make,Model,Description,Price
: 1997,Ford,E350,"ac, abs, moon",3000.00
: 1999,Chevy,"Venture ""Extended Edition""","",4900.00
: 1999,Chevy,"Venture ""Extended Edition, Very Large""","",5000.00
: 1996,Jeep,"Grand Cherokee","MUST SELL!
: air, moon roof, loaded",4799.00
However, the following fails, just because =:results= is set to default.
# BEGIN_SRC sqlite :db sample.db :exports results :results verbatim
#+BEGIN_SRC sqlite :db sample.db :exports results
DROP TABLE IF EXISTS cars;
CREATE TABLE cars ( Year,Make,Model,Description,Price );
select * from cars;
.mode csv
.import sample1.csv cars
SELECT * FROM cars;
#+END_SRC
next prev parent reply other threads:[~2016-09-14 19:01 UTC|newest]
Thread overview: 4+ messages / expand[flat|nested] mbox.gz Atom feed top
2016-09-14 8:48 bug with org-babel/sqlite? Dushyant Juneja
2016-09-14 19:00 ` Kaushal Modi [this message]
2016-09-14 21:16 ` Fwd: " Nick Dokos
[not found] ` <CAFyQvY34G=TSsQy-=hmB3ot-2CvpuwD66me6LemvfZaxr_8fjQ@mail.gmail.com>
2016-09-15 6:14 ` Dushyant Juneja
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to='CAFyQvY3OPxTaNa9Jyr73RSsALQLV5KfoCK=c6==Fbvs1Dz=QrQ@mail.gmail.com' \
--to=kaushal.modi@gmail.com \
--cc=emacs-orgmode@gnu.org \
--cc=juneja.dushyant@gmail.com \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.