I have three tables managed by SQLA: 'user' (with a 'username' column), 'server' (with 'servername' column), and 'account' (with 'password' column and foreign keys referring to 'user' and 'server'). The account table basically says "user X has an account on server Y with password Z". All are defined declaratively. Given a provided username, servername, and password, what's the nice SQLAlchemy way to get access to all three objects and verify that this is a valid account?
I have a solution working that does three separate queries (one for each table), but I'm sure there's a nicer way involving joins or some other mechanism that I'm not completely familiar with as a SQLA rookie. Thanks for any tips & suggestions anyone can offer! -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@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.