Hi all,
I am trying to use the postgres_returning feature with the latest svn
checkout of SqlAlchemy, Python 2.5.2, and Postgresql 8.3.
I have a declarative_base, which works in the declarative base
context. I get it's table reference this way:
al_table = ActivityLog.__table__
My postgres_returning usage looks like this:
result = al_table.insert(
postgres_returning=[
al_table.c.userID,
al_table.c.logtypeID,
al_table.c.logcategoryID,
al_table.c.notes,
al_table.c.direction]
).values(userID=1003,logtypeID=10,
logcategoryID=103,
notes="Member registered, push to TPA
is happening.",
direction= "INTERNAL")
new_record = result.fetchall()
This is my error:
-> new_record = result.fetchall()
(Pdb) c
Traceback (most recent call last):
File "outgoing_process.py", line 181, in <module>
x.prepOutgoing()
File "outgoing_process.py", line 96, in prepOutgoing
new_record = result.fetchall()
AttributeError: 'Insert' object has no attribute 'fetchall'
Did I mess this up in some way, or hit a bug? Can I use a
declarative_base table ref this way?
Thank you in advance,
Gloria
PS: I still owe you a working sample of a previous problem I reported
involving session scope. I have not forgotten, but I've been too
swamped to do it. I'll have time next week to prepare this and send it
out.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
