Hi,
Is there a way to get many to many relationship data easily?
The web2py book says
http://web2py.com/books/default/chapter/29/6#Many-to-many that "it may
be convenient to define a new set on which to perform operations" and it
basically does a join between the fields.
But what if I've this models:
db.define_table('genres',
Field('name')
)
db.define_table('movies',
Field('imdb_id', 'integer'),
Field('title'),
Field('poster', 'text'),
Field('trailer', 'text'),
Field('plot', 'text'),
Field('date', 'datetime'),
Field('updated', 'datetime')
)
db.define_table('movies_genres',
Field('movie', db.movies, requires=IS_IN_DB(db, 'movies.id',
db.movies._format)),
Field('genre', db.genres, requires=IS_IN_DB(db, 'genres.id',
db.genres._format))
)
and i do:
movie = db.movies[1]
movie has an movies_genres which is a set. can I use movie.movies_genres
to get a genre instance ?
I'm asking this because I'm in a view and I would like a compact way to
print genre.name from a movie instance.
Thank you
best regards,
--
Vincenzo Ampolo
http://vincenzo-ampolo.net
http://goshawknest.wordpress.com
--
