I went ahead and asked this on stackoverflow if anyone would like to have a
stab at it.
http://stackoverflow.com/questions/11021020/emulating-appengine-list-property-with-postgresql-array-and-sqlalchemy
On Tuesday, June 12, 2012 7:34:42 AM UTC-4, Tom Willis wrote:
Hello,
I'm hoping that
I wouldn't be too optimistic about an SO response on this one as the guts of
SQLA questions all hang out there until I answer them anyway.
haven't had time to play with this, but if the question regards the insides
of the ARRAY, ARRAY accepts another SQLAlchemy data type as the argument for
Well I had written another type to emulate appengines Key, basically an
object that will serialize/deserialize itself to json when asked and what I
thought were all the mechanics needed for type coercion in sa.
from sqlalchemy import types as sqltypes
from sqlalchemy import UnicodeText
there's not a lot of moving parts in SQLA here. the first step would be,
figure out how this needs to render with psycopg2 directly. If you can get it
to work with psycopg2 alone, passing the desired value as a bound parameter,
then we can work out what the type engine needs to do or not.
AH ok thanks for the tip. I'll poke around with that and see what I can
come up with.
Thanks for your help
On Wednesday, June 13, 2012 3:11:56 PM UTC-4, Michael Bayer wrote:
there's not a lot of moving parts in SQLA here. the first step would be,
figure out how this needs to render with
Version: 0.7
Driver: pyodbc
I am able to select GUIDs out of the SQLServer DB with my columns set
up like so:
Id = Column(SiteID, UNIQUEIDENTIFIER, primary_key=True)
I'm unable to query this field when I try this:
site_id = UNIQUEIDENTIFIER(GUID_STR)
q =
On Jun 13, 2012, at 3:13 PM, stevelewis wrote:
Version: 0.7
Driver: pyodbc
I am able to select GUIDs out of the SQLServer DB with my columns set
up like so:
Id = Column(SiteID, UNIQUEIDENTIFIER, primary_key=True)
thats fine
I'm unable to query this field when I try this:
site_id
On Jun 13, 2012, at 3:40 PM, Michael Bayer wrote:
I'm unable to query this field when I try this:
site_id = UNIQUEIDENTIFIER(GUID_STR)
Not sure what this is supposed to do. Seems like you're attempting to call
the type as a function. I've googled around and cannot find an example
Oh, duh! I just had the wrong string format. I knew I was doing
something dumb but I couldn't place my finger on it.
Thanks a ton!!!
On Jun 13, 4:06 pm, Michael Bayer mike...@zzzcomputing.com wrote:
On Jun 13, 2012, at 3:40 PM, Michael Bayer wrote:
I'm unable to query this field when I try