Permissions

[vanessacodes25]

import sqlite3

conn = sqlite3.connect("users.db")
cursor = conn.cursor()

cursor.execute("""
CREATE TALBE IF NOT EXIST users (
id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT UNIQUE NOT NULL, permisssion TEXT)""")

cursor.execute("INSERT OR IGNORE INTO user (username, permission) VALUES (?,?)", ("alice", "read,write"))
cursor.execute("INSERT OR IGNORE INTO user (username, permission) VALUES (?,?)", ("bob", "read"))
conn.commit

def get_user_permission(username):
cursor.execute("SELECT permission FORM users WHERE username = ?", (username,))
result = cursor.fetchone()
return result[0].split(",") if result else []

print("Alice permission:", get_user_permission("alice"))
print("Bob permission:", get_user_permission("bob"))

conn.close()