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