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

<<attachment: lists.vcf>>

_______________________________________________
Zope maillist  -  Zope@zope.org
https://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 https://mail.zope.org/mailman/listinfo/zope-announce
 https://mail.zope.org/mailman/listinfo/zope-dev )

Reply via email to