How to use t method in keyboard

Best Python code snippet using keyboard

leopardWeb.py

Source:leopardWeb.py Github

copy

Full Screen

...11 ret = False12 data = self.crs.printCourse()13 for val in data:14 ret = True15 print(16 f"{val['crn']} | {val['title']} | {val['instructor']} | {val['time']} | {val['credit']}")17 return ret18 except Exception as e:19 print("No Classes Found")20 return False 21 def searchCourseByName(self, name):22 try:23 ret = False24 data = self.crs.searchCourseByName(name)25 for val in data:26 ret = True27 print(28 f"{val['title']} | {val['instructor']} | {val['time']} | {val['credit']}")29 return ret30 except Exception as e:31 print("No Classes Found")32 return False33 def searchCourseByCrn(self, crn):34 try:35 ret = False36 data = self.crs.searchCourseByCrn(crn)37 for val in data:38 ret = True39 print(40 f"{val['title']} | {val['instructor']} | {val['time']} | {val['credit']}")41 return ret42 except Exception as e:43 print("No Classes Found")44 return False45 # Zach46 def searchCourseByTime(self, time):47 try:48 ret = False49 data = self.crs.searchCourseByTime(time)50 for val in data:51 ret = True52 print(53 f"{val['title']} | {val['instructor']} | {val['time']} | {val['credit']}")54 return ret55 except Exception as e:56 print("No Classes Found")57 return False 58 def searchCourseByDay(self, days):59 try:60 ret = False61 data = self.crs.searchCourseByDay(days)62 for val in data:63 ret = True64 print(65 f"{val['title']} | {val['instructor']} | {val['time']} | {val['credit']}")66 return ret67 except Exception as e:68 print("No Classes Found")69 return False70 # End Zach71# Brennan72class student(user):73 def login(self, uid, password):74 logRet = self.stud.checkLogin(uid, password)75 if logRet == True:76 self.uid = uid77 return logRet78 def addClass(self, crn):79 try:80 self.crs.addStudentTo(self.uid, crn)81 print("Class Added")82 return True83 except Exception as e:84 print("Error")85 return False86 def dropClass(self, crn):87 try:88 self.crs.removeStudentFrom(self.uid, crn)89 print("Class Dropped")90 return True91 except Exception as e:92 print("Error")93 return False94 def printSchedule(self):95 try:96 data = self.stud.printSchedule(self.uid)97 for val in data:98 print(99 f"{val['title']} | {val['instructor']} | {val['time']} | {val['credit']}")100 return True101 except Exception as e:102 print("No Classes Found")103 return False104class instructor(user):105 def login(self, uid, password):106 logRet = self.inst.checkLogin(uid, password)107 if logRet == True:108 self.uid = uid109 return logRet110 def printSchedule(self):111 try:112 data = self.inst.printSchedule(self.uid)113 for val in data:114 print(115 f"{val['title']} | {val['instructor']} | {val['time']} | {val['credit']}")116 return True117 except Exception as e:118 print("No Classes Found")119 return False120 def printClassList(self, crn):121 try:122 data = self.crs.printRoster(crn)123 for val in data:124 print(f"{val['uid']} | {val['name']}" | {val['email']})125 return True126 except Exception as e:127 print("Error")128 return False129class admin(user):130 def login(self, uid, password):131 logRet = self.adm.checkLogin(uid, password)132 if logRet == True:133 self.uid = uid134 return logRet135 # End Brennan136 # Zach137 # add course to COURSE db138 def addCourse(self, crn, title, dept, time, days, semester, year, creditVal, instructor):139 try:140 self.crs.createCourse(crn, title, dept, time, days, semester, year, creditVal, instructor)141 print("Course added")142 return True143 except Exception as e:144 print("Error: Course already exists")145 return False146 def removeCourse(self, crn): # remove course from COURSE db147 try:148 self.crs.removeCourse(crn)149 print("Course removed")150 return True151 except Exception as e:152 print("Error: Course not found")153 return False154 def addStudentTo(self, uid, crn): # add student to course list for specified course155 try:156 self.crs.addStudentTo(uid, crn)157 print("Student added to course")158 return True159 except Exception as e:160 print("Error: Student already in course")161 return False162 # remove student from course list for specified course163 def removeStudentTo(self, uid, crn):164 try:165 self.crs.removeStudentFrom(uid, crn)166 print("Student removed from course")167 return True168 except Exception as e:169 print("Error: Student not in course")170 return False171 # add student to STUDENT db172 def addStudent(self, uid, pword, fname, lname, gradyear, major, email):173 try:174 self.stud.createStudent(uid, pword, fname, lname, gradyear, major, email)175 print("Student added")176 return True177 except Exception as e:178 print("Error")179 return False180 # add instructor to INSTRUCTOR db181 def addInstructor(self, uid, pword, fname, lname, title, hireyear, dept, email):182 try:183 self.inst.createInstructor(uid, pword, fname, lname, title, hireyear, dept, email)184 print("Instructor added")185 return True186 except Exception as e:187 print("Error")188 return False189 def addAdmin(self, uid, pword, fname, lname, title, office, email): # add admin to ADMIN db190 try:191 self.adm.createAdmin(uid, pword, fname, lname, title, office, email)192 print("Admin added")193 return True194 except Exception as e:195 print("Error")196 return False197 198 def removeStudent(self, uid): # remove student from STUDENT db199 try:200 self.stud.removeStudent(uid)201 print("Student removed")202 return True203 except Exception as e:204 print("Error")205 return False206 def removeInstructor(self, uid): # remove instructor from INSTRUCTOR db207 try:208 self.inst.removeInstructor(uid)209 print("Instructor removed")210 return True211 except Exception as e:212 print("Error")213 return False214 def removeAdmin(self, uid): # remove admin from ADMIN db215 try:216 self.adm.removeAdmin(uid)217 print("Admin removed")218 return True219 except Exception as e:220 print("Error")221 return False222 # End Zach223# Brennan224 def printRoster(self, crn):225 try:226 data = self.crs.printRoster(crn)227 for val in data:228 print(f"{val['uid']} | {val['name']} | {val['email']}")229 return True230 except Exception as e:231 print("Error")232 return False233class leopardWeb():234 def __init__(self):235 self.menu()236 def menu(self):237 retry = True238 while(retry):239 print("Welcome to LeopardWeb!\n")240 print("Please select an option:")241 print("1. Login as a student")242 print("2. Login as an instructor")243 print("3. Login as an administrator")244 print("4. Quit")245 res = input("Enter your choice: ")246 if res == "1":247 self.student()248 elif res == "2":249 self.instructor()250 elif res == "3":251 self.admin()252 elif res == "4":253 print("Goodbye!")254 sys.exit()255 else:256 print("Invalid input.")257 def student(self):258 retry = True259 while(retry):260 self.student = student()261 print("Please enter your ID:")262 idNum = input("ID: ")263 print("Please enter your password:")264 pword = input("Password: ")265 login = self.student.login(idNum, pword)266 if login:267 retry = False268 else:269 print("Invalid ID or password. Please try again.")270 retry = True271 while(retry):272 print("Please select an option:")273 print("1. Search for a class")274 print("2. Add a class")275 print("3. Drop a class")276 print("4. Print your schedule")277 print("5. Logout")278 res = input("Enter your choice: ")279 if res == "1":280 print("1. Search for a class by name")281 print("2. Search for a class by CRN")282 print("3. Search for a class by time")283 print("4. Search for a class by day")284 res = input("Enter your choice: ")285 if res == "1":286 print("Please enter the name of the class:")287 name = input("Name: ")288 self.student.searchCourseByName(name)289 elif res == "2":290 print("Please enter the CRN of the class:")291 crn = input("CRN: ")292 self.student.searchCourseByCrn(crn)293 elif res == "3":294 print("Please enter the time of the class:")295 time = input("Time: ")296 self.student.searchCourseByTime(time)297 elif res == "4":298 print("Please enter the day of the class:")299 days = input("Day: ")300 self.student.searchCourseByDay(days)301 else:302 print("Invalid input.")303 elif res == "2":304 print("Please enter the CRN of the class:")305 crn = input("CRN: ")306 self.student.addClass(crn)307 elif res == "3":308 print("Please enter the CRN of the class:")309 crn = input("CRN: ")310 self.student.dropClass(crn)311 elif res == "4":312 self.student.printSchedule()313 elif res == "5":314 self.menu()315 def admin(self):316 retry = True317 while(retry):318 self.admin = admin()319 print("Please enter your ID:")320 idNum = input("ID: ")321 print("Please enter your password:")322 pword = input("Password: ")323 login = self.admin.login(idNum, pword)324 if login:325 retry = False326 else:327 print("Invalid ID or password. Please try again.")328# Brennan end329 # Zach330 retry = True331 while (retry):332 print("Please select an option:")333 print("1. Search for a course")334 print("2. Add course to system")335 print("3. Remove course from system")336 print("4. Add student to course")337 print("5. Remove student from course")338 print("6. Add user to system")339 print("7. Remove user from system")340 print("8. Print roster of course by CRN")341 print("9. Logout")342 res = input("Enter your choice: ")343 if res == "1": # search course344 print("1. Search for a class by name")345 print("2. Search for a class by CRN")346 print("3. Search for a class by meeting day")347 print("4. Search for a class by meeting time")348 print("5. Print all courses")349 res = input("Enter your choice: ")350 if res == "1": # search course by name351 print("Please enter the name of the class:")352 name = input("Name: ")353 self.admin.searchCourseByName(name)354 elif res == "2": # search course by CRN355 print("Please enter the CRN of the class:")356 crn = input("CRN: ")357 self.admin.searchCourseByCrn(crn)358 elif res == "3": # search course by meeting days359 print("M = Monday")360 print("T = Tuesday")361 print("W = Wednesday")362 print("R = Thursday")363 print("F = Friday")364 print("Combine days with no spaces - such as (MWF) or (TR)")365 print("Please enter the meeting days of the class:")366 days = input("Meeting Days: ")367 self.admin.searchCourseByDay(days)368 elif res == "4": # search course by meeting time369 print("Format is: (1:00pm-2:50pm)")370 print("Please enter the meeting time of the class:")371 time = input("Meeting time: ")372 self.admin.searchCourseByTime(time)373 elif res == "5": # print all courses374 self.admin.printCourse()375 else:376 print("Invalid input.")377 elif res == "2": # add course378 crn = input("Enter course CRN: ")379 title = input("Enter course title: ")380 dept = input("Enter course department: ")381 times = input("Enter course meeting time: ")382 days = input("Enter course meeting day(s): ")383 semester = input("Enter course semester: ")384 year = input("Enter course year: ")385 credit = input("Enter course credit amount: ")386 instructor_entry = input("Enter instructor id: ")387 self.admin.addCourse(388 crn, title, dept, times, days, semester, year, credit, instructor_entry)389 elif res == "3": # remove course from system390 print("Please enter the CRN of the class:")391 crn = input("CRN: ")392 self.admin.removeCourse(crn)393 elif res == "4": # add student to course394 print("Please enter the UID of the student")395 uid = input("UID: ")396 print("Please enter the CRN of the course")397 crn = input("CRN: ")398 self.admin.addStudentTo(uid, crn)399 elif res == "5": # remove student from course400 print("Please enter the UID of the student")401 uid = input("UID: ")402 print("Please enter the CRN of the course")403 crn = input("CRN: ")404 self.admin.removeStudentTo(uid, crn)405 elif res == "6": # add user to system406 print("1. Add student to system")407 print("2. Add instructor to system")408 print("3. Add administrator to system")409 res = input("Enter your choice: ")410 if res == "1": # add student to system411 uid = input("Enter student id: ")412 pword = input("Enter student password: ")413 fname = input("Enter first name: ")414 lname = input("Enter last name: ")415 gradyear = input("Enter graduation year: ")416 major = input("Enter student major: ")417 email = input("Enter student email: ")418 self.admin.addStudent(419 uid, pword, fname, lname, gradyear, major, email)420 elif res == "2": # add instructor to system421 uid = input("Enter instructor id: ")422 pword = input("Enter instructor password: ")423 fname = input("Enter first name: ")424 lname = input("Enter last name: ")425 title = input("Enter title: ")426 hireyear = input("Enter hire year: ")427 dept = input("Enter department: ")428 email = input("Enter instructor email: ")429 self.admin.addInstructor(430 uid, pword, fname, lname, title, hireyear, dept, email)431 elif res == "3": # add admin to system432 uid = input("Enter admin id: ")433 pword = input("Enter admin password: ")434 fname = input("Enter first name: ")435 lname = input("Enter last name: ")436 title = input("Enter title: ")437 office = input("Enter hire year: ")438 email = input("Enter admin email: ")439 self.admin.addAdmin(uid, pword, fname,440 lname, title, office, email)441 else:442 print("Invalid input.")443 elif res == "7":444 print("1. Remove student")445 print("2. Remove instructor")446 print("3. Remove administrator")447 res = input("Enter your choice: ")448 if res == "1": # remove student449 uid = input("Enter student id: ")450 self.admin.removeStudent(uid)451 elif res == "2": # remove instructor452 uid = input("Enter instructor id: ")453 self.admin.removeInstructor(uid)454 elif res == "3": # remove admin455 uid = input("Enter admin id: ")456 self.admin.removeAdmin(uid)457 else:458 print("Invalid input.")459 elif res == "8": # print roster of a course460 print("Please enter the CRN of the course")461 crn = input("CRN: ")462 self.admin.printRoster(crn)463 elif res == "9": # logout464 self.menu()465 else:466 print("Invalid Input.")467 # Zach end468# Brennan469 def instructor(self):470 retry = True471 while(retry):472 self.instructor = instructor()473 print("Please enter your ID:")474 idNum = input("ID: ")475 print("Please enter your password:")476 pword = input("Password: ")477 login = self.instructor.login(idNum, pword)478 if login:479 retry = False480 else:481 print("Invalid ID or password. Please try again.")482 retry = True483 while(retry):484 print("Please select an option:")485 print("1. Search for a class")486 print("2. Print your schedule")487 print("3. Print class list")488 print("4. Logout")489 res = input("Enter your choice: ")490 if res == "1":491 print("1. Search for a class by name")492 print("2. Search for a class by CRN")493 print("3. Search for a class by instructor")494 print("4. Search for a class by time")495 res = input("Enter your choice: ")496 if res == "1":497 print("Please enter the name of the class:")498 name = input("Name: ")499 self.instructor.searchCourseByName(name)500 elif res == "2":501 print("Please enter the CRN of the class:")502 crn = input("CRN: ")503 self.instructor.searchCourseByCrn(crn)504 elif res == "3":505 print("Please enter the name of the instructor:")506 name = input("Name: ")507 self.instructor.searchCourseByInstructor(name)508 elif res == "4":509 print("Please enter the time of the class:")510 time = input("Time: ")511 self.instructor.searchCourseByTime(time)512 else:513 print("Invalid input.")514 elif res == "2":515 self.instructor.printSchedule()516 elif res == "3":517 print("Please enter the CRN of the class:")518 crn = input("CRN: ")519 # Zach - added fix to print info properly520 # now displays as (student_name | student_id)521 self.instructor.printRoster(crn)522 elif res == "4":523 self.menu()524if __name__ == '__main__':...

