Method batchGetClassifications

server/src/db/catalog-db.ts:748–777

* Batch classification lookup — single query for all identifiers. * Returns the highest-confidence classification for each identifier value.

(
    identifierValues: string[]
  )

   * Returns the highest-confidence classification for each identifier value.
   */
  async batchGetClassifications(
    identifierValues: string[]
  ): Promise<Map<string, string>> {
    if (identifierValues.length === 0) return new Map();

    const result = await query<{ subject_value: string; object_value: string }>(
      `SELECT DISTINCT ON (subject_value) subject_value, object_value
       FROM catalog_facts
       WHERE fact_type = 'classification'
         AND subject_type = 'identifier'
         AND subject_value = ANY($1)
         AND predicate = 'classified_as'
         AND superseded_by IS NULL
       ORDER BY subject_value,
         CASE confidence
           WHEN 'authoritative' THEN 1
           WHEN 'strong' THEN 2
           WHEN 'medium' THEN 3
           WHEN 'weak' THEN 4
         END,
         created_at DESC`,
      [identifierValues]
    );

    const map = new Map<string, string>();
    for (const row of result.rows) {
      map.set(row.subject_value, row.object_value);
    }
    return map;
  }

  /**
   * Batch create properties with identifiers and facts.