def change_sgstatus(self, sg_url):
try:
query = "SELECT SgStatus from `STUDY_GROUP` WHERE SgUrl = %s"
self.sesh.cursor.execute(query, sg_url)
result = self.sesh.cursor.fetchone()
print(result)
status = result['SgStatus']
print("Current Status is: ", status)
while(True):
status = input("Enter Status [Completed/Active/Planned]: ")
if(status == "Completed" or status == "Active" or status == "Planned"):
break
else:
print("Invalid input. Try again!")
update = "UPDATE `STUDY_GROUP` SET SgStatus = %s WHERE SgUrl = %s"
self.sesh.cursor.execute(update, (status, sg_url))
self.sesh.connection.commit()
except Exception as e:
#print(e)
univutil.ask_user_action(self.change_sgstatus)
else:
print("Status updated successfully!")
input()
return
def create_event(self, sg_url):
try:
query = "SELECT COUNT(*) FROM `SG_EVENT` WHERE SgUrl = %s"
self.sesh.cursor.execute(query, sg_url)
event_number = self.sesh.cursor.fetchone()["COUNT(*)"]
attrE = {
"Event Title" : "",
"Event Info." : ""
}
for attribute in attrE:
while(attrE[attribute]==""):
attrE[attribute] = input(attribute+": ")
query = "INSERT INTO `SG_EVENT` (SgUrl, EventNum, EventTitle, EventInfo) VALUES (%s, %s, %s, %s);"
self.sesh.cursor.execute(query, (sg_url, event_number, attrE["Event Title"], attrE["Event Info."]))
self.sesh.connection.commit()
except Exception as e:
#print(e)
univutil.ask_user_action(self.create_event)
else:
selection = 0
while(selection!="1" and selection!="2"):
print("Enter 1 for Meet and 2 for Target: ")
selection = input()
if(selection=="1"):
self.create_meet(sg_url, event_number)
elif(selection=="2"):
self.create_target(sg_url, event_number)
input()
return
def befriend(self):
try:
attributes = {
"Friend2Name" : "",
"Friend2DNum" : ""
}
for attribute in attributes:
while(attributes[attribute]==""):
if(attribute == 'Friend2DNum'):
attributes[attribute] = int(input(attribute+": "))
else:
attributes[attribute] = input(attribute+": ")
query = "INSERT INTO `FRIENDS_WITH` (Friend1Name,Friend1DNum,Friend2Name,Friend2DNum) VALUES (%s,%s,%s,%s)"
self.sesh.cursor.execute(query, (attributes["Friend2Name"],attributes["Friend2DNum"],self.current_user[0],self.current_user[1]))
self.sesh.cursor.execute(query, (self.current_user[0],self.current_user[1], attributes["Friend2Name"],attributes["Friend2DNum"]))
self.sesh.connection.commit()
except Exception as e:
#print(e)
univutil.ask_user_action(self.befriend)
return
def rate_sg(self):
try:
sgquery = "SELECT SgUrl FROM MEMBER_OF WHERE UserSgRole = 'Member' AND UserName = '******' AND DNum = %d" % (self.current_user[0], self.current_user[1])
self.sesh.cursor.execute(sgquery)
if(self.sesh.cursor.rowcount==0):
print("You are not a member of any group :(")
return
result = self.sesh.cursor.fetchall()
print("You are a member of %d study groups" % (self.sesh.cursor.rowcount))
for sg in result:
print(sg["SgUrl"])
sg_url = input("Enter URL of Study Group to rate: ")
flag = 0
for sg in result:
if(sg["SgUrl"] == sg_url):
flag = 1
if(flag==0):
print("You are not a member of this group :(")
return
else:
print("Member rights authenticated!")
rating = -1
while(rating < 0 or rating > 10):
rating = int(input("Enter rating [0-10]: "))
query = "UPDATE MEMBER_OF SET UserSgRating = %d WHERE UserName = '******' AND DNum = %d AND SgUrl = '%s'" % (rating, self.current_user[0], self.current_user[1], sg_url)
self.sesh.cursor.execute(query)
self.sesh.cursor.connection.commit()
input()
except Exception as e:
#print(e)
univutil.ask_user_action(self.rate_sg)
def update_interest(self):
try:
values = self.sesh.see_all("SUBJECT")
choice = input("Pick subject index: ")
while(True):
try:
choice = int(choice)
SubName = values[choice-1]['SubName']
break
except:
print("Error. Invalid index")
InterestType = ""
while(InterestType == ""):
InterestType = input('Modified Interest Type["Research" ,"Professional" , "Major" ,"Minor" ,"Casual"]: ')
if InterestType not in ["Research" ,"Professional" , "Major" ,"Minor" ,"Casual"]:
InterestType = ""
query = "UPDATE `HAS_INTEREST_IN` SET InterestType = '%s' WHERE UserName = '******' and DNum = %d and SubName = '%s'" %(InterestType,self.current_user[0],self.current_user[1],SubName)
self.sesh.cursor.execute(query)
self.sesh.connection.commit()
except Exception as e:
#print(e)
univutil.ask_user_action(self.update_interest)
return
def show_friends_details(self):
try:
name = input("Enter friends name: ")
all_users = f'SELECT CONCAT_WS(" ",FName, MName, SName) as Name, UserName, DNum FROM USER WHERE CONCAT(FName, MName, SName) like \'%{name}%\';'
self.sesh.cursor.execute(all_users)
result = self.sesh.cursor.fetchall()
if(univutil.table_format(result) == 0):
print("No user with that name")
input()
except Exception as e:
univutil.ask_user_action(self.show_friends_details)
def view_user_posts(self):
try:
username = input("Enter UserName: "******"Enter DNum: "))
query = "SELECT PostTitle, PostContent, TimeStamp FROM POST WHERE UserName = '******' AND DNum = %d" % (username, dnum)
self.sesh.cursor.execute(query)
result = self.sesh.cursor.fetchall()
univutil.table_format(result)
input()
except Exception as e:
#print(e)
univutil.ask_user_action(self.view_user_posts)
def delete_course(self):
try:
values = self.sesh.see_all("COURSE")
choice = input("Enter course index: ")
choice = int(choice)
cname, corg, cplat = values[choice - 1]['CourseName'], values[
choice - 1]['CourseOrg'], values[choice - 1]['CoursePlatform']
sure = input("Are you sure? [y/n]: ")
if (sure == "n"):
return "Course not deleted"
sql_query = "DELETE FROM `COURSE_DIFFICULTY` WHERE CourseName = %s AND CourseOrg = %s AND CoursePlatform = %s"
self.sesh.cursor.execute(sql_query, (cname, corg, cplat))
self.sesh.connection.commit()
except:
univutil.ask_user_action(self.delete_course)
def update_usercontrib(self, sg_url):
try:
os.system("clear")
print("User List: ")
userquery = "SELECT UserName, DNum, UserSgRole FROM MEMBER_OF WHERE SgUrl = '%s'" % (sg_url)
self.sesh.cursor.execute(userquery)
result = self.sesh.cursor.fetchall()
univutil.table_format(result)
roles = ["Member", "Admin"]
roleidx = 0
flag = 0
while(flag==0):
username = input("Enter username: "******"Enter dnum"))
for r in result:
if(r["UserName"] == username and r["DNum"] == dnum):
flag = 1
if(r["UserSgRole"] == "Admin"):
roleidx = 1
if(flag==0):
print("No such user in study group, try again!")
contrib = -1
while(contrib < 0 or contrib > 10):
contrib = int(input("Contribution rating of user [1-10]: "))
contribquery = "UPDATE MEMBER_OF SET UserSgContrib = %s WHERE SgUrl = %s AND UserName = %s AND DNum = %s;"
self.sesh.cursor.execute(contribquery, (contrib, sg_url, username, dnum))
selection = 'X'
while(selection != 'Y' and selection != 'N'):
selection = input(f'Flip user role from {roles[roleidx]} to {roles[1-roleidx]} [Y/N]: ')
if(selection == 'Y'):
rolequery = "UPDATE MEMBER_OF SET UserSgRole = %s WHERE SgUrl = %s AND UserName = %s AND DNum = %s;"
self.sesh.cursor.execute(rolequery, (roles[1-roleidx], sg_url, username, dnum))
self.sesh.cursor.connection.commit()
except Exception as e:
#print(e)
univutil.ask_user_action(self.update_usercontrib)
else:
print("Contribution updated succesfully!")
input()
return
def make_post(self):
try:
query = "SELECT COUNT(*) FROM `POST` WHERE UserName = %s AND DNum = %s"
self.sesh.cursor.execute(query, (self.current_user[0], self.current_user[1]))
post_number = self.sesh.cursor.fetchone()["COUNT(*)"]
attrP = {
"Post Title" : "",
"Post Content" : ""
}
for attribute in attrP:
while(attrP[attribute]==""):
attrP[attribute] = input(attribute+": ")
post_type = ""
while(post_type!="Review" and post_type!="Blog"):
post_type = input("Type [Review/Blog]: ")
sql = "INSERT INTO `POST` "
if(post_type == "Review"):
attrR = {
"CourseID" : "",
"Rate course [1-10]" : ""
}
for attribute in attrR:
while(attrR[attribute]==""):
attrR[attribute] = input(attribute+": ")
sql += "(`UserName`, `DNum`, `PostNumber`, `PostTitle`, `PostContent`, "
sql += "`Type`, `CourseID`, `ReviewRating`) VALUES ( %s, %s, %s, %s, %s, %s, %s, %s );"
self.sesh.cursor.execute(sql, (self.current_user[0], self.current_user[1], post_number, attrP["Post Title"],
attrP["Post Content"], post_type, attrR["CourseID"], attrR["Rate course [1-10]"]))
else:
sql += "(`UserName`, `DNum`, `PostNumber`, `PostTitle`, `PostContent`, `Type`) VALUES ( %s, %s, %s, %s, %s, %s );"
self.sesh.cursor.execute(sql, (self.current_user[0], self.current_user[1], post_number, attrP["Post Title"],
attrP["Post Content"], post_type))
tag = input("Enter tag: ")
tag_sql = "INSERT INTO BLOGTAG VALUES(%s, %s, %s, %s)"
self.sesh.cursor.execute(tag, self.current_user[0], self.current_user[1], post_number)
self.sesh.connection.commit()
input()
except Exception as e:
#print(e)
univutil.ask_user_action(self.make_post)
return
def create_pin(self, sg_url):
try:
attrP = {
"Pinned Info" : "",
}
for attribute in attrP:
while(attrP[attribute]==""):
attrP[attribute] = input(attribute+": ")
query = "INSERT INTO `PINS` (SgUrl, PinDetails) VALUES (%s, %s)"
self.sesh.cursor.execute(query, (sg_url, attrP["Pinned Info"]))
self.sesh.connection.commit()
except Exception as e:
#print(e)
univutil.ask_user_action(self.create_pin)
input()
return
def add_subject(self):
try:
print('ADDING SUBJECT')
attributes = {"Subject Name: ": ""}
for attribute in attributes:
while (attributes[attribute] == ""):
attributes[attribute] = input(attribute)
query = "INSERT INTO `SUBJECT` VALUES ('%s');" % (
attributes["Subject Name: "])
self.sesh.cursor.execute(query)
self.sesh.connection.commit()
return "Added subject"
except Exception as e:
##print(e)
univutil.ask_user_action(self.add_subject)
def add_user(self):
try:
os.system('clear')
print("ADD NEW USER")
username = input("Username*: ")
dnum = self.sesh.get_number(username, "USER", "UserName")
fname = input("First Name*: ")
mname = input("Middle Name: ")
if (mname == ""):
mname = None
lname = input("Last Name*: ")
dob = input("Date of Birth (YYYY-MM-DD))*: ")
email = input("Email*: ")
password = input("Password*: ")
sql = "INSERT INTO `USER` values (%s, %s, %s, %s, %s, %s, %s, %s);"
self.sesh.cursor.execute(
sql,
(username, dnum, fname, mname, lname, dob, email, password))
values = self.sesh.see_all("LANGUAGE")
numberOfLanguagesKnown = 0
while (numberOfLanguagesKnown <= 0):
numberOfLanguagesKnown = int(
input("Enter Number of languages known[atleast one]: "))
for _ in range(numberOfLanguagesKnown):
self.add_languageKnown(username, dnum, values)
values = self.sesh.see_all("SUBJECT")
numberOfSubjectInterest = 0
while numberOfSubjectInterest <= 0:
numberOfSubjectInterest = int(
input("Enter Number of Subject Interest[atleast one]: "))
for _ in range(numberOfSubjectInterest):
self.add_subjectInterest(username, dnum, values)
self.sesh.connection.commit()
print(f'Registered succesfully! Username: {username} DNum: {dnum}')
input()
except Exception as e:
#print(e)
univutil.ask_user_action(self.add_user)
return "Added user"
def create_target(self, sg_url, event_num):
try:
attrT = {
"Deadline YYYY/MM/DD HH/MI/SS" : "",
}
for attribute in attrT:
while(attrT[attribute]==""):
attrT[attribute] = input(attribute+": ")
query = "INSERT INTO `TARGET` (SgUrl, EventNum, TargetDeadline) VALUES ('%s', '%s', '%s')" % (sg_url, event_num, attrT["Deadline YYYY/MM/DD HH/MI/SS"])
self.sesh.cursor.execute(query)
self.sesh.connection.commit()
print("Added Event Succesfully!")
input()
except Exception as e:
#print(e)
univutil.ask_user_action(self.create_target)
return
def add_language(self):
try:
print("ADDING LANGUAGE")
attributes = {'LangCode': "", 'LangName': ""}
for attribute in attributes:
while (attributes[attribute] == ""):
attributes[attribute] = input(attribute + ": ")
if attribute == 'LangCode':
while (len(attributes[attribute]) != 3):
print("LangCode should be of 3 characters")
attributes[attribute] = input(attribute + ": ")
query = "INSERT INTO `LANGUAGE` VALUES ('%s','%s')" % (
attributes['LangCode'], attributes['LangName'])
self.sesh.cursor.execute(query)
self.sesh.connection.commit()
return "Added subject"
except Exception as e:
#print(e)
univutil.ask_user_action(self.add_language)
def create_meet(self, sg_url, event_num):
try:
attrM = {
"Meet Time YYYY/MM/DD HH/MI/SS" : "",
"Meet Duration (mins)" : ""
}
for attribute in attrM:
while(attrM[attribute]==""):
attrM[attribute] = input(attribute+": ")
query = "INSERT INTO `MEET` (SgUrl, EventNum, MeetTime, MeetDuration) VALUES ('%s', '%s', '%s', '%s')" % (sg_url, event_num, attrM["Meet Time YYYY/MM/DD HH/MI/SS"], attrM["Meet Duration (mins)"])
self.sesh.cursor.execute(query)
self.sesh.connection.commit()
except Exception as e:
#print(e)
univutil.ask_user_action(self.create_meet)
else:
print("Added Event Succesfully!")
input()
return
def update_post(self):
try:
query = "SELECT `PostNumber`, `PostTitle`, `PostContent` FROM `POST` WHERE `UserName` = '%s' AND `DNum` = %d" % (self.current_user[0], self.current_user[1])
self.sesh.cursor.execute(query)
result = self.sesh.cursor.fetchall()
num_posts = self.sesh.cursor.rowcount
if(num_posts == 0):
print("Sorry, no posts exist to be updated!")
return
print(num_posts, "posts currently exist!")
post_num = num_posts
univutil.table_format(result)
while(post_num >= num_posts):
post_num = int(input("Enter the post number: "))
print("Post Title: ", result[post_num]["PostTitle"])
print("Post Content: ", result[post_num]["PostContent"])
print("Now, please enter your edited post details")
attrP = {
"Post Title" : "",
"Post Content" : ""
}
for attribute in attrP:
while(attrP[attribute]==""):
attrP[attribute] = input(attribute+": ")
attrP["Post Title"] += " [edited]"
update = "UPDATE `POST` SET `PostTitle` = %s, `PostContent` = %s WHERE `UserName` = %s AND `DNum` = '%s' AND `PostNumber` = '%s'"
self.sesh.cursor.execute(update, (attrP["Post Title"], attrP["Post Content"], self.current_user[0], self.current_user[1], post_num))
self.sesh.connection.commit()
input()
except Exception as e:
#print(e)
univutil.ask_user_action(self.update_post)
return
def delete_post(self):
try:
query = "SELECT `PostNumber`, `PostTitle`, `PostContent` FROM `POST` WHERE `UserName` = '%s' AND `DNum` = %d" % (self.current_user[0], self.current_user[1])
self.sesh.cursor.execute(query)
result = self.sesh.cursor.fetchall()
num_posts = self.sesh.cursor.rowcount
if(num_posts == 0):
print("Sorry, no posts exist to be deleted!")
return
print(num_posts, "posts currently exist!")
univutil.table_format(result)
post_num = num_posts
while(post_num >= num_posts):
post_num = int(input("Enter the post number to delete: "))
print("Are you sure you want to delete the following post: ")
print("Post Title: ", result[post_num]["PostTitle"])
print("Post Content: ", result[post_num]["PostContent"])
confirm = 'X'
while(confirm != 'Y' and confirm != 'N'):
confirm = input("I'm sure, delete [Y/N]: ")
if(confirm == 'N'):
return
sql = "DELETE FROM `POST` "
sql += "WHERE UserName = '******' AND DNum = '%s' AND PostNumber = '%s'" % (self.current_user[0], self.current_user[1], post_num)
self.sesh.cursor.execute(sql)
self.sesh.connection.commit()
input()
except Exception as e:
#print(e)
univutil.ask_user_action(self.delete_post)
return
def add_course(self):
try:
os.system("clear")
print("ADD NEW COURSE")
attributes = {
"Course Name: ": "",
"Course Org: ": "",
"Course Platform: ": "",
"Weekly Course Hours: ": "",
"Course Duration: ": ""
}
courseid_sql = "SELECT LAST_INSERT_ID();"
coursedifficulty = ""
for attribute in attributes:
while (attributes[attribute] == ""):
attributes[attribute] = input(attribute)
while (True):
coursedifficulty = input(
"Course Difficulty [1. Beginner/2. Intermediate/3. Expert]: "
)
if (coursedifficulty in ["1", "2", "3"]):
coursedifficulty = ["Beginner", "Intermediate",
"Expert"][int(coursedifficulty) - 1]
break
sql_difficulty = "INSERT INTO `COURSE_DIFFICULTY` (`CourseName`, `CourseOrg`, `CoursePlatform`, `CourseDifficulty`) values (%s, %s, %s, %s);"
sql_course = "INSERT INTO `COURSE` (`CourseName`, `CourseOrg`, `CoursePlatform`, `CourseHours`, `CourseDuration`) values (%s, %s, %s, %s, %s);"
self.sesh.cursor.execute(
sql_difficulty,
tuple(attributes.values())[:3] + (coursedifficulty, ))
self.sesh.cursor.execute(sql_course, tuple(attributes.values()))
self.sesh.cursor.execute(courseid_sql)
courseid = self.sesh.cursor.fetchone()['LAST_INSERT_ID()']
while (True):
subdub = ""
values = self.sesh.see_all("LANGUAGE")
choice = input("Pick language index: ")
while (True):
try:
choice = int(choice)
lang = values[choice - 1]['LangCode']
break
except:
print("Error. Invalid index")
while (subdub not in ["Native", "Sub", "Dub"]):
subdub = input("Language support [Native/Sub/Dub]: ")
if (subdub == "Native"):
subdub = None
sql_lang = "INSERT INTO `USED_FOR` values (%s, %s, %s)"
self.sesh.cursor.execute(sql_lang, (lang, courseid, subdub))
cont = input("More languages? [y/n]: ")
if (cont == "n"):
break
while (True):
values = self.sesh.see_all("SUBJECT")
choice = input("Pick subject index: ")
while (True):
try:
choice = int(choice)
subject = values[choice - 1]['SubName']
break
except:
print("Error. Invalid index")
sql_sub = "INSERT INTO `CONTAINS` values(%s, %s)"
self.sesh.cursor.execute(sql_sub, (subject, courseid))
cont = input("More subjects? [y/n]: ")
if (cont == "n"):
break
instructor = input("Add course instructor? [y/n]: ")
while (instructor == "y"):
courseinstructor = ""
while (courseinstructor == ""):
courseinstructor = input("Instructor Name: ")
sql_instructor = "INSERT INTO `COURSE_INSTRUCTOR` values (%s, %s)"
self.sesh.cursor.execute(sql_instructor,
(courseinstructor, courseid))
if (input("More instructors? [y/n]: ") == "n"):
break
prereq = input("Add course prerequisites? [y/n]: ")
while (prereq == "y"):
sql_query = f'SELECT CourseID, CourseName FROM `COURSE`;'
self.sesh.cursor.execute(sql_query)
result = self.sesh.cursor.fetchall()
univutil.table_format(result)
choice = input("Select course index: ")
while (True):
try:
choice = int(choice)
courseprerequisite = values[choice - 1]['CourseID']
break
except:
print("Error. Invalid index")
courseprerequisite_importance = ""
while (courseprerequisite_importance
not in ["Helpful", "Essential"]):
courseprerequisite_importance = input(
"Prequisite importance [Helpful/Essential]: ")
sql_instructor = "INSERT INTO `PREREQUISITE` values (%s, %s, %s)"
self.sesh.cursor.execute(sql_instructor,
(courseid, courseprerequisite,
courseprerequisite_importance))
if (input("More preqrequisites? [y/n]: ") == "n"):
break
self.sesh.connection.commit()
except Exception as e:
#print(e)
univutil.ask_user_action(self.add_course)
def enroll(self): # This would be a insertion into the quarternary relationship along with creating study_group if reqd.
try:
print("You can enroll in a new course (and a study group) or a new study group for a course already being taken.")
result = self.sesh.see_all("COURSE")
courseid = int(input("CourseID: "))
while(courseid not in [(lambda x: result[x]["CourseID"])(i) for i in range(len(result))]):
courseid = int(input("CourseID: "))
coursequery = "INSERT IGNORE INTO `TAKES` (UserName, DNum, CourseID) VALUES (%s, %s, %s);"
self.sesh.cursor.execute(coursequery, (self.current_user[0], self.current_user[1], courseid)) # This ignores if entry in TAKES already exists^
print("Available study groups for this course:")
values = self.showSgForCourse(courseid)
new_sg = 'X'
if(values == 0):
print("No study groups for this course.")
while(True):
new_sg = input("Create new study group? [Y/N]")
if(new_sg == "N"):
return
elif(new_sg == "Y"):
new_sg = "N"
break
while(new_sg != 'N' and new_sg != 'E'):
new_sg = input("Do you want to create your own study group (N) or join an existing one [E]: ")
if(new_sg == "E"):
sg = input("Study Group URL: ")
while(sg not in [(lambda x: values[x]["SgUrl"])(i) for i in range(len(values))]):
sg = input("Enter valid study group URL: ")
if(new_sg == 'N'):
sg = input("Study Group URL: ")
while(True):
try:
sgcreate = "INSERT INTO STUDY_GROUP (`SgUrl`) VALUES (%s);"
except:
print("Invalid study group URL. It might already exist.")
input()
break
self.sesh.cursor.execute(sgcreate, sg)
sgquery = "INSERT IGNORE INTO `MEMBER_OF` (UserName, DNum, SgUrl, UserSgRole) VALUES (%s, %s, %s, %s);"
self.sesh.cursor.execute(sgquery, (self.current_user[0], self.current_user[1], sg, "Admin"))
print("Created a new study group succesfully!")
print("Available languages for this study group")
langquery = "SELECT DISTINCT LangCode FROM PARTICIPATES_IN WHERE SgUrl = '%s'" % (sg)
self.sesh.cursor.execute(langquery)
result = self.sesh.cursor.fetchall()
lfound = 0
if(univutil.table_format(result) == 0):
values = self.sesh.see_all("LANGUAGE")
while(True):
choice = input("Pick language index: ")
try:
choice = int(choice)
langcode = values[choice-1]['LangCode']
lfound = 1
break
except:
print("Error. Invalid index")
while(lfound==0):
langcode = input("Language to participate in study_group (langcode) [N for none]: ")
if(langcode == "N"):
print("Let's find a new study group.")
input()
return
for i in range(self.sesh.cursor.rowcount):
if(result[i]["LangCode"]==langcode):
lfound=1
query = "INSERT INTO PARTICIPATES_IN VALUES (%s, %s, %s, %s, %s);"
self.sesh.cursor.execute(query, (self.current_user[0], self.current_user[1], sg, langcode, courseid))
self.sesh.connection.commit()
print("Enrolled in Course: %d as a member of Study Group: %s in language: %s succesfully!" % (courseid, sg, langcode))
input()
except Exception as e:
#print(e)
univutil.ask_user_action(self.enroll)
return
def addoption_studygroup(self, sg_url):
print("Choose a Course and it's corresponding discussion language! Atleast one must be new for the study group")
courseid = -1
langcode = ""
try:
#[TODO:] Validate if CourseID and Lang exist in DB or Display possible choices
coursequery = "SELECT DISTINCT `CourseID` FROM `PARTICIPATES_IN` WHERE `SgUrl` = '%s'" % sg_url
self.sesh.cursor.execute(coursequery)
course_count = self.sesh.cursor.rowcount
course_sg = self.sesh.cursor.fetchall()
langquery = "SELECT DISTINCT `LangCode` FROM `PARTICIPATES_IN` WHERE `SgUrl` = '%s'" % sg_url
self.sesh.cursor.execute(langquery)
lang_count = self.sesh.cursor.rowcount
lang_sg = self.sesh.cursor.fetchall()
lang_new_flag = 1
course_new_flag = 1
values = self.sesh.see_all("COURSE")
while(True):
try:
choice = input("Pick course index: ")
choice = int(choice)
courseid = values[choice-1]['CourseID']
break
except:
print("Error. Invalid index")
for i in range(course_count):
if(course_sg[i]["CourseID"] == courseid):
course_new_flag = 0
break
values = self.sesh.see_all("LANGUAGE")
while(True):
try:
choice = input("Pick language index: ")
choice = int(choice)
langcode = values[choice-1]['LangCode']
break
except:
print("Error. Invalid index")
for i in range(lang_count):
if(lang_sg[i]["LangCode"] == langcode):
lang_new_flag = 0
break
if(course_new_flag == 0 and lang_new_flag == 0):
print("You aren't inserting anything new!")
input()
return
query = "INSERT INTO `PARTICIPATES_IN` VALUES ('%s', %d, '%s', '%s', %d)" % (self.current_user[0], self.current_user[1], sg_url, langcode, courseid)
self.sesh.cursor.execute(query)
self.sesh.connection.commit()
if(course_new_flag):
print("Added a new course succesfully!")
if(lang_new_flag):
print("Added a new language succesfully!")
input()
except Exception as e:
#print(e)
univutil.ask_user_action(self.addoption_studygroup)
else: # Also add User - Course to User TAKES Course
try:
coursequery = "INSERT INTO `TAKES` (UserName, DNum, CourseID VALUES) VALUES (%s, %d, %d)" % (self.current_user[0], self.current_user[1], courseid)
self.sesh.cursor.execute(coursequery)
self.sesh.connection.commit()
except Exception as e:
pass
