def test_simulation_add(self, uname, upass, vcode, password, num, work, utime, pay, inps, expect): try: seek_data = { 'uname': uname, 'upass': upass, 'vcode': vcode, 'passwd': password, 'num': num, 'work': work, 'utime': utime, 'pay': pay, 'inps': inps } sql = 'select count(job_regist_id) FROM job_register' result = Utility.query_one('..\\config\\base_UI_four.conf', sql) self.login.do_login('..\\config\\base_UI_four.conf', seek_data) time.sleep(5) self.job.add_entry_information(seek_data) new_result = Utility.query_one('..\\config\\base_UI_four.conf', sql) if new_result[0] - result[0] == 1: actual = 'success' else: actual = 'fail' self.assertEqual(actual, expect) except Exception as e: actual = 'fail' self.assertEqual(actual, expect)
def test_deliver(self, password, name, region, status, source, name_2, region_2, num, expect): try: deliver_data = { 'passwd': password, 'name': name, 'region': region, 'status': status, 'source': source, 'name_2': name_2, 'region_2': region_2, 'num': num } sql = f'select count(customer_id) from customer' result = Utility.query_one('..\\config\\base_UI.conf', sql) self.train.do_submit('..\\config\\base_UI.conf', deliver_data) new_result = Utility.query_one('..\\config\\base_UI.conf', sql) if new_result[0] - result[0] != 1: actual = 'success' else: actual = 'fail' self.assertEqual(actual, expect) except Exception as e: actual = 'fail' self.assertEqual(actual, expect)
def test_upload(self, uname, upass, vcode, password, region, section, xsl, expect): try: xls_data = { 'uname': uname, 'upass': upass, 'vcode': vcode, 'passwd': password, 'region': region, 'section': section, 'xsl': xsl } sql = f'select count(customer_id) from customer' result = Utility.query_one('..\\config\\base_UI_four.conf', sql) self.login.do_login('..\\config\\base_UI_four.conf', xls_data) time.sleep(5) self.market.upload_do(xls_data) new_result = Utility.query_one('..\\config\\base_UI_four.conf', sql) if new_result[0] - result[0] > 1: actual = 'success' else: actual = 'fail' self.assertEqual(actual, expect) except Exception as e: actual = 'fail' self.assertEqual(actual, expect)
def test_simulation_view(self, uname, upass, vcode, password, pay, link, remark, expect): try: seek_data = { 'uname': uname, 'upass': upass, 'vcode': vcode, 'passwd': password, 'pay': pay, 'link': link, 'remark': remark } sql = f'select count(minterview_id) FROM mockinterview ' result = Utility.query_one('..\\config\\base_UI_four.conf', sql) self.login.do_login('..\\config\\base_UI_four.conf', seek_data) time.sleep(5) self.job.simulation_input(seek_data) new_result = Utility.query_one('..\\config\\base_UI_four.conf', sql) if new_result[0] - result[0] == 1: actual = 'success' else: actual = 'fail' self.assertEqual(actual, expect) except Exception as e: actual = 'fail' self.assertEqual(actual, expect)
def test_bus_add(self, uname, upass, vcode, password, buname, bucate, buaddr, buader, butel, expect): try: seek_data = { 'uname': uname, 'upass': upass, 'vcode': vcode, 'passwd': password, 'buname': buname, 'bucate': bucate, 'buaddr': buaddr, 'buader': buader, 'butel': butel } sql = 'select count(enterprise_id) FROM enterprise_info' result = Utility.query_one('..\\config\\base_UI_four.conf', sql) self.login.do_login('..\\config\\base_UI_four.conf', seek_data) time.sleep(5) self.job.busine_add(seek_data) new_result = Utility.query_one('..\\config\\base_UI_four.conf', sql) if new_result[0] - result[0] == 1: actual = 'success' else: actual = 'fail' self.assertEqual(actual, expect) except Exception as e: actual = 'fail' self.assertEqual(actual, expect)
def test_edit(self, uname, upass, vcode, password, region, section, tel, name, status, expect): try: edit_data = { 'uname': uname, 'upass': upass, 'vcode': vcode, 'passwd': password, 'region': region, 'section': section, 'tel': tel, 'name': name, 'status': status } sql = f'select count(customer_id) from customer' result = Utility.query_one('..\\config\\base_UI_four.conf', sql) self.login.do_login('..\\config\\base_UI_four.conf', edit_data) time.sleep(5) self.market.edit_do(edit_data) resp = self.driver.find_element_by_id('netCus-table') new_result = Utility.query_one('..\\config\\base_UI_four.conf', sql) if name in resp.text and new_result[0] - result[0] != 1: actual = 'success' else: actual = 'fail' self.assertEqual(actual, expect) except Exception as e: actual = 'fail' self.assertEqual(actual, expect)
def test_simulation_submit(self, uname, upass, vcode, password, num, agreement, expect): try: seek_data = { 'uname': uname, 'upass': upass, 'vcode': vcode, 'passwd': password, 'num': num, 'agreement': agreement, } sql = 'select count(student_id) FROM student WHERE is_sign="1"' result = Utility.query_one('..\\config\\base_UI_four.conf', sql) self.login.do_login('..\\config\\base_UI_four.conf', seek_data) time.sleep(5) self.job.do_entry_information(seek_data) new_result = Utility.query_one('..\\config\\base_UI_four.conf', sql) if new_result[0] != result[0]: actual = 'success' else: actual = 'fail' self.assertEqual(actual, expect) except Exception as e: actual = 'fail' self.assertEqual(actual, expect)
def test_querystaff(self, query_staff_url, post, query_staff_data, status_code, content): querystaff_resp = self.hr.query_staff(query_staff_url, query_staff_data) sql_all = 'select count(employee_id) from employee' all_staff_number = Utility.query_one('..\\config\\base.conf',sql_all)[0] sql_part = 'select count(employee_id) from employee where region_id=3' part_staff_number = Utility.query_one('..\\config\\base.conf', sql_part)[0] if querystaff_resp.json()['totalRow'] == 0: actual = 'query zero' elif querystaff_resp.json()['totalRow'] == 1: actual = 'query one' elif querystaff_resp.json()['totalRow'] == all_staff_number: actual = 'query all' elif querystaff_resp.json()['totalRow'] == part_staff_number: actual = 'query part' else: actual = 'query error' self.assertEqual(actual, content)
def test_querflow(self, query_flow_url, post, query_flow_data, status_code, content): queryflow_resp = self.finance.query_flow(query_flow_url, query_flow_data) sql_part01 = 'select count(detailed_id) from detailed_dealings where trading_time between "2018-05-29" and "2018-05-31"' part_flow_number01 = Utility.query_one('..\\config\\base.conf', sql_part01)[0] sql_part02 = 'select count(detailed_id) from detailed_dealings where trading_time between "2020-03-01" and "2020-03-31"' part_flow_number02 = Utility.query_one('..\\config\\base.conf', sql_part02)[0] sql_part03 = 'select count(detailed_id) from detailed_dealings where trading_time between "2020-04-01" and "2020-04-30"' part_flow_number03 = Utility.query_one('..\\config\\base.conf', sql_part03)[0] if queryflow_resp.json()['totalRow'] == part_flow_number01: actual = 'query part' elif queryflow_resp.json()['totalRow'] == part_flow_number02: actual = 'query lastmonth' elif queryflow_resp.json()['totalRow'] == part_flow_number03: actual = 'query thismonth' else: actual = 'query error' self.assertEqual(actual, content)
def test_add(self, password, phone, name, condition, SOURCE, expect): add_data = { 'passwd': password, 'phone': phone, 'name': name, 'condition': condition, 'SOURCE': SOURCE } #查询新增之前的总数 sql = f'select count(customer_id) from customer' result = Utility.query_one('..\\config\\base_UI.conf', sql) self.train.add_student('..\\config\\base_UI.conf', add_data) new_result = Utility.query_one('..\\config\\base_UI.conf', sql) if new_result[0] - result[0] == 1: actual = 'success' else: actual = 'fail' self.assertEqual(actual, expect)
def test_tail(self, password, state, priority, record, expect): tail_data = { 'passwd': password, 'state': state, 'priority': priority, 'record': record } sql = f'select count(customer_id) from customer' result = Utility.query_one('..\\config\\base_UI.conf', sql) self.train.do_tail('..\\config\\base_UI.conf', tail_data) new_result = Utility.query_one('..\\config\\base_UI.conf', sql) resp = self.driver.find_element_by_css_selector( '#personal-table > tbody:nth-child(2)') # print(resp.text) if new_result[0] - result[0] != 1 and record in resp.text: actual = 'success' else: actual = 'fail' self.assertEqual(actual, expect)
def test_email(self, uname, upass, vcode, password, expect): email_data = { 'uname': uname, 'upass': upass, 'vcode': vcode, 'passwd': password } sql = f'select count(customer_id) from customer' result = Utility.query_one('..\\config\\base_UI_four.conf', sql) self.login.do_login('..\\config\\base_UI_four.conf', email_data) time.sleep(5) self.market.email_read(email_data) time.sleep(10) new_result = Utility.query_one('..\\config\\base_UI_four.conf', sql) if new_result[0] - result[0] > 1: actual = 'success' else: actual = 'fail' self.assertEqual(actual, expect)
def test_public(self, password, name, status, source, ucus, num, expect): claim_data = { 'passwd': password, 'name': name, 'status': status, 'source': source, 'ucus': ucus, 'num': num } sql = f'select count(customer_id) from customer' result = Utility.query_one('..\\config\\base_UI.conf', sql) self.train.do_claim('..\\config\\base_UI.conf', claim_data) resp = self.driver.find_element_by_id('public-pool-table') self.train.affirm_claim() new_result = Utility.query_one('..\\config\\base_UI.conf', sql) if ucus not in resp.text and new_result[0] - result[0] != 1: actual = 'success' else: actual = 'fail' self.assertEqual(actual, expect)
def test_resource(self, password, source, ucus, num, name, expect): try: res_data = { 'passwd': password, 'source': source, 'ucus': ucus, 'num': num, 'name': name } sql = f'select count(customer_id) from customer' result = Utility.query_one('..\\config\\base_UI.conf', sql) self.train.resource_submit('..\\config\\base_UI.conf', res_data) resp = self.driver.find_element_by_id('allot-table') new_result = Utility.query_one('..\\config\\base_UI.conf', sql) if ucus not in resp.text and new_result[0] - result[0] != 1: actual = 'success' else: actual = 'fail' self.assertEqual(actual, expect) except Exception as e: actual = 'fail' self.assertEqual(actual, expect)
def test_edit(self, password, name, phone, intention, workage, expect): try: edit_data = { 'passwd': password, 'name': name, 'phone': phone, 'intention': intention, 'workage': workage } sql = f'select count(customer_id) from customer' result = Utility.query_one('..\\config\\base_UI.conf', sql) self.train.edit_customer('..\\config\\base_UI.conf', edit_data) new_result = Utility.query_one('..\\config\\base_UI.conf', sql) resp = self.driver.find_element_by_css_selector( '#personal-table > tbody:nth-child(2)') if new_result[0] - result[0] != 1 and name in resp.text: actual = 'success' else: actual = 'fail' self.assertEqual(actual, expect) except Exception as e: actual = 'fail' self.assertEqual(actual, expect)
def test_queryuser(self, query_user_url, post, query_user_data, status_code, content): queryuser_resp = self.backstage.query_user(query_user_url, query_user_data) sql_all = 'select count(id) from system_user' all_user_number = Utility.query_one('..\\config\\base.conf', sql_all)[0] if queryuser_resp.json()['totalRow'] == 0: actual = 'query zero' elif queryuser_resp.json()['totalRow'] == 1: actual = 'query one' elif queryuser_resp.json()['totalRow'] == all_user_number: actual = 'query all' else: actual = 'query error' self.assertEqual(actual, content)
def test_market_year(self, uname, upass, vcode, password, timeone, timetwo, expect): seek_data = { 'uname': uname, 'upass': upass, 'vcode': vcode, 'passwd': password, 'timeone': timeone, 'timetwo': timetwo } sql = f'select count(customer_id) FROM customer WHERE create_time LIKE "2020%" and work_id="WNCD005" ' result = Utility.query_one('..\\config\\base_UI_four.conf', sql) self.login.do_login('..\\config\\base_UI_four.conf', seek_data) self.report.market_year() if result[0] == 0: actual = 'success' else: actual = 'fail' self.assertEqual(actual, expect)
def test_console_month(self, uname, upass, vcode, password, timeone, timetwo, expect): seek_data = { 'uname': uname, 'upass': upass, 'vcode': vcode, 'passwd': password, 'timeone': timeone, 'timetwo': timetwo } sql = f'select count(tracking_record_id) FROM tracking_record WHERE remark != "None" and create_time like "2020-04%"' result = Utility.query_one('..\\config\\base_UI_four.conf', sql) self.login.do_login('..\\config\\base_UI_four.conf', seek_data) self.report.click_month() resp = self.driver.find_element_by_xpath( '//table[@id="成都"]/tbody/tr[1]/td[7]') if resp.text == str(result[0]): actual = 'success' else: actual = 'fail' self.assertEqual(actual, expect)