1 import sqlite3
2
3 dbpath = "test.sqlite"
4 conn = sqlite3.connect(dbpath)
5
6 cur = conn.cursor()
7 cur.executescript("""
8 DROP TABLE IF EXISTS items;
9
10 CREATE TABLE items(
11 item_id INTEGER PRIMARY KEY,
12 name TEXT UNIQUE,
13 price INTEGER
14 );
15
16 INSERT INTO items(name, price)VALUES('Apple', 800);
17 INSERT INTO items(name, price)VALUES('Orange',780);
18 INSERT INTO items(name, price)VALUES('Banana',430);
19 """)
20
21 conn.commit()
22
23 cur= conn.cursor()
24 cur.execute("SELECT item_id, name, price FROM items")
25 item_list = cur.fetchall()
26
27 for it in item_list:
28 print(it)
반응형