def updateAuthority(self, authorityId, text, menuIdList): DBConn().begin(); try: DBAuthority.deleteByAuthorityId(authorityId) DBAuthority.insrt(text, authorityId, menuIdList) DBConn().commit(); except Exception, e: print e DBConn().rollback();
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 selectByMenuId(self, menuId):
'''
'''
returnValue = {}
sql = ''' select menu_id,text,url,sort from mgame_tool.menu where menu_id=%s '''
db = DBConn()
rownum, db_res = db.query(sql, (menuId))
rownum += 0
for row in db_res:
returnValue['menuId'] = row[0]
returnValue['text'] = row[1]
returnValue['url'] = row[2]
returnValue['sort'] = row[3]
return returnValue
def select(self, userName):
'''
查找指定的用户
'''
returnValue = {}
sql = ''' select * from mgame_tool.user_info where user_name=%s '''
db = DBConn()
rownum, db_res = db.query(sql, (userName))
for row in db_res:
temp = {}
temp['userName'] = row[0]
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 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)
