all messages for Emacs-related lists mirrored at yhetil.org
 help / color / mirror / code / Atom feed
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

  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.