Hi,
I'm currently working on a TurboGears project that in its model has the
standard TurboGears User table, and a table of my own, Task. The idea is
that each user has a task list, and a task can have multiple Users
associated with it.
At the moment my model.py looks something like this:
class Task(SQLObject):
name = UnicodeCol()
users = RelatedJoin('User', joinColumn='user', otherColumn='task',
intermediateTable='user_tasks')
class User(SQLObject):
...
tasks = RelatedJoin('Task', joinColumn='task', otherColumn='user',
intermediateTable='user_tasks')
Now, I want to be able to assign each Task a priority, but I want two
Users to be able to prioritise a Task differently. To me, this would
mean putting an extra column in the user_tasks table to hold the
priority for each user/task pair, so I wrote:
class UserTasks(SQLObject):
user = ForeignKey('User')
task = ForeignKey('Task')
priority = FloatCol()
I then ran 'tg-admin sql create' (which I presume calls some SQLObject
command internally), and it didn't throw up any errors, but when I
inspected the sqlite database, the extra priority field wasn't included!
sqlite> .tables
group_permission tg_group user_tasks
permission tg_user visit
task user_group visit_identity
sqlite> .schema user_tasks
CREATE TABLE user_tasks (
user INT NOT NULL,
task INT NOT NULL
);
Presumably SQLObject creates the custom joining table first, then it
gets overwritten with the new auto-generated version?
Any help here would be great; I really need that priority column for
this project!
Thanks,
Nick Murdoch
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
