sqlite.py

import sqlite3
conn = sqlite3.connect('example.db')
conn.execute("CREATE TABLE tbl (id INTEGER PRIMARY KEY, someint INTEGER)");
conn.execute("INSERT INTO tbl (id, someint) VALUES (1, 3)");
conn.execute("INSERT INTO tbl (id, someint) VALUES (2, 4)");

result = conn.execute('SELECT * FROM tbl');

conn.execute('UPDATE tbl SET someint = 5 WHERE id = 1');
conn.execute('UPDATE tbl SET someint = 6 WHERE id = 2');

for item in result:
    print item