#!/usr/bin/env python3
import sqlite3
 
# sqlite3へ接続し、"myfriend.sqlite3"と言う名前のデータベースファイルを作成
slc = sqlite3.connect("myfriend.sqlite3")
 
# データベース・カーソルを作成
cur = slc.cursor()
 
# cur.execute で接続したデータベースへとSQLを転送する
cur.execute("create table user(id integer, name text, old integer, address text)")
[cur.execute(x) for x in ["insert into user values(1, 'Yamada', 19, 'Tokyo')",
                          "insert into user values(3, 'Mori', 32, 'Kyoto')",
                          "insert into user values(5, 'Ueda', 27, 'Tokyo')",
                          "insert into user values(6, 'Mitsui', 20, 'Nagoya')"]]
[print(row) for row in cur.execute("select * from user")]
 
# sqlite3との接続を停止する
slc.close()

IyEvdXNyL2Jpbi9lbnYgcHl0aG9uMwppbXBvcnQgc3FsaXRlMwoKIyBzcWxpdGUz44G45o6l57aa44GX44CBIm15ZnJpZW5kLnNxbGl0ZTMi44Go6KiA44GG5ZCN5YmN44Gu44OH44O844K/44OZ44O844K544OV44Kh44Kk44Or44KS5L2c5oiQCnNsYyA9IHNxbGl0ZTMuY29ubmVjdCgibXlmcmllbmQuc3FsaXRlMyIpCgojIOODh+ODvOOCv+ODmeODvOOCueODu+OCq+ODvOOCveODq+OCkuS9nOaIkApjdXIgPSBzbGMuY3Vyc29yKCkKCiMgY3VyLmV4ZWN1dGUg44Gn5o6l57aa44GX44Gf44OH44O844K/44OZ44O844K544G444GoU1FM44KS6Lui6YCB44GZ44KLCmN1ci5leGVjdXRlKCJjcmVhdGUgdGFibGUgdXNlcihpZCBpbnRlZ2VyLCBuYW1lIHRleHQsIG9sZCBpbnRlZ2VyLCBhZGRyZXNzIHRleHQpIikKW2N1ci5leGVjdXRlKHgpIGZvciB4IGluIFsiaW5zZXJ0IGludG8gdXNlciB2YWx1ZXMoMSwgJ1lhbWFkYScsIDE5LCAnVG9reW8nKSIsCiAgICAgICAgICAgICAgICAgICAgICAgICAgImluc2VydCBpbnRvIHVzZXIgdmFsdWVzKDMsICdNb3JpJywgMzIsICdLeW90bycpIiwKICAgICAgICAgICAgICAgICAgICAgICAgICAiaW5zZXJ0IGludG8gdXNlciB2YWx1ZXMoNSwgJ1VlZGEnLCAyNywgJ1Rva3lvJykiLAogICAgICAgICAgICAgICAgICAgICAgICAgICJpbnNlcnQgaW50byB1c2VyIHZhbHVlcyg2LCAnTWl0c3VpJywgMjAsICdOYWdveWEnKSJdXQpbcHJpbnQocm93KSBmb3Igcm93IGluIGN1ci5leGVjdXRlKCJzZWxlY3QgKiBmcm9tIHVzZXIiKV0KCiMgc3FsaXRlM+OBqOOBruaOpee2muOCkuWBnOatouOBmeOCiwpzbGMuY2xvc2UoKQ==