def createCourse(self, names, semester):
cursor = mysql.get_db().cursor()
cursor.execute('INSERT INTO courses (name,semester) VALUES (%s,%s)', (
names,
semester,
))
mysql.get_db().commit()
cursor.close()
def createCourse(self, materia, semestre):
cursor = mysql.get_db().cursor()
cursor.execute(
'INSERT INTO materias (materia,semestre) VALUES (%s,%s)', (
materia,
semestre,
))
mysql.get_db().commit()
cursor.close()
def createSession(self, course, date, starttime, endtime):
cursor = mysql.get_db().cursor()
cursor.execute(
'INSERT INTO session (course,date,start_time,end_time) VALUES (%s,%s,%s,%s)',
(
course,
date,
starttime,
endtime,
))
mysql.get_db().commit()
cursor.close()
def updateStudents(self, names, lastnames, phone, email, semester, id):
cursor = mysql.get_db().cursor()
cursor.execute(
"UPDATE students SET names = %s, lastnames = %s, phone = %s, email = %s, semester = %s WHERE id = %s",
(
names,
lastnames,
phone,
email,
semester,
id,
))
mysql.get_db().commit()
cursor.close()
def createStudents(self, uid, names, lastnames, phone, email, semester,
course):
cursor = mysql.get_db().cursor()
cursor.execute(
'INSERT INTO students (uid, names,lastnames,phone,email,semester, course) VALUES (%s, %s,%s,%s,%s,%s,%s)',
(
uid,
names,
lastnames,
phone,
email,
semester,
course,
))
mysql.get_db().commit()
cursor.close()
def createStudents(self, uid, nombre, apellido, telefono, email, semestre,
curso):
cursor = mysql.get_db().cursor()
cursor.execute(
'INSERT INTO registro_estudiantes (uid, nombre,apellido,telefono,email,semestre, curso) VALUES (%s, %s,%s,%s,%s,%s,%s)',
(
uid,
nombre,
apellido,
telefono,
email,
semestre,
curso,
))
mysql.get_db().commit()
cursor.close()
def listStudentsUnique(self, id):
cursor = mysql.get_db().cursor()
cursor.execute("SELECT * FROM registro_estudiantes WHERE id = %s",
(id, ))
students = cursor.fetchone()
cursor.close()
return students
def updateStudents(self, uid, nombre, apellido, telefono, email, semestre,
curso, id):
cursor = mysql.get_db().cursor()
cursor.execute(
"UPDATE registro_estudiantes SET uid = %s, nombre = %s, apellido = %s, telefono = %s, email = %s, semestre = %s, curso = %s WHERE id = %s",
(
uid,
nombre,
apellido,
telefono,
email,
semestre,
curso,
id,
))
mysql.get_db().commit()
cursor.close()
def listSessions(self):
cursor = mysql.get_db().cursor()
cursor.execute("SELECT * FROM session")
sessions = cursor.fetchall()
cursor.close()
return sessions
def deleteCourse(self, id):
cursor = mysql.get_db().cursor()
cursor.execute("DELETE FROM courses WHERE id = %s", (id, ))
mysql.get_db().commit()
cursor.close()
def listCourses(self):
cursor = mysql.get_db().cursor()
cursor.execute("SELECT * FROM courses")
courses = cursor.fetchall()
cursor.close()
return courses
def listStudents(self):
cursor = mysql.get_db().cursor()
cursor.execute("SELECT * FROM students")
students = cursor.fetchall()
cursor.close()
return students
def deleteStudents(self, id):
cursor = mysql.get_db().cursor()
cursor.execute("DELETE FROM students WHERE id = %s", (id, ))
mysql.get_db().commit()
cursor.close()