Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 1st, 2012  |  syntax: None  |  size: 0.81 KB  |  hits: 14  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. In SQLAlchemy, how can I make this conditional query on a child relationship?
  2. class Parent(Base):
  3.     __tablename__ = 'parent'
  4.     __table_args__ = {
  5.         UniqueConstraint("name", "version")
  6.         }
  7.  
  8.     name = Column(String, primary_key=True)
  9.     parent = Column(JSONEncodedDict)
  10.     tags = relationship(ParentTags)
  11.     version = Column(Integer)
  12.  
  13. class ParentTags(Base)::
  14.  
  15.     __tablename__ = 'parent_tags'
  16.     __table_args__ = {
  17.         UniqueConstraint("name", "tag"),
  18.         }
  19.  
  20.     id = Column(Integer, Sequence("parent_tag_id_seq"), primary_key=True)
  21.     name = Column(String, ForeignKey("parent.name"))
  22.     tag = Column(String)
  23.     version = Column(Integer)
  24.        
  25. session.query(Parent.name, Parent.version).
  26.               join(ParentTag).
  27.               filter(ParentTag.tag=='Production').
  28.               all()