Search notes:

Python: sqlite3.lastrowid

A cursor's lastrowid attribute returns the last inserted rowid.
#!/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)
Github repository about-python, path: /standard-library/sqlite3/cursor_lastrowid.py

See also

sqlite3

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758207169, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/languages/Python/standard-library/sqlite3/lastrowid(63): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78