def setUp(self):
self.session = get_session()
self.verificationErrors = []
self.data = {
"available": True,
"identify": rand_name(30),
"name": rand_name(20),
"permissionIds": [1]
}
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 setUp(self):
self.session = get_session()
self.verificationErrors = []
self.data = {
"name": rand_name(20),
"password": '******',
"roleIds": [2],
"sex": True,
"username": rand_name(20)
}
def test_user_register96(self):
'''用户注册:不输入密码注册'''
register_data = {
'name': rand_name(10),
'username': rand_name(10),
'password': None,
'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'[password不能为空]', msg)
self.assertFalse(success)
self.assertIsNone(result)
self.assertEqual(response.status_code, 200)
def test_user_register105(self):
'''用户注册:注册（密码15位）'''
register_data = {
'name': rand_name(6),
'username': rand_name(6),
'password': '******',
'sex': True
}
response = requests.post(user_register_api, data=register_data)
data = response.json()
msg = data['msg']
success = data['success']
result = data['result']
self.assertEqual(u'[password只能是6-15位的字符或数字]', msg)
self.assertFalse(success)
self.assertIsNone(result)
self.assertEqual(response.status_code, 200)
def test_user_register103(self):
'''用户注册:注册（username长度6位，name5位）'''
register_data = {
'name': rand_name(6),
'username': rand_name(5),
'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.assertTrue(success)
self.assertIsNone(result)
self.assertEqual(response.status_code, 200)
def test_user_register99(self):
'''用户注册:username长度超过25注册'''
register_data = {
'name': rand_name(6),
'username': rand_name(26),
'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'[username只能是5-25位的字符]', msg)
self.assertFalse(success)
self.assertIsNone(result)
self.assertEqual(response.status_code, 200)
def setUp(self):
self.session = get_session()
self.verificationErrors = []
self.data = {
"id": UserUpdate.id_id,
"name": rand_name(25),
"password": "******",
"roleIds": [2],
}
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_update111(self):
'''更新个人信息:修改name超过25位（26位）'''
self.data['name'] = rand_name(26)
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'[name只能是6-25位且不能有空格]', msg)
self.assertFalse(success)
self.assertIsNone(result)
def test_user_register93(self):
'''用户注册:注册数据库已存在的username用户'''
register_data = {
'name': rand_name(10),
'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_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_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)
