Hi,
Oracle queries/updates etc don't work in web.py 0.3 when I tested it.
It appears to use the wrong paramstyle, using the default pyformat,
instead of numeric. It just needed one line to fix it:
self.paramstyle = db.paramstyle
All db.select, db.update, db.insert and db.delete then work.
class OracleDB(DB):
def __init__(self, **keywords):
import cx_Oracle as db
if 'pw' in keywords:
keywords['password'] = keywords.pop('pw')
#@@ TODO: use db.makedsn if host, port is specified
keywords['dsn'] = keywords.pop('db')
self.dbname = 'oracle'
db.paramstyle = 'numeric'
---> self.paramstyle = db.paramstyle
Thanks for all your work on version 3.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web.py" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/webpy?hl=en
-~----------~----~----~----~------~----~------~--~---
