Re: LaTeXDB equivalent for ConTeXt ?

[Hans Hagen <pragma@wxs.nl>]

At 13:36 20/08/2003 +0200, you wrote:
>Hi,
>
>Is there anything like LaTeXDB:
>
><http://privat.hgesser.com/software/latexdb/>
>
>in ConTeXt?
>
>The short story is that LaTeXDB makes it possible to include SQL queries
>in a LaTeX document.

I have played with the following code:

% interface=en output=pdftex

\unprotect

\definesystemvariable{sq}

\def\startSQLquery#1#2\stopSQLquery
   {\setvalue{\??sq:#1}{#2}}

\def\applySQLquery#1% last line is quit without ;
   {\bgroup
    \def\\{\rawcharacter{`\\}}%
    \long\def\next##1;##2%
      {\ifx##2\empty
         \immediate\write\scratchwrite{##1}%
         \@EA\gobbleuntil\@EA\relax
       \else
         \immediate\write\scratchwrite{##1;}%
         \@EA\next
       \fi##2}%
    \immediate\openout\scratchwrite=\bufferprefix\jobname-sql.sql
    \@EAEAEA\next\csname\??sq:#1\endcsname\empty\empty;\empty\relax
    \immediate\closeout\scratchwrite
    \executeSQLcommand
      {\bufferprefix\jobname-sql.sql}%
      {\bufferprefix\jobname-sql.log}%
    \egroup}

\def\executeSQLcommand#1#2%
% {\executesystemcommand{c:/mysql/bin/mysql.exe < #1 > #2}}
   {\executesystemcommand{c:/mysql/bin/mysqldump.exe  -r #2 < #1}}

\protect % \endinput

\starttext

\startSQLquery{test}
   connect cod ;
%  select leerling into outfile "e:/tmp/test.tmp" from ws_p ;
%select data into outfile "e:/tmp/test.tmp"
select data from ws_p ;
   quit
\stopSQLquery

\applySQLquery{test}

\typefile{e:/tmp/test.tmp}

\stoptext

t
There have been discussions of extending the (fptex) url input file support 
with something that could talk to ports (services) ... maybe its time to 
pick up that thread.

Hans
-------------------------------------------------------------------------
                                   Hans Hagen | PRAGMA ADE | pragma@wxs.nl
                       Ridderstraat 27 | 8061 GH Hasselt | The Netherlands
  tel: +31 (0)38 477 53 69 | fax: +31 (0)38 477 53 74 | www.pragma-ade.com
-------------------------------------------------------------------------
                        information: http://www.pragma-ade.com/roadmap.pdf
                     documentation: http://www.pragma-ade.com/showcase.pdf
-------------------------------------------------------------------------