def saveUserInfo(self, appid, username, password):
"""
将用户注册信息入库
:param appid:
:param username:
:param password:
:return: 保存成功返回True : False
"""
sql = """
BEGIN;
INSERT INTO userinfo (appid_id, username, createtime, updatetime) VALUES (%s, %s, %s, %s);
INSERT INTO localauth (userid_id, password) VALUES (%s, %s);
COMMIT;
"""
insert_userinfo = "INSERT INTO userinfo (appid_id, username, createtime, updatetime) VALUES (%s, %s, %s, %s)"
insert_localauth = "INSERT INTO localauth (userid_id, password) VALUES (%s, %s)"
now = str(int(time.time()))
try:
userid_id = self.db.insert(insert_userinfo, appid, username, now, now)
except Exception as e:
logger.error(str(e))
return False
else:
try:
self.db.insert(insert_localauth, userid_id, utils.encodePassword(password))
except Exception as e:
logger.error(str(e))
return False
return True
def checkUserInfo(self, appid, username, password):
"""
验证用户名密码
:param appid:
:param username:
:param password:
:return: 验证成功返回True : False
"""
user = self.haveUserName(appid, username)
if user:
sql = "SELECT password FROM localauth WHERE userid_id=%s"
auth = self.db.get(sql, user['id'])
md5password = utils.encodePassword(password)
if auth['password'] == md5password:
return True
else:
return False
else:
return False
