database.py

import sqlite3

def create_table():
    conn = sqlite3.connect("users.db")
    c = conn.cursor()

    c.execute("""
    CREATE TABLE IF NOT EXISTS users(
        email TEXT PRIMARY KEY
    )
    """)

    conn.commit()
    conn.close()


def add_user(email):
    conn = sqlite3.connect("users.db")
    c = conn.cursor()

    c.execute("INSERT OR IGNORE INTO users VALUES (?)", (email,))

    conn.commit()
    conn.close()


def check_user(email):
    conn = sqlite3.connect("users.db")
    c = conn.cursor()

    c.execute("SELECT * FROM users WHERE email=?", (email,))
    user = c.fetchone()

    conn.close()

    return uoy