Method resolveIdentifiers

server/src/db/catalog-db.ts:132–309

* Resolve identifiers to property_rids. * In 'resolve' mode: creates missing properties, logs activity. * In 'lookup' mode: returns existing only, no creates, no logging.

(
    identifiers: ResolveInput[],
    mode: ResolveMode,
    memberId: string,
    provenance: Provenance
  )

   * In 'lookup' mode: returns existing only, no creates, no logging.
   */
  async resolveIdentifiers(
    identifiers: ResolveInput[],
    mode: ResolveMode,
    memberId: string,
    provenance: Provenance
  ): Promise<ResolveResult> {
    const normalized = identifiers.map(({ type, value }) => normalizeIdentifier(type, value));
    const results: ResolvedEntry[] = [];
    let created = 0;
    let excluded = 0;
    let notFound = 0;

    // Batch lookup: find all existing identifiers
    const existing = await this.batchLookupIdentifiers(
      normalized.map(n => ({ type: n.type, value: n.value }))
    );

    // Check aliases for any found rids
    const aliasMap = await this.batchResolveAliases(
      [...new Set(
        Array.from(existing.values())
          .filter(e => e !== null)
          .map(e => e!.property_rid)
      )]
    );

    // For unknown identifiers, batch-fetch classifications from catalog_facts
    const unknownNorms = normalized.filter(n => !existing.has(`${n.type}:${n.value}`));
    const classifications = unknownNorms.length > 0
      ? await this.batchGetClassifications(unknownNorms.map(n => `${n.type}:${n.value}`))
      : new Map<string, string>();

    // Collect entries to batch-create
    const toCreate: Array<{
      propertyRid: string;
      identifierType: string;
      identifierValue: string;
      memberId: string;
      provenance: Provenance;
    }> = [];

    // First pass: classify all results without DB writes
    for (const norm of normalized) {
      const key = `${norm.type}:${norm.value}`;
      const found = existing.get(key);

      if (found) {
        const canonicalRid = aliasMap.get(found.property_rid) ?? found.property_rid;
        results.push({
          identifier: { type: norm.type, value: norm.value },
          property_rid: canonicalRid,
          classification: found.classification,
          status: 'existing',
          source: found.source,
        });
      } else if (mode === 'resolve') {
        const classification = classifications.get(`${norm.type}:${norm.value}`) ?? null;