KaneAI - World’s First E2E Software Testing Agent.Book a Demo 
How to use query_fetch_one method in SeleniumBase
Best Python code snippet using SeleniumBase
common.py
Source:common.py 
...84 sql_str += " AND account_id = '" + user_id + "'"85 sql_str += " AND status = 'true'"8687 # CALL FUNCTION QUERY ONE88 ret = self.postgres.query_fetch_one(sql_str)8990 # RETURN91 return ret9293 def get_account_status(self, account_id):94 """ GET ACCOUNT STATUS """9596 # CREATE SQL QUERY97 sql_str = "SELECT status FROM account WHERE"98 sql_str += " id='{0}'".format(account_id)99100 # CALL FUNCTION QUERY ONE101 res = self.postgres.query_fetch_one(sql_str)102103 if res:104105 return res['status']106107 return 0108109 def update_token_data(self, account_id, request_info):110 """ UPDATE TOKEN DATA """111112 data = {}113 data['update_on'] = time.time()114 data['status'] = True115116 conditions = []117118 conditions.append({119 "col": "account_id",120 "con": "=",121 "val": account_id122 })123124 conditions.append({125 "col": "remote_addr",126 "con": "=",127 "val": request_info.remote_addr128 })129130 conditions.append({131 "col": "platform",132 "con": "=",133 "val": request_info.user_agent.platform134 })135136 conditions.append({137 "col": "browser",138 "con": "=",139 "val": request_info.user_agent.browser140 })141142 conditions.append({143 "col": "version",144 "con": "=",145 "val": request_info.user_agent.version146 })147148 self.postgres.update('account_token', data, conditions)149150 return 1151152 def validate_token(self, token, user_id, request_info):153 """Validate Token"""154155 # CHECK ACCOUNT STATUS156 status = self.get_account_status(user_id)157158 p_status = "status: {0}".format(status)159 syslog.syslog(p_status)160161 if not status:162163 return 0164165 # SET COLUMN FOR RETURN166 columns = ['account_id', 'update_on']167168 # CHECK IF TOKEN EXISTS169 user_data = self.get_user_info(columns, "account_token", user_id, token)170171 p_user_data = "user_data: {0}".format(user_data)172 syslog.syslog(p_user_data)173174 self.postgres = PostgreSQL()175176 # CHECK IF COLUMN EXIST,RETURN 0 IF NOT177 if user_data:178179 dt1 = datetime.fromtimestamp(user_data['update_on'])180 dt2 = datetime.fromtimestamp(time.time())181 dateutil.relativedelta.relativedelta(dt2, dt1)182183 rd1 = dateutil.relativedelta.relativedelta(dt2, dt1)184 # print(rd1.years, rd1.months, rd1.days, rd1.hours, rd1.minutes, rd1.seconds)185186 if rd1.years or rd1.months or rd1.days or rd1.hours:187188 return 0189190 if rd1.minutes > 30:191192 return 0193194 else:195196 return 0197198 self.update_token_data(user_id, request_info)199 # RETURN200 return 1201202 # COUNT DATA203 def count_data(self, datas, column, item):204 """Return Data Count"""205206 # INITIALIZE207 count = 0208209 # LOOP DATAS210 for data in datas:211212 # CHECK OF DATA213 if data[column] == item:214215 # INCREASE COUNT216 count += 1217218 # RETURN219 return count220221 def set_return(self, datas):222 """Set Return"""223 ret_data = {}224 ret_data['data'] = []225 for data in datas:226 ret_data['data'].append(data['value'])227228 return ret_data229230 def check_request_json(self, query_json, important_keys):231 """Check Request Json"""232 query_json = simplejson.loads(simplejson.dumps(query_json))233234 for imp_key in important_keys.keys():235236 if imp_key not in query_json:237 return 0238239 if type(query_json.get(imp_key)):240241 if type(query_json[imp_key]) != type(important_keys[imp_key]):242243 return 0244245 else:246247 return 0248249 return 1250251 def limits(self, rows, limit, page):252 """Limits"""253 skip = int((page - 1) * limit)254255 limit = skip + limit256257 return rows[skip:limit]258259 def param_filter(self, temp_datas, params, checklist):260 """Parameter Filter"""261 if not params:262263 return temp_datas264265 param_datas = []266 param_datas = temp_datas267268 output = []269270 i = 0271272 for param in params:273 key = checklist[i]274275 i += 1276277 for data in param_datas:278279 if self.filter_checker(str(param), str(data[key])):280281 output.append(data)282283 return output284285 def filter_checker(self, pattern, value):286 """Check Filter"""287 if '*' in pattern:288 pattern = pattern.replace('.', r'\.')289 if pattern == "*":290 pattern = "."291292 if not pattern[0] == "*" and pattern != ".":293 pattern = "^" + str(pattern)294295 if pattern[-1] == "*":296 pattern = pattern[:-1] + '+'297298 if not pattern[-1] == "+" and pattern != ".":299 pattern = str(pattern) + '$'300301 if pattern[0] == "*":302 pattern = '.?' + pattern[1:]303304 pattern = pattern.replace('*', '.+')305306 # print("pattern: ", pattern)307308 try:309310 if not re.findall(pattern, value, re.IGNORECASE):311312 return 0313314 except:315316 return 0317318 else:319320 if not value == pattern:321322 return 0323324 return 1325326 def isfloat(self, data):327 """Check if float"""328 try:329 if data == "infinity":330 return False331332 float(data)333 except ValueError:334 return False335 else:336 return True337338 def isint(self, data):339 """Check if Integer"""340 try:341 if data == "infinity":342 return False343344 tmp_data1 = float(data)345 tmp_data2 = int(tmp_data1)346 except ValueError:347 return False348 else:349 return tmp_data1 == tmp_data2350351 def file_replace(self, filename):352 """ File Naming """353354 file_name = filename.split(".")[0]355356 if "_" in file_name:357358 suffix = file_name.split("_")[-1]359360 if suffix.isdigit():361 new_name = filename.replace(suffix, str(int(suffix) + 1))362 else:363 new_name = filename.replace(suffix, str(suffix+"_1"))364 else:365 new_name = filename.replace(file_name, str(file_name+"_1"))366367 return new_name368369 def format_filter(self, datas):370 """ Return Filter in Format """371372 tmp = []373374 for data in datas:375376 tmp.append({377 "label": data,378 "value": data379 })380381 return tmp382383 def data_filter(self, datas, key):384 """Filter Data"""385 temp_data = []386387 if datas and key:388389 key = "{0}s".format(key)390391 data_list = []392 for data in datas[key]:393394 data_list.append(data)395396 for data in data_list:397 if data in [True, False]:398 data = "{0}".format(data)399400 if key == "statuss":401402 if data == "True":403 data = "Enabled"404405 if data == "False":406 data = "Disabled"407408 temp_data.append({409 "label": data,410 "value": data411 })412413414 return temp_data415416 def days_update(self, timestamp, count=0, add=False):417 """Days Update"""418 try:419420 named_tuple = time.localtime(int(timestamp))421422 # GET YEAR MONTH DAY423 year = int(time.strftime("%Y", named_tuple))424 month = int(time.strftime("%m", named_tuple))425 day = int(time.strftime("%d", named_tuple))426427 # Date in tuple428 date_tuple = (year, month, day, 0, 0, 0, 0, 0, 0)429430 local_time = time.mktime(date_tuple)431 orig = datetime.fromtimestamp(local_time)432433 if add:434435 new = orig + timedelta(days=count)436437 else:438439 new = orig - timedelta(days=count)440441 return new.timestamp()442443 except:444445 return 0446447 def check_progress(self, data):448 """ RETURN PROGRESS """449450 assert data, "Data is a must."451452 answer = [dta['answer'] for dta in data]453 total = len(answer)454 not_answer = [None, '', []]455 total_answer = len([ans for ans in answer if ans not in not_answer])456457 average = self.format_progress((total_answer / total) * 100)458459 return average460461 def format_progress(self, progress):462 """ Format Progress """463464 progress = round(progress, 2)465 if progress.is_integer():466 return int(progress)467468 return progress469470 def validate_user(self, userid, user_role):471 """ VALIDATE USER TYPE """472473 sql1 = "SELECT role_id FROM account_role WHERE"474 sql1 += " account_id='{0}'".format(userid)475476 sql_str = "SELECT role_name FROM role WHERE"477 sql_str += " role_id IN ({0})".format(sql1)478479 role = self.postgres.query_fetch_one(sql_str)480 role_name = role['role_name']481482 if role_name == user_role:483484 return 1485486 return 0487488 def check_answer(self, question_id, answer, userid=None):489 """Return Answer"""490491 # DATA492 sql_str = "SELECT e.*, cq.* FROM course_question cq"493 sql_str += " LEFT JOIN exercise e ON cq.exercise_id = e.exercise_id"494 sql_str += " WHERE course_question_id = '{0}'".format(question_id)495 result = self.postgres.query_fetch_one(sql_str)496497 data = {}498499 if result:500501 if result['question_type'] == 'FITBT':502503 question = result['question']['question'].replace("<ans>", "")504505 if question == answer:506507 if result['moving_allowed'] is False:508 data['message'] = "You cannot skip this question"509 data['isCorrect'] = False510511 else:512 data['message'] = "No answer given"513 data['isCorrect'] = False514515 if userid:516 data['message'] = self.translate(userid, data['message'])517518 return data519520 if result['question_type'] == 'FITBD':521522 question = result['question']['question'].replace("<ans>", "")523524 if question == answer:525 data['message'] = "No answer given"526 data['isCorrect'] = False527528 if userid:529 data['message'] = self.translate(userid, data['message'])530531 return data532533 if answer in [None,'', str( [""]), str([]), str(['']), [], ['']]:534 if result['moving_allowed'] is False:535 data['message'] = "You cannot skip this question"536 data['isCorrect'] = False537 else:538 data['message'] = "No answer given"539 data['isCorrect'] = False540541 if userid:542 data['message'] = self.translate(userid, data['message'])543544 return data545546 # FITBD547 if result['question_type'] in ['FITBD']:548549 correct_answer = result['correct_answer']['answer']550551 if answer in correct_answer:552 data['message'] = result['correct']553 data['isCorrect'] = True554 else:555 data['message'] = result['incorrect']556 data['isCorrect'] = False557558 if userid:559 data['message'] = self.translate(userid, data['message'])560561 return data562563 if result['question_type'] in ['MULRE', 'MATCH']:564565 correct_answer = result['correct_answer']['answer']566567 if len(correct_answer) != len(answer):568 data['message'] = result['incorrect']569 data['isCorrect'] = False570571 if userid:572 data['message'] = self.translate(userid, data['message'])573574 return data575576 # MATCH577 if result['question_type'] == 'MATCH':578 if answer == correct_answer:579 data['message'] = result['correct']580 data['isCorrect'] = True581 else:582 data['message'] = result['incorrect']583 data['isCorrect'] = False584585 if userid:586 data['message'] = self.translate(userid, data['message'])587588 return data589590 # MULRE591 if result['shuffle_answers'] is False:592 if answer == correct_answer:593 data['message'] = result['correct']594 data['isCorrect'] = True595 else:596 data['message'] = result['incorrect']597 data['isCorrect'] = False598599 else:600 score = 0601 for ans in answer:602 if ans in correct_answer:603 score += 1604605 if score == len(correct_answer):606 data['message'] = result['correct']607 data['isCorrect'] = True608 else:609 data['message'] = result['incorrect']610 data['isCorrect'] = False611612 if userid:613 data['message'] = self.translate(userid, data['message'])614615 return data616617 ans = {}618 ans["answer"] = answer619620 if str(result['correct_answer']) == str(ans):621 data['message'] = result['correct']622 data['isCorrect'] = True623 else:624 data['message'] = result['incorrect']625 data['isCorrect'] = False626627 if userid:628629 data['message'] = self.translate(userid, data['message'])630631 return data632633 def translate(self, user_id, message):634 """ Return Translation """635636 sql_str = "SELECT language FROM account WHERE"637 sql_str += " id='{0}'".format(user_id)638 language = self.postgres.query_fetch_one(sql_str)639640 if language['language'] != 'en-US':641642 message = "".join(re.findall(r'[a-zA-Z\ ]', message))643644 sql_str = "SELECT translation FROM translations WHERE word_id=("645 sql_str += "SELECT word_id FROM words WHERE"646 sql_str += " name = '{0}') AND ".format(message)647 sql_str += "language_id=(SELECT language_id FROM language WHERE "648 sql_str += "initial='{0}')".format(language['language'])649650 translate = self.postgres.query_fetch_one(sql_str)651652 if translate:653 message = translate['translation']654655 return message656657 def translate_course(self, user_id, course_id):658 """ Return Course Translation """659660 data = {}661 sql_str = "SELECT * FROM course WHERE course_id = '{0}'".format(course_id)662 result = self.postgres.query_fetch_one(sql_str)663664 data['course_name'] = self.translate(user_id, result['course_name'])665 data['description'] = self.translate(user_id, result['description'])666667 return data668669 def trim_url(self, url):670 """ Return domain url """671672 # FORMAT URL673 trim = re.compile(r"https?://(www\.)?")674 return trim.sub('', url).strip().strip('/')675676 def can_access_tutorenv(self, user_id):677 """ Check access rights """678679 sql_str = "SELECT * FROM account_role ac"680 sql_str += " LEFT JOIN role r ON ac.role_id = r.role_id"681 sql_str += " WHERE account_id = '{0}'".format(user_id)682 result = self.postgres.query_fetch_one(sql_str)683684 roles = ['MANAGER', 'TUTOR']685 if result['role_name'].upper() in roles:686 return 1687688 return 0689690 def check_question(self, question_id):691 """ Validate Question ID """692693 # DATA694 sql_str = "SELECT * FROM course_question"695 sql_str += " WHERE course_question_id = '{0}'".format(question_id)696 result = self.postgres.query_fetch_one(sql_str)697 if result:698 return 1699700 return 0701702 def allowed_file_type(self, filename):703 """ Check Allowed File Extension """704705 allowed_extensions = set(['csv'])706707 return '.' in filename and filename.rsplit('.', 1)[1].lower() in allowed_extensions708709 def course_header(self):710 """ RETURN COURSE COLUMN """711712 return [713 "Course ID",714 "Course Name",715 "Course Description",716 "Course Difficulty Level",717 "Course Requirements",718719 "Section ID",720 "Section Name",721 "Section Description",722 "Section Difficulty Level",723724 "Subsection ID",725 "Subsection Name",726 "Subsection Description",727 "Subsection Difficulty Level",728729 "Exercise ID",730 "Exercise Number",731 "Exercise Question Type",732 "Exercise Tags",733 "Exercise Description",734 "Exercise Draw By Tag",735 "Exercise Editing Allowed",736 "Exercise Help",737 "Exercise Instant Feedback",738 "Exercise Moving Allowed",739 "Exercise Number to Draw",740 "Exercise Passing Criterium",741 "Exercise Save Seed",742 "Exercise Seed",743 "Exercise Shuffled",744 "Exercise Text Before Start",745 "Exercise Text After End",746 "Exercise Timed Limit",747 "Exercise Timed Type",748749 "Question ID",750 "Question",751 "Question Type",752 "Question Tags",753 "Question Choices",754 "Question Shuffle Options",755 "Question Shuffle Answers",756 "Question Num Eval",757 "Question Correct Answer",758 "Question Correct",759 "Question Incorrect",760 "Question Feedback",761 "Question Description"762 ]763764 def fetch_course_details(self, userid, course_id):765 """ Return Course Details """766767 sql_str = "SELECT * FROM course_master WHERE"768 sql_str += " course_id='{0}'".format(course_id)769 result = self.postgres.query_fetch_all(sql_str)770771 for res in result:772 res['course_name'] = self.translate(userid, res['course_name'])773 res['description'] = self.translate(userid, res['description'])774775 return result776777 def check_headers(self, csv_data, headers):778 """ CHECK COLUMN """779780 for key in self.course_header():781782 if not key in headers:783784 return 0785786 return 1787788 def run_update(self, csv_data):789 """ CONVERT CSV TO JSON """790791 json_data = {}792 json_data['status'] = 'ok'793794 course_id = ""795 section_id = ""796 subsection_id = ""797798 for row in csv_data:799800 # COURSE801 if row['Course ID'] or row['Course Name']:802803 course_id = self.iu_course(row)804805 if not course_id:806807 json_data["alert"] = "Course already exist!"808 json_data['status'] = 'Failed'809810 return json_data811812 # CHECK IF COURSE IS ALREADY IN USE813 if not self.use_course(course_id):814815 json_data["alert"] = "Course is in use!"816 json_data['status'] = 'Failed'817818 return json_data819820 # SECTION821 if row['Section ID'] or row['Section Name']:822823 section_id = self.iu_section(row, course_id)824825 if not section_id:826827 json_data["alert"] = "Section {0} already exist!".format(row['Section Name'])828 json_data['status'] = 'Failed'829830 return json_data831832 # SUBSECTION833 if row['Subsection ID'] or row['Subsection Name']:834835 subsection_id = self.iu_subsection(row, course_id, section_id)836837 if not subsection_id:838839 json_data["alert"] = "Subsection {0} already exist!".format(row['Subsection Name'])840 json_data['status'] = 'Failed'841842 return json_data843844 # EXERCISE845 if row['Exercise ID'] or row['Exercise Number']:846847 exercise_id = self.iu_exercise(row, course_id, section_id, subsection_id)848849 if not exercise_id:850851 json_data["alert"] = "Exercise {0} already exist!".format(row['Exercise Number'])852 json_data['status'] = 'Failed'853854 return json_data855856 # QUESTION857 # if row['Question ID'] or row['Question']:858859 # question_id = self.iu_question(row, course_id, section_id, subsection_id, exercise_id)860861 # if not question_id:862863 # json_data["alert"] = "Question {0} already exist!".format(row['Question'])864 # json_data['status'] = 'Failed'865866 # return json_data867868 return json_data869870 def iu_course(self, data):871 """ UPDATE COURSE """872873 if data['Course ID']:874875 return self.update_course(data)876877 if data['Course Name']:878879 sql_str = "SELECT * FROM course WHERE"880 sql_str += " course_name ='{0}'".format(data['Course Name'])881882 cdata = self.postgres.query_fetch_one(sql_str)883884 if cdata:885886 return 0887888 updated_data = {}889890 data['Course Difficulty Level'] = 1891892 updated_data['course_name'] = data['Course Name']893 if data['Course Description']:894 updated_data['description'] = data['Course Description']895 if data['Course Difficulty Level']:896 updated_data['difficulty_level'] = data['Course Difficulty Level']897 if data['Course Requirements']:898 updated_data['requirements'] = data['Course Requirements']899 updated_data['status'] = True900 updated_data['created_on'] = time.time()901902 course_id = self.postgres.insert('course', updated_data, 'course_id')903904 return course_id905906 def iu_section(self, data, course_id):907 """ UPDATE SECTION """908909 if not data['Section Name'] and data['Section ID']:910911 conditions = []912913 conditions.append({914 "col": "section_id",915 "con": "=",916 "val": data['Section ID']917 })918919 self.postgres.delete('section', conditions)920921 if data['Section ID']:922923 updated_data = {}924925 updated_data['difficulty_level'] = 1926927 updated_data['section_name'] = data['Section Name']928 if data['Section Description']:929 updated_data['description'] = data['Section Description']930 if data['Section Difficulty Level']:931 updated_data['difficulty_level'] = data['Section Difficulty Level']932933 # INIT CONDITION934 conditions = []935936 # CONDITION FOR QUERY937 conditions.append({938 "col": "course_id",939 "con": "=",940 "val": course_id941 })942943 conditions.append({944 "col": "section_id",945 "con": "=",946 "val": data['Section ID']947 })948949 self.postgres.update('section', updated_data, conditions)950951 return data['Section ID']952953 if data['Section Name']:954955 sql_str = "SELECT * FROM section WHERE"956 sql_str += " section_name ='{0}'".format(data['Section Name'])957958 sdata = self.postgres.query_fetch_one(sql_str)959960 if sdata:961962 return 0963964 updated_data = {}965966 updated_data['difficulty_level'] = 1967968 updated_data['course_id'] = course_id969 updated_data['section_id'] = self.sha_security.generate_token(False)970 updated_data['section_name'] = data['Section Name']971 if data['Section Description']:972 updated_data['description'] = data['Section Description']973 if data['Section Difficulty Level']:974 updated_data['difficulty_level'] = data['Section Difficulty Level']975 updated_data['status'] = True976 updated_data['created_on'] = time.time()977978 section_id = self.postgres.insert('section', updated_data, 'section_id')979980 return section_id981982 def iu_subsection(self, data, course_id, section_id):983 """ UPDATE SUBSECTION """984985 if not data['Subsection Name'] and data['Subsection ID']:986987 conditions = []988989 conditions.append({990 "col": "subsection_id",991 "con": "=",992 "val": data['Subsection ID']993 })994995 self.postgres.delete('subsection', conditions)996997 if data['Subsection ID']:998999 updated_data = {}10001001 updated_data['difficulty_level'] = 110021003 updated_data['subsection_name'] = data['Subsection Name']1004 if data['Subsection Description']:1005 updated_data['description'] = data['Subsection Description']1006 if data['Subsection Difficulty Level']:1007 updated_data['difficulty_level'] = data['Subsection Difficulty Level']10081009 # INIT CONDITION1010 conditions = []10111012 # CONDITION FOR QUERY1013 conditions.append({1014 "col": "course_id",1015 "con": "=",1016 "val": course_id1017 })10181019 conditions.append({1020 "col": "section_id",1021 "con": "=",1022 "val": section_id1023 })10241025 conditions.append({1026 "col": "subsection_id",1027 "con": "=",1028 "val": data['Subsection ID']1029 })10301031 self.postgres.update('subsection', updated_data, conditions)10321033 return data['Subsection ID']10341035 if data['Subsection Name']:10361037 sql_str = "SELECT * FROM subsection WHERE"1038 sql_str += " subsection_name ='{0}'".format(data['Subsection Name'])10391040 ssdata = self.postgres.query_fetch_one(sql_str)10411042 if ssdata:10431044 return 010451046 updated_data = {}10471048 updated_data['difficulty_level'] = 110491050 updated_data['course_id'] = course_id1051 updated_data['section_id'] = section_id1052 updated_data['subsection_id'] = self.sha_security.generate_token(False)1053 updated_data['subsection_name'] = data['Subsection Name']1054 if data['Subsection Description']:1055 updated_data['description'] = data['Subsection Description']1056 if data['Subsection Difficulty Level']:1057 updated_data['difficulty_level'] = data['Subsection Difficulty Level']1058 updated_data['status'] = True1059 updated_data['created_on'] = time.time()10601061 subsection_id = self.postgres.insert('subsection', updated_data, 'subsection_id')10621063 return subsection_id10641065 def iu_exercise(self, data, course_id, section_id, subsection_id):1066 """ UPDATE COURSE """10671068 if not data['Exercise Number'] and data['Exercise ID']:10691070 conditions = []10711072 conditions.append({1073 "col": "exercise_id",1074 "con": "=",1075 "val": data['Exercise ID']1076 })10771078 self.postgres.delete('course_question', conditions)1079 self.postgres.delete('exercise', conditions)10801081 return data['Exercise ID']10821083 if data['Exercise ID']:10841085 updated_data = {}1086 updated_data['exercise_number'] = data['Exercise Number']10871088 # CODE FOR QUESTIONS10891090 if data['Exercise Question Type']:1091 updated_data['question_types'] = json.dumps(data['Exercise Question Type'].replace("\'", "").replace("\"", "")[1:-1].split(", "))1092 if data['Exercise Tags']:1093 updated_data['tags'] = json.dumps(data['Exercise Tags'].replace("\'", "").replace("\"", "")[1:-1].split(", "))1094 if data['Exercise Description']:1095 updated_data['description'] = data['Exercise Description']1096 if data['Exercise Draw By Tag']:1097 updated_data['draw_by_tag'] = data['Exercise Draw By Tag'].upper() == 'TRUE'1098 if data['Exercise Editing Allowed']:1099 updated_data['editing_allowed'] = data['Exercise Editing Allowed'].upper() == 'TRUE'1100 if data['Exercise Help']:1101 updated_data['help'] = data['Exercise Help'].upper() == 'TRUE'1102 if data['Exercise Instant Feedback']:1103 updated_data['instant_feedback'] = data['Exercise Instant Feedback'].upper() == 'TRUE'1104 if data['Exercise Moving Allowed']:1105 updated_data['moving_allowed'] = data['Exercise Moving Allowed'].upper() == 'TRUE'1106 if data['Exercise Number to Draw']:1107 updated_data['number_to_draw'] = data['Exercise Number to Draw']1108 if data['Exercise Passing Criterium']:1109 updated_data['passing_criterium'] = data['Exercise Passing Criterium']1110 if data['Exercise Save Seed']:1111 updated_data['save_seed'] = data['Exercise Save Seed'].upper() == 'TRUE'1112 if data['Exercise Seed']:1113 updated_data['seed'] = data['Exercise Seed']1114 if data['Exercise Shuffled']:1115 updated_data['shuffled'] = data['Exercise Shuffled'].upper() == 'TRUE'1116 if data['Exercise Text Before Start']:1117 updated_data['text_before_start'] = data['Exercise Text Before Start']1118 if data['Exercise Text After End']:1119 updated_data['text_after_end'] = data['Exercise Text After End']1120 if data['Exercise Timed Limit']:1121 updated_data['timed_limit'] = data['Exercise Timed Limit']1122 if data['Exercise Timed Type']:1123 updated_data['timed_type'] = data['Exercise Timed Type']112411251126 # INIT CONDITION1127 conditions = []11281129 # CONDITION FOR QUERY1130 conditions.append({1131 "col": "course_id",1132 "con": "=",1133 "val": course_id1134 })11351136 conditions.append({1137 "col": "section_id",1138 "con": "=",1139 "val": section_id1140 })11411142 conditions.append({1143 "col": "subsection_id",1144 "con": "=",1145 "val": subsection_id1146 })11471148 conditions.append({1149 "col": "exercise_id",1150 "con": "=",1151 "val": data['Exercise ID']1152 })11531154 self.postgres.update('exercise', updated_data, conditions)11551156 # ADD QUESTION to COURSE QUESTION1157 self.add_course_question(data['Exercise ID'])11581159 return data['Exercise ID']11601161 updated_data = {}1162 updated_data['draw_by_tag'] = False1163 updated_data['editing_allowed'] = True1164 updated_data['help'] = True1165 updated_data['instant_feedback'] = True1166 updated_data['moving_allowed'] = True1167 updated_data['number_to_draw'] = 101168 updated_data['passing_criterium'] = 51169 updated_data['save_seed'] = True1170 updated_data['seed'] = 101171 updated_data['shuffled'] = False1172 updated_data['timed_limit'] = 3001173 updated_data['timed_type'] = 'per_question'11741175 updated_data['course_id'] = course_id1176 updated_data['section_id'] = section_id1177 updated_data['subsection_id'] = subsection_id1178 updated_data['exercise_id'] = self.sha_security.generate_token(False)1179 updated_data['exercise_number'] = data['Exercise Number']1180 if data['Exercise Question Type']:1181 updated_data['question_types'] = json.dumps(data['Exercise Question Type'].replace("\'", "").replace("\"", "")[1:-1].split(", "))1182 if data['Exercise Tags']:1183 updated_data['tags'] = json.dumps(data['Exercise Tags'].replace("\'", "").replace("\"", "")[1:-1].split(", "))1184 if data['Exercise Description']:1185 updated_data['description'] = data['Exercise Description']1186 if data['Exercise Draw By Tag']:1187 updated_data['draw_by_tag'] = data['Exercise Draw By Tag'].upper() == 'TRUE'1188 if data['Exercise Description']:1189 updated_data['editing_allowed'] = data['Exercise Editing Allowed'].upper() == 'TRUE'1190 if data['Exercise Help']:1191 updated_data['help'] = data['Exercise Help'].upper() == 'TRUE'1192 if data['Exercise Instant Feedback']:1193 updated_data['instant_feedback'] = data['Exercise Instant Feedback'].upper() == 'TRUE'1194 if data['Exercise Moving Allowed']:1195 updated_data['moving_allowed'] = data['Exercise Moving Allowed'].upper() == 'TRUE'1196 if data['Exercise Number to Draw']:1197 updated_data['number_to_draw'] = data['Exercise Number to Draw']1198 if data['Exercise Passing Criterium']:1199 updated_data['passing_criterium'] = data['Exercise Passing Criterium']1200 if data['Exercise Save Seed']:1201 updated_data['save_seed'] = data['Exercise Save Seed'].upper() == 'TRUE'1202 if data['Exercise Seed']:1203 updated_data['seed'] = data['Exercise Seed']1204 if data['Exercise Shuffled']:1205 updated_data['shuffled'] = data['Exercise Shuffled'].upper() == 'TRUE'1206 if data['Exercise Text Before Start']:1207 updated_data['text_before_start'] = data['Exercise Text Before Start']1208 if data['Exercise Text After End']:1209 updated_data['text_after_end'] = data['Exercise Text After End']1210 if data['Exercise Timed Limit']:1211 updated_data['timed_limit'] = data['Exercise Timed Limit']1212 if data['Exercise Timed Type']:1213 updated_data['timed_type'] = data['Exercise Timed Type']1214 updated_data['created_on'] = time.time()12151216 exercise_id = self.postgres.insert('exercise', updated_data, 'exercise_id')12171218 # ADD QUESTION to COURSE QUESTION1219 self.add_course_question(exercise_id)12201221 return exercise_id12221223 def iu_question(self, data, course_id, section_id, subsection_id, exercise_id):1224 """ UPDATE QUESTION """12251226 question_id = self.get_question_id(data)12271228 sql_str = "SELECT question_id FROM course_question WHERE"1229 sql_str += " course_id='{0}'".format(course_id)1230 sql_str += " AND section_id='{0}'".format(section_id)1231 sql_str += " AND subsection_id='{0}'".format(subsection_id)1232 sql_str += " AND exercise_id='{0}'".format(exercise_id)1233 sql_str += " AND question_id='{0}'".format(question_id)12341235 if not self.postgres.query_fetch_one(sql_str):12361237 qtype = data['Question Type']12381239 temp = {}1240 temp['question_id'] = question_id1241 temp['course_question_id'] = self.sha_security.generate_token(False)1242 temp['course_id'] = course_id1243 temp['section_id'] = section_id1244 temp['subsection_id'] = subsection_id1245 temp['exercise_id'] = exercise_id1246 temp['question_type'] = data['Question Type']1247 temp['tags'] = json.dumps(data['Question Tags'].replace("\'", "").replace("\"", "")[1:-1].split(", "))1248 temp['shuffle_options'] = ""1249 temp['shuffle_answers'] = ""1250 temp['feedback'] = ""1251 array_choice = []12521253 if qtype == 'FITBT':12541255 ans = "".join(re.findall(r'[^\{$\}]', data['Question Correct Answer']))1256 answer = {}1257 answer['answer'] = data['Question'].replace("<ans>", str(ans))12581259 quest = {}1260 quest['question'] = data['Question']12611262 temp['correct_answer'] = json.dumps(answer)1263 temp['question'] = json.dumps(quest)12641265 elif qtype == 'FITBD':12661267 answer = {}1268 answer['answer'] = data['Question']12691270 allans = "".join(re.findall(r'[^\{$\}]', data['Question Correct Answer'])).split(", ")12711272 for ans in allans:12731274 correct_answer = answer['answer'].replace("[blank]", ans, 1)1275 answer['answer'] = correct_answer12761277 quest = {}1278 quest['question'] = data['Question'].replace("[blank]", "<ans>")12791280 temp['correct_answer'] = json.dumps(answer)1281 temp['question'] = json.dumps(quest)12821283 elif qtype == 'MULCH':12841285 choices = "".join(re.findall(r'[^\{$\}]', data['Question Choices']))1286 choices = choices.split(", ")12871288 for choice in choices:12891290 array_choice.append(choice)12911292 answer = {}1293 answer['answer'] = data['Question Correct Answer']12941295 quest = {}1296 quest['question'] = data['Question']12971298 temp['correct_answer'] = json.dumps(answer)1299 temp['question'] = json.dumps(quest)13001301 elif qtype == 'MATCH':13021303 temp['shuffle_options'] = data['Question Shuffle Options']1304 temp['shuffle_answers'] = data['Question Shuffle Answers']13051306 allans = "".join(re.findall(r'[^\{$\}]', data['Question Correct Answer'])).split(", ")1307 answer = {}1308 answer['answer'] = allans13091310 quest_data = data['Question'].replace("\"", "")1311 allquest = "".join(re.findall(r'[^\{$\}]', quest_data)).split(", ")1312 quest = {}1313 quest['question'] = allquest13141315 array_choice = "".join(re.findall(r'[^\{$\}]', data['Question Choices']))1316 array_choice = array_choice.split(", ")1317 temp['correct_answer'] = json.dumps(answer)1318 temp['question'] = json.dumps(quest)13191320 elif qtype == 'MULRE':13211322 temp['shuffle_options'] = data['Question Shuffle Options']1323 temp['shuffle_answers'] = data['Question Shuffle Answers']13241325 allans = data['Question Correct Answer'].replace("\"", "")1326 allans = "".join(re.findall(r'[^\{$\}]', allans)).split(", ")1327 answer = {}1328 answer['answer'] = allans13291330 quest = {}1331 quest['question'] = data['Question']13321333 array_choice = data['Question Choices'].replace("\"", "")1334 array_choice = "".join(re.findall(r'[^\{$\}]', array_choice))1335 array_choice = array_choice.split(", ")1336 temp['correct_answer'] = json.dumps(answer)1337 temp['question'] = json.dumps(quest)13381339 if data['Question Description']:13401341 temp['description'] = data['Question Description']13421343 else:1344 temp['description'] = "Lorem ipsum dolor sit amet, consectetur "1345 temp['description'] += "adipiscing elit, sed do eiusmod tempor "1346 temp['description'] += "incididunt ut labore et dolore magna aliqua."13471348 temp['choices'] = json.dumps(array_choice)1349 temp['correct'] = data['Question Correct']1350 temp['incorrect'] = data['Question Incorrect']1351 temp['status'] = True1352 temp['num_eval'] = data['Question Num Eval'].upper() == 'TRUE'1353 temp['created_on'] = time.time()13541355 self.postgres.insert('course_question', temp, 'course_question_id')13561357 return question_id13581359 def add_course_question(self, exercise_id):1360 """ Add Question for Exercise """13611362 sql_str = "SELECT * FROM exercise WHERE exercise_id='{0}'".format(exercise_id)1363 result = self.postgres.query_fetch_one(sql_str)13641365 if result:13661367 questions = []1368 if result['shuffled'] is True:13691370 # SELECT QUESTION BY QUESTION TYPE AND TAGS1371 tags = []1372 if result['draw_by_tag'] is True:1373 tags = result['tags']13741375 qtypes = result['question_types']1376 number_to_draw = result['number_to_draw']1377 questions = self.generate_random_questions(qtypes, int(number_to_draw), tags)1378 # questionnaires = self.get_questions_by_condition(qtypes, tags)1379 # questions = self.select_random_questions(questionnaires, number_to_draw, qtypes)13801381 # INSERT TO COURSE QUESTION TABLE1382 for question in questions:13831384 qdata = self.get_question_by_id(question)13851386 if qdata:13871388 tmp = {}1389 tmp['course_question_id'] = self.sha_security.generate_token(False)1390 tmp['course_id'] = result['course_id']1391 tmp['section_id'] = result['section_id']1392 tmp['subsection_id'] = result['subsection_id']1393 tmp['exercise_id'] = exercise_id1394 tmp['question_id'] = question1395 tmp['question'] = json.dumps(qdata['question'])1396 tmp['question_type'] = qdata['question_type']1397 tmp['tags'] = json.dumps(qdata['tags'])1398 tmp['choices'] = json.dumps(qdata['choices'])1399 tmp['num_eval'] = qdata['num_eval']1400 tmp['correct_answer'] = json.dumps(qdata['correct_answer'])1401 tmp['correct'] = qdata['correct']1402 tmp['incorrect'] = qdata['incorrect']14031404 if qdata['feedback']:1405 tmp['feedback'] = qdata['feedback']14061407 if qdata['shuffle_options']:1408 tmp['shuffle_options'] = qdata['shuffle_options']14091410 if qdata['shuffle_answers']:1411 tmp['shuffle_answers'] = qdata['shuffle_answers']14121413 tmp['description'] = qdata['description']1414 tmp['status'] = qdata['status']1415 tmp['created_on'] = time.time()14161417 self.postgres.insert('course_question', tmp, 'course_question_id')141814191420 def get_questions_by_condition(self, question_types, tags):1421 """ Return Question by type and tags """14221423 qtype = ','.join("'{0}'".format(qtype) for qtype in question_types)1424 tag = '"tags"'14251426 sql_str = "SELECT * FROM questions WHERE question_type IN ({0})".format(qtype)1427 if tags:1428 tags = ', '.join('"{0}"'.format(tag) for tag in tags)1429 sql_str += " AND CAST({0} AS text) = '[{1}]'".format(tag, tags)14301431 results = self.postgres.query_fetch_all(sql_str)14321433 return results14341435 def select_random_questions(self, questions, number_to_draw, question_type):1436 """ Return Questions by type """14371438 questionnaires = []14391440 number_to_draw = int(number_to_draw)1441 if not number_to_draw:1442 number_to_draw = 1014431444 limit = math.floor(number_to_draw / len(question_type))14451446 for qtype in question_type:1447 qlist = [question['question_id'] for question in questions \1448 if question['question_type'] == qtype]14491450 # SHUFFLE QUESTIONS1451 random.shuffle(qlist)14521453 qlist = qlist[:limit]1454 questionnaires += qlist14551456 if len(questionnaires) != number_to_draw:14571458 draw_again = number_to_draw - len(questionnaires)1459 qlist = [question['question_id'] for question in questions \1460 if question['question_type'] in question_type \1461 and question['question_id'] not in questionnaires]14621463 # SHUFFLE QUESTIONS1464 random.shuffle(qlist)14651466 qlist = qlist[:draw_again]1467 questionnaires += qlist14681469 return questionnaires14701471 def get_question_by_id(self, question_id):1472 """ Return Question Data by ID """14731474 sql_str = "SELECT * FROM questions WHERE question_id = '{0}'".format(question_id)1475 result = self.postgres.query_fetch_one(sql_str)14761477 return result14781479 def use_course(self, course_id):1480 """ CHECK IF COURSE IN USE """14811482 sql_str = "SELECT * FROM student_course WHERE"1483 sql_str += " course_id='{0}'".format(course_id)14841485 if not self.postgres.query_fetch_one(sql_str):14861487 return 114881489 return 014901491 def update_course(self, data, course_id=None):1492 """ UPDATE COURSE """14931494 updated_data = {}1495 updated_data['course_name'] = data['Course Name']1496 updated_data['description'] = data['Course Description']1497 updated_data['difficulty_level'] = data['Course Difficulty Level']1498 updated_data['requirements'] = data['Course Requirements']14991500 # INIT CONDITION1501 conditions = []15021503 # CONDITION FOR QUERY1504 conditions.append({1505 "col": "course_id",1506 "con": "=",1507 "val": data['Course ID']1508 })15091510 self.postgres.update('course', updated_data, conditions)15111512 return data['Course ID']15131514 def get_question_id(self, row):1515 """ RETURN QUESTION ID """15161517 if row['Question'] and row['Question ID']:15181519 return row['Question ID']15201521 sql_str = "SELECT question_id FROM questions WHERE"1522 sql_str += " question='{0}'".format(row['Question'])1523 sql_str += " AND question_type='{0}'".format(row['Question Type'])1524 sql_str += " AND tags='{0}'".format(row['Question Tags'])1525 response = self.postgres.query_fetch_one(sql_str)15261527 question_id = ""15281529 if not response:15301531 qtype = row['Question Type']15321533 question_id = self.sha_security.generate_token(False)15341535 temp = {}1536 temp['question_id'] = question_id1537 temp['question_type'] = row['Question Type']1538 temp['tags'] = json.dumps(row['Question Tags'].replace("\'", "").replace("\"", "")[1:-1].split(", "))1539 temp['shuffle_options'] = ""1540 temp['shuffle_answers'] = ""1541 temp['feedback'] = ""1542 array_choice = []15431544 if qtype == 'FITBT':15451546 ans = "".join(re.findall(r'[^\{$\}]', row['Question Correct Answer']))1547 answer = {}1548 answer['answer'] = row['Question'].replace("<ans>", str(ans))15491550 quest = {}1551 quest['question'] = row['Question']15521553 temp['correct_answer'] = json.dumps(answer)1554 temp['question'] = json.dumps(quest)15551556 elif qtype == 'FITBD':15571558 answer = {}1559 answer['answer'] = row['Question']15601561 allans = "".join(re.findall(r'[^\{$\}]', row['Question Correct Answer'])).split(", ")15621563 for ans in allans:15641565 correct_answer = answer['answer'].replace("[blank]", ans, 1)1566 answer['answer'] = correct_answer15671568 quest = {}1569 quest['question'] = row['Question'].replace("[blank]", "<ans>")15701571 temp['correct_answer'] = json.dumps(answer)1572 temp['question'] = json.dumps(quest)15731574 elif qtype == 'MULCH':15751576 choices = "".join(re.findall(r'[^\{$\}]', row['Question Choices']))1577 choices = choices.split(", ")15781579 for choice in choices:15801581 array_choice.append(choice)15821583 answer = {}1584 answer['answer'] = row['Question Correct Answer']15851586 quest = {}1587 quest['question'] = row['Question']15881589 temp['correct_answer'] = json.dumps(answer)1590 temp['question'] = json.dumps(quest)15911592 elif qtype == 'MATCH':15931594 temp['shuffle_options'] = row['Question Shuffle Options']1595 temp['shuffle_answers'] = row['Question Shuffle Answers']15961597 allans = "".join(re.findall(r'[^\{$\}]', row['Question Correct Answer'])).split(", ")1598 answer = {}1599 answer['answer'] = allans16001601 quest_data = row['Question'].replace("\"", "")1602 allquest = "".join(re.findall(r'[^\{$\}]', quest_data)).split(", ")1603 quest = {}1604 quest['question'] = allquest16051606 array_choice = "".join(re.findall(r'[^\{$\}]', row['Question Choices']))1607 array_choice = array_choice.split(", ")1608 temp['correct_answer'] = json.dumps(answer)1609 temp['question'] = json.dumps(quest)16101611 elif qtype == 'MULRE':16121613 temp['shuffle_options'] = row['Question Shuffle Options']1614 temp['shuffle_answers'] = row['Question Shuffle Answers']16151616 allans = row['Question Correct Answer'].replace("\"", "")1617 allans = "".join(re.findall(r'[^\{$\}]', allans)).split(", ")1618 answer = {}1619 answer['answer'] = allans16201621 quest = {}1622 quest['question'] = row['Question']16231624 array_choice = row['Question Choices'].replace("\"", "")1625 array_choice = "".join(re.findall(r'[^\{$\}]', array_choice))1626 array_choice = array_choice.split(", ")1627 temp['correct_answer'] = json.dumps(answer)1628 temp['question'] = json.dumps(quest)16291630 if row['Question Description']:16311632 temp['description'] = row['Question Description']16331634 else:1635 temp['description'] = "Lorem ipsum dolor sit amet, consectetur "1636 temp['description'] += "adipiscing elit, sed do eiusmod tempor "1637 temp['description'] += "incididunt ut labore et dolore magna aliqua."16381639 temp['choices'] = json.dumps(array_choice)1640 temp['correct'] = row['Question Correct']1641 temp['incorrect'] = row['Question Incorrect']1642 temp['num_eval'] = row['Question Num Eval'].upper() == 'TRUE'16431644 if row['Question Feedback']:1645 temp['feedback'] = row['Question Feedback']1646 temp['status'] = True1647 temp['created_on'] = time.time()1648 self.postgres.insert('questions', temp)16491650 else:16511652 question_id = response['question_id']16531654 return question_id165516561657 def get_period(self, epoch_range, format_range):1658 """ Return Start and End Time """16591660 start = epoch_range[0]1661 end = epoch_range[-1]16621663 year = datetime.fromtimestamp(int(end)).strftime('%Y')1664 month = datetime.fromtimestamp(int(end)).strftime('%m')1665 day = datetime.fromtimestamp(int(end)).strftime('%d')16661667 if format_range in ['day', 'days']:1668 end = datetime(int(year), int(month), int(day), 23, 59, 59).timestamp()16691670 elif format_range in ['weeks', 'week']:1671 end = self.week_end_date(end)16721673 elif format_range in ['year', 'years']:1674 month_end = calendar.monthrange(int(year), int(month))[1]1675 end = datetime(int(year), 12, int(month_end), 23, 59, 59).timestamp()16761677 else:1678 month_end = calendar.monthrange(int(year), int(month))[1]1679 end = datetime(int(year), int(month), int(month_end), 23, 59, 59).timestamp()16801681 tmp = {}1682 tmp['start'] = int(start)1683 tmp['end'] = int(end)16841685 return tmp16861687 def epoch_range(self, epoch_format, number):1688 """ Return Epoch Timestamp Coverage """16891690 if epoch_format in ['years', 'year']:1691 epoch_format = "years"16921693 if epoch_format in ['months', 'month']:1694 epoch_format = "months"16951696 if epoch_format in ['weeks', 'week']:1697 epoch_format = "weeks"16981699 if epoch_format in ['days', 'day']:1700 epoch_format = "days"17011702 year = datetime.now().strftime("%Y")1703 month = datetime.now().strftime("%m")1704 day = datetime.now().strftime("%d")17051706 is_default = False1707 if not epoch_format and not number:1708 start = datetime(int(year), 1, 1, 0, 0)1709 end = datetime(int(year), int(month), 1, 0, 0)1710 number = dateutil.relativedelta.relativedelta(end, start).months1711 epoch_format = "months"1712 is_default = True17131714 epoch = []17151716 if epoch_format == "months":1717 day = 117181719 if epoch_format == "years":1720 day = 11721 month = 117221723 base_start = datetime(int(year), int(month), int(day), 0, 0)17241725 if number and int(number):1726 for num in range(int(number)):1727 kwargs = {}1728 kwargs[epoch_format] = int(num + 1)17291730 start = base_start - dateutil.relativedelta.relativedelta(**kwargs)1731 epoch_start = round(start.timestamp())1732 epoch.append(epoch_start)17331734 if is_default:1735 epoch.append(round(base_start.timestamp()))1736 else:1737 epoch.append(round(base_start.timestamp()))1738 epoch.sort()1739 epoch.remove(epoch[0])17401741 epoch.sort()17421743 return epoch17441745 def week_end_date(self, epoch):1746 """ Return end of week date """17471748 timestamp = epoch1749 one_day = 864001750 end_week_date = (timestamp + (one_day * 7)) - 11751 return end_week_date17521753 def week_start_end(self, epoch):1754 """ Return week start and end """17551756 date = datetime.fromtimestamp(int(epoch)).strftime('%Y-%m-%d')17571758 date = datetime.strptime(date, '%Y-%m-%d')17591760 week_start = date - timedelta(days=date.weekday()) # Monday1761 week_end = week_start + timedelta(days=6) # Sunday17621763 data = {}1764 data['week_start'] = week_start.timestamp()1765 data['week_end'] = week_end.timestamp()1766 return data17671768 def epoch_week_number(self, epoch):1769 """ Return Week Number """17701771 return datetime.fromtimestamp(int(epoch)).strftime("%V")17721773 def yearend_month_date(self, epoch_date):1774 """ Return Month Year End Date in Epoch"""17751776 year = datetime.fromtimestamp(int(epoch_date)).strftime('%Y')1777 epoch_year = datetime(int(year), 12, 1, 0, 0).strftime('%s')1778 return epoch_year17791780 def month_end(self, epoch_date):1781 """ Return Month End """17821783 year = datetime.fromtimestamp(int(epoch_date)).strftime('%Y')1784 month = datetime.fromtimestamp(int(epoch_date)).strftime('%m')1785 day = calendar.monthrange(int(year), int(month))[1]17861787 month_end = int(datetime(int(year), int(month), int(day), 0, 0).timestamp())1788 return month_end17891790 def get_epoch_weekday(self, epoch_date):1791 """ Return day of epoch date """17921793 return datetime.fromtimestamp(epoch_date).strftime("%A")17941795 def get_epoch_month(self, epoch_date):1796 """ Return Epoch Date Month """17971798 return datetime.fromtimestamp(int(epoch_date)).strftime('%b')17991800 def get_epoch_year(self, epoch_date):1801 """ Return Epoch Year """18021803 return datetime.fromtimestamp(int(epoch_date)).strftime('%Y')18041805 def day_end(self, epoch_date):1806 """ Return Day End"""18071808 # END1809 year = datetime.fromtimestamp(int(epoch_date)).strftime("%Y")1810 month = datetime.fromtimestamp(int(epoch_date)).strftime("%m")1811 day = datetime.fromtimestamp(int(epoch_date)).strftime("%d")1812 end = int(datetime(int(year), int(month), int(day), 23, 59, 59).timestamp())1813 return end18141815 def generate_random_questions(self, question_types, number_to_draw, tags):1816 """ Generate Random Question """18171818 questions = []1819 limit = math.floor(number_to_draw / len(question_types))1820 for qtype in question_types:18211822 questions += self.get_random_questions(qtype, limit, tags)18231824 if len(questions) != number_to_draw:18251826 draw_again = number_to_draw - len(questions)1827 question_type = random.choice(question_types)1828 questions += self.get_random_questions(question_type, draw_again, tags)18291830 return questions1831 1832 def get_random_questions(self, question_type, number_to_draw, tags):1833 """ Return Question by Type and Tags """18341835 if question_type.upper() == "MATCH":1836 # GENERATE FITBT MATCHING TYPE QUESTIONS1837 questions = self.create_match_question(tags, number_to_draw)18381839 else:1840 questionnaires = self.get_questions(question_type, tags, number_to_draw)1841 questions = [question['question_id'] for question in questionnaires]18421843 return questions18441845 def get_questions(self, question_type, tags, limit):1846 """ Return Questions """18471848 tag = '"tags"'18491850 sql_str = "SELECT * FROM questions WHERE question_type='{0}'".format(question_type)1851 if tags:1852 tags = ', '.join('"{0}"'.format(tag) for tag in tags)1853 sql_str += " AND CAST({0} AS text) = '[{1}]'".format(tag, tags)18541855 results = self.postgres.query_fetch_all(sql_str)18561857 if results:1858 # questions = [result['question_id'] for result in results]1859 random.shuffle(results)1860 results = results[:limit]1861 return results18621863 def create_match_question(self, tags, number_to_draw):1864 """ Create Matching Type Questions """18651866 data = []1867 match_qlimit = 51868 for _ in range(number_to_draw):1869 questions = self.get_questions("FITBT", tags, match_qlimit)18701871 if questions:1872 match_questions = []1873 correct_answer = []1874 for question in questions:18751876 quest = question['question']['question'].replace("<ans>", "")1877 if "rest" in question['question']['question']:1878 quest = question['question']['question'].replace("<ans> rest <ans>", "")18791880 answer = question['correct_answer']['answer'].replace(quest, "")1881 if "rest" in answer:1882 answer = answer.replace("rest", "/")1883 answer = answer.replace(" ", "")18841885 match_questions.append(quest.rstrip())1886 correct_answer.append(answer)18871888 choices = correct_answer1889 random.shuffle(choices)18901891 tmp_question = {}1892 tmp_question['question'] = match_questions18931894 tmp_correct_answer = {}1895 tmp_correct_answer['answer'] = correct_answer18961897 temp = {}1898 temp['question_id'] = self.sha_security.generate_token(False)1899 temp['question'] = json.dumps(tmp_question)1900 temp['question_type'] = "MATCH"1901 temp['tags'] = json.dumps(tags)1902 temp['choices'] = json.dumps(choices)1903 temp['shuffle_options'] = True1904 temp['shuffle_answers'] = False1905 temp['num_eval'] = True1906 temp['correct_answer'] = json.dumps(tmp_correct_answer)1907 temp['correct'] = questions[0]['correct']1908 temp['incorrect'] = questions[0]['incorrect']1909 temp['feedback'] = questions[0]['feedback']1910 temp['description'] = questions[0]['description']1911 temp['status'] = True1912 temp['created_on'] = time.time()19131914 question_id = self.postgres.insert('questions', temp, 'question_id')1915 data.append(question_id)19161917 return data19181919 def get_translation(self, message, language):1920 """ Return Translation """19211922 sql_str = "SELECT translation FROM translations WHERE word_id=("1923 sql_str += "SELECT word_id FROM words WHERE"1924 sql_str += " name = '{0}') AND ".format(message)1925 sql_str += "language_id=(SELECT language_id FROM language WHERE "1926 sql_str += "initial='{0}')".format(language)19271928 return self.postgres.query_fetch_one(sql_str)19291930 def update_translate(self, data, userid):1931 """ Update Translation """19321933 sql_str = "SELECT language FROM account WHERE"1934 sql_str += " id='{0}'".format(userid)1935 language = self.postgres.query_fetch_one(sql_str)19361937 if language['language'] != 'en-US':1938 keys = ['rows', 'data', 'course']1939 for key in keys:19401941 if key in data.keys():19421943 if type(data[key]) == list:1944 for row in data[key]:19451946 # COURSE NAME1947 if 'course_name' in row.keys():1948 row['course_name'] = self.translate_key(language,1949 row['course_name'])19501951 # DESCRIPTION1952 if 'description' in row.keys():1953 row['description'] = self.translate_key(language,1954 row['description'])19551956 if 'notification_name' in row.keys():1957 row['notification_name'] = self.translate_key(language,1958 row['notification_name'])1959 else:1960 if 'course_name' in data[key].keys():1961 if type(data[key]['course_name']) == str:19621963 data[key]['course_name'] = self.translate_key(language,1964 data[key]['course_name'])19651966 if 'description' in data[key].keys():1967 if type(data[key]['description']) == str:19681969 data[key]['description'] = self.translate_key(language,1970 data[key]['description'])19711972 # else:19731974 # if 'course_name' in data[key].keys():1975 # if type(data[key]['course_name']) == str:19761977 # data[key]['course_name'] = self.translate_key(language,1978 # data[key]['course_name'])1979 # else:1980 # for row in data[key]:1981 # if 'course_name' in row.keys():1982 # row['course_name'] = self.translate_key(language,1983 # row['çourse_name'])1984 1985 # # DESCRIPTION1986 # if 'description' in data[key].keys():19871988 # if type(data[key]['description']) == str:1989 1990 # data[key]['description'] = self.translate_key(language,1991 # data[key]['course_name'])1992 # else:1993 # for row in data[key]:1994 # if 'course_name' in row.keys():1995 # row['course_name'] = self.translate_key(language, row['description'])19961997 return data19981999 def translate_key(self, language, original):2000 """ Translate Key """20012002 message = "".join(re.findall(r'[a-zA-Z\ \.\,]', original))2003 translate = self.get_translation(message, language['language'])20042005 if translate:2006 return translate['translation']20072008 return original20092010 def get_account_details(self, user_id):2011 """ Return Account Details """20122013 sql_str = "SELECT * FROM account WHERE id='{0}'".format(user_id)2014 result = self.postgres.query_fetch_one(sql_str)
...
progress.py
Source:progress.py
...23 exercise_table = "{0}_exercise".format(key)24 sql_str = "SELECT * FROM {0}".format(exercise_table)25 sql_str += " WHERE exercise_id='{0}'".format(exercise_id)26 sql_str += " AND account_id='{0}' AND status is True".format(user_id)27 result = self.postgres.query_fetch_one(sql_str)2829 if result:3031 # QUESTIONS32 column_id = "{0}_exercise_id".format(key)3334 sql_str = "SELECT * FROM {0}_exercise_questions".format(key)35 sql_str += " WHERE {0} = '{1}'".format(column_id, result[column_id])36 questions = self.postgres.query_fetch_all(sql_str)3738 score = 039 for question in questions:40 ans = self.check_answer(question['course_question_id'], question['answer'])4142 if ans['isCorrect'] is True:43 score += 14445 # UPDATE PROGRESS46 progress = self.check_progress(questions)4748 # PERCENT SCORE49 total = len(questions)50 percent_score = self.format_progress((score / total) * 100)5152 # UPDATE SCORE53 tmp = {}54 tmp['score'] = score55 tmp['progress'] = progress56 tmp['percent_score'] = percent_score57 if key.upper() == "STUDENT":58 tmp['end_on'] = time.time()5960 tmp['update_on'] = time.time()61 conditions = []6263 conditions.append({64 "col": "exercise_id",65 "con": "=",66 "val": exercise_id67 })6869 conditions.append({70 "col": column_id,71 "con": "=",72 "val": result[column_id]73 })7475 data = self.remove_key(tmp, "exercise_id")7677 self.postgres.update(exercise_table, data, conditions)7879 def update_subsection_progress(self, user_id, exercise_id, key):80 """ Update Course Progress """8182 exercise_table = "{0}_exercise".format(key)83 subsection_table = "{0}_subsection".format(key)84 exercise_questions_table = "{0}_exercise_questions".format(key)85 key_subsection_id = "{0}_subsection_id".format(key)86 key_exercise_id = "{0}_exercise_id".format(key)8788 sql_str = "SELECT * FROM exercise e LEFT JOIN {0}".format(subsection_table)89 sql_str += " sub ON e.subsection_id = sub.subsection_id"90 sql_str += " WHERE e.exercise_id='{0}'".format(exercise_id)91 subsection = self.postgres.query_fetch_one(sql_str)9293 student_subsection_id = subsection[key_subsection_id]94 subsection_id = subsection['subsection_id']95 course_id = subsection['course_id']9697 sql_str = "SELECT answer, percent_score FROM {0}".format(exercise_questions_table)98 sql_str += " WHERE {0} IN (SELECT {0}".format(key_exercise_id)99 sql_str += " FROM {0} WHERE status is True AND".format(exercise_table)100 sql_str += " account_id='{0}' AND".format(user_id)101 sql_str += " exercise_id IN (SELECT exercise_id FROM exercise WHERE "102 sql_str += " subsection_id='{0}' AND status is True))".format(subsection_id)103 student_exercise = self.postgres.query_fetch_all(sql_str)104105 answer = [dta['answer'] for dta in student_exercise]106 total = len(answer)107 not_answer = [None, '', []]108 total_answer = len([ans for ans in answer if ans not in not_answer])109 # print("Total: {0} Answer: {1}".format(total, total_answer))110 progress = 0111 if total_answer:112 progress = self.format_progress((total_answer / total) * 100)113114 # PERCENT SCORE115 percent_score = [dta['percent_score'] for dta in student_exercise]116 total = len(percent_score)117 percent_100 = len([dta['percent_score'] for dta in student_exercise \118 if dta['percent_score'] is not None and \119 int(dta['percent_score']) == 100])120121 percent_score = self.format_progress((percent_100 / total) * 100)122123 # UPDATE PROGRESS124 conditions = []125126 conditions.append({127 "col": key_subsection_id,128 "con": "=",129 "val": student_subsection_id130 })131132 conditions.append({133 "col": "course_id",134 "con": "=",135 "val": course_id136 })137138 data = {}139 data['progress'] = progress140 data['percent_score'] = percent_score141 data['update_on'] = time.time()142143 self.postgres.update(subsection_table, data, conditions)144145 def update_section_progress(self, user_id, exercise_id, key):146 """ Update Course Progress """147148 section_table = "{0}_section".format(key)149 key_section_id = "{0}_section_id".format(key)150 exercise_question_table = "{0}_exercise_questions".format(key)151 key_exercise_id = "{0}_exercise_id".format(key)152 exercise_table = "{0}_exercise".format(key)153154 sql_str = "SELECT * FROM exercise e"155 sql_str += " LEFT JOIN {0} ss ON e.section_id = ss.section_id".format(section_table)156 sql_str += " WHERE e.exercise_id='{0}'".format(exercise_id)157 section = self.postgres.query_fetch_one(sql_str)158159 section_id = section['section_id']160 course_id = section['course_id']161 student_section_id = section[key_section_id]162163 sql_str = "SELECT answer, percent_score FROM {0}".format(exercise_question_table)164 sql_str += " WHERE {0} IN (SELECT {0}".format(key_exercise_id)165 sql_str += " FROM {0} WHERE status is True AND".format(exercise_table)166 sql_str += " account_id='{0}' AND".format(user_id)167 sql_str += " exercise_id IN (SELECT exercise_id FROM exercise WHERE "168 sql_str += " section_id='{0}' AND status is True))".format(section_id)169 student_exercise = self.postgres.query_fetch_all(sql_str)170171 answer = [dta['answer'] for dta in student_exercise]172 total = len(answer)173 not_answer = [None, '', []]174 total_answer = len([ans for ans in answer if ans not in not_answer])175176 progress = 0177 if total_answer:178 progress = self.format_progress((total_answer / total) * 100)179180 # PERCENT SCORE181 percent_100 = len([dta['percent_score'] for dta in student_exercise \182 if dta['percent_score'] is not None and \183 int(dta['percent_score']) == 100])184185 percent_score = self.format_progress((percent_100 / total) * 100)186187 # UPDATE PROGRESS188 conditions = []189190 conditions.append({191 "col": key_section_id,192 "con": "=",193 "val": student_section_id194 })195196 conditions.append({197 "col": "course_id",198 "con": "=",199 "val": course_id200 })201202 data = {}203 data['progress'] = progress204 data['percent_score'] = percent_score205 data['update_on'] = time.time()206207 self.postgres.update(section_table, data, conditions)208209210 def update_course_progress(self, user_id, exercise_id, key):211 """ Update Course Progress """212213 exercise_table = "{0}_exercise".format(key)214 exercise_question_table = "{0}_exercise_questions".format(key)215 key_exercise_id = "{0}_exercise_id".format(key)216 course_table = "{0}_course".format(key)217218 sql_str = "SELECT * FROM {0} WHERE".format(exercise_table)219 sql_str += " exercise_id='{0}' AND status=true".format(exercise_id)220 sql_str += " AND account_id='{0}'".format(user_id)221 student_course = self.postgres.query_fetch_one(sql_str)222 course_id = student_course['course_id']223224 sql_str = "SELECT answer, percent_score FROM {0}".format(exercise_question_table)225 sql_str += " WHERE {0} IN (SELECT {0}".format(key_exercise_id)226 sql_str += " FROM {0} WHERE status is True AND".format(exercise_table)227 sql_str += " account_id='{0}' AND status is True)".format(user_id)228 student_exercise = self.postgres.query_fetch_all(sql_str)229230 answer = [dta['answer'] for dta in student_exercise]231 total = len(answer)232233 not_answer = [None, '', []]234 total_answer = len([ans for ans in answer if ans not in not_answer])235236 progress = self.format_progress((total_answer / total) * 100)237238 # PERCENT SCORE239 percent_score = [dta['percent_score'] for dta in student_exercise]240 total = len(percent_score)241 percent_100 = len([dta['percent_score'] for dta in student_exercise \242 if dta['percent_score'] is not None and \243 int(dta['percent_score']) == 100])244245 percent_score = self.format_progress((percent_100 / total) * 100)246247 # UPDATE PROGRESS248 conditions = []249250 conditions.append({251 "col": "account_id",252 "con": "=",253 "val": user_id254 })255256 conditions.append({257 "col": "course_id",258 "con": "=",259 "val": course_id260 })261262 data = {}263 data['progress'] = progress264 data['percent_score'] = percent_score265 data['update_on'] = time.time()266267 self.postgres.update(course_table, data, conditions)268269 if key == 'student':270271 self.all_progress(user_id)272 self.group_progress(user_id)273274 def all_progress(self, user_id):275 """ UPDATE ALL PROGRESS """276277 sql_str = "SELECT progress FROM student_course WHERE"278 sql_str += " account_id='{0}' AND status='t'".format(user_id)279 progress = self.postgres.query_fetch_all(sql_str)280281 total_prog = 0282 total_course = len(progress) * 100283 for pgrss in progress:284285 total_prog = total_prog + float(pgrss['progress'])286287 average = self.format_progress((total_prog/total_course) * 100)288289 # UPDATE PROGRESS290 conditions = []291292 conditions.append({293 "col": "id",294 "con": "=",295 "val": user_id296 })297298 data = {}299 data['progress'] = average300 data['update_on'] = time.time()301302 self.postgres.update('account', data, conditions)303304 return 1305306 def group_progress(self, user_id):307 """ UPDATE GROUP PROGRESS """308309 sql_str = "SELECT user_group_id FROM user_group_students WHERE"310 sql_str += " student_id='{0}'".format(user_id)311312 user_group = self.postgres.query_fetch_all(sql_str)313314 # UPDATE GROUP315 for sgroup in user_group:316317 user_group_id = sgroup['user_group_id']318319 # GET ALL USER PROGRESS IN A GROUP320 sql_str = "SELECT progress FROM account WHERE id IN ("321 sql_str += "SELECT student_id FROM user_group_students WHERE"322 sql_str += " user_group_id='{0}')".format(user_group_id)323 progress = self.postgres.query_fetch_all(sql_str)324325 total_prog = 0326 total_student = len(progress) * 100327328 for pgrss in progress:329330 total_prog = total_prog + float(pgrss['progress'])331332 # GET AVERAGE PROGRESS333 average = self.format_progress((total_prog/total_student) * 100)334335 # UPDATE PROGRESS336 conditions = []337338 conditions.append({339 "col": "user_group_id",340 "con": "=",341 "val": user_group_id342 })343344 # GET LEAST PERFORMER345 sql_str = "SELECT id, ROUND(cast(progress as numeric),2) AS progress"346 sql_str += " FROM account WHERE id IN (SELECT student_id FROM"347 sql_str += " user_group_students WHERE"348 sql_str += " user_group_id='{0}')".format(user_group_id)349 sql_str += " ORDER BY progress ASC"350 student = self.postgres.query_fetch_one(sql_str)351352 # UPDATE GROUP PROGRESS353 data = {}354 data['least_performer'] = student['id']355 data['progress'] = average356 data['update_on'] = time.time()357358 self.postgres.update('user_group', data, conditions)359
...
questions.py
Source:questions.py
...23 """ Generate Questionnaires based on settings """2425 sql_str = "SELECT * FROM exercise WHERE exercise_id = '{0}'".format(exercise_id)26 sql_str += " AND course_id = '{0}'".format(course_id)27 result = self.postgres.query_fetch_one(sql_str)2829 if result:3031 # shuffle = result['shuffled']32 # question_types = result['question_types']33 # tags = result['tags']34 # cast = '"tags"'3536 # qtype = ""37 # if question_types:38 # qtype = ','.join("'{0}'".format(qtype) for qtype in question_types)3940 sql_str = "SELECT * FROM course_question"41 sql_str += " WHERE course_id = '{0}'".format(course_id)42 sql_str += " AND exercise_id='{0}'".format(result['exercise_id'])4344 # if shuffle is True:45 # if question_types:46 # sql_str += " AND question_type IN ({0})".format(qtype)4748 # if tags not in [None, [], str(['']), str([""]), ['']]:49 # sql_str += " AND CAST({0} AS text) = '{1}'".format(cast, json.dumps(tags))5051 questions = self.postgres.query_fetch_all(sql_str)5253 number_to_draw = 10 # BY DEFAULT54 if result['number_to_draw']:55 number_to_draw = result['number_to_draw']5657 # questions = self.select_questions(questions, number_to_draw, question_types, shuffle)58 questions = [question['course_question_id'] for question in questions]5960 questions = questions[:number_to_draw]61 result['questions'] = questions6263 self.add_student_exercise(user_id, course_id, key, result)64 return result6566 def select_questions(self, questions, number_to_draw, question_type, shuffle):67 """ Return Questions by type """6869 questionnaires = []7071 if not question_type:72 question_type = ['FITBT', 'MULRE', 'MATCH', 'MULCH']73 limit = math.floor(number_to_draw / len(question_type))7475 for qtype in question_type:76 qlist = [question['course_question_id'] for question in questions \77 if question['question_type'] == qtype]7879 if shuffle is True:80 # SHUFFLE QUESTIONS81 random.shuffle(qlist)8283 qlist = qlist[:limit]84 questionnaires += qlist8586 if len(questionnaires) != number_to_draw:8788 draw_again = number_to_draw - len(questionnaires)89 qlist = [question['course_question_id'] for question in questions \90 if question['question_type'] in question_type \91 and question['course_question_id'] not in questionnaires]9293 if shuffle is True:94 # SHUFFLE QUESTIONS95 random.shuffle(qlist)9697 qlist = qlist[:draw_again]98 questionnaires += qlist99100 return questionnaires101102 def regenerate_questions(self, exercise_id, user_id, key):103 """ Generate Seed Questionnaires based on settings """104105 sql_str = "SELECT * FROM exercise WHERE exercise_id = '{0}'".format(exercise_id)106 result = self.postgres.query_fetch_one(sql_str)107 shuffle = result['shuffled']108 question_types = result['question_types']109 tags = result['tags']110 cast = '"tags"'111112 exercise_table = "{0}_exercise".format(key)113 questions_table = "{0}_exercise_questions".format(key)114 key_id = "{0}_exercise_id".format(key)115116 sql_str = "SELECT * FROM {0} se LEFT JOIN {1}".format(exercise_table, questions_table)117 sql_str += " seq ON se.{0} = seq.{0}".format(key_id)118 sql_str += " WHERE se.status is True AND se.exercise_id = '{0}'".format(exercise_id)119 result = self.postgres.query_fetch_all(sql_str)120121 answered = [res['course_question_id'] for res in result if res['answer'] is not None]122 total_answered = len(answered)123 total = len(result)124 number_to_draw = total - total_answered125126 qtype = ""127 if question_types:128 qtype = ','.join("'{0}'".format(qtype) for qtype in question_types)129130 sql_str = "SELECT * FROM course_question"131 sql_str += " WHERE exercise_id='{0}'".format(result[0]['exercise_id'])132 if question_types:133 sql_str += " AND question_type IN ({0})".format(qtype)134135 if answered:136 answered_questions = ','.join("'{0}'".format(ans) for ans in answered)137 sql_str += " AND course_question_id NOT IN ({0})".format(answered_questions)138139 if tags:140 tags = ', '.join('"{0}"'.format(tag) for tag in tags)141 sql_str += " AND CAST({0} AS text) = '[{1}]'".format(cast, tags)142143 questions = self.postgres.query_fetch_all(sql_str)144 questions = self.select_questions(questions, number_to_draw, question_types, shuffle)145146 # DELETE ITEMS TO SHUFFLE NEW QUESTION(S)147 no_answer = [res['course_question_id'] for res in result if res['answer'] is None]148 self.delete_item_sequence(key, result[0][key_id], no_answer)149150 # ADD STUDENT EXERCISE QUESTIONS151 next_item = self.get_next_sequence(result[0][key_id], key)152 if self.add_student_questions(result[0][key_id], key, questions,153 next_item, user_id):154 return 1155 return 0156157 def delete_item_sequence(self, key, student_exercise_id, items):158 """ DELETE ITEMS TO BE SHUFFLED """159160 key_exercise_id = "{0}_exercise_id".format(key)161 table = "{0}_exercise_questions".format(key)162163 conditions = []164165 conditions.append({166 "col": "course_question_id",167 "con": "in",168 "val": items169 })170171 conditions.append({172 "col": key_exercise_id,173 "con": "=",174 "val": student_exercise_id175 })176177 if self.postgres.delete(table, conditions):178 return 1179180 return 0181182 def get_next_sequence(self, student_exercise_id, key):183 """ Return next item sequence """184185 table = "{0}_exercise_questions".format(key)186 key_id = "{0}_exercise_id".format(key)187188 sql_str = "SELECT MAX(sequence) as sequence FROM {0}".format(table)189 sql_str += " WHERE {0}='{1}'".format(key_id, student_exercise_id)190 result = self.postgres.query_fetch_one(sql_str)191192 if result['sequence'] is None:193 return 1194195 return result['sequence'] + 1196197 def add_student_exercise(self, user_id, course_id, key, data):198 """ Assign Exercise to Student """199200 if data:201202 key_exercise_id = "{0}_exercise_id".format(key)203 table = "{0}_exercise".format(key)204 # ADD EXERCISE205206 temp = {}207 temp[key_exercise_id] = self.sha_security.generate_token(False)208 temp['exercise_id'] = data['exercise_id']209 temp['account_id'] = user_id210 temp['course_id'] = course_id211 temp['exercise_number'] = data['exercise_number']212 temp['status'] = True213 temp['created_on'] = time.time()214215 add = self.postgres.insert(table, temp, key_exercise_id)216217 # ADD QUESTIONS218 sequence = 1219 self.add_student_questions(add, key, data['questions'], sequence, user_id)220221 return 1222223 return 0224225 def add_student_questions(self, exercise_id, key, questions, sequence, user_id):226 """ ADD STUDENT EXERCISE QUESTIONS BY SEED """227228 key_exercise_id = "{0}_exercise_id".format(key)229 table = "{0}_exercise_questions".format(key)230231 # ADD QUESTIONS232 for question in questions:233234 tmp = {}235 tmp[key_exercise_id] = exercise_id236 tmp['account_id'] = user_id237 tmp['course_question_id'] = question238 tmp['sequence'] = sequence239 tmp['skip_times'] = 0240241 self.postgres.insert(table, tmp, key_exercise_id)242 sequence += 1243244 return 1245246 # FOR COURSE DEVELOPMENT247 def get_question_by_id(self, question_id):248 """ Return Question Data by ID """249250 sql_str = "SELECT * FROM questions WHERE question_id = '{0}'".format(question_id)251 result = self.postgres.query_fetch_one(sql_str)252253 return result254255 def get_questions_by_condition(self, question_types, tags):256 """ Return Question by type and tags """257258 qtype = ','.join("'{0}'".format(qtype) for qtype in question_types)259 tag = '"tags"'260261 sql_str = "SELECT * FROM questions WHERE question_type IN ({0})".format(qtype)262 if tags:263 tags = ', '.join('"{0}"'.format(tag) for tag in tags)264 sql_str += "AND CAST({0} AS text) = '[{1}]'".format(tag, tags)265
...
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:
- JUnit Tutorial
- TestNG Tutorial
- Webdriver Tutorial
- WebDriverIO Tutorial
- Protractor Tutorial
- Selenium 4 Tutorial
- Jenkins Tutorial
- NUnit Tutorial
- Jest Tutorial
- Playwright Tutorial
- Cypress Tutorial
- PyTest Tutorial
YouTube
You could also refer to video tutorials over LambdaTest YouTube channel to get step by step demonstration from industry experts.
Run SeleniumBase 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!!
Was this article helpful?
