[Zope] run raw sql

[Andreas Jung]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Andreas Jung wrote:
> Garry Saddington wrote:
>> Is there any way to run raw sql statements from within a python script?
>> Any help at all much appreciated.
> 
> Free out of my head:
> 
> - write a ZSQL method "genericSQL.sql" containing something like
>   <dtml-var query>
> 
> - call the method from Python using acquisition:
> 
>   context.genericSQL(query='drop table XXXX')
> 
> The risk regarding SQL injection etc. is at you.

In addition: most database adapters from a generic method
(usually query()?) that could be used...you might check the
code of the database adapter you are using.

- -aj
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkxPC/0ACgkQCJIWIbr9KYzB6wCgjGoKlN0mOfyS9uxkzy2158Uz
uGYAn2a/J7W405pFIS8feP/0oQCkM5WK
=ytKn
-----END PGP SIGNATURE-----
-------------- next part --------------
A non-text attachment was scrubbed...
Name: lists.vcf
Type: text/x-vcard
Size: 316 bytes
Desc: not available
Url : http://mail.zope.org/pipermail/zope/attachments/20100727/83a78abe/attachment.vcf