Class ProfilesRepo

new ProfilesRepo(options: DbRepoOptions): ProfilesRepo

getByEmail(
    email: string,
): Promise<
    {
        clinic_size: string
        | null;
        created_at: string | null;
        customer_id: string | null;
        email: string | null;
        expectations: string | null;
        external_system:
            | "kipu"
            | "lightningstep"
            | "sunwave"
            | "qualifacts_insync"
            | null;
        external_system_id: string
        | null;
        first_name: string | null;
        hear_about_us: string | null;
        id: number;
        is_superadmin: boolean;
        last_name: string | null;
        last_updated: string | null;
        price_id: string | null;
        profile_type: "user" | "external";
        session_limit: number | null;
        subscription_status:
            | "trial_ended"
            | "trial_running"
            | "active"
            | "inactive"
            | null;
        title: string
        | null;
        user_id: string | null;
        vertical: string | null;
    },
>

upsert(
    params: {
        clinic_size?: string | null;
        created_at?: string | null;
        customer_id?: string | null;
        email?: string | null;
        expectations?: string | null;
        external_system?:
            | "kipu"
            | "lightningstep"
            | "sunwave"
            | "qualifacts_insync"
            | null;
        external_system_id?: string
        | null;
        first_name?: string | null;
        hear_about_us?: string | null;
        id?: number;
        is_superadmin?: boolean;
        last_name?: string | null;
        last_updated?: string | null;
        price_id?: string | null;
        profile_type?: "user" | "external";
        session_limit?: number | null;
        subscription_status?:
            | "trial_ended"
            | "trial_running"
            | "active"
            | "inactive"
            | null;
        title?: string
        | null;
        user_id?: string | null;
        vertical?: string | null;
    },
): Promise<
    {
        clinic_size: string
        | null;
        created_at: string | null;
        customer_id: string | null;
        email: string | null;
        expectations: string | null;
        external_system:
            | "kipu"
            | "lightningstep"
            | "sunwave"
            | "qualifacts_insync"
            | null;
        external_system_id: string
        | null;
        first_name: string | null;
        hear_about_us: string | null;
        id: number;
        is_superadmin: boolean;
        last_name: string | null;
        last_updated: string | null;
        price_id: string | null;
        profile_type: "user" | "external";
        session_limit: number | null;
        subscription_status:
            | "trial_ended"
            | "trial_running"
            | "active"
            | "inactive"
            | null;
        title: string
        | null;
        user_id: string | null;
        vertical: string | null;
    },
>

upsert(
    params: {
        clinic_size?: string | null;
        created_at?: string | null;
        customer_id?: string | null;
        email?: string | null;
        expectations?: string | null;
        external_system?:
            | "kipu"
            | "lightningstep"
            | "sunwave"
            | "qualifacts_insync"
            | null;
        external_system_id?: string
        | null;
        first_name?: string | null;
        hear_about_us?: string | null;
        id?: number;
        is_superadmin?: boolean;
        last_name?: string | null;
        last_updated?: string | null;
        price_id?: string | null;
        profile_type?: "user" | "external";
        session_limit?: number | null;
        subscription_status?:
            | "trial_ended"
            | "trial_running"
            | "active"
            | "inactive"
            | null;
        title?: string
        | null;
        user_id?: string | null;
        vertical?: string | null;
    }[],
): Promise<
    {
        clinic_size: string
        | null;
        created_at: string | null;
        customer_id: string | null;
        email: string | null;
        expectations: string | null;
        external_system:
            | "kipu"
            | "lightningstep"
            | "sunwave"
            | "qualifacts_insync"
            | null;
        external_system_id: string
        | null;
        first_name: string | null;
        hear_about_us: string | null;
        id: number;
        is_superadmin: boolean;
        last_name: string | null;
        last_updated: string | null;
        price_id: string | null;
        profile_type: "user" | "external";
        session_limit: number | null;
        subscription_status:
            | "trial_ended"
            | "trial_running"
            | "active"
            | "inactive"
            | null;
        title: string
        | null;
        user_id: string | null;
        vertical: string | null;
    }[],
>