Sqlite3を使ってみる
import sqlite3
conn = sqlite3.connect('test.sqlite')
c = conn.cursor()
c.execute('''CREATE TABLE items (name text, price real)''')
fruit = [('Banana', 300),
('Apple', 150),
('Mango', 250)
]
c.executemany('INSERT INTO stocks VALUES (?,?)', fruit)
conn.commit()
for row in c.execute('SELECT * FROM items '):
print(row[0],row[1])
conn.close()