Method getProperty

server/src/db/catalog-db.ts:315–328

(propertyRid: string)

  // ═══════════════════════════════════════════════════════════════════════════

  async getProperty(propertyRid: string): Promise<PropertyWithIdentifiers | null> {
    const propResult = await query<CatalogProperty>(
      'SELECT * FROM catalog_properties WHERE property_rid = $1',
      [propertyRid]
    );
    if (propResult.rows.length === 0) return null;

    const identResult = await query<CatalogIdentifier>(
      'SELECT * FROM catalog_identifiers WHERE property_rid = $1 AND disputed = FALSE ORDER BY created_at',
      [propertyRid]
    );

    return { ...propResult.rows[0], identifiers: identResult.rows };
  }

  async listProperties(filters: ListFilters): Promise<{ properties: CatalogProperty[]; next_cursor: string | null; total: number }> {
    const conditions: string[] = [];