database.py

import sqlite3

# Create or connect to an SQLite3 database
conn = sqlite3.connect("db.sqlite3")  # This creates db.sqlite3 if it doesn't exist
cursor = conn.cursor()

# Create a sample table
cursor.execute('''

    CREATE TABLE IF NOT EXISTS users (

        id INTEGER PRIMARY KEY AUTOINCREMENT,

        name TEXT NOT NULL,

        email TEXT UNIQUE NOT NULL

    )

''')

# Commit changes and close connection
conn.commit()
conn.close()

print("Database and table created successfully!")