# --------------------------------------------------------
# -- Databases => SQLite => Very Important Informations --
# --------------------------------------------------------
# Import SQLite Module
import sqlite3
# Create Database And Connect
db = sqlite3.connect("app.db")
# Setting Up The Cursor
cr = db.cursor()
my_tuple = ('Pascal', '65', 4)
# Inserting Data
# cr.execute("insert into skills values(?, ?, ?)", my_tuple)
# Fetch Data From Database
# cr.execute("select * from skills order by name limit 3 offset 2")
# cr.execute("select * from skills where user_id > 1")
cr.execute("select * from skills where user_id not in(1, 2, 3)")
# Assign Data To Variable
results = cr.fetchall()
# Loop On Results
for row in results:
print(f"Skill Name => {row[0]},", end=" ")
print(f"Skill Progress => {row[1]},", end=" ")
print(f"User ID => {row[2]}")
# Save (Commit) Changes
db.commit()
# Close Database
db.close()