Hi,
I try to insert a big number of of rows to a table and want to receive the ids
that were assigned to these (new) rows.
If i insert a single row, it works as expected, but with multiple rows I run
into an error:
AttributeError: 'DefaultExecutionContext' object has no
attribute '_inserted_primary_key' .
I use SQLAlchemy 0.6.3-3 (Debian Squeeze) with an sqlite database.
Pseudo code follows.
Is there another obvious way to retrieve the ids?
Enjoy,
--felix
#
# Setup Session etc.
#
data_table = Table('data', metadata,
Column('id', Integer, primary_key=True),
Column('stuff', String, nullable=False) )
insert_dicts = []
for x in range(10):
insert_dicts.append(dict(stuff=str(x)))
stmt = data_table.insert(bind=Session.bind)
res = stmt.execute(insert_dicts)
# Correct:
print res.rowcount
print r.inserted_primary_key()
# Raises:
#AttributeError: 'DefaultExecutionContext' object has no
#attribute '_inserted_primary_key'
# Initial trial with r.last_inserted_ids()
#SADeprecationWarning: Use inserted_primary_key
#Error - <type 'exceptions.AttributeError'>: 'DefaultExecutionContext' object
#has no attribute '_inserted_primary_key'
--
Felix Wolfsteller | ++49 541 335083-783 | http://www.intevation.de/
PGP Key: 39DE0100
Intevation GmbH, Neuer Graben 17, 49074 Osnabrück | AG Osnabrück, HR B 18998
Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner
--
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.
