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 of
> what this would represent on SQL server ( i.e.
> http://msdn.microsoft.com/en-us/library/ms190215%28v=sql.105%29.aspx,
> http://msdn.microsoft.com/en-us/library/ms187942.aspx). From what I can
> see, "uniqueidentifier" is a type only, not a function.
>
> Types, like String, VARCHAR, UNIQUEIDENTIFIER here, are meant to be called in
> two places - in CREATE TABLE statements and in CAST statements. If there's
> some data-level procedure or something, that would be something else, such as
> a function you'd invoke in SQLAlchemy as func.uniqueidentifier(value). But
> I can't find documentation for such a function, if you can point me to the
> SQL you want then your issue is solved.
oh, you just want to query against a string guid. Just pass it in as a
string, sorry.
from sqlalchemy import MetaData, Table, Column, create_engine
from sqlalchemy.dialects.mssql import UNIQUEIDENTIFIER
import uuid
m = MetaData()
t1 = Table('t', m, Column('id', UNIQUEIDENTIFIER))
e = create_engine("mssql://scott:tiger@ms_2005")
with e.begin() as conn:
m.create_all(conn)
id_str = str(uuid.uuid4())
conn.execute(t1.insert(), id=id_str)
print conn.execute(t1.select().where(t1.c.id==id_str)).first()
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
