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)
