Twisted adbapi: number affected rows and last insert id

Question

ConnectionPool.runQuery returns Transaction.fetchall(). How do I get number of affected rows or last insert id?

score 2 · Answer 1 · edited Dec 06 '12 at 11:20

2

You can use the property Transaction.lastrowid.

edited Dec 06 '12 at 11:20

Konrad Viltersten

answered Dec 06 '12 at 11:01

Randell

score 0 · Answer 2 · edited May 23 '17 at 12:15

0

Here's an example of use Transaction to get the last insert id, please refer the question demo code.

You will always get 0 if you do like this in two separate query:

self.dbpool.runQuery('insert into table_x (%s, %s)', ('str1', 'str2'))
self.dbpool.runQuery('select LAST_INSERT_ID()')

edited May 23 '17 at 12:15

Community

answered Feb 27 '16 at 08:41

Chen wei

2 Answers2