How to use SQLite3 in Python3.

sqlite_sample.py

import sqlite3

conn = sqlite3.connect("sqlite3.db")
sql = "drop table test"
conn.execute(sql)

sql = """create table test (
  key int,
  value varchar(20)
)"""
conn.execute(sql)

sql = "insert into test values (1, 'aaa')"
conn.execute(sql)
sql = "insert into test values (2, 'bbb')"
conn.execute(sql)
sql = "insert into test values (3, 'ccc')"
conn.execute(sql)
conn.commit()

cursor = conn.cursor()
sql = "select key, value from test"
cursor.execute(sql)
rows = cursor.fetchall()
for row in rows:
  key, value = row 
  print(str(key) + ':' + value)

conn.close()