class UserModel(object): def __init__(self): self.api = MySqlApi() self.fields = { "nickname": "nickname", "email": "email", "password": "******" } def add(self, nickname, email, password): sql = "INSERT INTO users(nickname, email, password) " +\ "VALUES('{0}', '{1}', '{2}');".format( nickname, email.encode("utf-8"), password ) self.api.add(sql) return True def is_exists(self, nickname, email): sql = "SELECT nickname, email FROM users WHERE "+\ "nickname = '{0}' OR email = '{1}'".format( nickname, email) data = self.api.get(sql) if not data: return False else: return True def get(self, email): sql = "SELECT * FROM users WHERE email = '{0}'".format( email) user = self.api.get(sql) return user
def __init__(self): self.api = MySqlApi() self.fields = { "nickname": "nickname", "email": "email", "password": "******" }