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(path, sql) self.train.do_submit(path, deliver_data) new_result = Utility.query_one(path, 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_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(path, sql) self.train.add_student(path, add_data) new_result = Utility.query_one(path, 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(path, sql) self.train.do_tail(path, tail_data) new_result = Utility.query_one(path, 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_excute_tech(self, question, result, expect): contents = {'question': question, 'result': result} self.job.excute_tech(contents) sql_one = 'select question from skill_record where skillrecord_student_id="858"' result_one = Utility.query_one(path, sql_one) if contents['question'] == result_one[0]: actual = 'add-pass' else: actual = 'add-fail' self.assertEqual(actual, expect)
def test_console_query_six(self): self.report.click_console() # 上周 self.report.click_oldweek_console() sql_six = 'select count(last_status) from customer where work_id = "23" and last_status="新认领"' result_six = Utility.query_one(path, sql_six) if self.driver.find_element_by_xpath('//table[@id="成都"]/tbody/tr[2]/td[8]').text == result_six[0]: actual = 'query-pass' else: actual = 'query-fail' self.assertEqual(actual, 'query-pass')
def test_market_data_eight(self): self.report.click_market() # 本年 self.report.click_market_eveyear_console() sql_eight = 'select count(department_id) from customer where "2020-01-01"<=create_time<="2020-04-13"' result_eight = Utility.query_one(path, sql_eight) if result_eight[0] == 2: actual = 'query-pass' else: actual = 'query-fail' self.assertEqual(actual, 'query-pass')
def test_market_data_seven(self): self.report.click_market() # 上月 self.report.click_market_oldmonth_console() sql_seven = 'select count(department_id) from customer where "2020-03-01"<=create_time<="2020-03-31"' result_seven = Utility.query_one(path, sql_seven) if result_seven[0] == 0: actual = 'query-pass' else: actual = 'query-fail' self.assertEqual(actual, 'query-pass')
def test_market_data_six(self): self.report.click_market() # 上周 self.report.click_market_oldweek_console() sql_six = 'select count(department_id) from customer where "2020-04-06"<=create_time<="2020-04-12"' result_six = Utility.query_one(path, sql_six) if result_six[0] == 0: actual = 'query-pass' else: actual = 'query-fail' self.assertEqual(actual, 'query-pass')
def test_market_data_three(self): self.report.click_market() # 今日 self.report.click_market_eveday_console() sql_three = 'select count(department_id) from customer where create_time="2020-04-13"' result_three = Utility.query_one(path, sql_three) if result_three[0] == 2: actual = 'query-pass' else: actual = 'query-fail' self.assertEqual(actual, 'query-pass')
def test_market_data_two(self): self.report.click_market() # 当期 self.report.click_market_evedate_console() sql_two = 'select count(department_id) from customer where "2020-01-31"<=create_time<="2020-03-31' result_two = Utility.query_one(path, sql_two) if result_two[0] == 0: actual = 'query-pass' else: actual = 'query-fail' self.assertEqual(actual, 'query-pass')
def test_console_query_two(self): self.report.click_console() # 当期 self.report.click_evedate_console() sql_two = 'select count(last_status) from customer where work_id="11" and last_status="已认领"' result_two = Utility.query_one(path, sql_two) if self.driver.find_element_by_xpath('//table[@id="成都"]/tbody/tr[1]/td[9]').text == result_two[0]: actual = 'query-pass' else: actual = 'query-fail' self.assertEqual(actual, 'query-pass')
def test_sale_data_eight(self): self.report.click_sale() # 本年 self.report.click_sale_eveyear_console() sql_eight = 'select count(last_status) from customer where work_id = "66" and last_status="已认领"' result_eight = Utility.query_one(path, sql_eight) if self.driver.find_element_by_xpath('//table[@id="成都"]/tbody/tr[2]/td[9]').text == result_eight[0]: actual = 'query-pass' else: actual = 'query-fail' self.assertEqual(actual, 'query-pass')
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(path, sql) self.train.do_claim(path, claim_data) resp = self.driver.find_element_by_id('public-pool-table') self.train.affirm_claim() new_result = Utility.query_one(path, 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_console_query_one(self, starttime, endtime, expect): self.report.click_console() # 搜索 self.report.input_console_date(starttime, endtime) self.report.click_cnsole_query() sql_one = 'select count(last_status) from customer where work_id = "23" and last_status="新认领"' result_one = Utility.query_one(path, sql_one) if self.driver.find_element_by_xpath('//table[@id="成都"]/tbody/tr[2]/td[8]').text == result_one[0]: actual = 'query-pass' else: actual = 'query-fail' self.assertEqual(actual, expect)
def test_market_data_one(self, starttime, endtime, expect): self.report.click_market() # 搜索 self.report.input_market_date(starttime, endtime) self.report.click_market() sql_one = 'select count(department_id) from customer where create_time="2020-04-13" ' result_one = Utility.query_one('../config/base.conf', sql_one) if result_one[0] == 2: actual = 'query-pass' else: actual = 'query-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(path, sql) self.train.resource_submit(path, res_data) resp = self.driver.find_element_by_id('allot-table') new_result = Utility.query_one(path, 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(path, sql) self.train.edit_customer(path, edit_data) new_result = Utility.query_one(path, 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)