I have a composite type that I defined as:
CREATE TYPE farm.job_status_ret AS
(total bigint,
"valid" bigint,
invalid bigint,
processing bigint,
pending bigint,
canceled bigint);
I dropped the text field. When I run the query in postgres I get the six
distinct fields:
hdpsdb=# SELECT * FROM farm.call_job_status('testshow');
total | valid | invalid | processing | pending | canceled
---------+-------+---------+------------+---------+----------
9892718 | 116 | 20 | 0 | 9886233 | 6349
but from SQLAlchemy I just get a string:
>>> session.query(func.farm.call_job_status('testshow')).first()
('(9892718,116,20,0,9886233,6349)',)
Looks like the TypeDecorator will do what I need.
Michael Bayer wrote:
> David Gardner wrote:
>
>> I have a PostgreSQL function that returns a composite type (a text field
>> and 6 bigint columns).
>> Currently I am calling it with:
>> session.query(Job,func.farm.call_job_status(Job.path)).filter(Job.path=='testshow').first()
>>
>> Which returns a tuple, but the second element is a string. I could
>> probably parse the string, but that wouldn't be very elegant.
>> I was wondering is there an object that I can subclass to support this?
>>
>> I tried passing in type_=(String,Integer,...) as well as
>> type_=composite(SomeObj) neither worked.
>>
>
> unsure what this means. the text field + 6 int columns are returned as
> one big string ? if so, that would be a postgresql/psycopg2 behavior, so
> you'd have to parse the string (most cleanly using TypeDecorator).
>
>
>
> >
>
>
--
David Gardner
Pipeline Tools Programmer
Jim Henson Creature Shop
[email protected]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
