From mboxrd@z Thu Jan 1 00:00:00 1970 X-Msuck: nntp://news.gmane.io/gmane.comp.tex.context/12054 Path: main.gmane.org!not-for-mail From: Taco Hoekwater Newsgroups: gmane.comp.tex.context Subject: Re: database Date: Fri, 25 Apr 2003 12:23:52 +0200 Organization: Elvenkind Sender: ntg-context-admin@ntg.nl Message-ID: <20030425122352.587e40c5.taco@elvenkind.com> References: <21413054A555D5118C9600805FC1B17ECC0D5D@CASERV02> Reply-To: ntg-context@ntg.nl NNTP-Posting-Host: main.gmane.org Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="Multipart_Fri__25_Apr_2003_12:23:52_+0200_08307008" X-Trace: main.gmane.org 1051266359 10025 80.91.224.249 (25 Apr 2003 10:25:59 GMT) X-Complaints-To: usenet@main.gmane.org NNTP-Posting-Date: Fri, 25 Apr 2003 10:25:59 +0000 (UTC) Cc: F.LEGUEDOIS@OBERTHURCS.com Original-X-From: ntg-context-admin@ntg.nl Fri Apr 25 12:25:57 2003 Return-path: Original-Received: from ref.vet.uu.nl ([131.211.172.13] helo=ref.ntg.nl) by main.gmane.org with esmtp (Exim 3.35 #1 (Debian)) id 1990Oq-0002af-00 for ; Fri, 25 Apr 2003 12:25:48 +0200 Original-Received: from ref.ntg.nl (localhost.localdomain [127.0.0.1]) by ref.ntg.nl (Postfix) with ESMTP id 5C12F10AF1; Fri, 25 Apr 2003 12:26:46 +0200 (MEST) Original-Received: from glenfiddich.elvenkind.com (elvenknd.xs4all.nl [213.84.171.68]) by ref.ntg.nl (Postfix) with ESMTP id D9A2F10AB6 for ; Fri, 25 Apr 2003 12:23:52 +0200 (MEST) Original-Received: from glenlivet.elvenkind.com (glenlivet.elvenkind.com [10.10.0.6]) by glenfiddich.elvenkind.com (Postfix) with SMTP id 309BBB6DC; Fri, 25 Apr 2003 12:18:46 +0200 (CEST) Original-To: ntg-context@ntg.nl In-Reply-To: <21413054A555D5118C9600805FC1B17ECC0D5D@CASERV02> X-Mailer: Sylpheed version 0.8.11claws (GTK+ 1.2.10; i686-pc-linux-gnu) Errors-To: ntg-context-admin@ntg.nl X-BeenThere: ntg-context@ntg.nl X-Mailman-Version: 2.0.13 Precedence: bulk List-Help: List-Post: List-Subscribe: , List-Id: mailing list for ConTeXt users List-Unsubscribe: , List-Archive: Xref: main.gmane.org gmane.comp.tex.context:12054 X-Report-Spam: http://spam.gmane.org/gmane.comp.tex.context:12054 This is a multi-part message in MIME format. --Multipart_Fri__25_Apr_2003_12:23:52_+0200_08307008 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hi, 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 --Multipart_Fri__25_Apr_2003_12:23:52_+0200_08307008 Content-Type: application/octet-stream; name="t-mysql.tex" Content-Disposition: attachment; filename="t-mysql.tex" Content-Transfer-Encoding: base64 JUQgXG1vZHVsZQolRCAgIFsgICAgICAgZmlsZT10LW15c3FsLAolRCAgICAgICAgdmVyc2lvbj0y MDAzLjA0LjI1LAolRCAgICAgICAgICB0aXRsZT1cQ09OVEVYVFwgQ29udHJpYiBtYWNyb3MsCiVE ICAgICAgIHN1YnRpdGxlPU15U1FMIEkvTyAoYWxmYSksCiVEICAgICAgICAgYXV0aG9yPVRhY28g SG9la3dhdGVyLAolRCAgICAgICAgICAgZGF0ZT1cY3VycmVudGRhdGUsCiVEICAgICAgY29weXJp Z2h0PXtUYWNvIEhvZWt3YXRlcn1dCgoKXGRlZlxzZXR1cE15U1FMIzFbIzJdeyUKICBcZ2V0cGFy YW1ldGVyc1tNeV1bSG9zdD0sRGF0YWJhc2U9LFVzZXI9LFBhc3N3b3JkPSxFeGVjdXRhYmxlPW15 c3FsLENvdW50ZXhlY3V0YWJsZT13YywjMl0lCn0KClxsb25nXGRlZlxzdGFydE15U1FMIzFbIzJd IzNcc3RvcE15U1FMe1xzZXR4dmFsdWV7TXlTUUxxdWVyeSMyfXsjM319CgpcbmV3cmVhZFxNeVNR THJlYWQKXG5ld2NvdW50XE15U1FMc2NyYXRjaGNvdW50ZXIKXG5ld2JveFxNeVNRTHNjcmF0Y2hi b3gKClxsb25nXGRlZlxNeVNRTGdldHJvd3MjMVxyZWxheHslCiAgXGdsb2JhbFxNeVNRTHNjcmF0 Y2hjb3VudGVyPTAgCiAgXHNldGJveFxNeVNRTHNjcmF0Y2hib3hcaGJveHtcZ2xvYmFsXE15U1FM c2NyYXRjaGNvdW50ZXIjMX0lCn0KClxkZWZcZXhlY3V0ZU15U1FMWyMxXXslCiAgICAgICAgXGlm eFxNeVBhc3N3b3JkXGVtcHR5IFxkZWZcTXlQYXN7IH0gXGVsc2UgXGVkZWZcTXlQYXN7XHNwYWNl LXBcTXlQYXNzd29yZCBcc3BhY2V9XGZpCiAgICAgICAgXGlmeFxNeUhvc3QgICAgXGVtcHR5IFxk ZWZcTXlIb3N7IH0gXGVsc2UgXGVkZWZcTXlIb3N7XHNwYWNlLWhcTXlIb3N0ICAgICBcc3BhY2V9 XGZpCiAgICAgICAgXGlmeFxNeVVzZXIgICAgXGVtcHR5IFxkZWZcTXlVc2V7IH0gXGVsc2UgXGVk ZWZcTXlVc2V7XHNwYWNlLXVcTXlVc2VyICAgICBcc3BhY2V9XGZpCiAgICAgICAgXGltbWVkaWF0 ZSBcd3JpdGUxOHtcTXlFeGVjdXRhYmxlXHNwYWNlLWUnXGdldHZhbHVle015U1FMcXVlcnkjMX0n CiAgICAgICAgICAgICAgICAgICAgICAgICAgICBcTXlIb3NcTXlVc2VcTXlQYXNcTXlEYXRhYmFz ZVxzcGFjZSA+IFxqb2JuYW1lLSMxLXJlc3VsdC5kYXR9JQogICAgICAgIFxpbW1lZGlhdGUgXHdy aXRlMTh7XE15Q291bnRleGVjdXRhYmxlXHNwYWNlCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICBcam9ibmFtZS0jMS1yZXN1bHQuZGF0ID4gXGpvYm5hbWUtIzEtcmVzdWx0LXJvd3MuZGF0fSUK ICAgICAgICBcaW1tZWRpYXRlXG9wZW5pblxNeVNRTHJlYWQ9IFxqb2JuYW1lLSMxLXJlc3VsdC1y b3dzLmRhdAogICAgICAgIFxkZWZcbXltYWN7fSUKICAgICAgICBccmVhZFxNeVNRTHJlYWQgdG8g XG15bWFjCiAgICAgICAgXGV4cGFuZGFmdGVyXE15U1FMZ2V0cm93c1xteW1hY1xyZWxheAogICAg ICAgIFxhZHZhbmNlXE15U1FMc2NyYXRjaGNvdW50ZXIgLSAxICUgZm9yIGNvbHVtbiBoZWFkZXJz CiAgICAgICAgXHNldHh2YWx1ZXtNeVNRTHJvd3MjMX17XHRoZVxNeVNRTHNjcmF0Y2hjb3VudGVy fSUKICAgICAgICBcaW1tZWRpYXRlXGNsb3NlaW5cTXlTUUxyZWFkCiAgICAgICAgXGltbWVkaWF0 ZVxvcGVuaW5cTXlTUUxyZWFkPSBcam9ibmFtZS0jMS1yZXN1bHQuZGF0CiAgICAgICAgXHJlYWRc TXlTUUxyZWFkIHRvIFxteW1hYwogICAgICAgIFxleHBhbmRhZnRlclxwcm9jZXNzTXlTUUxmaXJz dGxpbmVcbXltYWNccmVsYXgKCVxzZXR4dmFsdWV7TXlTUUxjb2xzIzF9e1x0aGVcTXlTUUxzY3Jh dGNoY291bnRlcn0lICAgICAgICAKCVxzZXR4dmFsdWV7TXlTUUxjdXJyZW50fXsjMX0lCn0KClxn ZGVmXHByb2Nlc3NNeVNRTGZpcnN0bGluZSMxXHJlbGF4eyUKXE15U1FMc2NyYXRjaGNvdW50ZXI9 MApcZG9wcm9jZXNzTXlTUUxmaXJzdGxpbmUjMV5eSSVub3RlIHRoZSB0cmFpbGluZyBcdApcYWR2 YW5jZVxNeVNRTHNjcmF0Y2hjb3VudGVyLTEKfQoKXGxvbmdcZ2RlZlxkb3Byb2Nlc3NNeVNRTGZp cnN0bGluZSMxXl5JeyUKIFxhZHZhbmNlXE15U1FMc2NyYXRjaGNvdW50ZXIgMQogXHhkZWZcd2hh dGV2ZXJ7IzF9JQogXGlmeFx3aGF0ZXZlclxlbXB0eQogICAgXGxldFxuZXh0XHJlbGF4CiBcZWxz ZQogICAgXHNldHh2YWx1ZXtNeVNRTGNvbHVtbm5hbWVcdGhlXE15U1FMc2NyYXRjaGNvdW50ZXJ9 eyMxfSUKICAgIFxsZXRcbmV4dFxkb3Byb2Nlc3NNeVNRTGZpcnN0bGluZQogXGZpIAogXG5leHQK fQoKe1xjYXRjb2RlYFxeXkk9MTIKXGdkZWZccHJvY2Vzc015U1FMbGluZSMxXHJlbGF4eyUKIFxN eVNRTHNjcmF0Y2hjb3VudGVyPTAKIFxkZWZcY3VycmVudE15U1FMbGlzdHt9JQogXGNhdGNvZGVg XF5eST0xMgogXGRvcHJvY2Vzc015U1FMbGluZSMxXl5JJW5vdGUgdGhlIHRyYWlsaW5nIFx0CiAl Cn0KClxsb25nXGdkZWZcZG9wcm9jZXNzTXlTUUxsaW5lIzFeXkl7JQogXGFkdmFuY2VcTXlTUUxz Y3JhdGNoY291bnRlciAxCiBceGRlZlx3aGF0ZXZlcnsjMX0lCiBcaWZudW1cTXlTUUxzY3JhdGNo Y291bnRlcj1cTXlTUUxjb2xjb3VudAogICAgXGxldFxuZXh0XHJlbGF4CiBcZWxzZQogICBcbGV0 XG5leHRcZG9wcm9jZXNzTXlTUUxsaW5lCiBcZmkgIAogXGlmeFxjdXJyZW50TXlTUUxsaXN0XGVt cHR5CiAgIFxlZGVmXGN1cnJlbnRNeVNRTGxpc3R7XGdldHZhbHVle015U1FMY29sdW1ubmFtZVx0 aGVcTXlTUUxzY3JhdGNoY291bnRlcn09eyMxfX0lCiBcZWxzZQogICBcZWRlZlxjdXJyZW50TXlT UUxsaXN0e1xjdXJyZW50TXlTUUxsaXN0LFxnZXR2YWx1ZXtNeVNRTGNvbHVtbm5hbWVcdGhlXE15 U1FMc2NyYXRjaGNvdW50ZXJ9PXsjMX19JQogXGZpCiBcbmV4dAp9CgpcZ2RlZlxwcm9jZXNzTXlT UUxsaW5lc2ltcGxlIzFccmVsYXh7JQogXE15U1FMc2NyYXRjaGNvdW50ZXI9MAogXGRlZlxjdXJy ZW50TXlTUUxsaXN0e30lCiBcY2F0Y29kZWBcXl5JPTEyCiBcZG9wcm9jZXNzTXlTUUxsaW5lc2lt cGxlIzFeXkklbm90ZSB0aGUgdHJhaWxpbmcgXHQKICUKfQoKXGxvbmdcZ2RlZlxkb3Byb2Nlc3NN eVNRTGxpbmVzaW1wbGUjMV5eSXslCiBcYWR2YW5jZVxNeVNRTHNjcmF0Y2hjb3VudGVyIDEKIFx4 ZGVmXHdoYXRldmVyeyMxfSUKIFxpZm51bVxNeVNRTHNjcmF0Y2hjb3VudGVyPVxNeVNRTGNvbGNv dW50CiAgICBcbGV0XG5leHRccmVsYXgKIFxlbHNlCiAgIFxsZXRcbmV4dFxkb3Byb2Nlc3NNeVNR TGxpbmVzaW1wbGUKIFxmaSAgCiBcaWZ4XGN1cnJlbnRNeVNRTGxpc3RcZW1wdHkKICAgXGVkZWZc Y3VycmVudE15U1FMbGlzdHt7IzF9fSUKIFxlbHNlCiAgIFxlZGVmXGN1cnJlbnRNeVNRTGxpc3R7 XGN1cnJlbnRNeVNRTGxpc3QseyMxfX0lCiBcZmkKIFxuZXh0Cn0KCiVcZ2RlZlxmZXRjaE15U1FM YXJyYXkjMVsjMl0jM3slCiVcY2F0Y29kZWBcXl5JPTEyCiVcZWRlZlxNeVNRTGNvbGNvdW50e1xn ZXR2YWx1ZXtNeVNRTGNvbHMjMn19JQolXHJlYWRcTXlTUUxyZWFkIHRvIFxteW1hYwolXGV4cGFu ZGFmdGVyXHByb2Nlc3NNeVNRTGxpbmVzaW1wbGVcbXltYWNccmVsYXgKJVxsZXQjM1xjdXJyZW50 TXlTUUxsaXN0CiVcY2F0Y29kZWBcXl5JPTEwIH0KXGdkZWZcZmV0Y2hNeVNRTGFycmF5IzF7JQpc Y2F0Y29kZWBcXl5JPTEyClxlZGVmXE15U1FMY29sY291bnR7XGdldHZhbHVle015U1FMY29sc1xN eVNRTGN1cnJlbnR9fSUKXGJncm91cCBcZW5kbGluZWNoYXIgPSAtMVxkZWZcdHsgfVxkZWZcbnsg fVxnbG9iYWxccmVhZFxNeVNRTHJlYWQgdG8gXG15bWFjClxleHBhbmRhZnRlclxwcm9jZXNzTXlT UUxsaW5lc2ltcGxlXG15bWFjXHJlbGF4ClxnbG9iYWxcbGV0IzFcY3VycmVudE15U1FMbGlzdCBc ZWdyb3VwClxjYXRjb2RlYFxeXkk9MTAgfQoKXGdkZWZcZmV0Y2hNeVNRTGhhc2gjMXslClxjYXRj b2RlYFxeXkk9MTIKXGVkZWZcTXlTUUxjb2xjb3VudHtcZ2V0dmFsdWV7TXlTUUxjb2xzXE15U1FM Y3VycmVudH19JQpcYmdyb3VwIFxlbmRsaW5lY2hhciA9IC0xXGRlZlx0eyB9XGRlZlxueyB9XGds b2JhbFxyZWFkXE15U1FMcmVhZCB0byBcbXltYWMKXGV4cGFuZGFmdGVyXHByb2Nlc3NNeVNRTGxp bmVcbXltYWNccmVsYXhccmVsYXgKXGdsb2JhbFxsZXQjMVxjdXJyZW50TXlTUUxsaXN0IFxlZ3Jv dXAKXGNhdGNvZGVgXF5eST0xMCB9Cn0KClxkZWZcTXlTUUxyb3dze1xnZXR2YWx1ZXtNeVNRTHJv d3NcTXlTUUxjdXJyZW50fX0KClxkZWZcTXlTUUxjb2x1bW5ze1xnZXR2YWx1ZXtNeVNRTGNvbHNc TXlTUUxjdXJyZW50fX0KCg== --Multipart_Fri__25_Apr_2003_12:23:52_+0200_08307008 Content-Type: application/octet-stream; name="sqltest.tex" Content-Disposition: attachment; filename="sqltest.tex" Content-Transfer-Encoding: base64 Clx1c2Vtb2R1bGVbbXlzcWxdCgpcc2V0dXBNeVNRTFtIb3N0PXR1bGxhbW9yZSwKCSAgICBVc2Vy PXRhY28sCgkgICAgUGFzc3dvcmQ9LAoJICAgIERhdGFiYXNlPXRlc3QsCiAgICAgICAgICAgICVF eGVjdXRhYmxlPW15c3FsLAogICAgICAgICAgICAlQ291bnRleGVjdXRhYmxlPXdjIC1sLAogXQoK XGRlZlxwcmludGxpc3QjMXtcbWVzc2FnZXsjMX19Cgpcc3RhcnRNeVNRTFtVc2Vyc10KU0VMRUNU ICogZnJvbSB0c3Q7ClxzdG9wTXlTUUwKClxzdGFydHRleHQKCQpcZXhlY3V0ZU15U1FMW1VzZXJz XQoKXGRvcmVjdXJzZXtcTXlTUUxjb2x1bW5zfXsKCVxtZXNzYWdle1xnZXR2YWx1ZXtNeVNRTGNv bHVtbm5hbWVccmVjdXJzZWxldmVsfX0KfQoKXGRvcmVjdXJzZXtcTXlTUUxyb3dzfXsKICBcZmV0 Y2hNeVNRTGhhc2hcdXNlcmxpc3QKICBccHJvY2Vzc2NvbW1hY29tbWFuZFtcdXNlcmxpc3RdXHBy aW50bGlzdAp9CgpcZXhlY3V0ZU15U1FMW1VzZXJzXQoKXGRvcmVjdXJzZXtcTXlTUUxyb3dzfXsK ICBcZmV0Y2hNeVNRTGFycmF5XHVzZXJsaXN0CiAgXHByb2Nlc3Njb21tYWNvbW1hbmRbXHVzZXJs aXN0XVxwcmludGxpc3QKfQoKXHN0b3B0ZXh0 --Multipart_Fri__25_Apr_2003_12:23:52_+0200_08307008--