def get_by_username_password(cls, username, password): line = dbutil.execute_fetch(cls.SQL_USER_LOGIN, (username, password), True) if line: return User(**line) #$return User(id=line['id'], username=line['username'], age=line['age'], tel=line['tel'], password=line['password']) return None
def all(cls): users = [] lines = dbutil.execute_fetch(cls.SQL_USER_LIST) for user in lines: obj = User(id=user['id'], username=user['username'], age=user['age'], tel=user['tel']) users.append(obj) return users
def get_messages(): lines = dbutil.execute_fetch(SQL_ALL) rt_list = [] for line in lines: message = dict(zip(SQL_MESSAGES_LIST_COLLMNS, line)) if message['publish_date']: message['publish_date'] = message['publish_date'].strftime( '%Y-%m-%d %H:%M:%S') rt_list.append(message) return rt_list
def all(cls): rt_list = [] lines = dbutil.execute_fetch(cls.SQL_MESSAGE_LIST) for message in lines: if message['publish_date']: message['publish_date'] = message['publish_date'].strftime( '%Y-%m-%d %H:%M:%S') obj = Message(id=message['id'], username=message['username'],\ title=message['title'], content=message['content'], publish_date=message['publish_date']) rt_list.append(obj) return rt_list
def get_by_id(cls, id): line = dbutil.execute_fetch(cls.SQL_USER_FIND_BY_ID, (id, ), True) return User(**line) if line else None
def get_by_username(cls, username): line = dbutil.execute_fetch(cls.SQL_USER_FIND_BY_NAME, (username, ), True) return User(**line) if line else None
def all(cls): lines = dbutil.execute_fetch(cls.SQL_USER_LIST) return [User(**line) for line in lines]
def get_by_username_password(cls, username, password): line = dbutil.execute_fetch(cls.SQL_USER_LOGIN, (username, password), True) return User(**line) if line else None
def get_user_by_id(self): args = (self.id, ) return dbutil.execute_fetch(self.SQL_USER_FIND_BY_ID, args, True)
def __get_user_by_username(username): args = (username, ) return dbutil.execute_fetch(SQL_USER_FIND_BY_NAME, args, True)
def find(self): args = (self.id, ) user = dbutil.execute_fetch(self.SQL_USER_FIND_BY_ID, args, True) return user
def login(self): args = (self.username, self.password) return dbutil.execute_fetch(self.SQL_USER_LOGIN, args, True)