def removeUserFromCourse(idcourses, idusers):
cursor = mydb.cursor()
print(idcourses, ' -- ', idusers)
for iduser in idusers:
query_string = "DELETE FROM userscourses WHERE idusers = %s AND idcourses = %s"
# "INSERT INTO userscourses(idusers, idcourses) VALUES (%s ,%s)"
# try:
cursor.execute(query_string, (str(iduser), str(idcourses)))
# accept the change
# cursor.commit()
# except Error as error:
# print(error)
# finally:
# cursor.close()
# conn.close()
# cursor.execute(query_string, (str(iduser),str(idcourses)))
mydb.commit()
print('Removed TA Success!')
# query_string = "INSERT INTO "+idcourses+"(idusers) VALUES (%s)"
# cursor.execute(query_string, (str(iduser),))
mydb.commit()
cursor.execute('SELECT * FROM userscourses')
records = cursor.fetchall()
for record in records:
print(record)
def addUserInCourse(idcourses, idusers):
cursor = mydb.cursor()
for iduser in idusers:
query_string = "INSERT INTO userscourses(idusers, idcourses) VALUES (%s ,%s)"
cursor.execute(query_string, (str(iduser), str(idcourses)))
mydb.commit()
print('Adding TA Success!')
def addStudentInCourse(idcourses, idusers):
cursor = mydb.cursor()
for iduser in idusers:
query_string = "INSERT INTO userscourses(idusers, idcourses) VALUES (%s ,%s)"
cursor.execute(query_string, (str(iduser), str(idcourses)))
query_string = "INSERT INTO " + idcourses + "(idusers,marks) VALUES (%s,-1)"
cursor.execute(query_string, (str(iduser), ))
mydb.commit()
print('Adding Student Success!')
def deleteStudentMarks(idcourses, idusers):
cursor = mydb.cursor()
for i in range(0, len(idusers)):
query_string = "UPDATE " + idcourses + ' SET marks = %s WHERE idusers = %s'
cursor.execute(query_string, (
'-1',
str(idusers[i]),
))
mydb.commit()
print('Marks Successfully Updated!')
def insertEditedMarksInCourse(idcourses, idusers, marks):
cursor = mydb.cursor()
for i in range(0, len(idusers)):
try:
marks[i] = float(marks[i])
query_string = "UPDATE " + idcourses + ' SET marks = %s WHERE idusers = %s'
cursor.execute(query_string, (
str(marks[i]),
str(idusers[i]),
))
mydb.commit()
except ValueError:
print('Non Int Input, not updated!')
print('Marks Successfully Updated!')
def createNewUser(name, emailid, password, salt):
res = 'Email-id already exists!'
cursor = mydb.cursor()
query_string = "SELECT * FROM users WHERE emailid = %s"
cursor.execute(query_string, (emailid, ))
emchk = cursor.fetchall()
if (len(emchk) == 0):
query_string = "INSERT INTO users(name,emailid,password,salt) VALUES (%s ,%s, %s, %s)"
try:
cursor.execute(query_string,
(str(name), str(emailid), str(password), str(salt)))
res = 'Adding user Success!'
mydb.commit()
except:
res = 'Some Database Error'
print(res)
return res
def accountRoleApproval(notnonedata):
cursor = mydb.cursor()
for i in range(0, len(notnonedata)):
idroles = getRoleIdByName(notnonedata[i][1])
try:
query_string = "UPDATE users SET idroles = %s WHERE idusers = %s"
cursor.execute(query_string, (
str(idroles),
str(notnonedata[i][0]),
))
mydb.commit()
except ValueError:
print('Database error, not updated!')
return 'Some Database Error'
res = 'Roles Assigned Success!'
print(res)
return res
def addNewCourse(idcourses, coursesname):
courses = getAllExistingCourses()
flag = True
for i in courses:
if (i[0] == idcourses):
flag = False
res = 'Course ID already existing!'
if (flag):
cursor = mydb.cursor()
query_string = "INSERT INTO courses(idcourses,coursesname) VALUES (%s ,%s)"
try:
cursor.execute(query_string, (str(idcourses), str(coursesname)))
res = 'Adding Courses Success!'
mydb.commit()
except:
res = 'Some Database Error'
print(res)
return res
return res
