[Zope] ZSQL, call for early beta testers
Peter Bengtsson
peter at fry-it.com
Sun Apr 1 14:55:40 EDT 2007
I've developed a little module that makes it really easy to plug in .sql
files into a python product class as ZSQLMethods. It's extremely easy to
use and doesn't require any CMF or ZODB stuff. It also has support for
memcache for those of you with slow db queries that you need to repeat.
It works something like this::
from Products.ZSQL import initializeSQLfiles
class _SQLBase(Acquisition.Implicit):
dbConnection = 'Psycopg_database_connection'
class SQLUser(_SQLBase):
pass
folders2classes = {'sql/Userstuff': SQLUser}
home = package_home(globals())
initializeSQLfiles(folders2classes, home)
If in the folder 'sql/Userstuff' you have a file called
'select_users.sql' you will the be able to just run:
# select users:
print SQLUser.select_users()
# same but first printed the final SQL used
print SQLUser.select_users(debug__=True)
# save time for the next call
print SQLUser.select_users(memcache__=True)
Is anybody interested in a being early beta testers before I release it
as Open Source? It works quite well here for me but I fear I'm getitng a
bit home blind based on just my needs. I'm pretty sure it works but some
early feedback would be appreciated.
Peter
--
Peter Bengtsson,
work www.fry-it.com
home www.peterbe.com
hobby www.issuetrackerproduct.com
More information about the Zope
mailing list