Creating and manipulating a run number database.

sqlite3_example.py

import sqlite3
import random

# Create the database
con = sqlite3.connect('/path/to/database.db')
con.execute('CREATE TABLE runs (run INTEGER PRIMARY KEY)')

# Insert many runs...
runs = range(int(1e3))
random.shuffle(runs)
con.executemany('INSERT INTO runs (run) VALUES (?)', [(r,) for r in runs])
# ... or a single one
con.execute('INSERT INTO runs (run) VALUES (?)', (123987,))

# Remove many runs...
con.executemany('DELETE FROM runs WHERE run=?', [(r,) for r in range(100, 200)])
# ... or a single one
con.execute('DELETE FROM runs WHERE run=?', (123987,))

# Count the number of runs
nruns, = con.execute('SELECT Count(*) FROM runs').fetchone()

# Get the list of sorted runs
sorted_runs = con.execute('SELECT run FROM runs ORDER BY run ASC').fetchall()

print nruns
print sorted_runs