karl.latti...@innolabs.uk writes: > current_time = datetime.datetime.utcnow() > s = current_time - datetime.timedelta(hours=1) > hour_ago = s.isoformat() > query = session.query(func.count(MyTable)).filter(MyTable > hour_ago) > ... > StatementError: (sqlalchemy.exc.InvalidRequestError) Can't reconnect until > invalid transaction is rolled back [SQL: u'SELECT count(`MyTable`.id) AS > count_1 \nFROM `MyTable` \nWHERE `MyTable`.tstamp > %s'] [parameters: [
It seems unlikely that's the actual statement: for one, the filter condition seems wrong, because it does not reference the correct column but the whole table. Also, I'd try to find a better way to pass the parameter, possibly without transforming it into a string with isoformat(). ciao, lele. -- nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia. l...@metapensiero.it | -- Fortunato Depero, 1929. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.