Perfect.
I had seen 'with_alias' explained elsewhere, but couldn't figure out
precisely how to use it.
Thanks so much!
On Wednesday, August 29, 2012 6:55:09 PM UTC-4, Massimo Di Pierro wrote:
>
> In web2py you can alias tables but not fields just because that is all you
> need to resolve ambigious joins. The aliasing of fields is not necessary
> functionally. You want:
>
> star = db.person.with_alias('star')
> dir = db.person.with_alias('dir')
>
> db(db.movie.title == 'Citizen Kane').select(db.movie.title, star*.name <as
> star**>*, dir*.name,*
> left = [db.actor.on(db.movie.id == db.actor.movie_id),
> star.on(db.actor.person_id == star.id),
> db.director.on(db.movie.id == db.director.movie_id),
> dir.on(db.director.person_id == dir.id)]
>
> On Wednesday, 29 August 2012 17:10:46 UTC-5, Mike Girard wrote:
>>
>> Hello,
>>
>> Could someone tell me how I should modify the following to alias the
>> results for actor and director? Both actors and directors consist of a
>> movie_id and a person_id, linking them up respectively to a person.idand a
>> movie.id.
>>
>> db(db.movie.title == 'Citizen Kane').select(db.movie.title,
>> *db**.person.name
>> <as star**>*, *db**.person.name <as director**>*,
>> left = [db.actor.on(db.movie.id == db.actor.movie_id),
>> db.person.on(db.actor.person_id == db.person.id),
>> db.director.on(db.movie.id == db.director.movie_id),
>> db.person.on(db.director.person_id == db.person.id)]
>> )
>>
>>
>>
>> Not crufting this up with my model since I think this is a syntax issue.
>> My model is very standard many-to-many.
>>
>>
>>
>>
>>
--
