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