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)
