package repository import ( "database/sql" "time" ) // PreviewRow mémorise la vignette servie (V3 S7, migration 000024). type PreviewRow struct { SrcSize int64 SrcUpdatedAt time.Time } // GetPreview lit la génération servie. Absente → sql.ErrNoRows (régénérer). func (r *Resources) GetPreview(resourceID string) (PreviewRow, error) { var row PreviewRow err := r.DB.QueryRow( `SELECT src_size_bytes, src_updated_at FROM resource_previews WHERE resource_id = $1`, resourceID, ).Scan(&row.SrcSize, &row.SrcUpdatedAt) if err == sql.ErrNoRows { return PreviewRow{}, err } return row, err } // UpsertPreview mémorise la génération servie (taille + updated_at sources). func (r *Resources) UpsertPreview(resourceID string, srcSize int64, srcUpdatedAt time.Time) error { _, err := r.DB.Exec( `INSERT INTO resource_previews (resource_id, src_size_bytes, src_updated_at) VALUES ($1, $2, $3) ON CONFLICT (resource_id) DO UPDATE SET src_size_bytes = EXCLUDED.src_size_bytes, src_updated_at = EXCLUDED.src_updated_at, created_at = NOW()`, resourceID, srcSize, srcUpdatedAt, ) return err }