createの例
import sqlite3
connection = sqlite3.connect('test.db')
cursor = connection.cursor()
cursor.execute('create table kokyaku (id int, name varchar(64))')
connection.commit()
connection.close()
insertの例
import sqlite3
connection = sqlite3.connect('test.db')
cursor = connection.cursor()
kokyaku_data = [
(1, 'ペガ'),
(2, 'ドラコ'),
(3, 'グリ'),
]
for kokyaku in kokyaku_data:
cursor.execute('insert into kokyaku values (?, ?)', kokyaku)
connection.commit()
connection.close()
selectの例
import sqlite3
connection = sqlite3.connect('test.db')
cursor = connection.cursor()
for row in cursor.execute('select * from kokyaku'):
print(row)
connection.close()