Re: Associations and queries using 2 models

2008-05-16 Thread grigri
> Video hasMany AlbumVideo; AlbumVideo hasMany Albums. This implies that Album belongsTo AlbumVideo and AlbumVideo belongsTo Video; i.e: Video : [id, ...] AlbumVideo: [id, video_id, ...] Album: [id, album_video_id, ...] > Now I would like to search in Album and song title. You're not being cle

Re: Associations and queries using 2 models

2008-05-16 Thread Filip Camerman
I'd reverse the question: is there any reason to NOT just write this in SQL? This is a genuine question; to me it seems manic inefficiency for someone who's comfortable with SQL to struggly with another complex query system which will just translate everything back to SQL. --~--~-~--~---

Associations and queries using 2 models

2008-05-15 Thread Nicolás Andrade
Hello to all. I would like to share with you a problem I'm having and I need your suggestions. We have the following models: Video, Album, Artist. Video and Album are not relationed using HABTM; but Video hasMany AlbumVideo; AlbumVideo hasMany Albums. AlbumVideo has an Order field to sort th