Function getAssetData

server/src/db/perspective-asset-db.ts:72–83

(
  perspectiveId: string,
  fileName: string
)

/** Get asset binary data for serving. */
export async function getAssetData(
  perspectiveId: string,
  fileName: string
): Promise<{ file_data: Buffer; file_mime_type: string; file_name: string } | null> {
  const result = await query<{ file_data: Buffer; file_mime_type: string; file_name: string }>(
    `SELECT file_data, file_mime_type, file_name
     FROM perspective_assets
     WHERE perspective_id = $1 AND file_name = $2`,
    [perspectiveId, fileName]
  );
  return result.rows[0] || null;
}

/** List all assets for a perspective (metadata only, no binary). */
export async function getAssetsByPerspective(perspectiveId: string): Promise<PerspectiveAsset[]> {