def get_all_users(self):
query = f'SELECT * FROM {User.table_name};'
self._main_cursor.execute(query)
return [
User.from_table_values(result)
for result in self._main_cursor.fetchall()
]
def get_user_by_login(self, search_login):
query = f'SELECT * FROM {User.table_name} ' \
f'WHERE "login" = {sql.Literal(search_login).as_string(self._main_cursor)};'
self._main_cursor.execute(query)
query_result = self._main_cursor.fetchone()
if query_result is not None:
return User.from_table_values(query_result)
else:
return None
