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