Method createProfile

server/src/db/member-db.ts:50–91

* Create a new member profile

(input: CreateMemberProfileInput)

   * Create a new member profile
   */
  async createProfile(input: CreateMemberProfileInput): Promise<MemberProfile> {
    const agents = input.agents || [];
    const publishers = input.publishers || [];
    const data_providers = input.data_providers || [];

    const result = await query<MemberProfile>(
      `INSERT INTO member_profiles (
        workos_organization_id, display_name, slug, tagline, description,
        primary_brand_domain,
        contact_email, contact_website, contact_phone,
        linkedin_url, twitter_url,
        offerings, agents, publishers, data_providers, headquarters, markets, metadata, tags,
        is_public, show_in_carousel
      ) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21)
      RETURNING *`,
      [
        input.workos_organization_id,
        input.display_name,
        input.slug,
        input.tagline || null,
        input.description || null,
        input.primary_brand_domain || null,
        input.contact_email || null,
        input.contact_website || null,
        input.contact_phone || null,
        input.linkedin_url || null,
        input.twitter_url || null,
        input.offerings || [],
        JSON.stringify(agents),
        JSON.stringify(publishers),
        JSON.stringify(data_providers),
        input.headquarters || null,
        input.markets || [],
        JSON.stringify(input.metadata || {}),
        input.tags || [],
        input.is_public ?? false,
        input.show_in_carousel ?? false,
      ]
    );

    return this.deserializeProfile(result.rows[0]);
  }

  /**
   * Get profile by ID