1zTP8NLs

1import sqlite3
2
3
4
5def create_table(conn, create_table_sql):
6    """ create a table from the create_table_sql statement
7    :param conn: Connection object
8    :param create_table_sql: a CREATE TABLE statement
9    :return:
10    """
11    try:
12        c = conn.cursor()
13        c.execute(create_table_sql)
14    except Error as e:
15        print(e)
16
17
18
19
20def create_member(conn, newMember):
21 
22    sql = ''' INSERT INTO tomtePeople(id,name,hasbeen)
23              VALUES(?,?,?) '''
24    cur = conn.cursor()
25    cur.execute(sql, newMember)
26    return cur.lastrowid
27
28
29
30
31def select_all_members(conn):
32    cur = conn.cursor()
33    cur.execute("SELECT * FROM tomtePeople")
34 
35    rows = cur.fetchall()
36 
37    for row in rows:
38        print(row)
39
40
41
42
43conn = sqlite3.connect('tomteLista.db')
44
45
46 
47sql_create_projects_table = """ CREATE TABLE IF NOT EXISTS tomtePeople (
48                                    id integer PRIMARY KEY,
49                                    name text NOT NULL,
50									hasbeen bool NOT NULL
51                                ); """
52								
53								
54create_table(conn, sql_create_projects_table)
55
56newMember_1 = (1,'Steffan',0)
57newMember_2 = (2,'Erik',0)
58newMember_3 = (3,'Sofie',0)
59newMember_4 = (4,'Jonas',0)
60newMember_5 = (5,'Petrus',0)
61newMember_6 = (6,'Simon',0)
62 
63create_member(conn, newMember_1)
64create_member(conn, newMember_2)
65create_member(conn, newMember_3)
66create_member(conn, newMember_4)
67create_member(conn, newMember_5)
68create_member(conn, newMember_6)
69
70select_all_members(conn)