objectif

Créer et interroger une base SQLite intégrée.

code minimal

import sqlite3
con = sqlite3.connect(":memory:")
cur = con.cursor()
cur.execute("create table t(id integer, v integer)")
cur.executemany("insert into t values (?,?)", [(1,10),(2,20)])
cur.execute("select sum(v) from t")
print(cur.fetchone()[0])

utilisation

import sqlite3
con = sqlite3.connect(":memory:")
con.execute("create table x(a)")
print(con.execute("select count(*) from x").fetchone()[0])

variante(s) utile(s)

import sqlite3
con = sqlite3.connect(":memory:")
con.execute("create table y(a int)")
con.execute("insert into y values (1)"); con.execute("insert into y values (2)")
for row in con.execute("select a from y"):
    pass
print(True)

notes

• Idéal pour petits ETL rapides et joints simples.