Greetings,
for my model I have this:
user_table=Table("users", metadata,
Column("id", Integer, primary_key=True),
Column("gender", Unicode),
Column("age", Integer, ForeignKey("ages.id")),
Column("occupation", Integer, ForeignKey("occupations.id")),
Column("zipCode", Integer(5))
)
movie_table=Table("movies", metadata,
Column("id", Integer, primary_key=True),
Column("title", Unicode)
)
movie_vote_table=Table("movie_votes", metadata,
Column("id", Integer, primary_key=True),
Column("user", Integer, ForeignKey("users.id")),
Column("movie", Integer, ForeignKey("movies.id")),
Column("score", Float)
)
I've of course left out some of the other tables that weren't needed
for this question
so I of course a many to many relationship between the users and the
movies they have rated. but the only problem is how do I access that
score?
It would be cool to have something like User.movies[0].score,
User.movies[1].score .. etc.
is this something I would want to use the association proxy for?
-Jason
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
