[Zope] Calling a SQL method from python and storing the results

[Tino Wildenhain]

Am Donnerstag, den 24.11.2005, 13:04 -0500 schrieb Mike Jakowlew:
> Here is what I need to accomplish:
> 
> I need to call a Z-SQL method from within python and store the result
> in a variable in python. I know this could probably be done easier
> with ZPT's or DTML, however the program that I've written does many
> things and depends on this particular variable for the majority of the
> program. 

ou contraire, its much more easy in python.

> My overall program:
> 
> Uploads a File (Working)
> Write an entry to a MS SQL DB (Working)
> Send an Email to alert user of upload (Working)
> 
> in this particular case all I need is the id of the last row in the db
> before the e-mail is sent out. The e-mail itself sends a link that
> calls another SQL method with ID as the parameter passed. 

This is a bit problematic with MS SQL since it does not have
sequences for easy access to automatically generated ids.

You might work around that by doing the insert with a stored
procedure, returning the id of your insert.

> I've tried to use the container.id method, but that just returns the
> name of the Z-SQL method.

ZSQL methods are high level above the database and simply dont know
about such internals. If your SQL statement however returns
rows, you can happily retrieve it with your method.