On Jan 14, 2008, at 12:12 PM, Alexandre Conrad wrote:
> Mike, > > Michael Bayer wrote: >> a certain id_channel. otherwise im still having trouble wrapping my >> head around what youre trying to do there. > > Enough guessing, here's the full test case with description of what > I'm > trying to do. :) > > Although, I wasn't able to make it run with sqlite, so it's running a > under a "foo" table with MySQL. (another hidden bug, I'm getting > (IntegrityError) medias.id may not be NULL). > your best bet with this mapping right now is: print Media .query .select_from (media_table .join (catalog_table ).join (catalog_channel_table )).filter(CatalogChannel.c.id_channel==playlist.id_channel).all() which is really how select_from() was intended to be used. the "select_table" option should be working here, which would make this super easy, but its not - will investigate more closely. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
