Method updateProfile

server/src/db/member-db.ts:144–205

* Update member profile

(
    id: string,
    updates: UpdateMemberProfileInput
  )

   * Update member profile
   */
  async updateProfile(
    id: string,
    updates: UpdateMemberProfileInput
  ): Promise<MemberProfile | null> {
    // Build SET clause dynamically using explicit column mapping
    const COLUMN_MAP: Record<keyof UpdateMemberProfileInput, string> = {
      display_name: 'display_name',
      tagline: 'tagline',
      description: 'description',
      primary_brand_domain: 'primary_brand_domain',
      contact_email: 'contact_email',
      contact_website: 'contact_website',
      contact_phone: 'contact_phone',
      linkedin_url: 'linkedin_url',
      twitter_url: 'twitter_url',
      offerings: 'offerings',
      agents: 'agents',
      publishers: 'publishers',
      brands: 'brands',
      data_providers: 'data_providers',
      headquarters: 'headquarters',
      markets: 'markets',
      metadata: 'metadata',
      tags: 'tags',
      is_public: 'is_public',
      show_in_carousel: 'show_in_carousel',
      is_founding_member: 'is_founding_member',
    };

    const setClauses: string[] = [];
    const params: unknown[] = [];
    let paramIndex = 1;

    for (const [key, value] of Object.entries(updates)) {
      const columnName = COLUMN_MAP[key as keyof UpdateMemberProfileInput];
      if (!columnName) {
        continue; // Skip unknown fields
      }

      setClauses.push(`${columnName} = $${paramIndex++}`);
      if (key === 'metadata' || key === 'agents' || key === 'publishers' || key === 'brands' || key === 'data_providers') {
        params.push(JSON.stringify(value));
      } else {
        params.push(value);
      }
    }

    if (setClauses.length === 0) {
      return this.getProfileById(id);
    }

    params.push(id);
    const sql = `
      UPDATE member_profiles
      SET ${setClauses.join(', ')}, updated_at = NOW()
      WHERE id = $${paramIndex}
      RETURNING *
    `;