Skip to content

Instantly share code, notes, and snippets.

Last active Apr 30, 2020
What would you like to do?
IT Fundamentals Final Project
import sqlite3
def verify_user():
verify if user input correct username/password
if True then run get_data function else program ends
print("Student Exam Score Result")
print("Please type in your username and password to access result")
username = input("Username: ")
password = input("Password: ")
if username == "admin" and password == "2020":
print("Your username or password is incorrect")
def get_data():
connect to database and get data
format and present result in console
conn = sqlite3.connect("university.db")
cur = conn.cursor()
cur.execute("SELECT id, firstname, exam_score FROM student;")
result = cur.fetchall()
print("Student Exam Score Report")
print("=" * 30)
for row in result:
print(f"name: {row[1]} \texam score: {row[2]}")
def main():
"""our main program"""
if __name__ == "__main__":
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment