[sqlalchemy] Strange behaviour with func.timediff?

2010-11-18 Thread Christian Démolis
Hi, I found a usecase that is illogical Here is the first code and his result in term. All is *False* milieu = model.aliased(model.Plage) s2 = model.session.query( milieu, model.func.timediff(milieu.Fin, milieu.Debut), *model.func.timediff(milieu.Fin,

Re: [sqlalchemy] Strange behaviour with func.timediff?

2010-11-18 Thread Michael Bayer
This has everything to do with the database driver in use and the database itself. Acceptance of a Python timedelta object by the DBAPI and proper interpretation of it against the result of a TIMEDIFF call (which is MySQL specific) is not a given on most DBAPIs. For cases like these your

Re: [sqlalchemy] Strange behaviour with func.timediff?

2010-11-18 Thread Christian Démolis
Thanks, Ok, i use MySQLdb as database driver... I solved the problem with func.unix_timestamp def lg(self): extrait les créneaux libres groupés xref = time.time() haut = model.aliased(model.Plage) milieu = model.aliased(model.Plage) bas =

Re: [sqlalchemy] Strange behaviour with func.timediff?

2010-11-18 Thread Michael Bayer
On Nov 18, 2010, at 10:26 AM, Christian Démolis wrote: As u can see, your wonderful library is used in many projects around the world !) You're the best! hey thanks for the appreciation ! 2010/11/18 Michael Bayer mike...@zzzcomputing.com This has everything to do with the