WiPP4fPw

1import sqlite3
2import sys
3
4conn = sqlite3.connect('testdb.db')
5c = conn.cursor()
6
7sql = '''
8CREATE TABLE IF NOT EXISTS user(
9    id integer primary key,
10    name text,
11    auth integer,
12    registdate text
13    );
14'''
15
16c.execute(sql)
17
18sql = "INSERT OR IGNORE INTO user  VALUES(1,'taro tanaka',0,'2016-10-01');"
19
20conn.execute(sql)
21conn.commit()
22
23sql = "SELECT * FROM user;"
24
25result = c.execute(sql)
26for row in result:
27    print("id="+str(row[0])+",name="+row[1])
28
29sql = "SELECT count(*) FROM user;"
30
31result = c.execute(sql)
32for row in result:
33    print(row[0])
34
35sql = "DELETE FROM user WHERE id = 1;"
36c.execute(sql)  
37      
38c.close()
39conn.close()