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()