Re: [sqlalchemy] TIMEDIFF and SQLAlchemy

Try this: from sqlalchemy import func from sqlalchemy.sql import select s = select( [Plage.Id, func.timediff(Plage.Start, Plage.Start) ], (func.timediff(Plage.Start, Plage.Start) = func.time('02:20:00')) ) Thanks, -- Abdul Kader M On Wed, Nov 17,

Re: [sqlalchemy] Insert from select?!

Try this http://www.sqlalchemy.org/docs/05/reference/ext/compiler.html?highlight=compiler#compiling-sub-elements-of-a-custom-expression-construct -- Abdul Kader On Wed, Nov 3, 2010 at 5:09 PM, Torsten Landschoff torsten.landsch...@dynamore.de wrote: Hi *, I am wondering if there is a way to

[sqlalchemy] Renaming column

Hi All, I want to rename a column, eg. from Column('cl1', String (1)) to Column('cl2', String(1)), and then do create_all, nothing changes. Any idea how to do this ? Thanks, Abdul Kader -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to

[sqlalchemy] Function based index

Hi All, I would like to create an index like this: CREATE UNIQUE INDEX index_name ON tbl_name ( UPPER(col1), col2); Is there a way to do that using the Index() ? Thanks, -- Abdul Kader -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To