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 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 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):
'''
'''
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);
