[DB-SIG] Multiple Statements

William Trenker wtrenker@shaw.ca
Tue, 28 May 2002 16:20:10 -0700

Content-type: text/plain; x-avg-checked=avg-ok-4677EA0; charset=iso-8859-1;
Content-transfer-encoding: quoted-printable

At 06:41 PM 5/28/02 -0400, Andy Dustman wrote:
>Nearly all DB-API modules I have seen require a single statement passed to=
>either execute() or executemany(), i.e. no multiple statement queries.=20
>nextset() is for SELECTs which return multiple result sets; I've never=20
>seen this used.

I am the culprit behind Gerhard H=E4ring's question that prompted the above=
reply.  I have posted a question on zope-db@zope.org asking how Zope ends=20
up passing a multiple SQL statement query from a ZSQL Method to a Zope=20
Database Adapter.

I am simply trying to make sure that the Python SQLite DB-API 2.0 module=20
that Garhard, myself, et al are developing will also be Zope=20
compliant.  Or, more specially, I'm trying to determine the "proper" way to=
interface a Zope DA to a Python DB-API 2.0 module.

Bill Trenker

"The commandments of the LORD are right, bringing joy to the heart. The=20
commands of the LORD are clear, giving insight to life . . . For this is=20
the love of God, that we keep His commandments. And His commandments are=20
not burdensome." (Psalm 19:8, 1John=20
5:3)    <http://torahteacher.com/>torahteacher.com

Content-type: text/plain; charset=us-ascii; x-avg=cert;
Content-transfer-encoding: 7BIT
Content-disposition: inline

Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.363 / Virus Database: 201 - Release Date: 5/21/02