Skip to content

Insert

  • Full name: \Qubus\Expressive\Insert

Methods

returning

Returning (Postgres etc.)

public returning(string $cols = '*'): \Qubus\Expressive\Database

Parameters:

Parameter Type Description
$cols string

upsert

Upsert (basic support)

public upsert(array $conflictCols, array $updateData): \Qubus\Expressive\Database

Parameters:

Parameter Type Description
$conflictCols array
$updateData array

lastInsertId

Retrieves the ID of the last record inserted.

public lastInsertId(string|null $pk = null): string|false

Parameters:

Parameter Type Description
$pk string|null

insert

Insert new rows $data can be 2-dimensional to add a bulk insert If a single row is inserted, it will return its row instance

public insert(array $data): \Qubus\Expressive\Database|int

Parameters:

Parameter Type Description
$data array - data to populate