Re: [sqlalchemy] Not able to filter column by datetime

Thank you Michael, I think sometimes I am blind xD Regards El miércoles, 15 de abril de 2015, 15:13:38 (UTC+2), Michael Bayer escribió: On 4/15/15 6:52 AM, Juan Antonio Ibáñez wrote: Hello, I have dozens of queries filtering DateTime columns but I have got one I don't know why

[sqlalchemy] Not able to filter column by datetime

Hello, I have dozens of queries filtering DateTime columns but I have got one I don't know why it doesn't work. I have: --- q = DBSession.query(func.sum(RecargaCredito.importe), Local.nombre)\ .join((Local, RecargaCredito.locales_id == Local.id)) fl_desde =

[sqlalchemy] DateTime format

Hello, I am using Sqlalchemy under Turbogears and I'd like to know which is the best way to customize column to string conversion of a DateTime column. I need to do it in an automatic way instead having to format it before showing. Regards -- You received this message because you are

[sqlalchemy] Count over aliased JOIN

Hello I am joining one table with itself so I am using alias as: alias_usuarios1 = aliased(Usuario) alias_usuarios2 = aliased(Usuario) usuarios = DBSession.query(alias_usuarios1, alias_usuarios2.nombre).filter(alias_usuarios1.resellers_id == alias_usuarios2.id)

[sqlalchemy] Subtransactions problem

Hello! I am dealing with Turbogears and SQL Alchemy. I need to make one import from a CSV file to a MySQL DB. I need also to controll which rows fails on import. I am working with the next code inside a loop: try: session.begin(subtransactions=True)