Michael Bayer wrote:

ok well how should it look ?  do you want to take a crack at it....?

Done as at r1256.

It leverage's off of the existing sqlalchemy.types for some degree of database independence, e.g.

  select([cast(tbl.c.integer_col as TEXT)])

will end up as

SELECT CAST(table_name.integer_col as TEXT) FROM table_name in Postgres/MySQL/SQLite

but

  SELECT CAST(table_name.integer_col as CLOB) FROM table_name in Oracle

It also supports literals as well, e.g. cast(1234 as TEXT).

Robert

PS Thanks to Mike for patiently answering all my questions on the best way to tackle this.


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to