Hi,
I'm wondering if SA can help in the following situation.
I'm trying to store a schedule which can be reduced to an id and a
recurrence rule encoded as an rrule from python-dateutil. Something
like the following:
schedule = Table('schedules_table', meta,
Column('id', Integer, primary_key=True),
Column('rrule', PickleType, nullable=False))
Ideally, I would like to query such a table and get back a list of
(potentially) same id's but with different dates as derived by the
recurrence rule. It's not always convenient to expand the recurrence
rule and store corresponding dates in children of the schedule table,
as such rules can be infinite.
Now, this brakes the relational model but I'm still wondering whether
there is an SA pattern I can follow, possibly extending a list
collection class or constructing a relation based on the rrule
attribute, to do what I want.
Any help greatly appreciated,
Andronikos
--
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.
