Method getProfileByOrgId

server/src/db/member-db.ts:132–139

* Get profile by organization ID

(workos_organization_id: string)

   * Get profile by organization ID
   */
  async getProfileByOrgId(workos_organization_id: string): Promise<MemberProfile | null> {
    const result = await query<MemberProfile>(
      'SELECT * FROM member_profiles WHERE workos_organization_id = $1',
      [workos_organization_id]
    );

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

  /**
   * Update member profile