Hi,
I'm having problems with the current revision and multipleJoins =(
This is a boil down model:
class Task(SQLObject):
name = StringCol()
owner = ForeignKey("Person")
class Person(SQLObject):
name = StringCol(length=250)
tasks = MultipleJoin("Task")
-It doesn't matter if I create them with tg-admin sql create or
directy: Task.createTable() from the tg-admin shell -
This is a sample session:
>>> p = Person(name='ronald')
>>> p.tasks
Traceback (most recent call last):
File "<console>", line 1, in ?
File "<string>", line 1, in <lambda>
File "/Library/Frameworks/Python.framework/Versions/2.4/lib/
python2.4/site-packages/SQLObject-0.7.1dev_r1457-py2.4.egg/sqlobject/
joins.py", line 131, in performJoin
inst.id)
File "/Library/Frameworks/Python.framework/Versions/2.4/lib/
python2.4/site-packages/SQLObject-0.7.1dev_r1457-py2.4.egg/sqlobject/
dbconnection.py", line 598, in _SO_selectJoin
return self.queryAll("SELECT %s FROM %s WHERE %s = %s" %
File "/Library/Frameworks/Python.framework/Versions/2.4/lib/
python2.4/site-packages/SQLObject-0.7.1dev_r1457-py2.4.egg/sqlobject/
dbconnection.py", line 744, in queryAll
return self._dbConnection._queryAll(self._connection, s)
File "/Library/Frameworks/Python.framework/Versions/2.4/lib/
python2.4/site-packages/SQLObject-0.7.1dev_r1457-py2.4.egg/sqlobject/
dbconnection.py", line 309, in _queryAll
self._executeRetry(conn, c, s)
File "/Library/Frameworks/Python.framework/Versions/2.4/lib/
python2.4/site-packages/SQLObject-0.7.1dev_r1457-py2.4.egg/sqlobject/
dbconnection.py", line 295, in _executeRetry
return cursor.execute(query)
OperationalError: no such column: person_id
Hmm? Any ideas?
Cheers
Ronald
________________________________
Ronald Jaramillo
mail: ronald AT checkandshare DOT com
blog: http://www.checkandshare.com/blog
