[sqlalchemy] Strings larger than 16K are truncated? Even for a TEXT column?

2011-04-28 Thread Joel Zhou
Hi I am using sqlalchemy 0.6.6 with sybase dialect, I found that strings larger than 16K are truncated to 16K even for TEXT column. Debug trace shows that string contents are correct in SQL statement but after execution (session.commit()) they are truncated to 16KB. It is a known issue or I mis-c

[sqlalchemy] How can I do an eager loading when joining multiple tables?

2011-01-24 Thread Joel Zhou
Hi list, I defined two tables, Users, Orders and Items, where Orders has a foreign key "user_id" depending on User.id and Items has a foreign key "order_id" on Order.id. I'd like to do eager loading when joining these three tables by: session.query(Users).join(Users.orders, Orders.items).options(

[sqlalchemy] Query doesn't work for Sybase?

2011-01-21 Thread Joel Zhou
Hi All I am using sqlalchemy 0.6.5 with sybase dialect. Python-Sybase driver is 0.39. The query SQL generated by sqlachemy has double quotes on each identifier, something like: SELECT "MYTABLE"."ID" AS "MYTABLE_ID" FROM "MYTABLE" among which "MYTABLE"."ID" is syntactically wrong in ASE 12.5. I