Full Screen

Full Screen

database.py

Source:database.py Github

copy

Full Screen

...45 students = ForeignKeyField(STUDENT, backref='courses')46 course = ForeignKeyField(COURSE, backref='courses')47class courseController():48 def createCourse(self, crnEntry, titleEntry, departmentEntry, dayEntry, timeEntry, semesterEntry, yearEntry, creditEntry, instructorEntry):49 instr = INSTRUCTOR.get(INSTRUCTOR.UID == instructorEntry)50 COURSE.create(crn=crnEntry, title=titleEntry, department=departmentEntry, time=timeEntry,51 days=dayEntry, semester=semesterEntry, year=yearEntry, credit=creditEntry, instructor=instr)52 def removeCourse(self, crnVal):53 '''remove COURSE based on CRN'''54 COURSE.delete().where(COURSE.crn == crnVal).execute()55 def printCourse(self):56 crs = COURSE.select()57 crsInfo = []58 for entry in crs:59 csrEntry = {}60 csrEntry['crn'] = entry.crn61 csrEntry['title'] = entry.title62 csrEntry['instructor'] = entry.instructor.NAME + " " + entry.instructor.SURNAME63 csrEntry['time'] = entry.time64 csrEntry['credit'] = entry.credit65 crsInfo.append(csrEntry)66 return crsInfo67 def searchCourseByCrn(self, crnVal):68 '''search COURSE by crn, return as dict'''69 crs = COURSE.select().where(COURSE.crn == crnVal)70 crsInfo = []71 for entry in crs:72 csrEntry = {}73 csrEntry['title'] = entry.title74 csrEntry['instructor'] = entry.instructor.NAME + " " + entry.instructor.SURNAME75 csrEntry['time'] = entry.time76 csrEntry['credit'] = entry.credit77 crsInfo.append(csrEntry)78 return crsInfo79 def searchCourseByName(self, nameVal):80 # search COURSE by name, return as list81 crs = COURSE.select().where(COURSE.title == nameVal)82 crsInfo = []83 for entry in crs:84 csrEntry = {}85 csrEntry['title'] = entry.title86 csrEntry['instructor'] = entry.instructor.NAME + " " + entry.instructor.SURNAME87 csrEntry['time'] = entry.time88 csrEntry['credit'] = entry.credit89 crsInfo.append(csrEntry)90 return crsInfo91 # Zach - added functions to search crs by some additional parameters92 def searchCourseByTime(self, timeVal):93 # search COURSE by time, return as nested list94 crs = COURSE.select().where(COURSE.time == timeVal)95 crsInfo = []96 for entry in crs:97 csrEntry = {}98 csrEntry['title'] = entry.title99 csrEntry['instructor'] = entry.instructor.NAME + " " + entry.instructor.SURNAME100 csrEntry['time'] = entry.time101 csrEntry['credit'] = entry.credit102 crsInfo.append(csrEntry)103 return crsInfo104 def searchCourseByDay(self, dayVal):105 # search COURSE by days, return as list106 crs = COURSE.select().where(COURSE.days == dayVal)107 crsInfo = []108 for entry in crs:109 csrEntry = {}110 csrEntry['title'] = entry.title111 csrEntry['instructor'] = entry.instructor.NAME + " " + entry.instructor.SURNAME112 csrEntry['time'] = entry.time113 csrEntry['credit'] = entry.credit114 crsInfo.append(csrEntry)115 return crsInfo116 def addStudentTo(self, uid, crn): # add student to course - update COURSE_LIST117 stud = STUDENT.get(STUDENT.UID == uid)118 crsEntry = COURSE.get(COURSE.crn == crn)119 COURSE_LIST.create(students=stud, course=crsEntry)120 # remove student from course - update COURSE_LIST121 def removeStudentFrom(self, uid, crn):122 stud = STUDENT.get(STUDENT.UID == uid)123 crs = COURSE.get(COURSE.crn == crn)124 COURSE_LIST.delete().where(COURSE_LIST.students == stud).where(125 COURSE_LIST.course == crs).execute()126 def printRoster(self, crn):127 crs = COURSE.select().where(COURSE.crn == crn)128 roster = COURSE_LIST.select().where(COURSE_LIST.course == crs)129 crsList = []130 for entry in roster:131 data = {}132 data['uid'] = entry.students.UID133 data['name'] = entry.students.NAME + " " + entry.students.SURNAME134 data['email'] = entry.students.EMAIL135 crsList.append(data)136 return crsList137 def updateCourse(self, crnEntry=None, titleEntry=None, departmentEntry=None, timeEntry=None, dayEntry=None, semesterEntry=None, yearEntry=None, creditEntry=None, instructorEntry=None):138 '''update STUDENT, set any vals that should not be changed to null'''139 crs = COURSE.select().where(COURSE.crn == crnEntry).dicts()140 if crnEntry != None:141 crs.crn = crnEntry142 if titleEntry != None:143 crs.title = titleEntry144 if departmentEntry != None:145 crs.department = departmentEntry146 if timeEntry != None:147 crs.time = timeEntry148 if dayEntry != None:149 crs.days = dayEntry150 if semesterEntry != None:151 crs.semester = semesterEntry152 if yearEntry != None:153 crs.year = yearEntry154 if creditEntry != None:155 crs.credit = creditEntry156 if instructorEntry != None:157 instr = INSTRUCTOR.get(INSTRUCTOR.UID == instructorEntry)158 crs.instructor = instr159 crs.save()160 def matchInstructor(self):161 '''List all available instructors for each course'''162 retList = []163 for entry in COURSE:164 instList = []165 instQuery = INSTRUCTOR.select().where(INSTRUCTOR.DEPT == entry.department).get()166 try:167 for inst in instQuery:168 instList.append(inst.NAME)169 except Exception as e:170 instList.append(instQuery.NAME)171 retList.append({entry.title: instList})172 return retList173class studentController():174 def createStudent(self, idVal, pword, fName, lName, expecGrad, majorVal, emailVal):175 STUDENT.create(UID=idVal, PASSWORD=pword, NAME=fName, SURNAME=lName,176 GRADYEAR=expecGrad, MAJOR=majorVal, EMAIL=emailVal)177 def removeStudent(self, idNum):178 '''remove STUDENT based on uid'''179 STUDENT.delete().where(STUDENT.UID == idNum).execute()180 def searchStudentByUID(self, idVal):181 '''search STUDENT by id, return as dict'''182 stud = STUDENT.select().where(STUDENT.UID == idVal)183 return stud.get()184 def printSchedule(self, uid):185 stud = STUDENT.get(STUDENT.UID == uid)186 retList = []187 for entry in COURSE_LIST:188 if entry.students == stud:189 data = {}190 data['title'] = entry.course.title191 try: #check to see if instructor is assigned to course192 data['instructor'] = entry.instructor.NAME + " " + entry.course.instructor.SURNAME193 except Exception as e:194 data['instructor'] = "N/A"195 data['time'] = entry.course.time196 data['credit'] = entry.course.credit197 retList.append(data)198 return retList199 def checkLogin(self, uid, pword):200 try:201 user = STUDENT.select().where(STUDENT.UID == uid).get()202 if user.PASSWORD == pword:203 return True204 else:205 return False206 except Exception as e:207 return False208 def updateStudent(self, idVal, newID=None, pword=None, fName=None, lName=None, expecGrad=None, majorVal=None, emailVal=None):209 '''update STUDENT, set any vals that should not be changed to null'''210 stud = STUDENT.select().where(STUDENT.UID == idVal).get()211 if newID != None:212 stud.UID = newID213 if pword != None:214 stud.PASSWORD = pword215 if fName != None:216 stud.NAME = fName217 if lName != None:218 stud.SURNAME = lName219 if expecGrad != None:220 stud.GRADYEAR = expecGrad221 if majorVal != None:222 stud.MAJOR = majorVal223 if emailVal != None:224 stud.EMAIL = emailVal225 stud.save()226class instructorController():227 def createInstructor(self, idVal, pword, fName, lName, titleVal, yearHired, departmentVal, emailVal):228 INSTRUCTOR.create(UID=idVal, PASSWORD=pword, NAME=fName, SURNAME=lName,229 TITLE=titleVal, HIREYEAR=yearHired, DEPT=departmentVal, EMAIL=emailVal)230 def removeInstructor(self, idNum):231 '''remove INSTRUCTOR based on uid'''232 INSTRUCTOR.delete().where(INSTRUCTOR.UID == idNum).execute()233 def searchInstructorByUID(self, idVal):234 '''search INSTRUCTOR by id, return as dict'''235 inst = INSTRUCTOR.select().where(INSTRUCTOR.UID == idVal)236 return inst.get()237 def printSchedule(self, uid):238 inst = INSTRUCTOR.get(INSTRUCTOR.UID == uid)239 retList = []240 for entry in COURSE_LIST:241 if entry.instructor == inst:242 data = {}243 data['title'] = entry.title244 data['crn'] = entry.crn245 data['time'] = entry.time246 data['days'] = entry.days247 retList.append(data)248 return retList249 def checkLogin(self, uid, pword):250 try:251 user = INSTRUCTOR.select().where(INSTRUCTOR.UID == uid).get()252 if user.PASSWORD == pword:253 return True254 else:255 return False256 except Exception as e:257 return False258 def updateInstructor(self, idVal, newID=None, pword=None, fName=None, lName=None, titleVal=None, yearHired=None, departmentVal=None, emailVal=None):259 '''search STUDENT by id, return as dict'''260 instr = INSTRUCTOR.select().where(INSTRUCTOR == idVal).get()261 if newID != None:262 instr.UID = newID263 if pword != None:264 instr.PASSWORD = pword265 if fName != None:266 instr.NAME = fName267 if lName != None:268 instr.SURNAME = lName269 if titleVal != None:270 instr.TITLE = titleVal271 if yearHired != None:272 instr.HIREYEAR = yearHired273 if departmentVal != None:274 instr.DEPT = departmentVal275 if emailVal != None:276 instr.EMAIL = emailVal277 instr.save()278class adminController():279 def createAdmin(self, idVal, pword, fName, lName, titleVal, officeVal, emailVal):280 ADMIN.create(UID=idVal, PASSWORD=pword, NAME=fName, SURNAME=lName,281 TITLE=titleVal, OFFICE=officeVal, EMAIL=emailVal)282 def removeAdmin(self, idNum):283 '''remove ADMIN based on uid'''284 ADMIN.delete().where(ADMIN.UID == idNum).execute()285 def searchAdminByUID(self, idVal):286 '''search ADMIN by id, return as dict'''287 adm = ADMIN.select().where(ADMIN.UID == idVal)288 return adm.get()289 def checkLogin(self, uid, pword):290 try:291 user = ADMIN.select().where(ADMIN.UID == uid).get()292 if user.PASSWORD == pword:293 return True294 else:295 return False296 except Exception as e:297 return False298 def updateAdmin(self, idVal, newID=None, pword=None, fName=None, lName=None, titleVal=None, OfficeVal=None, emailVal=None):299 '''search STUDENT by id, return as dict'''300 adm = ADMIN.select().where(ADMIN.UID == idVal).get()301 if newID != None:302 adm.UID = newID303 if pword != None:304 adm.PASSWORD = pword305 if fName != None:306 adm.NAME = fName307 if lName != None:308 adm.SURNAME = lName309 if titleVal != None:310 adm.TITLE = titleVal311 if OfficeVal != None:312 adm.OFFICE = OfficeVal313 if emailVal != None:314 adm.EMAIL = emailVal315 adm.save()316if __name__ == '__main__':317 # Run this file on its own to create COURSE table318 parser = argparse.ArgumentParser("Create databases or delete databases.")319 parser.add_argument('mode', type=str,320 help='flag, if c then create database tables if d delete')321 args = parser.parse_args(sys.argv[1:])322 db.connect()323 if args.mode == 'c':324 db.create_tables([INSTRUCTOR, STUDENT, COURSE, COURSE_LIST, ADMIN])325 elif args.mode == 'd':326 db.drop_tables([INSTRUCTOR, STUDENT, COURSE, COURSE_LIST, ADMIN])327 else:...

