TSqlUpdate
extends TSqlStatement
in package
Provides an Interface to create UPDATE statements
Tags
Table of Contents
Properties
- $criteria : mixed
- $entity : mixed
- $sql : mixed
- $columnValues : mixed
- $preparedVars : mixed
Methods
- getEntity() : mixed
- Returns the database entity name
- getInstruction() : mixed
- Returns the UPDATE plain statement
- getPreparedVars() : mixed
- Return the prepared vars
- setCriteria() : mixed
- Define a select criteria
- 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
- replacePseudoPreparedVars() : mixed
- Replace pseudo prepared vars
- 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
getEntity()
Returns the database entity name
public
final getEntity() : mixed
getInstruction()
Returns the UPDATE 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()
Define a select criteria
public
setCriteria(mixed $criteria) : mixed
Parameters
- $criteria : mixed
-
An TCriteria object, specifiyng the filters
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
replacePseudoPreparedVars()
Replace pseudo prepared vars
private
replacePseudoPreparedVars(mixed $value) : mixed
Parameters
- $value : 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