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