TSqlInsert
extends TSqlStatement
in package
Provides an Interface to create an INSERT statement
Tags
Table of Contents
Properties
- $criteria : mixed
- $entity : mixed
- $sql : mixed
- $columnValues : mixed
- $preparedVars : mixed
Methods
- __construct() : mixed
- Constructor method
- getEntity() : mixed
- Returns the database entity name
- getInstruction() : mixed
- Returns the INSERT plain statement
- getPreparedVars() : mixed
- Return the prepared vars
- setCriteria() : mixed
- this method doesn't exist in this class context
- setEntity() : mixed
- defines the database entity name
- setRowData() : mixed
- Assign values to the database columns
- unsetRowData() : mixed
- Unset row data
- getRandomParameter() : mixed
- Returns a random parameter
- transform() : Transformed
- Transform the value according to its PHP type before send it to the database
Properties
$criteria
protected
mixed
$criteria
$entity
protected
mixed
$entity
$sql
protected
mixed
$sql
$columnValues
private
mixed
$columnValues
$preparedVars
private
mixed
$preparedVars
Methods
__construct()
Constructor method
public
__construct() : mixed
getEntity()
Returns the database entity name
public
final getEntity() : mixed
getInstruction()
Returns the INSERT plain statement
public
getInstruction([mixed $prepared = FALSE ]) : mixed
Parameters
- $prepared : mixed = FALSE
-
Return a prepared Statement
getPreparedVars()
Return the prepared vars
public
getPreparedVars() : mixed
setCriteria()
this method doesn't exist in this class context
public
setCriteria(mixed $criteria) : mixed
Parameters
- $criteria : mixed
-
A TCriteria object, specifiyng the filters
Tags
setEntity()
defines the database entity name
public
final setEntity(mixed $entity) : mixed
Parameters
- $entity : mixed
-
Name of the database entity
setRowData()
Assign values to the database columns
public
setRowData(mixed $column, mixed $value) : mixed
Parameters
- $column : mixed
-
Name of the database column
- $value : mixed
-
Value for the database column
unsetRowData()
Unset row data
public
unsetRowData(mixed $column) : mixed
Parameters
- $column : mixed
-
Name of the database column
getRandomParameter()
Returns a random parameter
protected
getRandomParameter() : mixed
transform()
Transform the value according to its PHP type before send it to the database
private
transform(mixed $value[, mixed $prepared = FALSE ]) : Transformed
Parameters
- $value : mixed
-
Value to be transformed
- $prepared : mixed = FALSE
-
If the value will be prepared
Return values
Transformed —Value