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)
