SqlBatch
Class SqlBatch
Table of Contents
Methods
- divide() : array<string|int, mixed>
- Return true if batch fulled.
- getInString() : string
- Get string for sql-IN.
- insert() : void
- Insert.
- update() : void
- Update.
Methods
divide()
Return true if batch fulled.
public
static divide(array<string|int, mixed> $list[, int $limit = 300 ]) : array<string|int, mixed>
Parameters
- $list : array<string|int, mixed>
-
List.
- $limit : int = 300
-
Batch limit.
Return values
array<string|int, mixed>getInString()
Get string for sql-IN.
public
static getInString(array<string|int, mixed> $values) : string
Parameters
- $values : array<string|int, mixed>
-
Values.
Return values
stringinsert()
Insert.
public
static insert(string $tableName, array<string|int, mixed> $fields[, array<string|int, mixed> $onDuplicateUpdateFields = [] ][, array<string|int, mixed> $primaryFields = [] ]) : void
Parameters
- $tableName : string
-
Table name.
- $fields : array<string|int, mixed>
-
Fields.
- $onDuplicateUpdateFields : array<string|int, mixed> = []
-
Duplicate update fields.
- $primaryFields : array<string|int, mixed> = []
-
Flat array of column with unique index
update()
Update.
public
static update(string $tableName, array<string|int, mixed> $fields) : void
Parameters
- $tableName : string
-
Table name.
- $fields : array<string|int, mixed>
-
Fields.