def _bind_project_product(self, projectID, productIDs, user):
isdeletefalse = state.Boole['false']
isdeletetrue = state.Boole['true']
yz = (isdeletetrue, user, projectID, isdeletefalse)
result = mysql.insert_or_update_or_delete(self._del_bind_project_product_sql, yz)
for productID in productIDs:
yz = (productID, projectID, '', isdeletefalse, user, user)
result = mysql.insert_or_update_or_delete(self._add_bind_project_product_sql, yz)
return 0 == result
def delete_user_bind(userID , roleID , user):
istruedelete = state.Boole['true']
isfalsedelete = state.Boole['false']
yz = (istruedelete, user, roleID, userID, isfalsedelete)
result = mysql.insert_or_update_or_delete(_delete_user_bind_role_sql, yz)
yz2 = (istruedelete, user, userID, isfalsedelete, roleID)
result2 = mysql.insert_or_update_or_delete(_delete_user_bind_user_group_sql, yz2)
return 0 == result and 0 == result2
def _bind_project_user(self, projectID, users, user):
isdeletefalse = state.Boole['false']
isdeletetrue = state.Boole['true']
yz = (isdeletetrue, user, projectID, isdeletefalse)
result = mysql.insert_or_update_or_delete(self._del_bind_project_user_sql, yz)
for u in users:
yz = (projectID, u['userName'], u['userRealName'], u['type'], '', isdeletefalse, user, user)
result = mysql.insert_or_update_or_delete(self._add_bind_project_user_sql, yz)
return 0 == result
def delete_user_bind(userID, roleID, user):
istruedelete = state.Boole['true']
isfalsedelete = state.Boole['false']
yz = (istruedelete, user, roleID, userID, isfalsedelete)
result = mysql.insert_or_update_or_delete(_delete_user_bind_role_sql, yz)
yz2 = (istruedelete, user, userID, isfalsedelete, roleID)
result2 = mysql.insert_or_update_or_delete(
_delete_user_bind_user_group_sql, yz2)
return 0 == result and 0 == result2
def _bind_project_product(self, projectID, productIDs, user):
isdeletefalse = state.Boole['false']
isdeletetrue = state.Boole['true']
yz = (isdeletetrue, user, projectID, isdeletefalse)
result = mysql.insert_or_update_or_delete(
self._del_bind_project_product_sql, yz)
for productID in productIDs:
yz = (productID, projectID, '', isdeletefalse, user, user)
result = mysql.insert_or_update_or_delete(
self._add_bind_project_product_sql, yz)
return 0 == result
def _bind_project_user(self, projectID, users, user):
isdeletefalse = state.Boole['false']
isdeletetrue = state.Boole['true']
yz = (isdeletetrue, user, projectID, isdeletefalse)
result = mysql.insert_or_update_or_delete(
self._del_bind_project_user_sql, yz)
for u in users:
yz = (projectID, u['userName'], u['userRealName'], u['type'], '',
isdeletefalse, user, user)
result = mysql.insert_or_update_or_delete(
self._add_bind_project_user_sql, yz)
return 0 == result
def add(self, name, type, projectID, userName, userRealName, date,
startDate, endDate, users, preID, parentID, sort, status, degree, remark, user):
isdelete = state.Boole['false']
yz = (name, type, projectID, userName, userRealName, date ,
startDate, endDate, users, preID, parentID, sort, status, degree, remark, isdelete, user, user)
result = mysql.insert_or_update_or_delete(self._add_sql, yz, isbackinsertid = True)
return result
def update(self, id, name, userName, userRealName, date, startDate, endDate, users,
degree, remark, user):
s = self.get_task_status(degree = degree)
yz = (name, userName, userRealName, date, startDate, endDate, users, s, degree,
remark, user, id)
result = mysql.insert_or_update_or_delete(self._update_sql, yz)
return 0 == result
def delete_right_by_role_app( roleID, appCode, user):
sql = _delete_right_by_role_app_sql
isdeletetrue = state.Boole['true']
isdeletefalse = state.Boole['false']
yz = (isdeletetrue, user, isdeletefalse, roleID, appCode)
result = mysql.insert_or_update_or_delete(sql, yz)
return 0 == result
def update_status( id, status, user):
lockTime = None
if status != state.statusUserActive:
lockTime = str_helper.get_now_datetimestr()
yz = (status, user, lockTime, id)
result = mysql.insert_or_update_or_delete(_update_status_sql, yz)
return 0 == result
def update(self, id, name, userName, userRealName, date, startDate,
endDate, users, degree, remark, user):
s = self.get_task_status(degree=degree)
yz = (name, userName, userRealName, date, startDate, endDate, users, s,
degree, remark, user, id)
result = mysql.insert_or_update_or_delete(self._update_sql, yz)
return 0 == result
def add(self,
name,
teamPath,
productUserName,
productUserRealName,
devUserName,
devUserRealName,
startDate,
endDate,
status,
remark,
user,
productIDs=[],
users=[]):
obj = self.query_one_by_name(name=name)
if None != obj:
raise error.ProjectError(code=111002)
isdelete = state.Boole['false']
yz = (name, teamPath, productUserName, productUserRealName,
devUserName, devUserRealName, startDate, endDate, status, remark,
isdelete, user, user)
result = mysql.insert_or_update_or_delete(self._add_sql,
yz,
isbackinsertid=True)
if result > 0:
self._bind_project_product(result, productIDs, user)
self._bind_project_user(projectID=result, users=users, user=user)
return result
def update(self,
id,
name,
teamPath,
productUserName,
productUserRealName,
devUserName,
devUserRealName,
startDate,
endDate,
status,
remark,
user,
productIDs=[],
users=[]):
obj = self.query_one_by_name(name=name)
if None != obj and str(obj['id']) != str(id):
raise error.ProjectError(code=111002)
yz = (name, teamPath, productUserName, productUserRealName,
devUserName, devUserRealName, startDate, endDate, status, remark,
user, id)
result = mysql.insert_or_update_or_delete(self._update_sql, yz)
self._bind_project_product(id, productIDs, user)
self._bind_project_user(projectID=id, users=users, user=user)
return 0 == result
def delete_right_by_role_app(roleID, appCode, user):
sql = _delete_right_by_role_app_sql
isdeletetrue = state.Boole['true']
isdeletefalse = state.Boole['false']
yz = (isdeletetrue, user, isdeletefalse, roleID, appCode)
result = mysql.insert_or_update_or_delete(sql, yz)
return 0 == result
def update(self, id, name, userName, userRealName, status, remark, user):
obj = self.query_one_by_name(name=name)
if None != obj and str(obj['id']) != str(id):
raise error.ProjectError(code=110002)
yz = (name, userName, userRealName, status, remark, user, id)
result = mysql.insert_or_update_or_delete(self._update_sql, yz)
return 0 == result
def del_group_user(self, id, userGroupID, user):
isdelete = state.Boole['true']
yz = (isdelete, user, id)
result = mysql.insert_or_update_or_delete(self._del_group_user_sql, yz)
if result == 0:
#操作成功，清空用户组用户缓存
self._del_user_group_cache(userGroupID = userGroupID)
return result == 0
def update(self, id, name, userName, userRealName, status, remark, user):
obj = self.query_one_by_name(name = name)
if None != obj and str(obj['id']) != str(id):
raise error.ProjectError(code = 110002)
yz = (name, userName, userRealName, status, remark, user, id)
result = mysql.insert_or_update_or_delete(self._update_sql, yz)
return 0 == result
def del_group_user(id, userGroupID, user):
isdelete = state.Boole['true']
yz = (isdelete, user, id)
result = mysql.insert_or_update_or_delete(_del_group_user_sql, yz)
if result == 0:
#操作成功，清空用户组用户缓存
_del_user_group_cache(userGroupID=userGroupID)
return result == 0
def add(self, name, userName, userRealName, status, remark, user):
obj = self.query_one_by_name(name = name)
if None != obj:
raise error.ProjectError(code = 110002)
isdelete = state.Boole['false']
yz = (name, userName, userRealName, status, remark, isdelete, user, user)
result = mysql.insert_or_update_or_delete(self._add_sql, yz, True)
return result
def update(self, id, realName, parentID, mobile, tel, email, status, remark, user):
u = self.query_one_by_email(email) #判断用户邮箱是否已存在
if None != u and str(u['id']) != str(id):
raise error.RightError(code = 103001)
isdelete = state.Boole['false']
yz = (realName, parentID, mobile, tel, email, status, remark, user, id)
result = mysql.insert_or_update_or_delete(self._update_sql, yz)
return 0 == result
def delete( id, user):
isdelete = state.Boole['true']
func = query_one_by_id(id = id)
if None == func:
raise error.RightError(code=102002)
path = func['path'] + '.%'
yz = (isdelete, user, id, path)
result = mysql.insert_or_update_or_delete(_delete_sql, yz)
return 0 == result
def update(name, code, developer, url, status, remark, user):
obj = query_one_by_name(name=name)
if None != obj and obj['code'] != str(code):
raise error.RightError(code=101001)
isdelete = state.Boole['false']
yz = (name, developer, url, status, remark, user, code)
result = mysql.insert_or_update_or_delete(_update_sql, yz)
return 0 == result
def update( id, name, status, remark, user):
obj = query_one_by_name(name = name)
if None != obj and str(obj['id']) != str(id):
raise error.RightError(code = 104001)
isdelete = state.Boole['false']
yz = (name, status, remark, user, id)
result = mysql.insert_or_update_or_delete(_update_sql, yz)
return 0 == result
def update(id, name, status, remark, user):
obj = query_one_by_name(name=name)
if None != obj and str(obj['id']) != str(id):
raise error.RightError(code=106001)
isdelete = state.Boole['false']
yz = (name, status, remark, user, id)
result = mysql.insert_or_update_or_delete(_update_sql, yz)
return 0 == result
def add(name, status, remark, user):
obj = query_one_by_name(name=name)
if None != obj:
raise error.RightError(code=106001)
isdelete = state.Boole['false']
yz = (name, status, remark, isdelete, user, user)
result = mysql.insert_or_update_or_delete(_add_sql, yz)
return 0 == result
def add( name, status, remark, user):
obj = query_one_by_name(name = name)
if None != obj:
raise error.RightError(code = 104001)
isdelete = state.Boole['false']
yz = (name, status, remark, isdelete, user, user)
uid = mysql.insert_or_update_or_delete(_add_sql, yz, True)
return uid
def update(self, name, code, developer, url, status, remark, user):
obj = self.query_one_by_name(name = name)
if None != obj and obj['code'] != str(code):
raise error.RightError(code = 101001)
isdelete = state.Boole['false']
yz = (name, developer, url, status, remark, user, code)
result = mysql.insert_or_update_or_delete(self._update_sql, yz)
return 0 == result
def bind_group_role( userGroupID, roleID, user):
roles = query_all_group_roles(userGroupID)
if roles != None:
for r in roles:
if r['roleID'] == roleID:
return True
isdelete = state.Boole['false']
yz = (userGroupID, roleID, '', isdelete, user, user)
result = mysql.insert_or_update_or_delete(_bind_group_role_sql, yz, isbackinsertid = True)
return result
def add(self, name, userName, userRealName, status, remark, user):
obj = self.query_one_by_name(name=name)
if None != obj:
raise error.ProjectError(code=110002)
isdelete = state.Boole['false']
yz = (name, userName, userRealName, status, remark, isdelete, user,
user)
result = mysql.insert_or_update_or_delete(self._add_sql, yz, True)
return result
def update( id, name, sort, rights, customJson, remark, user):
if not _check_customJson(customJson):
raise error.RightError(code = 102001)
rr = _check_and_format_rights(rights)
if False == rr[0]:
raise error.RightError(code = rr[1])
rights2 = rr[1]
yz = (name, sort, rights2, customJson, remark, user, id)
result = mysql.insert_or_update_or_delete(_update_sql, yz)
return 0 == result
def add(self, name, projectID, userName, userRealName, startDate, endDate,
users, preID, parentID, sort, status, remark, user):
isdelete = state.Boole['false']
yz = (name, projectID, userName, userRealName, startDate, endDate,
users, preID, parentID, sort, status, remark, isdelete, user,
user)
result = mysql.insert_or_update_or_delete(self._add_sql,
yz,
isbackinsertid=True)
return result
def bind_user_role( userID, roleID, user):
roles = query_all_user_roles(userID)
if roles != None:
for role in roles:
if role['roleID'] == roleID:
return True
isdelete = state.Boole['false']
yz = (userID, roleID, '', isdelete, user, user)
result = mysql.insert_or_update_or_delete(_bind_group_role_sql, yz)
return 0 == result
def reset_password( name):
passWord = str_helper.get_uuid()
isdelete = state.Boole['false']
pw = _format_user_password_md5(passWord)
yz = (pw, name, isdelete)
result = mysql.insert_or_update_or_delete(_update_password_sql, yz)
if 0 == result:
return passWord
return None
def bind_group_role(userGroupID, roleID, user):
roles = query_all_group_roles(userGroupID)
if roles != None:
for r in roles:
if r['roleID'] == roleID:
return True
isdelete = state.Boole['false']
yz = (userGroupID, roleID, '', isdelete, user, user)
result = mysql.insert_or_update_or_delete(_bind_group_role_sql,
yz,
isbackinsertid=True)
return result
def add(self, name, code, developer, url, status, remark, user):
obj = self.query_one_by_name(name = name)
if None != obj:
raise error.RightError(code = 101001)
obj = self.query_one(code = code)
if None != obj:
raise error.RightError(code = 101005)
isdelete = state.Boole['false']
yz = (code, name, developer, url, status, remark, isdelete, user, user)
result = mysql.insert_or_update_or_delete(self._add_sql, yz)
return 0 == result
def update(self, id, name, teamPath, productUserName, productUserRealName,
devUserName, devUserRealName, startDate, endDate, status, remark, user, productIDs = [], users = []):
obj = self.query_one_by_name(name = name)
if None != obj and str(obj['id']) != str(id):
raise error.ProjectError(code = 111002)
yz = (name, teamPath, productUserName, productUserRealName, devUserName,
devUserRealName, startDate, endDate, status, remark, user, id)
result = mysql.insert_or_update_or_delete(self._update_sql, yz)
self._bind_project_product(id, productIDs, user)
self._bind_project_user(projectID = id, users = users, user = user)
return 0 == result
def add(appCode, name, code, parentID, path, rights, customJson,
sort, status, remark, user):
if not _check_customJson(customJson):
raise error.RightError(code = 102001)
rr = _check_and_format_rights(rights)
if False == rr[0]:
raise error.RightError(code = rr[1])
rights2 = rr[1]
isdelete = state.Boole['false']
yz = (appCode, name, code, parentID, path, rights2, customJson,
sort, status, remark, isdelete, user, user)
result = mysql.insert_or_update_or_delete(_add_sql, yz, True)
return result
def bind_group_user(self, userGroupID, userID, user):
users = self.query_all_group_users(userGroupID)
if users != None:
for u in users:
if u['userID'] == userID:
return True
isdelete = state.Boole['false']
yz = (userGroupID, userID, '', isdelete, user, user)
result = mysql.insert_or_update_or_delete(self._bind_group_user_sql, yz, True)
if result > 0:
#操作成功，清空用户组用户缓存
self._del_user_group_cache(userGroupID = userGroupID)
return result > 0
def bind_group_user(userGroupID, userID, user):
users = query_all_group_users(userGroupID)
if users != None:
for u in users:
if u['userID'] == userID:
return True
isdelete = state.Boole['false']
yz = (userGroupID, userID, '', isdelete, user, user)
result = mysql.insert_or_update_or_delete(_bind_group_user_sql, yz, True)
if result > 0:
#操作成功，清空用户组用户缓存
_del_user_group_cache(userGroupID=userGroupID)
return result > 0
def add(self, name, teamPath, productUserName, productUserRealName, devUserName,
devUserRealName, startDate, endDate, status, remark, user, productIDs = [], users = []):
obj = self.query_one_by_name(name = name)
if None != obj:
raise error.ProjectError(code = 111002)
isdelete = state.Boole['false']
yz = (name, teamPath, productUserName, productUserRealName,
devUserName, devUserRealName, startDate, endDate, status, remark, isdelete, user, user)
result = mysql.insert_or_update_or_delete(self._add_sql, yz, isbackinsertid = True)
if result > 0:
self._bind_project_product(result, productIDs, user)
self._bind_project_user(projectID = result, users = users, user = user)
return result
def update( id, realName, departmentID, parentID, mobile, tel, email, status,
beginDate, endDate, remark, user):
u = query_one_by_email(email) #判断用户邮箱是否已存在
if None != u and str(u['id']) != str(id):
raise error.RightError(code = 103001)
isdelete = state.Boole['false']
lockTime = None
if status != state.statusUserActive:
lockTime = str_helper.get_now_datetimestr()
yz = (realName, departmentID, parentID, mobile, tel, email,
status, beginDate, endDate + ' 23:59:59', remark, user, lockTime, id)
result = mysql.insert_or_update_or_delete(_update_sql, yz)
return 0 == result
def add(self, name, passWord, realName, mobile, tel, email, status, remark, parentID, user):
u = self.query_one_by_email(email) #判断用户邮箱是否已存在
if None != u:
raise error.RightError(code = 103001)
u = self.query_one_by_name(name) #判断用户名是否已存在
if None != u:
raise error.RightError(code = 103008)
pwComp = self._check_password_complexity(password = passWord)
if pwComp != 0:
raise error.RightError(code = pwComp)
isdelete = state.Boole['false']
passWord = self._format_user_password_md5(passWord)
yz = (name, passWord, realName, parentID, mobile, tel, email, status, remark, isdelete, user, user)
uid = mysql.insert_or_update_or_delete(self._add_sql, yz, True)
return uid
def add(operID,
operUserName,
operRealName,
appCode,
funcPath,
action,
targetType=0,
targetID='',
targetName='',
startStatus='',
endStatus='',
operIp=''):
yz = (operID, operUserName, operRealName, appCode, funcPath, action,
targetType, targetID, targetName, startStatus, endStatus, operIp)
result = mysql.insert_or_update_or_delete(_add_sql, yz)
return 0 == result
def update_password( name , oldPassWord, newPassWord1, newPassWord2):
if newPassWord1 != newPassWord2:
raise error.RightError(code = 103010)
if oldPassWord == newPassWord1:
raise error.RightError(code = 103011)
pwComp = _check_password_complexity(password = newPassWord1)
if pwComp != 0:
raise error.RightError(code = pwComp)
u = login(name, oldPassWord) #旧密码是否正确
if None == u:
raise error.RightError(code = 103009)
isdelete = state.Boole['false']
pw = _format_user_password_md5(newPassWord1)
yz = (pw, name, isdelete)
result = mysql.insert_or_update_or_delete(_update_password_sql, yz)
return 0 == result
def update_degree_remark(self, id, degree, users, remark, user):
s = self.get_task_status(degree=degree)
yz = (s, degree, users, remark, user, id)
result = mysql.insert_or_update_or_delete(
self.update_degree_remark_sql, yz)
return 0 == result
def delete( id, user):
isdelete = state.Boole['true']
yz = (isdelete, user, id)
result = mysql.insert_or_update_or_delete(_delete_sql, yz)
return 0 == result
def add(cust_key, region_key, dept_key, user_name, user_password, user_id, user_tel, user_tel2, user_email, user_status,
user_seq, user_beginDate, user_endDate, remark, isDelete, creater, lastUpdater):
# u = query_one_by_email(email) #判断用户邮箱是否已存在
# if None != u:
# raise error.RightError(code = 103001)
# u = query_one_by_name(name) #判断用户名是否已存在
# if None != u:
# raise error.RightError(code = 103008)
u = query_one_by_id(user_id) #判断用户账号是否已存在
if None != u:
raise error.RightError(code = 103008)
pwComp = _check_password_complexity(password = user_password)
if pwComp != 0:
raise error.RightError(code = pwComp)
isdelete = state.Boole['false']
user_password = _format_user_password_md5(user_password)
yz = (cust_key, region_key, dept_key, user_name, user_password, user_id, user_tel, user_tel2, user_email,
user_status , user_seq, user_beginDate + ' 00:00:01', user_endDate + ' 23:59:59', remark, isDelete,
creater, lastUpdater)
uid = mysql.insert_or_update_or_delete(_add_sql, yz, True)
return uid
#
# _update_sql = ''' update sso_user set `realName` = %s, `departmentID` = %s, `parentID` = %s, `mobile` = %s, `tel` = %s, `email` = %s,
# `status` = %s, beginDate = %s, endDate = %s, `remark` = %s, `lastUpdater` = %s,
# `lastUpdateTime` = now() where `id` = %s '''
# ''' 更新用户 '''
# def update( id, realName, departmentID, parentID, mobile, tel, email, status,
# beginDate, endDate, remark, user):
# u = query_one_by_email(email) #判断用户邮箱是否已存在
# if None != u and str(u['id']) != str(id):
# raise error.RightError(code = 103001)
#
# isdelete = state.Boole['false']
# yz = (realName, departmentID, parentID, mobile, tel, email,
# status, beginDate, endDate + ' 23:59:59', remark, user, id)
# result = mysql.insert_or_update_or_delete(_update_sql, yz)
# return 0 == result
#
#
# _delete_sql = ''' update sso_user set isDelete = %s, lastUpdater = %s,
# lastUpdateTime = now() where id = %s '''
# ''' 删除用户，逻辑删除 '''
# def delete( id, user):
# isdelete = state.Boole['true']
# yz = (isdelete, user, id)
# result = mysql.insert_or_update_or_delete(_delete_sql, yz)
# return 0 == result
#
#
#
#
# _update_password_sql = ''' update sso_user set `passWord` = %s where `name` = %s and isDelete = %s '''
# ''' 修改用户密码 '''
# def update_password( name , oldPassWord, newPassWord1, newPassWord2):
# if newPassWord1 != newPassWord2:
# raise error.RightError(code = 103010)
# if oldPassWord == newPassWord1:
# raise error.RightError(code = 103011)
# pwComp = _check_password_complexity(password = newPassWord1)
# if pwComp != 0:
# raise error.RightError(code = pwComp)
# u = login(name, oldPassWord) #旧密码是否正确
# if None == u:
# raise error.RightError(code = 103009)
#
# isdelete = state.Boole['false']
# pw = _format_user_password_md5(newPassWord1)
# yz = (pw, name, isdelete)
# result = mysql.insert_or_update_or_delete(_update_password_sql, yz)
# return 0 == result
#
#
# ''' 重置用户密码 '''
# def reset_password( name):
# passWord = str_helper.get_uuid()
# isdelete = state.Boole['false']
# pw = _format_user_password_md5(passWord)
# yz = (pw, name, isdelete)
#
# result = mysql.insert_or_update_or_delete(_update_password_sql, yz)
#
# if 0 == result:
# return passWord
# return None
#
#
# _update_status_sql = ''' update sso_user set `status` = %s, `lastUpdater` = %s,
# `lastUpdateTime` = now() where `id` = %s '''
# ''' 更新用户 '''
# def update_status( id, status, user):
# yz = (status, user, id)
# result = mysql.insert_or_update_or_delete(_update_status_sql, yz)
# return 0 == result
#
#
# _update_goto_app_sql = ''' update sso_user set `lastLoginTime` = now(), `lastLoginApp` = %s, `lastLoginIp` = %s,
# `loginCount` = `loginCount` + 1 where `name` = %s and isDelete = %s '''
# ''' 更新用户最后登录应用信息 '''
# def update_goto_app( name , appCode, ip):
# isdelete = state.Boole['false']
# yz = (appCode, ip, name, isdelete)
# result = mysql.insert_or_update_or_delete(_update_goto_app_sql, yz)
# return 0 == result
#
#
# _query_user_roles_sql = ''' select ugu.id, ugu.userID, ugu.roleID, ugu.remark, ugu.isDelete, ugu.creater,
# ugu.createTime, ugu.lastUpdater, ugu.lastUpdateTime, u.`name` as roleName from sso_user_role as ugu
# LEFT JOIN sso_role u on u.id = ugu.roleID
# where ugu.userID = %s and ugu.isDelete = %s and u.status = %s order by ugu.id desc '''
# # _query_user_roles_col = str_helper.format_str_to_list_filter_empty(
# # 'id, userID, roleID, remark, isDelete, creater, createTime, lastUpdater, lastUpdateTime, roleName', ',')
# ''' 分页查询用户所属角色 '''
# def query_page_user_roles( userID, page = 1, size = 12):
# isdelete = state.Boole['false']
# yz = (userID, isdelete, state.statusActive)
# roles = mysql.find_page(_query_user_roles_sql, yz, _query_user_roles_col, page, size)
# return roles
#
# ''' 查询用户所有的角色 '''
# def query_all_user_roles( userID):
# isdelete = state.Boole['false']
# yz = (userID, isdelete, state.statusActive)
# roles = mysql.find_all(_query_user_roles_sql, yz, _query_user_roles_col)
# return roles
#
#
# _bind_group_role_sql = ''' INSERT INTO sso_user_role(userID, roleID, remark, isDelete, creater,
# createTime, lastUpdater, lastUpdateTime) VALUES(%s, %s, %s, %s, %s, NOW(), %s, NOW()) '''
# ''' 绑定用户的角色 '''
# def bind_user_role( userID, roleID, user):
# roles = query_all_user_roles(userID)
# if roles != None:
# for role in roles:
# if role['roleID'] == roleID:
# return True
# isdelete = state.Boole['false']
# yz = (userID, roleID, '', isdelete, user, user)
# result = mysql.insert_or_update_or_delete(_bind_group_role_sql, yz)
# return 0 == result
#
#
# _del_user_role_sql = ''' update sso_user_role set isDelete = %s , lastUpdater = %s , lastUpdateTime = now() WHERE id = %s '''
# ''' 删除用户角色 '''
# def del_user_role( id, user):
# isdelete = state.Boole['true']
# yz = (isdelete, user, id)
# result = mysql.insert_or_update_or_delete(_del_user_role_sql, yz)
# return 0 == result
#
# _get_user_role_sql = ''' select id, userID, roleID from sso_user_role WHERE id = %s '''
# # _get_user_role_col = str_helper.format_str_to_list_filter_empty('id, userID, roleID', ',')
# ''' 获得用户角色信息 '''
# def get_user_role( id):
# yz = (id)
# info = mysql.find_one(_get_user_role_sql, yz, _get_user_role_col)
# return info
#
#
# ''' 查询用户权限 '''
# def query_user_app_right( userID, appCode):
# user = query_one(userID)
# if user == None:
# return None
# funcs = func_logic.query_all_by_app(appCode)
# if None == funcs or len(funcs) <= 0:
# return None
#
# ''' 初始化权限 '''
# funcs = role_logic.init_func_right(funcs)
#
# ''' 统计绑定的用户组权限 '''
# userGroups = usergroup_logic.query_all_user_groups(userID)
# if userGroups != None and len(userGroups) > 0:
# for userGroup in userGroups:
# funcs = usergroup_logic.query_user_group_app_right(userGroupID = userGroup['userGroupID'], appCode = appCode, funcs = funcs)
#
# ''' 统计绑定的角色权限 '''
# roles = query_all_user_roles(userID)
# if None != roles and len(roles) > 0:
# for role in roles:
# funcs = role_logic.format_role_func_right(appCode = appCode, roleID = role['roleID'], funcs = funcs)
# return funcs
#
#
#
# _user_by_name_key = 'soc_api_user_by_name_%s'
# ''' 根据用户名获取用户信息 '''
# def query_user_by_name_cache( name):
# key = _user_by_name_key % name
# user = redis_cache.getObj(key)
# if None == user:
# user = query_one_by_name(name = name)
# redis_cache.setObj(key = key, val = user, time = config.cache['apiTimeOut'])
# return user
#
# ''' 删除用户名获取用户 '''
# def _del_user_by_name_cache( name):
# key = _user_by_name_key % name
# redis_cache.delete(key = key)
def update_taskid(self, newTaskID, oldTaskID, user):
yz = (newTaskID, oldTaskID)
result = mysql.insert_or_update_or_delete(self._update_taskid_sql, yz)
return 0 == result
def delete(id, user):
isdelete = state.Boole['true']
yz = (isdelete, user, id)
result = mysql.insert_or_update_or_delete(_delete_sql, yz)
return 0 == result
def delete_by_projectID(self, projectID, user):
isdelete = state.Boole['true']
isdeletefalse = state.Boole['false']
yz = (isdelete, user, projectID, isdeletefalse)
result = mysql.insert_or_update_or_delete(self._delete_sql, yz)
return 0 == result
def update_goto_app( name , appCode, ip):
isdelete = state.Boole['false']
yz = (appCode, ip, name, isdelete)
result = mysql.insert_or_update_or_delete(_update_goto_app_sql, yz)
return 0 == result
def update(self, id, name, userName, userRealName, users, status, remark,
user):
yz = (name, userName, userRealName, users, status, remark, user, id)
result = mysql.insert_or_update_or_delete(self._update_sql, yz)
return 0 == result
def update_parentID_preID(self, id, parentID, preID, user):
yz = (parentID, preID, user, id)
result = mysql.insert_or_update_or_delete(
self._update_parentID_preID_sql, yz)
return 0 == result
