Is there a simple way in SQLA to check if a relationship exists between two rows in a many-to-many situation, where the relationship is defined using another table?
eg. the join table might look like this: user_towns = Table('user_towns', Base.metadata, Column('user_id', Integer, ForeignKey('users.id')), Column('town_id', Integer, ForeignKey('towns.id')) ) to check if a relationship exists, the SQL would be fairly simple, with no joins required (is there a row in this table where user.id = user_id and town.id = town_id) Is there a simple way of asking this using SQLA, with the query syntax? thanks for your time --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---