Fj6Rbn9y

1import sqlite3
2
3conn = sqlite3.connect("test.db")
4
5cursor = conn.cursor()
6
7create_db = 'CREATE TABLE IF NOT EXISTS users (id INTEGER NOT NULL ' \
8            'PRIMARY KEY AUTOINCREMENT, login VARCHAR(200), password VARCHAR(200),' \
9            'favourite_team VARCHAR(300), favourite_number INTEGER )'
10
11cursor.execute(create_db)
12
13conn.commit()
14
15insert_user = 'INSERT INTO users VALUES (1,"Vasya","Vasya123","Суслики",13)'
16
17cursor.execute(insert_user)
18conn.commit()
19
20get_users = "SELECT * FROM users"
21cursor.execute(get_users)
22
23result = cursor.fetchall()
24
25print(result)