Re: database

[Hans Hagen <pragma@wxs.nl>]

[-- Attachment #1: Type: text/plain, Size: 1813 bytes --]

In addition to taco's stuff i attached what i could locate on my machine 
(last year i played a bit with mysql and storing xml and so)

Hans

>What you are asking for (MySQL I/O) cannot be done. The context
>command you refer to intended solely for syntax highlighting of
>SQL statements.
>
>However, you got me thinking. :)
>
>See attached context module and test file. It's extremely crude
>and more of a proof of concept than a full module, but it seems
>to work OK on the simple tests I threw at it. All of the commands
>and macros it provides are in the demonstration file.
>
>Stuff to keep in mind:
>
>- \write18 had better be enabled
>
>- the statement is fed to a 'mysql' in batchmode during \MySQLexecute
>
>- The result is saved to a file named \jobname-[Queryname]-result.dat
>
>- You always have to re-execute before you attempt to process the
>   the results
>
>- The 'Countexecutable' is supposed to return a single line that starts with
>   the number of lines of the \jobname-[Queryname]-result.dat file.
>
>- No error checking whatsoever is done. Spefically, nothing is done
>   about MySQL's output format, so you can expect problems with
>   embedded newlines and other specials characters
>
>The module is a joke, ok? But a fun one :-)
>
>Greetings, Taco
>
>
>On Wed, 23 Apr 2003 20:55:16 +0200, LEGUEDOIS, wrote:
>
> > but I don't know how to use this (how to use the result of the query, where
> > I write database connection's parameters...). Do you know where can I 
> find a
> > manual or any help?
>
>
>--
>groeten,
>
>Taco
>
>================================================================
>Deze e-mail is door E-mail VirusScanner van Planet Internet gecontroleerd 
>op virussen.
>Op http://www.planet.nl/evs staat een verwijzing naar de actuele lijst 
>waar op wordt gecontroleerd.
>

[-- Attachment #2: xmlvvsql.tex --]
[-- Type: text/plain, Size: 1139 bytes --]

% interface=en output=pdftex

\unprotect 

\def\??sq{@@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 

\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

[-- Attachment #3: Type: text/plain, Size: 597 bytes --]

-------------------------------------------------------------------------
                                   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
-------------------------------------------------------------------------