Flow PHP

BulkData

Read onlyYes

FinalYes

Methods

__construct() : mixed
columns() : Columns
count() : int
parametersStyle() : SQLParametersStyle
rows() : array<int, array<string, mixed>>: Example:.
sqlRows() : array<int, array<string, mixed>>: Example:.
toSqlCastedPlaceholders() : string
toSqlNamedCastedPlaceholders() : string
toSqlNamedParameters() : array<string, mixed>: Example:.
toSqlNamedPlaceholders() : string
toSqlParameters() : array<int<0, max>|string, mixed>
toSqlPlaceholders() : string
toSqlPositionalCastedPlaceholders() : string
toSqlPositionalParameters() : array<int<0, max>, mixed>: Example:.
toSqlPositionalPlaceholders() : string
types() : array<string|int, Type>

__construct()


    public
                    __construct(array<int, array<string, mixed>> $rows[, array<string|int, Type> $types = [] ][, SQLParametersStyle $parametersStyle = SQLParametersStyle::POSITIONAL ]) : mixed

Parameters

$rows : array<int, array<string, mixed>>
$types : array<string|int, Type> = []
$parametersStyle : SQLParametersStyle = SQLParametersStyle::POSITIONAL

columns()


    public
                    columns() : Columns

Return values

Columns

count()


    public
                    count() : int

Return values

int

parametersStyle()


    public
                    parametersStyle() : SQLParametersStyle

Return values

SQLParametersStyle

rows()

Example:.


    public
                    rows() : array<int, array<string, mixed>>

[ ['id' => 1, 'name' => 'some name'], ['id' => 2, 'name' => 'other name'], ]

Return values

array<int, array<string, mixed>>

sqlRows()

Example:.


    public
                    sqlRows() : array<int, array<string, mixed>>

[ ['id_0' => 1, 'name_0' => 'some name'], ['id_1' => 2, 'name_1' => 'other name'], ]

Return values

array<int, array<string, mixed>>

toSqlCastedPlaceholders()


    public
                    toSqlCastedPlaceholders(TableDefinition $table) : string

Parameters

$table : TableDefinition

Return values

string

toSqlNamedCastedPlaceholders()


    public
                    toSqlNamedCastedPlaceholders(TableDefinition $table) : string

Parameters

$table : TableDefinition

Return values

string

toSqlNamedParameters()

Example:.


    public
                    toSqlNamedParameters(TableDefinition $table) : array<string, mixed>

[ 'id_0' => 1, 'name_0' => 'some name', 'id_1' => 2, 'name_1' => 'other name', ]

Parameters

$table : TableDefinition

Return values

array<string, mixed>

toSqlNamedPlaceholders()


    public
                    toSqlNamedPlaceholders() : string

Return values

string —

It returns a string for SQL bulk insert query, eg: (:id_0, :name_0, :title_0), (:id_1, :name_1, :title_1), (:id_2, :name_2, :title_2)

toSqlParameters()


    public
                    toSqlParameters(TableDefinition $table) : array<int<0, max>|string, mixed>

Parameters

$table : TableDefinition

Return values

array<int<0, max>|string, mixed>

toSqlPlaceholders()


    public
                    toSqlPlaceholders() : string

Return values

string

toSqlPositionalCastedPlaceholders()


    public
                    toSqlPositionalCastedPlaceholders(TableDefinition $table) : string

Parameters

$table : TableDefinition

Return values

string

toSqlPositionalParameters()

Example:.


    public
                    toSqlPositionalParameters(TableDefinition $table) : array<int<0, max>, mixed>

[1, 'some name', 2, 'other name']

Parameters

$table : TableDefinition

Return values

array<int<0, max>, mixed>

toSqlPositionalPlaceholders()


    public
                    toSqlPositionalPlaceholders() : string

Return values

string —

It returns a string for SQL bulk insert query with positional parameters, eg: (?,?,?), (?,?,?), (?,?,?)

types()


    public
                    types() : array<string|int, Type>

Return values

array<string|int, Type>