ubi3e9mk

1from config import conn
2
3cursor = conn.cursor()
4
5
6def create_table():
7    CREATE_TABLE = """
8    CREATE TABLE IF NOT EXISTS students1(
9        id VARCHAR(40),
10        name VARCHAR(40),
11        age INTEGER,
12        year INTEGER
13    )
14    """
15    cursor.execute(CREATE_TABLE)
16    conn.commit()
17
18def insert_table(name, hex, id):
19    cursor.execute(f"INSERT INTO colors VALUES('{name}','{hex}', {id})")
20    conn.commit()
21
22insert_table("GREEN", "#00ff00", 2)
23def select_table():
24    cursor.execute("SELECT * FROM colors")
25    data = cursor.fetchall()
26    return data
27
28create_table()
29print(select_table())