Method updateProfile

server/src/db/community-db.ts:156–207

(userId: string, updates: UpdateCommunityProfileInput)

  // =====================================================

  async updateProfile(userId: string, updates: UpdateCommunityProfileInput): Promise<CommunityProfile | null> {
    const COLUMN_MAP: Record<keyof UpdateCommunityProfileInput, string> = {
      slug: 'slug',
      headline: 'headline',
      bio: 'bio',
      avatar_url: 'avatar_url',
      expertise: 'expertise',
      interests: 'interests',
      linkedin_url: 'linkedin_url',
      twitter_url: 'twitter_url',
      github_username: 'github_username',
      is_public: 'is_public',
      open_to_coffee_chat: 'open_to_coffee_chat',
      open_to_intros: 'open_to_intros',
      city: 'city',
    };

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

    // Normalize tag arrays: lowercase, trim, deduplicate
    if (updates.expertise) {
      updates.expertise = [...new Set(updates.expertise.map(t => t.trim().toLowerCase()).filter(Boolean))];
    }
    if (updates.interests) {
      updates.interests = [...new Set(updates.interests.map(t => t.trim().toLowerCase()).filter(Boolean))];
    }

    for (const [key, value] of Object.entries(updates)) {
      const columnName = COLUMN_MAP[key as keyof UpdateCommunityProfileInput];
      if (!columnName) continue;
      setClauses.push(`${columnName} = $${paramIndex++}`);
      params.push(value);
    }

    if (setClauses.length === 0) {
      return this.getProfile(userId);
    }

    params.push(userId);
    const sql = `
      UPDATE users
      SET ${setClauses.join(', ')}, updated_at = NOW()
      WHERE workos_user_id = $${paramIndex}
      RETURNING workos_user_id, slug, headline, bio, avatar_url, expertise, interests,
                linkedin_url, twitter_url, github_username, is_public, open_to_coffee_chat, open_to_intros, city
    `;

    const result = await query<CommunityProfile>(sql, params);
    return result.rows[0] || null;
  }

  async getProfile(userId: string): Promise<CommunityProfile | null> {
    const result = await query<CommunityProfile>(