# DO NOT copy this pattern. It shows why user input must never be pasted into SQL.
# Same query as r4-python-bridge.py, but built with an f-string.
# Try a real name (Stage Band), then try:  x' OR '1'='1
import sqlite3

DATABASE = 'ridgeview.db'


def get_roll_unsafe(activity_name):
    conn = sqlite3.connect(DATABASE)
    cursor = conn.cursor()

    sql = f"""SELECT Student.FirstName, Student.LastName, Student.Email
              FROM Student, Registration, Activity
              WHERE Student.StudentID = Registration.StudentID
                AND Registration.ActivityID = Activity.ActivityID
                AND Activity.ActivityName = '{activity_name}';"""

    print("The SQL that actually ran:\n" + sql)
    cursor.execute(sql)
    records = cursor.fetchall()
    conn.close()
    return records


activity = input("Activity name: ")
records = get_roll_unsafe(activity)
print(f"\n{len(records)} rows returned")
