connection.py

#sqlite connection

import sqlite3
connection = sqlite3.connect('database.db')
print("Opened database successfully")

conn = connection.cursor()
conn.execute('''
             CREATE TABLE IF NOT EXISTS users (
                 id INTEGER PRIMARY KEY AUTOINCREMENT,
                 name TEXT NOT NULL,
                 email TEXT NOT NULL,
                 password TEXT NOT NULL
             );''')

print("Table created successfully")

conn.execute('''
             INSERT INTO users (name, email, password)
             VALUES ('John Doe', 'bqN2j@example.com', 'password123'),
                    ('GGPw', '4Vq0O@example.com', 'password456');
                     ''')
           
print("Record inserted successfully")

conn.execute('''
             SELECT * FROM users;
             ''')

print("Record selected successfully")

results = conn.fetchall()
for row in results:
    print(row)


conn.close()
connection.close()