[DB-SIG] pydal release
randall at tnr.cc
Sat Nov 20 09:15:23 CET 2004
Some of you may remember a discussion a few months back about creating a
database wrapper to hide differences between database modules. I made a
release tonight that you can download from sourceforge.
It is alpha so don't use it in production. Two of the key features are
consistent, settable date types and paramstyles. I would appreciate bug
reports and suggestions.
dbdriver = dal.wrapdriver('psycopg')
con = dbdriver
# Set date type (optional - defaults to Python datetime)
con.dtmod = 'py'
# Set param style (optional - defaults to qmark)
con.paramstyle = 'qmark'
mydt = dbdriver.Date(2004,1,1)
query = "Select * from mytable where dtcol > ?"
cur = con.cursor()
result = cur.fetchall()
# Returned datetime fields will be Python datetime type
# dtmod and paramstyle can be changed on the cursor.
I appreciate all of your input thus far. Feel free to contact me
directly or to post in the Sourceforge forums.
More information about the DB-SIG