Mike, Thank you for the reply. That looks very close to what I have. At the very least, my understanding about what I should be able to do looks correct. I will do some further testing and examination and post back with details.
Thanks again. -------------------------------------- Randy Syring RCS Computers & Web Solutions 502-644-4776 www.rcs-comp.com "Whether, then, you eat or drink or whatever you do, do all to the glory of God." 1 Cor 10:31 On Tue, Aug 11, 2009 at 10:04 PM, Mike Conley <[email protected]> wrote: > Not much detail to tell what is wrong. Here is a contrived but working > example based on one of my examples: > > > ut = Table('user',meta, > Column('uid',String,primary_key=True), > Column('name',String) > ) > > kt = Table('keywords',meta, > Column('keyword',String,primary_key=True) > ) > > ukt = Table('userkeywords',meta, > Column('uid',String,ForeignKey('user.uid')), > Column('kw',String,ForeignKey('keywords.keyword')) > ) > > class User(Base): > __table__ = ut > keywords = relation('Keyword', > secondary=ukt, > backref='users') > def __repr__(s): return "<User %s:%s>" % (s.uid,s.name) > > class Keyword(Base): > __table__ = kt > def __repr__(s): return "<Keyword %s>" % s.keyword > > q = session.query(User).\ > select_from(join(ut,ukt,ut.c.uid==ukt.c.uid)).\ > filter(case([(ut.c.uid=='mike','M'), > (ut.c.uid=='sue','F')], > else_='X') == 'M') > > > -- > Mike Conley > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
