def test_em_student_id_query(cls, student_id_query, expect): try: EmploymentManagement(cls.driver).em_student_id_query(student_id_query) actual = Service.text_css(cls.driver,'/html/body/div[7]/div[3]/div/div/div/div[2]/div[3]/div[2]/div[2]/table/tbody/tr[1]/td[1]') cls.assertEqual(actual, expect) cls.driver.refresh() except Exception as e: actual = 'EM_failed' cls.driver.refresh() cls.assertEqual(actual, expect)
def test_em_interview_query(cls, technology, expect): try: EmploymentManagement(cls.driver).em_technology_query(technology) actual = Service.text_xpath(cls.driver,'/html/body/div[7]/div[3]/div/div/div/div[1]/div[2]/div[2]/div[2]/table/tbody/tr[1]/td[1]') cls.assertEqual(actual, expect) cls.driver.refresh() except Exception as e: actual = 'EM_failed' cls.driver.refresh() cls.assertEqual(actual, expect)
def test_em_end_time(cls, data, expect): try: test_em_interview = EmploymentManagement(cls.driver).em_technology() if '全部' in test_em_interview: actual = 'EM_correct' else: actual = 'EM_failed' cls.driver.refresh() cls.assertEqual(actual, expect) except Exception as e: actual = 'EM_failed' cls.driver.refresh() cls.assertEqual(actual, expect)
def test_em_technology_interface(cls, data, expect): try: EmploymentManagement(cls.driver).em_technology_interface() if Service.is_element_present(cls.driver, By.LINK_TEXT, '技术面试'): actual = 'EM_correct' else: actual = 'EM_failed' cls.driver.refresh() cls.assertEqual(actual, expect) except Exception as e: actual = 'EM_failed' cls.driver.refresh() cls.assertEqual(actual, expect)
def test_em_direction(cls, data, expect): try: test_em_direction = EmploymentManagement(cls.driver).em_direction() if '全部' in test_em_direction: actual = 'EM_correct' else: actual = 'EM_failed' cls.driver.refresh() cls.assertEqual(actual, expect) except Exception as e: actual = 'EM_failed' cls.driver.refresh() cls.assertEqual(actual, expect)
def test_em_induction(cls, enterprise, jobs, em_induction_time, em_induction_salary, em_interview_note, expect):
try:
EmploymentManagement(cls.driver).em_induction(enterprise, jobs, em_induction_time,em_induction_salary, em_interview_note)
em_enterprise = f"'{enterprise}'"
induction_salary = f"'{em_induction_salary}'"
sql = f'SELECT job_position FROM job_register WHERE ent_name = {em_enterprise} and operator = {induction_salary};'
em_induction = Utility.query_one(em_technology_user_info, sql)
em_results = em_induction[0]
if em_results == jobs:
actual = 'EM_correct'
else:
actual = 'EM_failed'
cls.driver.refresh()
cls.assertEqual(actual, expect)
cls.driver.refresh()
except Exception as e:
actual = 'EM_failed'
cls.driver.refresh()
cls.assertEqual(actual, expect)
def test_em_real_interview(cls, enterprise, jobs, em_interview_time, em_interview_feedback, expect):
try:
EmploymentManagement(cls.driver).em_real_interview(enterprise, jobs, em_interview_time, em_interview_feedback)
interview_time = f"'{em_interview_time}'"
interview_feedback = f"'{em_interview_feedback}'"
sql = f'SELECT interview_post FROM realinterview WHERE rinterview_time = {interview_time} and remark = {interview_feedback};'
em_real_interview = Utility.query_one(em_technology_user_info, sql)
em_results = em_real_interview[0]
if em_results == jobs:
actual = 'EM_correct'
else:
actual = 'EM_failed'
cls.driver.refresh()
cls.assertEqual(actual, expect)
cls.driver.refresh()
except Exception as e:
actual = 'EM_failed'
cls.driver.refresh()
cls.assertEqual(actual, expect)
def test_em_mock_interviews(cls, em_xpected_salary, mock_interviews, em_note, expect):
try:
EmploymentManagement(cls.driver).em_mock_interviews(em_xpected_salary, mock_interviews, em_note)
interviews = f"'{mock_interviews}'"
note = f"'{em_note}'"
sql = f'SELECT intent_salary FROM mockinterview WHERE comm = {interviews} and remark = {note};'
em_mock_interviews = Utility.query_one(em_technology_user_info, sql)
em_results = em_mock_interviews[0]
if em_results == em_xpected_salary:
actual = 'EM_correct'
else:
actual = 'EM_failed'
cls.driver.refresh()
cls.assertEqual(actual, expect)
cls.driver.refresh()
except Exception as e:
actual = 'EM_failed'
cls.driver.refresh()
cls.assertEqual(actual, expect)
def test_em_technology_interview(cls, results, em_questions, em_evaluation, expect):
try:
EmploymentManagement(cls.driver).em_technology_interview(results, em_questions, em_evaluation)
questions = f"'{em_questions}'"
valuate = f"'{em_evaluation}'"
sql = f'SELECT result FROM skill_record WHERE questions = {questions} and valuate= {valuate};'
em_technology_interview = Utility.query_one(em_technology_user_info, sql)
em_results = em_technology_interview[0]
if em_results == results:
actual = 'EM_correct'
else:
actual = 'EM_failed'
cls.driver.refresh()
cls.assertEqual(actual, expect)
cls.driver.refresh()
except Exception as e:
actual = 'EM_failed'
cls.driver.refresh()
cls.assertEqual(actual, expect)