Source code for cata_log_hub.utils.queries

# SPDX-License-Identifier: AGPL-3.0-or-later
#
# Cata-Log - the central hub for digital flyers
# Copyright (C) 2026 David Aderbauer & The Cata-Log Contributors
#
# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU Affero General Public License as
# published by the Free Software Foundation, either version 3 of the
# License, or (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU Affero General Public License for more details.
#
# You should have received a copy of the GNU Affero General Public License
# along with this program. If not, see <https://www.gnu.org/licenses/>.

from sqlalchemy import ScalarSelect, sql

from cata_log_hub import database




def latest_provider_catalog_id_subquery(provider_id: int) -> ScalarSelect[int]:
    """Create a subquery for the id of the latest catalog of a provider.

    Args:
        provider_id: The id of the provider.

    Returns:
        A subquery to use in sql queries that need the latest provider catalog id.
    """
    return (
        sql.select(database.Catalog.id)
        .filter(database.Catalog.provider_id == provider_id)
        .order_by(database.Catalog.created_at.desc())
        .limit(1)
        .scalar_subquery()
    )