PythonDB - mwicat/personal GitHub Wiki

import sqlite3
conn = sqlite3.connect('/var/tmp/storage.sqlite')

c = conn.cursor()
c.execute('CREATE TABLE if not exists storage(user_id text, data_type integer, count integer, size integer)')
c.executemany('INSERT INTO storage VALUES (?,?,?,?)', stats)

conn.commit()
conn.close()