"""Video Dashboard Item Logic."""

from typing import Any

from video.models.sql import queries


def get_new_assets(
    dashboard_item_id: int, offset: int
) -> tuple[list[dict[str, Any]], int | None]:
    """Get new assets from video dashboard item table.

    Args:
        dashboard_item_id (int): ID of last video dashboard item encoded.
        offset (int): Pagination offset.

    Returns:
        tuple: (list of asset dicts, total count of assets)
    """
    items = queries.get_new_assets(dashboard_item_id, offset)
    count = queries.get_new_assets_count(dashboard_item_id)
    return items, count


def get_max_dashboard_item_id() -> int | None:
    """Get most recent id from video dashboard item table."""
    return queries.get_max_dashboard_item_id()