prorm API Reference
    Preparing search index...

    Interface BulkCreateOptions

    Options for inserting many rows in one statement, including upsert behaviour and whether each row is validated.

    interface BulkCreateOptions {
        include?: IncludeOptions[] | Includeable[];
        raw?: boolean;
        isNewRecord?: boolean;
        using?: string;
        transaction?: Transaction;
        sideEffects?: boolean;
        logging?: boolean | ((sql: string, time?: number) => void);
        benchmark?: boolean;
        ignoreDuplicates?: boolean;
        validate?: boolean;
        fields?: string[];
        hooks?: boolean;
        individualHooks?: boolean;
        returning?: boolean | string[];
        upsert?: boolean;
        conflictFields?: string[];
        updateOnDuplicate?: string[];
    }

    Hierarchy (View Summary)

    Index
    include?: IncludeOptions[] | Includeable[]
    raw?: boolean
    isNewRecord?: boolean
    using?: string

    Connection name to use for this query Allows querying a different database connection

    transaction?: Transaction
    sideEffects?: boolean
    logging?: boolean | ((sql: string, time?: number) => void)
    benchmark?: boolean
    ignoreDuplicates?: boolean
    validate?: boolean
    fields?: string[]
    hooks?: boolean
    individualHooks?: boolean
    returning?: boolean | string[]
    upsert?: boolean

    Perform upsert instead of insert (insert or update on conflict)

    conflictFields?: string[]

    Fields to use for conflict resolution in upsert

    updateOnDuplicate?: string[]

    Fields to update on conflict in upsert