def test_log_delete35(self): '''删除系统日志:正常删除日志''' sql1 = ''' select id,is_delete from log where is_delete!=1 order by id limit 1; ''' sql_res1 = query(sql1)[0] result1 = [sql_res1] is_delete = query(sql1)[1] data = json.dumps(result1) del_response = self.session.post(log_delete_api, headers=json_header, data=data) del_data = del_response.json() msg = del_data['msg'] success = del_data['success'] result = del_data['result'] sql2 = ''' select is_delete from log where id = %s ''' sql_res2 = query(sql2, sql_res1)[0] self.assertEqual(msg, u'操作成功') self.assertTrue(success) self.assertIsNone(result) self.assertEqual(del_response.status_code, 200) self.assertEqual(0, int(is_delete)) self.assertEqual(1, sql_res2)
def test_log_delete37(self): '''删除系统日志:无权限删除日志''' response = get_session(data=data_no_permission) sql1 = ''' select id,is_delete from log where is_delete!=1 order by id limit 1; ''' sql_res1 = query(sql1)[0] result1 = [sql_res1] is_delete = query(sql1)[1] data = json.dumps(result1) del_response = response.post(log_delete_api, headers=json_header, data=data) del_data = del_response.json() msg = del_data['msg'] success = del_data['success'] result = del_data['result'] sql2 = ''' select is_delete from log where id = %s ''' sql_res2 = query(sql2, sql_res1)[0] self.assertEqual(msg, u'没有权限') self.assertFalse(success) self.assertIsNone(result) self.assertEqual(del_response.status_code, 401) self.assertEqual(0, sql_res2)
def test_dict_delete17(self): '''删除字典:正常删除''' data1 = json.dumps(self.datas) self.session.post(dict_add_api, headers=json_header, data=data1) sql1 = ''' select id from dict where name =%s ''' result1 = [query(sql1, self.name)[0]] sql2 = ''' select is_delete from dict where name =%s ''' result2 = query(sql2, self.name)[0] data2 = json.dumps(result1) del_response = self.session.post(dict_delete_api, headers=json_header, data=data2) del_data = del_response.json() msg = del_data['msg'] success = del_data['success'] result = del_data['result'] result3 = query(sql2, self.name)[0] assert result2 == 0 assert result3 == 1 assert msg == u'操作成功' assert success is True assert result is None assert del_response.status_code == 200
def test_dict_update34(self): '''修改字典:修改value为空''' sql = ''' select id,name from dict order by id limit 1; ''' sql_id = query(sql)[0] sql_name = str(query(sql)[1]) data = { "description": None, "id": sql_id, "name": sql_name, "value": None } json_data = json.dumps(data) response = self.session.post(dict_update_api, headers=json_header, data=json_data) res_data = response.json() msg = res_data['msg'] success = res_data['success'] result = res_data['result'] self.assertEqual(msg, u'[value不能为null]') self.assertFalse(success) self.assertIsNone(result) self.assertEqual(response.status_code, 200)
def tearDown(self): sql = ''' update user set name='超级管理员',username='******' where id=1; ''' query(sql) self.session.cookies.clear_session_cookies() self.assertEqual(self.verificationErrors, [], 'test has bug!')
def test_role_update220(self): '''修改角色信息:正常修改角色信息''' role_add_data = { "available": True, "identify": rand_name(20), "name": rand_name(20), "permissionIds": [2, 3] } self.session.post(role_add_api, headers=json_header, json=role_add_data) role_sql = ''' select id,identify,name from role order by id desc; ''' role_id = query(role_sql)[0] identify = query(role_sql)[1] name = query(role_sql)[2] user_add_data = self.data = { "name": rand_name(20), "password": '******', "roleIds": [role_id], "sex": True, "username": rand_name(20) } self.session.post(user_add_api, headers=json_header, json=user_add_data) role_update_data = { "available": True, "id": role_id, "identify": identify, "name": name, "permissionIds": [2] } self.session.post(role_update_api, headers=json_header, json=role_update_data) user_sql = ''' select username from user order by id desc ''' user_name = query(user_sql)[0] login_date = { 'username': user_name, 'password': '******', 'rememberMe': False } login_session = get_session(login_date) response = login_session.get(dicts_api) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] self.assertEqual(u'没有权限', msg) self.assertFalse(success) self.assertIsNone(result) self.assertEqual(response.status_code, 401)
def test_role_add191(self): '''添加角色信息:available为False添加角色再相关角色用户请求相关接口''' self.data['available'] = False self.data['permissionIds'] = [2, 3] sql = ''' select max(id) from role; ''' role_id = query(sql) self.session.post(role_add_api, headers=json_header, json=self.data) update_data = { "id": 3, "name": "胡桓", "password": "******", "roleIds": [role_id], } self.session.post(user_update_api, headers=json_header, json=update_data) login_date = { 'username': '******', 'password': '******', 'rememberMe': False } login_session = get_session(login_date) response = login_session.get(user_page_api) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] self.assertEqual(u'没有权限', msg) self.assertFalse(success) self.assertIsNone(result) self.assertEqual(response.status_code, 401)
def test_dict_update29(self): '''修改字典:无权限用户修改字典''' sql = ''' select id from dict limit 1; ''' sql_data = query(sql)[0] data = { "description": "string", "id": sql_data, "name": "1", "value": 0 } json_data = json.dumps(data) login_session = get_session(data=data_no_permission) response = login_session.post(dict_update_api, headers=json_header, data=json_data) res_data = response.json() msg = res_data['msg'] success = res_data['success'] result = res_data['result'] self.assertEqual(msg, u'没有权限') self.assertFalse(success) self.assertIsNone(result) self.assertEqual(response.status_code, 401)
def test_permission_add48(self): '''添加权限:标识符重复创建权限''' sql = ''' select name from permission limit 1; ''' sql_name = query(sql)[0] add_data = { "available": True, "icon": "string", "identify": sql_name, "name": str(time.time()), "parentId": 0, "resourceType": "button", "sort": 0, "url": str(time.time()) } json_data = json.dumps(add_data) response = self.session.post(permission_add_api, headers=json_header, data=json_data) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] self.assertEqual(msg, u'权限名称或权限标识或Url已经存在') self.assertFalse(success) self.assertIsNone(result) self.assertEqual(response.status_code, 200)
def test_dict_update32(self): '''修改字典:修改name超过50个字节''' sql = ''' select id from dict limit 1; ''' sql_data = query(sql)[0] name = '1' * 51 data = { "description": "string", "id": sql_data, "name": name, "value": 1 } json_data = json.dumps(data) response = self.session.post(dict_update_api, headers=json_header, data=json_data) res_data = response.json() msg = res_data['msg'] success = res_data['success'] result = res_data['result'] self.assertEqual(msg, u'[name长度需要在1和50之间]') self.assertFalse(success) self.assertIsNone(result) self.assertEqual(response.status_code, 200)
def test_user_add151(self): '''添加用户:name为特殊字符添加用户''' sql = ''' delete from user where name = '!@#$%^&' ''' query(sql) self.data['name'] = '!@#$%^&' add_data = json.dumps(self.data) response = self.session.post(user_add_api, headers=json_header, data=add_data) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] self.assertEqual(u'操作成功', msg) self.assertTrue(success) self.assertIsNone(result) self.assertEqual(response.status_code, 200)
def test_role_delete201(self): '''删除角色信息:正常删除角色''' roleIds = [3] response = self.session.post(role_delete_api, headers=json_header, json=roleIds) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] sql = ''' update role_permission set is_delete=0 where id=3; ''' sql1 = ''' update role set is_delete=0 where id=3; ''' sql2 = ''' update user_role set is_delete=0 where id=3; ''' query(sql) query(sql1) query(sql2) self.assertEqual(u'操作成功', msg) self.assertTrue(success) self.assertIsNone(result) self.assertEqual(response.status_code, 200)
def test_role_delete204(self): '''删除角色信息:删除角色用户再请求之前有权限接口''' role_sql = '''select max(role_id) from user_role where user_id = 3 and is_delete = 0 ''' role_id = query(role_sql)[0] roleIds = [role_id] self.session.post(role_delete_api, headers=json_header, json=roleIds) #删除角色(关联用户是cbbtest) add_data = { "available": True, "identify": rand_name(30), "name": rand_name(20), "permissionIds": [2, 3, 4] } self.session.post(role_add_api, headers=json_header, json=add_data) #添加新的角色,且拥有之前的3,4(查看日志)权限 sql = ''' select max(id) from role; ''' role_id = query(sql)[0] #获取最新生成的role_id update_data = { "id": 3, "name": 'cbbtest', "password": "******", "roleIds": [role_id], } self.session.post(user_update_api, headers=json_header, json=update_data) #修改用户的role为最新的role_id login_session = get_session(cbb) response = login_session.get(dicts_api) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] self.assertEqual(u'操作成功', msg) self.assertTrue(success) self.assertIsNotNone(result) self.assertEqual(response.status_code, 200)
def test_user_info_update110(self): '''更新个人信息:修改值为本身自己的name''' self.data['name'] = query(self.sql)[0] json_data = json.dumps(self.data) response = self.session.post(user_info_update_api, headers=json_header, data=json_data) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] self.assertEqual(u'该用户名或用户昵称已被注册', msg) self.assertFalse(success) self.assertIsNone(result)
def test_role_page212(self): '''分页获得角色信息:不输入参数分页获得角色信息''' sql = ''' select count(*) from role where is_delete=0; ''' count = query(sql)[0] response = self.session.get(role_page_api) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] self.assertEqual(u'操作成功', msg) self.assertEqual((result['totalCount']), count) self.assertTrue(success) self.assertEqual(response.status_code, 200)
def test_role_list209(self): '''获得简单的角色信息:正常获得简单的角色信息''' sql = ''' select count(*) from role where is_delete=0; ''' count = query(sql)[0] response = self.session.get(role_list_api) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] self.assertEqual(u'操作成功', msg) self.assertEqual(len(result), count) self.assertTrue(success) self.assertEqual(response.status_code, 200)
def test_dicts22(self): '''检索字典:无参数直接查询''' response = self.session.get(dicts_api) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] sql = ''' select count(*) from dict where parent_id=0 and is_delete=0; ''' sql_res = query(sql)[0] self.assertEqual(msg,u'操作成功') self.assertTrue(success) self.assertEqual(result['totalCount'],sql_res) self.assertEqual(response.status_code,200)
def test_permission_menu65(self): '''查询用户的所有权限的菜单权限:直接查询菜单权限''' sql = ''' select count(*) from permission where parent_id = 0 and resource_type = 'menu'; ''' count = query(sql)[0] response = self.session.get(permission_menu_api) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] self.assertEqual(u'操作成功', msg) self.assertTrue(success) self.assertEqual(count, len(result)) self.assertEqual(response.status_code, 200)
def test_user_delete164(self): '''删除用户:删除已被注销用户''' sql = ''' select id from user where is_delete=1; ''' id_id = query(sql)[0] json_id = json.dumps([id_id]) response = self.session.post(user_delete_api, headers=json_header, data=json_id) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] self.assertEqual(u'操作成功', msg) self.assertTrue(success) self.assertIsNone(result) self.assertEqual(response.status_code, 200)
def test_permission_list62(self): '''获得所有权限(数组形式):直接查询菜单权限''' sql = ''' select count(*) from permission where is_delete=0; ''' sql_count = query(sql)[0] response = self.session.get(permission_list_api) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] self.assertEqual(msg, u'操作成功') self.assertTrue(success) self.assertEqual(sql_count, len(result)) for i in result: self.assertIsNone(i['children'])
def test_user_page165(self): '''分页查询用户:不输入参数查询用户''' sql = ''' select count(*) from user where is_delete=0; ''' count = query(sql)[0] response = self.session.get(user_page_api) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] self.assertEqual(u'操作成功', msg) self.assertTrue(success) self.assertIsNotNone(result) self.assertEqual(response.status_code, 200) self.assertEqual(count, result['totalCount'])
def test_permission_delete58(self): '''删除权限:有子权限的直接删除权限''' sql = ''' select max(a.id) from permission a inner join permission b where a.is_delete = 0 and a.id =b.parent_id; ''' sql_id = [query(sql)[0]] json_data = json.dumps(sql_id) response = self.session.post(permission_delete_api, headers=json_header, data=json_data) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] self.assertEqual(msg, u'不能删除有子权限的权限') self.assertFalse(success) self.assertIsNone(result) self.assertEqual(response.status_code, 200)
def test_log_page40(self): '''分页检索系统日志列表:不输入参数查询日志''' response = self.session.get(log_page_api) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] sql_count = ''' select count(*) from log where is_delete!=1; ''' count = query(sql_count)[0] self.assertEqual(count, result['totalCount'] + 1) self.assertTrue(success) self.assertEqual(msg, u'操作成功') self.assertEqual(response.status_code, 200) self.assertEqual(result['pageNum'], 1) self.assertEqual(result['pageSize'], 10) self.assertEqual(len(result['data']), 10)
def test_dicts23(self): '''检索字典:输入参数查询''' resquests_data = {'pageNum': 2, 'pageSize': 11} response = self.session.get(dicts_api, params=resquests_data) res_data = response.json() msg = res_data['msg'] success = res_data['success'] result = res_data['result'] sql = ''' select count(*) from dict where parent_id=0 and is_delete=0; ''' sql_res = query(sql)[0] self.assertEqual(msg, u'操作成功') self.assertTrue(success) self.assertEqual(result['totalCount'], sql_res) self.assertEqual(result['pageNum'], 2) self.assertEqual(result['pageSize'], 11) self.assertEqual(response.status_code, 200)
def test_permission_delete60(self): '''删除权限:未登录删除权限''' sql = ''' select max(id) from permission where is_delete = 0 limit 1; ''' sql_id = [query(sql)[0]] json_data = json.dumps(sql_id) response = requests.post(permission_delete_api, headers=json_header, data=json_data) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] self.assertEqual(msg, u'没有登录') self.assertFalse(success) self.assertIsNone(result) self.assertEqual(response.status_code, 401)
def test_user_info_update116(self): '''更新个人信息:修改已注销的账号''' sql = ''' select name from user where is_delete=1 order by id desc limit 1; ''' name = query(sql)[0] self.data['name'] = name json_data = json.dumps(self.data) response = self.session.post(user_info_update_api, headers=json_header, data=json_data) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] self.assertEqual(u'该用户名或用户昵称已被注册', msg) self.assertFalse(success) self.assertIsNone(result)
def test_user_update182(self): '''更新用户:更新已删除用户''' delete_sql = ''' select id from user where is_delete=1; ''' delete_id = query(delete_sql) self.data['id'] = delete_id response = self.session.post(user_update_api, headers=json_header, json=self.data) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] self.assertEqual(u'传入数据有误', msg) self.assertFalse(success) self.assertIsNone(result) self.assertEqual(response.status_code, 200)
def test_user_register100(self): '''用户注册:使用已注销的username注册''' sql = '''select username from user where is_delete=1 limit 1''' username = query(sql)[0] register_data = { 'name': rand_name(6), 'username': username, 'password': '******', 'sex': False } response = requests.post(user_register_api, data=register_data) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] self.assertEqual(u'该用户名或用户昵称已被注册', msg) self.assertFalse(success) self.assertIsNone(result) self.assertEqual(response.status_code, 200)
def test_dict_delete19(self): '''删除字典:无权限用户删除字典''' response = get_session(data=data_no_permission) sql = ''' select id from dict; ''' result = [query(sql)[0]] datas = json.dumps(result) del_response = response.post(dict_delete_api, headers=json_header, data=datas) del_data = del_response.json() msg = del_data['msg'] success = del_data['success'] result = del_data['result'] assert msg == u'没有权限' assert success is False assert result is None assert del_response.status_code == 401
def test_user_register101(self): '''用户注册:注册数据库已存在的name用户''' sql = ''' select name from user where is_delete=0 limit 2,3; ''' name_sql = query(sql)[0] register_data = { 'name': name_sql, 'username': rand_name(17), 'password': '******', 'sex': False } response = requests.post(user_register_api, data=register_data) data = response.json() msg = data['msg'] success = data['success'] result = data['result'] self.assertEqual(u'该用户名或用户昵称已被注册', msg) self.assertFalse(success) self.assertIsNone(result) self.assertEqual(response.status_code, 200)