lang/python/ PythonSqlite3

Module {{sqlite3}} is part of the python standard library. ==== Examples {{c import sqlite3

con = sqlite3.connect("file.db") con2 = sqlite3.connect(":memory:") # in memory only

cur = con.cursor() cur.execute(sql)

vals = ('Mr Flibble','today','Fry everybody with hex vision') sql = '''INSERT INTO mytable(name,date,plan) VALUES (?,?,?)''' cur.execute(sql,vals) con.commit() print(cur.lastrowid)

vals = ('Mr Flibble','today','Fry everybody with hex vision',42) sql = '''UPDATE mytable SET name = ?, date = ?, plan = ? WHERE id = ?''' cur.execute(sql,vals) con.commit()

sql = '''SELECT name, date, plan FROM mytable''' cur.execute(sql) rows = cur.fetchall() for row in rows: print(row)

sql = '''DELETE FROM mytable WHERE name = ?''' vals = ('Mr Flibble',) cur.execute(sql,vals) con.commit()

}}%TIME=1617722413