[SQLObject] Re: Update(): AssertionError: Database None unknown

[Oleg B. <ph...@ph...>]

Hello! I hope I haven't flooded the list too much?

On Sat, Nov 13, 2004 at 08:48:21PM +0300, Oleg Broytmann wrote:
> 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

   Found and fixed. the problem is in the line

>   File "/usr/local/lib/python2.3/site-packages/sqlobject/sqlbuilder.py", line 480, in __sqlrepr__
>     update += " WHERE %s" % repr(self.whereClause)

   It must be

            update += " WHERE %s" % sqlrepr(self.whereClause, db)

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.