Python SQL example

db_example.py

from cs50 import SQL

db = SQL("sqlite:///students.db")

name = input("Name: ")
student_id = db.execute("INSERT INTO people (name) VALUES (?)", name)

course_id = int(input("Course id: "))
results = db.execute("SELECT id FROM courses WHERE id = ?", course_id)
if len(results) == 0:
    print(f"No course number {course_id}")
else:
    results = db.execute("INSERT INTO enrollment (course_id, person_id) VALUES (?, ?)", course_id, student_id)
    print(results)