Full Screen

Full Screen

leopardWebTest.py

Source:leopardWebTest.py Github

copy

Full Screen

...5from leopardWeb import admin67#TODO: Fix search functions so they return False when no result is found89class adminTest(unittest.TestCase):10 @classmethod11 def setUpClass(self):12 self.adm = admin()13 self.admin = adminController()14 self.instructor = instructorController()1516 self.admin.createAdmin(90287, 'slyOmen12', 'Adam', 'Santano', 'President', 'Wentworth100', 'santanoa')17 18 self.instructor.createInstructor(201100, 'pword', 'Aaron', 'Carpenter', 'Assistant Professor', '2002', 'Electrical', 'acarpenter')19 20 #test login with incorrect credentials21 def testFalseLogin(self):22 self.assertFalse(self.adm.login(11111, 'pword'),23 "Expected error while login")2425 #test login with correct UID & password26 def testLogin(self):27 self.assertTrue(self.adm.login(90287, 'slyOmen12'), 28 "Expected successful login")2930 #test creating admin31 def testCreateAdmin(self):32 ret = self.adm.addAdmin(67824, 'pword', 'Tom', 'Cat', 'Registrar', 'Williston110', 'catt')33 self.assertTrue(ret)34 35 #test creating admin with invalid UID36 def testCreateFalseAdmin(self):37 ret = self.adm.addAdmin(67824, 'pword', 'Tom', 'Cat', 'Registrar', 'Williston110', 'catt')38 self.assertFalse(ret)3940 #test deleting admin41 def testDeleteAdmin(self):42 ret = self.adm.removeAdmin(67824)43 self.assertTrue(ret)4445 #test adding a course to the system46 def testAddCourse(self):47 ret = self.adm.addCourse(918026, 'Applied Programming Concepts', 'BSCS', '8:00am-9:50am', 'TR', 'Spring', '2022', 3, 201100)48 self.assertTrue(ret)4950 #test adding an invalid course51 def testAddInvalidCourse(self):52 ret = self.adm.addCourse(918026, 'Applied Programming Concepts', 'BSCS', '8:00am-9:50am', 'TR', 'Spring', '2022', 3, 201100)53 self.assertFalse(ret)5455 #test removing course from system56 def testRemoveCourse(self):57 ret = self.adm.removeCourse(918026)58 self.assertTrue(ret)5960 #test incorrectly removing course from system61 def testRemoveFalseCourse(self):62 ret = self.adm.removeCourse(000000)63 self.assertTrue(ret)6465 @classmethod66 def tearDownClass(self):67 self.admin.removeAdmin(90287)68 self.instructor.removeInstructor(201100)697071class userTest(unittest.TestCase):72 @classmethod73 def setUpClass(self):74 self.user = user()75 self.inst = instructorController()76 self.course = courseController()7778 self.inst.createInstructor(201100, 'pword', 'Aaron', 'Carpenter', 'Assistant Professor', '2002', 'Electrical', 'acarpenter')79 self.course.createCourse(4011423, "Cyber-Physical Systems", "BSEE", "MWF", "1:00pm-2:50pm", "Spring", "2022", 3, 201100)8081 #test search course by CRN82 def testSearchCourseByCRN(self):83 self.assertTrue(self.user.searchCourseByCrn(4011423))8485 #test search course by invalid CRN86 def testSearchCourseByFalseCRN(self):87 self.assertFalse(self.user.searchCourseByCrn(0000000))8889 #test search course by name90 def testSearchCourseByName(self):91 self.assertTrue(self.user.searchCourseByName('Cyber-Physical Systems'))9293 #test search course by invalid name94 def testSearchCourseByFalseName(self):95 self.assertFalse(self.user.searchCourseByName('Course Name'))96 97 #test search course by days98 def testSearchCourseByDays(self):99 self.assertTrue(self.user.searchCourseByDay('MWF'))100101 #test search course by invalid days102 def testSearchCourseByFalseDays(self):103 self.assertFalse(self.user.searchCourseByDay('days'))104105 #test search course by time106 def testSearchCourseByTime(self):107 self.assertTrue(self.user.searchCourseByTime('1:00pm-2:50pm'))108109 #test search course by invalid time110 def testSearchCourseByFalseTime(self):111 self.assertFalse(self.user.searchCourseByTime('time'))112113 #test print course114 def testPrintCourse(self):115 self.assertTrue(self.user.printCourse())116117 @classmethod118 def tearDownClass(self):119 self.inst.removeInstructor(201100)120 self.course.removeCourse(4011423)121122class instructorTest(unittest.TestCase):123 @classmethod124 def setUpClass(self):125 self.inst = instructor()126 self.instructor = instructorController()127 self.course = courseController()128129 self.instructor.createInstructor(201100, 'pword', 'Aaron', 'Carpenter', 'Assistant Professor', '2002', 'Electrical', 'acarpenter')130 self.course.createCourse(4011422, "Cyber-Physical Systems", "BSEE", "MWF", "1:00pm-2:50pm", "Spring", "2022", 3, 201100)131132 #test login with incorrect credentials133 def testFalseLogin(self):134 self.assertFalse(self.inst.login(11111, 'pword'),135 "Expected error while login")136137 #test login with correct UID & password138 def testLogin(self):139 self.assertTrue(self.inst.login(201100, 'pword'), 140 "Expected successful login")141142 def testPrintSchedule(self):143 self.assertTrue(self.inst.printSchedule())144 145 def testPrintClassList(self):146 self.assertTrue(self.inst.printClassList(4011422))147 148 @classmethod149 def tearDownClass(self):150 self.instructor.removeInstructor(201100)151 self.course.removeCourse(4011422)152153154class studentTest(unittest.TestCase):155 @classmethod156 def setUpClass(self):157 self.stud = student()158159 self.studentCont = studentController()160 self.instructor = instructorController()161 self.course = courseController()162163 self.studentCont.createStudent(301823, "pword", "test", "student", "2023", "BSCO", "dylanbob")164 self.instructor.createInstructor(201100, 'pword', 'Aaron', 'Carpenter', 'Assistant Professor', '2002', 'Electrical', 'acarpenter')165 self.course.createCourse(4011422, "Cyber-Physical Systems", "BSEE", "MWF", "1:00pm-2:50pm", "Spring", "2022", 3, 201100)166167 #test login with incorrect credentials168 def testFalseLogin(self):169 self.assertFalse(self.stud.login(30182356, 'pword'),170 "Expected error while login")171172 #test login with correct UID & password173 def testLogin(self):174 ret = self.stud.login(301823, 'pword')175 self.assertTrue(ret, 176 "Expected successful login")177178 #test adding student to course179 def testAddClass(self):180 self.stud.login(301823, 'pword')181 ret = self.stud.addClass(4011422)182 self.assertTrue(ret)183184 #test adding student to invalid course185 def testAddClassInvalid(self):186 self.stud.login(301823, 'pword')187 ret = self.stud.addClass(401142223)188 self.assertFalse(ret)189190 #test removing student from course191 def testDropClass(self):192 self.stud.login(301823, 'pword')193 ret = self.stud.dropClass(4011422)194 self.assertTrue(ret)195196 #test removing student from invalid course197 def testDropClassInvalid(self):198 self.stud.login(301823, 'pword')199 ret = self.stud.dropClass(401142223)200 self.assertFalse(ret)201202 #test incorrectly removing course from system203 def testPrintSchedule(self):204 ret = self.stud.printSchedule()205 self.assertTrue(ret)206207 @classmethod208 def tearDownClass(self):209 self.studentCont.removeStudent(301823)210 self.instructor.removeInstructor(201100)211 self.course.removeCourse(4011422)212213214215if __name__ == '__main__':216 unittest.main() ...

Full Screen

Full Screen

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.

LambdaTest Learning Hubs:

YouTube

You could also refer to video tutorials over LambdaTest YouTube channel to get step by step demonstration from industry experts.

Run keyboard automation tests on LambdaTest cloud grid

Perform automation testing on 3000+ real desktop and mobile devices online.

Try LambdaTest Now !!

Get 100 minutes of automation test minutes FREE!!

Next-Gen App & Browser Testing Cloud

Was this article helpful?

Helpful

NotHelpful