(TurboGears 0.8a5)
given the following model (using sqlite):
class Task(SQLObject):
name = StringCol(length=50, notNull=True)
category = ForeignKey('TaskCategory')
class TaskCategory(SQLObject):
name = StringCol(length=50, notNull=True)
tasks = MultipleJoin('Task')
this gives me an error:
>>> t = TaskCategory.select()[0]
>>> t.tasks
OperationalError: no such column: task_category_id
I checked the database that was created and the "task" table has a
"category_id" column for the foreign key.
I guess I'm confused about the relationship between the variable name
and the string parameter in the ForeignKey definition. Any insight is
appreciated.
--
DaveS