Method getProfileBySlug

server/src/db/member-db.ts:108–115

* Get profile by slug

(slug: string)

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

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

  /**
   * Get profile by primary brand domain