Hi,
I have a table of phone numbers which has 3 columns named -
1. ph_no Integer not null
2. last_contacted Datetime not null
3. expiry_code Text()
The behaviour of the table should be - When the last_contacted column
has a date which is 3 months older, the expiry_code column should have
the value 'number expired'. I'm not sure how this can be done using
declarative method. I did the following -
class PhNumber(Base):
__tablename__ = 'ph_numbers'
ph_no = Column(Integer, nullable=False)
last_con = Column(DateTime, nullable=False)
expiry_code = Column(Text(), default=mydefault,
onupdate=mydefault)
def mydefault(context):
msg = 'Expired 3 months'
now = datetime.datetime.now()
if now > (context.current_parameters['last_con'] - 90):
return msg
return 'Not Applicable'
mydefault function calculates if the value in last_con column is
greater than 3 months of today's date, it stores 'Expired 3 months' in
expiry_code. But this happens only when a new insert or update occurs
in this table.
I want the value in expiry_code to be changed even without any update/
insert operations on the table. Whenever the table is selected, the
updated value should be shown. Is this possible in SQLAlchemy? Please
let me know.
--
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.
