[sqlalchemy] Re: Setting column value that changes everyday

2011-03-02 Thread dalia
Hi, Thanks for the reply. This definitely looks good but my problem is i want to save the data into the database as a column and I need to show this message to user. I'm using formalchemy to show the data and this way, formalchemy grid view is throwing Attribute error on expiry_code. May be I'm

[sqlalchemy] Re: Setting column value that changes everyday

2011-03-02 Thread dalia
Hi, Thanks for the reply. I too have noticed I can not store numbers starting with 0 while number is integer. May be I'll make that column string :) On Mar 2, 12:33 am, Sergey V. sergey.volob...@gmail.com wrote: Do you need to store expiry_code? seeing as it is a function of last_con and the

[sqlalchemy] Re: Setting column value that changes everyday

2011-03-01 Thread GHZ
Hi, Do you need to store expiry_code? seeing as it is a function of last_con and the current date. class PhNumber(Base): __tablename__ = 'ph_numbers' ph_no = Column(Integer, nullable=False) last_con = Column(DateTime, nullable=False) @property def expiry_code(self): msg = 'Expired

[sqlalchemy] Re: Setting column value that changes everyday

2011-03-01 Thread Sergey V.
Do you need to store expiry_code? seeing as it is a function of last_con and the current date. Second that. I would also point out that phone number probably shouldn't be an integer - how would you store phone numbers which start with 0, for example? I'd rather make it a String. -- You