def get_student_information(nuid):
student_information_query = "SELECT * FROM students WHERE nuid = '%d'" % int(nuid)
db_connection = DatabaseConnection.initiate_database_connection()
cursor = db_connection.cursor()
cursor.execute(student_information_query)
student_information_result = cursor.fetchone()
cursor.close()
DatabaseConnection.exit_database_connection(db_connection)
return student_information_result
def add_student_information(nuid):
first_name = input("Enter your first name: ")
last_name = input("Enter your last name: ")
level_study = input("Enter the level of study: ")
department = input("Enter what department you are in: ")
add_student_query = "INSERT INTO students " \
"(studentAccount_nuid, firstName, lastName, level, department)" \
"VALUES (%s, %s, %s, %s, %s)"
data_student = (nuid, first_name, last_name, level_study, department)
db_connection = DatabaseConnection.initiate_database_connection()
cursor = db_connection.cursor()
cursor.execute(add_student_query, data_student)
cursor.close()
DatabaseConnection.exit_database_connection(db_connection)
def get_student_account(username, password):
db_connection = DatabaseConnection.initiate_database_connection()
cursor = db_connection.cursor()
student_account_sql = "SELECT * FROM studentAccount " \
"WHERE username = %s "
data_student_account = (username, )
cursor.execute(student_account_sql, data_student_account)
student_account_result = cursor.fetchone()
cursor.close()
DatabaseConnection.exit_database_connection(db_connection)
if student_account_result and check_password_matches(
student_account_result[2], password):
return StudentAccount(int(student_account_result[0]), username,
password)
else:
return
def add_student_account():
username = input("Enter username: "******"Enter password: "******"INSERT INTO studentAccount (username, password)" \
"VALUES (%s, %s)"
hashed_password = hash_password(password)
student_account_data = (username, hashed_password)
db_connection = DatabaseConnection.initiate_database_connection()
cursor = db_connection.cursor()
cursor.execute(add_student_account_query, student_account_data)
cursor.close()
DatabaseConnection.exit_database_connection(db_connection)
# adding student information after their account has been create
student_account = StudentAccount.get_student_account(
username, password)
StudentInformation.add_student_information(student_account.nuid)
from database_connection import DatabaseConnection
db_connection = DatabaseConnection.initiate_database_connection()
#cursor
cursor = db_connection.cursor()
#create a database
db = "CREATE DATABASE IF NOT EXISTS UNL"
cursor.execute(db)
#Drop the table when needed
# sql = "DROP TABLE UNL.userAccount"
# cursor.execute(sql)
#create table
studentInformationtable = "CREATE TABLE IF NOT EXISTS UNL.students (nuid INT PRIMARY KEY," \
" firstName VARCHAR(255)," \
" lastName VARCHAR(255)," \
" level VARCHAR(255)," \
" department VARCHAR(255))"
studentAccountTable = "CREATE TABLE IF NOT EXISTS UNL.studentAccount (nuid INT PRIMARY KEY," \
" username VARCHAR(255)," \
" password VARCHAR(255))"
cursor.execute(studentInformationtable)
cursor.execute(studentAccountTable)
