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