use super::{PgPool, Uuid};

#[derive(sqlx::FromRow)]
pub struct LinkPreviewRow {
    pub post_id: Uuid,
    pub url: String,
    pub title: Option<String>,
    pub description: Option<String>,
}

/// Batch-fetch link previews for a set of post IDs.
#[tracing::instrument(skip_all)]
pub async fn list_link_previews_for_posts(
    pool: &PgPool,
    post_ids: &[Uuid],
) -> Result<Vec<LinkPreviewRow>, sqlx::Error> {
    sqlx::query_as!(
        LinkPreviewRow,
        "SELECT post_id, url, title, description
         FROM link_previews
         WHERE post_id = ANY($1)
         ORDER BY fetched_at",
        post_ids,
    )
    .fetch_all(pool)
    .await
}