#!/usr/bin/python
#
# cursor.lastrowid returns the last inserted rowid
#
import os
import sys
import sqlite3
db_filename = 'cursor_lastrowid.db'
if os.path.isfile(db_filename):
os.remove(db_filename)
def ins(a):
cur.execute('insert into t(a) values (?)', (a, ))
print('Inserted a record, lastrowid is ' + str(cur.lastrowid))
db = sqlite3.connect(db_filename)
cur = db.cursor()
cur.execute('create table t (id integer primary key, a)')
ins(42)
ins(99)