[sqlalchemy] Retrive datetime attributes

2012-06-21 Thread fribes
Hi all, I'm using Python 2.6.5 and SQLAlchemy-0.7.8 over sqlite3 to store and retrieve logs with in table like this : class LogEntry(Base): Log class __tablename__ = 'log' #common data id = Column(Integer, primary_key=True) timestamp = Column(DateTime()) When querying back

Re: [sqlalchemy] Re: Retrive datetime attributes

2012-06-21 Thread fribes
Thanks! Here is a slightly modified version that shows what happens : if querying in another session, with a from_statement, the string is not processed. Is it the expected behaviour ? from datetime import datetime from sqlalchemy import Column, DateTime, Integer, create_engine from

[sqlalchemy] Deletion

2011-10-18 Thread fribes
Hi all, Despite some doc and web digging, I didn't find how to tell sqa to behave the way I want : on deletion on Peripheral, also delete in Actuator. with the following code, the record in Actuator remains after a deletion, and a subsequent creation fails with IntegrityError. class

Re: [sqlalchemy] Re: Speed matters

2011-06-02 Thread fribes
Hi Sergey, I'll give it a try, thanks ! On 2 June 2011 03:15, Sergey V. sergey.volob...@gmail.com wrote: Hi, One easy/obvious improvement would be to delete all user's identifiers and groups at once without iterating over them for every user. Actually, iterating over the list of user_ids