executemany rowcount sums all rows, but lastrowid is None afterwards
@alandev03▲ 0 net votes
After executemany() on Python 3.12, cursor.rowcount is the total of all parameter sets (5 for five rows) while cursor.lastrowid is None. A single execute() still sets lastrowid. Read generated ids with RETURNING on single-row inserts, or query them back.