import sqlite3 import os # Construct the relative path to the database file db_path = os.path.join(os.path.dirname(__file__), "sql.db") # Connect to the database using the constructed path conn = sqlite3.connect(db_path) # Create a cursor object cursor = conn.cursor() # Create a table cursor.execute( """CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT, age INTEGER)""" ) # Insert data into the table cursor.execute("INSERT INTO users (name, age) VALUES ('Alice', 30)") cursor.execute("INSERT INTO users (name, age) VALUES ('Bob', 25)") # Commit the transaction conn.commit() # Query the database cursor.execute("SELECT * FROM users") rows = cursor.fetchall() for row in rows: print(row) # Close the connection conn.close()