TSqlSelect
extends TSqlStatement
in package
Provides an Interface to create SELECT statements
Tags
Table of Contents
Properties
Methods
- addColumn() : mixed
- Add a column name to be returned
- getEntity() : mixed
- Returns the database entity name
- getInstruction() : mixed
- Returns the SELECT statement as an string according to the database driver
- getInterbaseInstruction() : mixed
- Returns the SELECT statement as an string for standard open source drivers
- getOracleInstruction() : mixed
- Returns the SELECT statement as an string for oci8 drivers
- getSqlServerInstruction() : mixed
- Returns the SELECT statement as an string for mssql/dblib drivers
- getStandardInstruction() : mixed
- Returns the SELECT statement as an string for standard open source drivers
- setCriteria() : mixed
- Define a select criteria
- setEntity() : mixed
- defines the database entity name
- getRandomParameter() : mixed
- Returns a random parameter
Properties
$criteria
protected
mixed
$criteria
$entity
protected
mixed
$entity
$sql
protected
mixed
$sql
$columns
private
mixed
$columns
Methods
addColumn()
Add a column name to be returned
public
addColumn(mixed $column) : mixed
Parameters
- $column : mixed
-
A string containing a column name
getEntity()
Returns the database entity name
public
final getEntity() : mixed
getInstruction()
Returns the SELECT statement as an string according to the database driver
public
getInstruction([mixed $prepared = FALSE ]) : mixed
Parameters
- $prepared : mixed = FALSE
-
Return a prepared Statement
getInterbaseInstruction()
Returns the SELECT statement as an string for standard open source drivers
public
getInterbaseInstruction(mixed $prepared) : mixed
Parameters
- $prepared : mixed
-
Return a prepared Statement
getOracleInstruction()
Returns the SELECT statement as an string for oci8 drivers
public
getOracleInstruction(mixed $prepared) : mixed
Parameters
- $prepared : mixed
-
Return a prepared Statement
getSqlServerInstruction()
Returns the SELECT statement as an string for mssql/dblib drivers
public
getSqlServerInstruction(mixed $prepared) : mixed
Parameters
- $prepared : mixed
-
Return a prepared Statement
getStandardInstruction()
Returns the SELECT statement as an string for standard open source drivers
public
getStandardInstruction(mixed $prepared) : mixed
Parameters
- $prepared : mixed
-
Return a prepared Statement
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
getRandomParameter()
Returns a random parameter
protected
getRandomParameter() : mixed