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( $column) : mixed
Parameters
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([ $prepared = FALSE ]) : mixed
Parameters
getInterbaseInstruction()
Returns the SELECT statement as an string for standard open source drivers
public
getInterbaseInstruction( $prepared) : mixed
Parameters
getOracleInstruction()
Returns the SELECT statement as an string for oci8 drivers
public
getOracleInstruction( $prepared) : mixed
Parameters
getSqlServerInstruction()
Returns the SELECT statement as an string for mssql/dblib drivers
public
getSqlServerInstruction( $prepared) : mixed
Parameters
getStandardInstruction()
Returns the SELECT statement as an string for standard open source drivers
public
getStandardInstruction( $prepared) : mixed
Parameters
setCriteria()
Define a select criteria
public
setCriteria( $criteria) : mixed
Parameters
setEntity()
defines the database entity name
public
final setEntity( $entity) : mixed
Parameters
getRandomParameter()
Returns a random parameter
protected
getRandomParameter() : mixed