Question about MySQL queries in Python Scripts
Hi, I've written a few python scripts that use some sql queries to a mysql database. I have a script that can access the database and get information ok but i have a sript that tries to insert data to the database, but when i try to run it, i get a zope error that mentions Unauthorized: query. Does anyone know why this is and how to get round it? Cheers Alan
I've written a few python scripts that use some sql queries to a mysql database. I have a script that can access the database and get information ok but i have a sript that tries to insert data to the database, but when i try to run it, i get a zope error that mentions Unauthorized: query.
Does anyone know why this is and how to get round it?
Hmm, some more information about your script or the traceback in your error message would be helpful. If I wanted to create SQL queries in a python script, I would create a MySQL DB connection in Zope, then a simple Z SQL Method that took a single arguement as a string, like this: Params: query:string Method: <dtml-var query> Then I'd only allow Manager access to this Z SQL Method and then give the python script a proxy role so that it could access the Z SQL Method. Then call that Z SQL Method from the Python Script perhaps like this: container['zsqlmethodid'](query='SELECT * FROM your_table') Kevin Teague http://www.bud.ca
I've been trying to accomplish a similar task... SQL calls from within python using the excellent PoPy and ZPoPy modules. Will this work in a external method? Or equally well in a product? Thanks all! zope hackers rule! -e- ----- Original Message ----- From: "Kevin Teague" <kevin@bud.ca> To: "alankirk" <alankirk@genie.co.uk>; " Zope" <zope@zope.org> Sent: Sunday, February 25, 2001 4:25 AM Subject: Re: [Zope] Question about MySQL queries in Python Scripts
I've written a few python scripts that use some sql queries to a mysql database. I have a script that can access the database and get information ok but i have a sript that tries to insert data to the database, but when i try to run it, i get a zope error that mentions Unauthorized: query.
Does anyone know why this is and how to get round it?
Hmm, some more information about your script or the traceback in your error message would be helpful. If I wanted to create SQL queries in a python script, I would create a MySQL DB connection in Zope, then a simple Z SQL Method that took a single arguement as a string, like this:
Params: query:string Method: <dtml-var query>
Then I'd only allow Manager access to this Z SQL Method and then give the python script a proxy role so that it could access the Z SQL Method. Then call that Z SQL Method from the Python Script perhaps like this:
container['zsqlmethodid'](query='SELECT * FROM your_table')
Kevin Teague http://www.bud.ca
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
On 2/26/01 7:58 AM, "ed colmar" <ecolmar@uswest.net> typed this:
I've been trying to accomplish a similar task... SQL calls from within python using the excellent PoPy and ZPoPy modules.
Will this work in a external method? Or equally well in a product?
Thanks all! zope hackers rule!
For a working example of using Z SQL Methods in a Python Product (my Z SQL Methods also use the excellent PoPy/ZPoPy modules), check out my SQL Poll Product. Some of the code still needs cleaning up, but it does work. http://www.zope.org/Members/kteague/SQLPoll And zope hackers do rule! Kevin Teague http://www.bud.ca
participants (3)
-
alankirk -
ed colmar -
Kevin Teague