def test_a004_bmyg_add(self): try: conn = MySQL.connect_os() cur = conn.cursor() sql = "select a.role_id,b.dep_id from role a,department b where a.app_name='cp' and a.partner_id=" + cpComId + " and b.partner_id=a.partner_id and depart_name="+"'自动化';" cur.execute(sql) sql_result = cur.fetchone()[0:2] roles = sql_result[0] depId = sql_result[1] empName = ''.join(random.sample(['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'x', 'j'], 6)) jobNo = ''.join(random.sample(['1', '2', '3', '4', '5', '6', '7', '8', '9', '0'], 6)) mobile_02 = ''.join(random.sample(['1', '2', '3', '4', '5', '6', '7', '8', '9', '0'], 8)) mobile_01 = '131' mobile = mobile_01 + mobile_02 mail_01 = '@qq.com' mail = mobile + mail_01 params = [ {"roles": [roles], "departments": [{"depId": depId, "position": 1}], "empName": empName, "jobNo": jobNo, "email": mail, "phone": mobile, "status": 1, "entryDate": "2018-05-02T16:00:00.000Z"}] url = "http://cp.ejw.cn/cp/v1/partner/"+cpComId+"/employees" result_act = requests.post(url, data=json.dumps(params), headers=headers) result_exp = 200 self.assertEqual(result_exp, result_act.status_code) log.info("企业设置-部门及员工管理, 新增员工结果如下:") log_exp.info(result_exp) log_act.info(result_act.text) except TypeError: log.info("数据库异常或角色、部门信息为空")
def test_a002_bmyg_serach(self): try: conn = MySQL.connect_os() cur = conn.cursor() sql = "select b.dep_id from employee a,department b where a.partner_id=b.partner_id and a.emp_id=" + cpEmpId cur.execute(sql) sql_result = cur.fetchone()[0:1] dep_id = str(sql_result[0]) emp_name = "xxxxxxxxxxxxxxxxxxx" url = "http://cp.ejw.cn/cp/v1/partner/" + cpComId + "/employees?depId=" + dep_id + "&pageNo=1&pageSize=10&sort=%7B%22gmtCreate%22%3A%22desc%22%7D&curEmpId=" + cpEmpId + "&jobNoOrEmpName=" + emp_name result = requests.get(url, headers=headers) result_act = result.text self.assertNotIn(emp_name, result_act, msg="没有查询到该用户信息") log.info("企业设置-部门员工管理, 不存在的员工信息查询如下:") log_exp.info(emp_name) log_act.info(result_act) except TypeError: log.info("该企业不存在用户信息")
def test_a001_bmyg_serach(self): global log, log_exp, log_act log_exp = Logger(logger="供应商平台_预期结果").getlog() log_act = Logger(logger="供应商平台_实际结果").getlog() log = Logger(logger="供应商平台").getlog() try: conn = MySQL.connect_os() cur = conn.cursor() sql = "select a.emp_name,b.dep_id from employee a,department b where a.partner_id=b.partner_id and a.emp_id=" + cpEmpId cur.execute(sql) sql_result = cur.fetchone()[0:2] emp_name = sql_result[0] dep_id = str(sql_result[1]) url = "http://cp.ejw.cn/cp/v1/partner/" + cpComId + "/employees?&pageNo=1&pageSize=10&sort=%7B%22gmtCreate%22%3A%22desc%22%7D&curEmpId=" + cpEmpId + "&jobNoOrEmpName=" + emp_name result = requests.get(url, headers=headers) result_act = result.text self.assertIn(emp_name, result_act, msg="没有查询到该用户信息") log.info("企业设置-部门员工管理, 已存在的员工信息查询信息如下:") log_exp.info(emp_name) log_act.info(result_act) except TypeError: log.info("该企业不存在用户信息")