Re: [sqlalchemy] SQLAlchemy Auto Converts BLOB To Str?

2013-10-29 Thread Jerry
Hi Mike, It works -- bytearray is now returned after changing JobSpec from BLOB to NullType. Thank you very much for the wonderful library and great support. Jerry On Tuesday, October 29, 2013 12:13:15 AM UTC+8, Michael Bayer wrote: > > > On Oct 28, 2013, at 11:14 AM, Jerry &

[sqlalchemy] SQLAlchemy Auto Converts BLOB To Str?

2013-10-28 Thread Jerry
xn.cursor() cursor.execute("select JobSpec from ScheduledJob") for row in cursor.fetchall(): type(row.JobSpec) # == type(bytearray()) It seems SQLAlchemy auto converts BLOB to str -- if it's true, it'd be a bug, isn't it? Or am I using SQLAlchemy correctly? Is there

[sqlalchemy] SQLAlchemy 0.8 Generates Wrong SQL for self-join

2013-10-12 Thread Jerry
R JOIN "ScheduledJob" AS "ScheduledJob_1" ON "ScheduledJob"."DependentJob1" = "ScheduledJob_1"."Id" What could have gone so wrong? Any pointer will be greatly appreciated. BTW, I'm mapping multiple databases, could it be related to this