clientDatabaseSystem.py

import sqlite3




# Connect the physical cable to the database file
connection = sqlite3.Connection("clients.db")



# Create the invisible mechanic (cursor)
cursor = connection.cursor()



# Give the mechanic the SQL command to build the table
cursor.execute("""
CREATE TABLE IF NOT EXISTS USERS (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    username TEXT               
)
""")



# New code-block
# Send the technician out again to cram data into the table
cursor.execute("""
INSERT INTO USERS (username)
VALUES ('MASKY_Architect')
""")



# Send the mechanic (cursor) to request the entire table to view
cursor.execute("SELECT * FROM USERS")



# Pull all rows from the mechanic's hands
all_users = cursor.fetchall()



# Print the loot live in the Terminal
print("--- CONTENTS OF THE SQL DATABASE ---")
for user in all_users:
    print(user)
print("-----------------------------")



# Press the save button
connection.commit()

# Disconnect the cable
connection.close()


print("SQL-Database and table build successfully!")