On Sep 30, 4:00 pm, Andrew <[email protected]> wrote:
> On Sep 30, 3:46 pm, "Michael Bayer" <[email protected]> wrote:
>
> > what happens if you say:
>
> > engine.execute(myquery.statement).fetchall()
>
> > ?
>
> That worked (spaced out for readability):
>
> [
>
> (Decimal('468811'), ... ),
>
> (Decimal('468810'), ... ),
>
> (Decimal('468721'), ...) ,
>
> ...]
>
> What does this mean, then?
>
> Andrew
I also went ahead and checked the raw output of query.all()--it worked
correctly; all the IDs were retrieved and displayed in raw format:
"Decimal(###)" and so on. HOWEVER, when parsing those rows using a
simple for loop, a'la
str = ""
for row in query.all():
if row.sync_session_sid == None:
str = str + "None<br>\n"
else:
str = str + "%d<br>\n" % row.sync_session_sid
return str
Which then returns:
468811
None
468721
In other words, the *raw data* that it returns is good. The mapping
to objects is not.
Andrew
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
