On Jun 17, 2013, at 2:36 AM, Chris Withers <ch...@simplistix.co.uk> wrote:
> Hi All,
>
> I have a model roughly like this:
>
> class Instrument(Base):
> __tablename__ = 'instrument'
> id = Column(String(10), primary_key=True)
> name = Column(String(100))
>
> class Symbol(Base):
> __tablename__ = 'symbol'
>
> instrument_id = Column(String(10),
> ForeignKey('instrument.id', onupdate='cascade'),
> primary_key=True)
> instrument = relationship("Instrument")
> name = Column(String(20), nullable=False)
> period = Column(TSRANGE(), nullable=False, primary_key=True)
>
> How can I set up a 'symbols' dictionary-based collection on Instrument which
> uses the following query to populate:
>
> session.query(Symbol).filter(
> instrument_id==self.id,
> Symbol.period.contains(func.now())
> )
well you're going to have relationship with
"primaryjoin=and_(Symbol.instrument_id==Instrument.id,
Symbol.period.contains(func.now()))" (what does contains(func.now()) do ?
havent seen that one before). then
collection_class=attribute_mapped_collection(<attribute you want to key on>).
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.
