Re: TaBlE from Lua

[Daniel Lyons <fusion@storytotell.org>]

On Feb 23, 2011, at 11:35 PM, luigi scarso wrote:

> On Thu, Feb 24, 2011 at 2:45 AM, Daniel Lyons <fusion@storytotell.org> wrote:
>> 
>> On Feb 23, 2011, at 6:16 PM, Philipp Gesang wrote:
>> 
>>> On 2011-02-23 <17:07:38>, Daniel Lyons wrote:
>>>> Is there a convenient way to create TaBlE tables from Lua? If so,
>>>> where can I read about it?
>>> 
>>> Good evening, Daniel!
>>> 
>>> [-1] Isn’t TaBlE deprecated?  <http://wiki.contextgarden.net/Tables_Overview>
>> 
>> I didn't know that!
>> 
>>> [0] If you aim for convenience, wouldn’t you rather want to
>>>    switch to \[start|stop]tabulate? Its syntax is very similar
>>>    and there are a few examples to learn from in the context
>>>    source code.
>> 
>> My particular situation is a bit more involved. I want to put SQL in my ConTeXt source and have it run it against my database and format the result nicely in my document. I think I see how to do it, I just need to be able to take the parsed output and make the visually appealing table.
> Have a look at
> http://robitex.wordpress.com/2011/02/22/postgresql-gestisce-i-dati-lualatex-li-stampa/
> It's in italian & latex & postgres, but pretty clear.


This is gorgeous, and I'm sure it will come in handy, thanks! I'm glad to know I'm not alone in trying this.

My particular situation is a bit different though, I need to be able to do something along the lines of:

\startSQLinteraction
SELECT * FROM foo;
\stopSQLinteraction

and have it produce something like this (possibly):

SELECT * FROM mailinglists;
Listing 6.1

+-------------------+------------------------+
| mailing list name | email address          |
+-------------------+------------------------+
| ConTeXt           | ntg-context@ntg.nl     |
| Snap Framework    | snap@snapframework.com |
+-------------------+------------------------+
Output of Listing 6.1


My inspiration here is the Real World Haskell book, which ran the snippets in the book during rendering, ensuring both that the snippets actually work and that their output was faithful to the input. I don't mind having one connection as a constant.

— 
Daniel Lyons

___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!

maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage  : http://www.pragma-ade.nl / http://tex.aanhet.net
archive  : http://foundry.supelec.fr/projects/contextrev/
wiki     : http://contextgarden.net
___________________________________________________________________________________