def checkUrl(self, url): ''' 测试url是否在权限管理之内 ''' # Logger.info('DBAuthority.checkUrl begin') sql = 'select count(*) from mgame_tool.menu where url=%s' db = DBConn() rownum, db_res = db.query(sql, (url)) rownum += 0 for row in db_res: if row[0] >= 1: return True # Logger.info('DBAuthority.checkUrl end') elif row[0] == 0: return False # Logger.info('DBAuthority.checkUrl end') ''' elif row[0] > 1: msg = 'DBAuthority.checkUrl:有重复url[%s]' % url Logger.error(msg) raise Exception(msg); ''' msg = 'DBUserInfo.login:有重复url[%s]' % url Logger.error(msg) raise Exception(msg);
def changePassword(self, userName, afterPassword, beforePassword): ''' 修改用户密码 ''' Logger.info('DBUserInfo.changePassword begin') sql = ''' update mgame_tool.user_info set password=%s where user_name=%s and password=%s ''' pass Logger.info('DBUserInfo.changePassword end')
def insert(self, userName, password): ''' 创建用户 ''' Logger.info('DBUserInfo.insert begin') sql = ''' insert into mgame_tool.user_info(user_name, password) values(%s,%s)''' db = DBConn() rownum, db_res = db.query(sql, (userName, password)) return rownum
def selectAuthority(self, text): ''' 查找指定的用户 ''' Logger.info('DBAuthority.selectAuthority begin') returnValue = {} sql = ''' select authority_id,comment from mgame_tool.authority where comment=%s group by authority_id,comment ''' db = DBConn() rownum, db_res = db.query(sql, (text)) for row in db_res: temp = {} temp['id'] = row[0] temp['comment'] = row[1] returnValue.append(temp) if rownum == 0: return None else: return returnValue;
def selectAll(self): ''' ''' returnValue = [] Logger.info('DBMenu.selectAll begin') db = DBConn() sql = 'select menu_id,text,url,sort from mgame_tool.menu where parent_id>0 order by parent_id,sort' rownum, db_res = db.query(sql) rownum += 0 for row in db_res: temp = {} temp['menuId'] = row[0] temp['text'] = row[1] temp['url'] = row[2] temp['sort'] = row[3] returnValue.append(temp) return returnValue
def selectAll(self, userName=''): ''' 查询用户 ''' Logger.info('DBUserInfo.select begin') returnValue = [] sql = ''' select * from mgame_tool.user_info ''' where = ''' where user_name like %s ''' rownum, db_res = None, None db = DBConn() if userName == '': rownum, db_res = db.query(sql) else: sql = sql + where rownum, db_res = db.query(sql, ('%' + userName + '%')) rownum += 0 for row in db_res: temp = {} temp['userName'] = row[0] returnValue.append(temp) return returnValue
def selectAll(self, userName=''): ''' 查询用户 ''' Logger.info('DBUserInfo.select begin') returnValue = [] sql = ''' select * from mgame_tool.user_info ''' where = ''' where user_name like %s ''' rownum, db_res = None, None db = DBConn() if userName == '': rownum, db_res = db.query(sql) else: sql = sql + where rownum, db_res = db.query(sql, ('%' + userName + '%')) rownum += 0 for row in db_res: temp = {} temp['userName'] = row[0] returnValue.append(temp) return returnValue;
def selectAllAuthority(self, text=''): ''' 查询用户 ''' Logger.info('DBAuthority.selectAllAuthority begin') returnValue = [] sql = ''' select authority_id,comment from mgame_tool.authority ''' where = ''' where comment like %s ''' groupBy = ''' group by authority_id,comment ''' rownum, db_res = None, None db = DBConn() if text == '': rownum, db_res = db.query(sql + groupBy) else: sql = sql + where + groupBy rownum, db_res = db.query(sql, ('%' + text + '%')) rownum += 0 for row in db_res: temp = {} temp['id'] = row[0] temp['comment'] = row[1] returnValue.append(temp) return returnValue;
def login(self, userName, password): ''' 用户登录 ''' Logger.info('DBUserInfo.login begin') # Logger.info('DBUserInfo.login begin') db = DBConn() sql = 'select count(*) from mgame_tool.user_info where user_name=%s and password=%s' rownum, db_res = db.query(sql, (userName, password)) rownum += 0 for row in db_res: if row[0] == 1: return True # Logger.info('DBUserInfo.login end') elif row[0] == 0: return False # Logger.info('DBUserInfo.login end') elif row[0] > 1: msg = 'DBUserInfo.login:有重复用户userName[%s]' % userName Logger.error(msg) raise Exception(msg) msg = 'DBUserInfo.login:用户数据错误userName[%s]' % userName Logger.error(msg) raise Exception(msg)
def login(self, userName, password): ''' 用户登录 ''' Logger.info('DBUserInfo.login begin') # Logger.info('DBUserInfo.login begin') db = DBConn() sql = 'select count(*) from mgame_tool.user_info where user_name=%s and password=%s' rownum, db_res = db.query(sql, (userName, password)) rownum += 0 for row in db_res: if row[0] == 1: return True # Logger.info('DBUserInfo.login end') elif row[0] == 0: return False # Logger.info('DBUserInfo.login end') elif row[0] > 1: msg = 'DBUserInfo.login:有重复用户userName[%s]' % userName Logger.error(msg) raise Exception(msg); msg = 'DBUserInfo.login:用户数据错误userName[%s]' % userName Logger.error(msg) raise Exception(msg);