Insert/Update

Inserts data into a database table.

$etl->load('insert_update', 'table_name', $options);

Options

Columns

Columns that will be loaded. If null, all columns in the process will be inserted/updated.

Type	Default value
array	null

To select which columns will be loaded, use an array with the columns list:

$options = ['columns' => ['id', 'name', 'email']];

To map columns from the etl process to the database table, use an associative array where the key is the name of the process column and the value is the table column:

$options = ['columns' => [
    'id' => 'user_id',
    'name' => 'full_name',
]];

Connection

Name of the database connection to use.

Type	Default value
string	default

$options = ['connection' => 'app'];

Key

List of primary keys or identifiers of the table.

Type	Default value
array	['id']

$options = ['key' => ['id', 'type']];

Timestamps

Populates the created_at and/or updated_at columns with the current timestamp when inserting or updating a row.

Type	Default value
boolean	false

$options = ['timestamps' => true];

Transaction

Indicates if the loader will perform database transactions.

Type	Default value
boolean	true

$options = ['transaction' => false];

Commit Size

Transaction commit size. The transaction option must be enabled.

Type	Default value
int	100

$options = ['commit_size' => 500];