[sqlalchemy] Re: OID usage - sdob...@sistechnology.com - com.googlegroups.sqlalchemy

3 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: OID usage

From	Sent On	Attachments
sdob...@sistechnology.com	27 Sep 2007 13:02
Eric N	27 Sep 2007 13:11
Michael Bayer	27 Sep 2007 13:43

Subject:	[sqlalchemy] Re: OID usage
From:	sdob...@sistechnology.com (sdob...@sistechnology.com)
Date:	09/27/2007 01:02:47 PM
List:	com.googlegroups.sqlalchemy

just some ideas.

Here is an example of a properly interpreted row using the dbutils.OID class: " 08C82B7C6A844743::SDRAM::64Mb::Marketing::0C::70C::DC Electrical Characteristics::::"

Here is the binding statement being generated by SqlAlchemy: 2007-09-27 13:32:12,444 INFO sqlalchemy.engine.base.Engine.0x..cL {'spec_section_symbols_section_OID': '\x08\xc8+|j\x84GC'}

I know in Perl I have to format the query without quotes or I don't get any results. Something like this: "select * from table where section_OID=0x08C82B7C6A844743"

the dict shows that your value is sent/assumed a raw byte-string, while what u're suggesting in the perl example is that the server expects a sort of hexadecimal longint representation. Are these equivalent? maybe u need to convert from one to another?

I am not receiving any type of error, just an empty result set. I have verified that the OID is being interpreted correctly by running an interactive sql statement on the interpreted value shown.

I'm wondering if SqlAlchemy is quoting the parameter when it is bound or if anyone has any other suggestions as to why I am not getting any results.

insert one row via sqlalchey with OID=aabbccddeeff and see what u get. may give u idea of what conversion happens on the way.