From: "Sébastien Vauban" <wxhgmqzgwmuf-geNee64TY+gS+FvcfC7Uqw@public.gmane.org>
To: emacs-orgmode-mXXj517/zsQ@public.gmane.org
Subject: Re: [Babel] How to pass variables to SQL blocks?
Date: Wed, 01 Dec 2010 11:35:31 +0100 [thread overview]
Message-ID: <80tyixlr0s.fsf@missioncriticalit.com> (raw)
In-Reply-To: 87ipzefcga.fsf@gmail.com
Hi Eric,
"Eric Schulte" wrote:
> Sébastien Vauban <wxhgmqzgwmuf-geNee64TY+gS+FvcfC7Uqw@public.gmane.org> writes:
>
> Babel's sql support did not have any variable handling. I just copied over
> the variable support from ob-sqlite to ob-sql, so the following should now
> work (notice: my code block is different from yours)
>
> ** sql variables
> #+results: sql-param
> | table | valueTable0 |
> | column | valueColumn0 |
> | type | valueType0 |
> | nullability | valueNullability0 |
>
> I want to apply the values onto the following chunk of code:
>
> #+srcname: add-column-in-table-0
> #+begin_src sql :var table=sql-param[0,1] :var column=sql-param[1,1] :var type=sql-param[2,1] :var nullability=sql-param[3,1]
> -- add column `@column' (if column does not exist yet)
> IF NOT EXISTS (SELECT *
> FROM INFORMATION_SCHEMA.COLUMNS
> WHERE TABLE_NAME = '@table'
> AND COLUMN_NAME = '@column')
> BEGIN
> ALTER TABLE $table
> ADD $column $type @nullability
> END
> #+end_src
>
> results in the following code block expansion (C-c C-v v)
> #+begin_src sql
> -- add column `@column' (if column does not exist yet)
> IF NOT EXISTS (SELECT *
> FROM INFORMATION_SCHEMA.COLUMNS
> WHERE TABLE_NAME = '@table'
> AND COLUMN_NAME = '@column')
> BEGIN
> ALTER TABLE valueTable0
> ADD valueColumn0 valueType0 @nullability
> END
> #+end_src
For your information, this was the intended code snippet:
#+srcname: add-column-in-table-0
#+begin_src sql :var table=sql-param[0,1] :var column=sql-param[1,1] :var type=sql-param[2,1] :var nullability=sql-param[3,1] :tangle yes
-- add column `$column' (if column does not exist yet)
IF NOT EXISTS (SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = '$table'
AND COLUMN_NAME = '$column')
BEGIN
ALTER TABLE $table
ADD $column $type $nullability
END
#+end_src
(I thought this feature would be implemented using "real" SQL vars, hence my @
prefix. But viewing the code shows the replacement is made outside of the SQL
snippet's knowledge.)
Tested. Works as expected... Thanks a lot!
Maybe the following should be put on some TODO list, even if not urgent?
>> * No warning if block does not exist
>>
>> Please note that inexistent references are ignored, without further notice.
>> That's the case for such a block (where I forgot the number suffix):
>>
>> #+srcname: contains-inexistent-ref
>> #+begin_src sql :noweb yes
>> <<add-column-in-table>>
>> #+end_src
Thanks.
Best regards,
Seb
--
Sébastien Vauban
_______________________________________________
Emacs-orgmode mailing list
Please use `Reply All' to send replies to the list.
Emacs-orgmode-mXXj517/zsQ@public.gmane.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
next prev parent reply other threads:[~2010-12-01 10:35 UTC|newest]
Thread overview: 6+ messages / expand[flat|nested] mbox.gz Atom feed top
2010-11-29 16:07 [Babel] How to pass variables to SQL blocks? Sébastien Vauban
2010-12-01 2:34 ` Eric Schulte
2010-12-01 10:35 ` Sébastien Vauban [this message]
2010-12-13 19:53 ` Eric Schulte
2010-12-13 21:23 ` Sébastien Vauban
2010-12-13 22:06 ` Eric Schulte
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=80tyixlr0s.fsf@missioncriticalit.com \
--to=wxhgmqzgwmuf-genee64ty+gs+fvcfc7uqw@public.gmane.org \
--cc=emacs-orgmode-mXXj517/zsQ@public.gmane.org \
/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.