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)
