Hi!
from sqlobject.sqlbuilder import Delete
from DB import dbConn, Files
delete = Delete("files", where=Files.q.filename == "Ocean")
print dbConn.sqlrepr(delete)
=> DELETE FROM files WHERE (files.filename = 'Ocean')
Ok.
from sqlobject.sqlbuilder import Update
from DB import dbConn, Files
update = Update("files", {"filename": "value"}, where=Files.q.filename == "Ocean")
print dbConn.sqlrepr(update)
=> Traceback (most recent call last):
File "test.py", line 5, in ?
print dbConn.sqlrepr(update)
File "/usr/local/lib/python2.3/site-packages/sqlobject/dbconnection.py", line 463, in sqlrepr
return sqlrepr(v, self.dbName)
File "/usr/local/lib/python2.3/site-packages/sqlobject/converters.py", line 189, in sqlrepr
return reprFunc(db)
File "/usr/local/lib/python2.3/site-packages/sqlobject/sqlbuilder.py", line 480, in __sqlrepr__
update += " WHERE %s" % repr(self.whereClause)
File "/usr/local/lib/python2.3/site-packages/sqlobject/sqlbuilder.py", line 155, in __repr__
return self.__sqlrepr__(None)
File "/usr/local/lib/python2.3/site-packages/sqlobject/sqlbuilder.py", line 222, in __sqlrepr__
return "(%s %s %s)" % (sqlrepr(self.expr1, db), self.op, sqlrepr(self.expr2, db))
File "/usr/local/lib/python2.3/site-packages/sqlobject/converters.py", line 187, in sqlrepr
return converter(obj, db)
File "/usr/local/lib/python2.3/site-packages/sqlobject/converters.py", line 98, in StringLikeConverter
assert 0, "Database %s unknown" % db
AssertionError: Database None unknown
Ouch!
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ ph...@ph...
Programmers don't die, they just GOSUB without RETURN.
|