From: "Eric Schulte" <schulte.eric@gmail.com>
To: yesare <email.snr@gmail.com>
Cc: emacs-orgmode@gnu.org, Bastien <bastien.guerry@wikimedia.fr>
Subject: Re: Help with Babel and using SQL
Date: Sun, 13 Feb 2011 11:21:55 -0700 [thread overview]
Message-ID: <87r5bbrdgh.fsf@gmail.com> (raw)
In-Reply-To: AANLkTimphKRetaW2C02XEoWHMZws81JQQh6KBKtQjMWy@mail.gmail.com
yesare <email.snr@gmail.com> writes:
> Thanks.
>
> I opened up ob-sql.el and read the code to see if I can figure it out.
>
> I think I have answered my first question. I wrote the following and hit
> C-c C-c and I got the result set back.
>
> #+srcname: sampsql
> #+begin_src sql :engine mysql :cmdline -h hostname -u username -pmypass -D dbname
> select * from tablename;
> #+end_src
>
Hi,
I'm happy to see that the above is now working, so you are successfully
using sql to query an external database and insert the results into an
Org-mode file as a table.
>
> regarding my 2nd question (reading orgtables), I am thinking that one can't
> read orgtables in the same way as you read a db table. But you can use an
> org table to extract data snippets to pass as variables to a sql or build a
> dynamic sql. Is my understanding correct?
>
>
> I was also experimenting on passing variables. I modified the above example
> as shown below but I did not get any results
>
> #+srcname: sampsql
> #+begin_src sql :engine mysql :cmdline -h hostname -u username -pmypass -D dbname :var table="tablename"
> select * from $table;
> #+end_src
>
A useful tool in these situations where you are not sure what a code
block will do is to call `org-babel-expand-src-block' C-c C-v v. This
will show you how the code block is expanded. When called on your
example above, I see the following
select * from tablename;
so your two previous code blocks should behave identically.
If rather, you were hoping to read a value from an Org-mode table you
will need to make some adjustments to your previous block, see my
modified example below. It is different in that...
1. I broke the header arguments out into multiple lines (for readability)
2. I don't quote the table name so the Org reads it as a reference and
not a literal string
3. when Org-mode passes tabular data to sql, it writes the data into an
external file, and then passes the name of that file into the sql
code block, so I adjusted the body of the sql code block to reflect
this behavior. Try expanding the org-mode code block below to see
the results.
#+tblname: example-table-for-sql
| a | b |
|---+----|
| 1 | 10 |
| 2 | 11 |
| 3 | 12 |
| 4 | 13 |
| 5 | 14 |
| 6 | 15 |
#+srcname: sampsql
#+headers: :var table=example-table-for-sql
#+headers: :cmdline -h hostname -u username -pmypass -D dbname
#+begin_src sql :engine mysql
load data infile "$table" into mytable;
#+end_src
Hope this is helpful. Best -- Eric
next prev parent reply other threads:[~2011-02-13 18:34 UTC|newest]
Thread overview: 6+ messages / expand[flat|nested] mbox.gz Atom feed top
2011-02-12 19:06 Help with Babel and using SQL yesare
2011-02-13 9:08 ` Bastien
2011-02-13 15:20 ` yesare
2011-02-13 18:21 ` Eric Schulte [this message]
2011-02-14 1:54 ` yesare
2011-02-13 22:08 ` Dan Davison
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
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=87r5bbrdgh.fsf@gmail.com \
--to=schulte.eric@gmail.com \
--cc=bastien.guerry@wikimedia.fr \
--cc=emacs-orgmode@gnu.org \
--cc=email.snr@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 public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).