import sqlite3

conn = sqlite3.connect('database.db')

cursor = conn.cursor()

create_table = '''
    CREATE TABLE IF NOT EXISTS users (
        id INTEGER PRIMARY KEY,
        name TEXT NOT NULL,
        email TEXT NOT NULL UNIQUE
    )
'''

cursor.execute(create_table)

conn.commit()
conn.close()

import sqlite3

conn = sqlite3.connect('database.db')

cursor = conn.cursor()

insert_query = '''
    INSERT INTO users (name, email)
    VALUES (?, ?)
'''

data = ('kim', '[email protected]')
cursor.execute(insert_query, data)

conn.commit()
conn.close()

import sqlite3

conn = sqlite3.connect('database.db')

cursor = conn.cursor()

select_query = '''
    SELECT * FROM users
'''

cursor.execute(select_query)
rows = cursor.fetchall()

for row in rows:
    print(row)

conn.close()

import sqlite3

conn = sqlite3.connect('database.db')

cursor = conn.cursor()

delete_query = '''
    DELETE FROM users WHERE id = ?
'''

data = (1,)
cursor.execute(delete_query, data)

conn.commit()
conn.close()