Methods summary
public
string
|
#
delimite( string $name )
Delimites identifier for use in a SQL statement.
Delimites identifier for use in a SQL statement.
Parameters
Returns
string
Implementation of
|
public
|
#
formatBool( $value )
Formats boolean for use in a SQL statement.
Formats boolean for use in a SQL statement.
|
public
string
|
#
formatDateTime( DateTime $value )
Formats date-time for use in a SQL statement.
Formats date-time for use in a SQL statement.
Returns
string
Implementation of
|
public
string
|
#
formatLike( string $value, integer $pos )
Encodes string for use in a LIKE statement.
Encodes string for use in a LIKE statement.
Parameters
- $value
string
- $pos
integer
Returns
string
Implementation of
|
public
|
#
applyLimit( string & $sql, integer $limit, integer $offset )
Injects LIMIT/OFFSET to the SQL query.
Injects LIMIT/OFFSET to the SQL query.
Parameters
- $sql
string SQL query that will be modified.
- $limit
integer
- $offset
integer
Implementation of
|
public
array
|
#
normalizeRow( array $row, Statement $statement )
Normalizes result row.
Parameters
- $row
array
- $statement
Statement
Returns
array
Implementation of
|
public
array
|
#
getTables( )
Returns list of tables.
Returns
array of [name [, (bool) view]]
Implementation of
|
public
array
|
#
getColumns( string $table )
Returns metadata for all columns in a table.
Returns metadata for all columns in a table.
Parameters
Returns
array of [name, nativetype [, table, fullname, (int) size, (bool) nullable, (mixed)
default, (bool) autoincrement, (array) vendor]]
Implementation of
|
public
array
|
#
getIndexes( string $table )
Returns metadata for all indexes in a table.
Returns metadata for all indexes in a table.
Parameters
Returns
array of [name, (array of names) columns [, (bool) unique, (bool) primary]]
Implementation of
|
public
array
|
#
getForeignKeys( string $table )
Returns metadata for all foreign keys in a table.
Returns metadata for all foreign keys in a table.
Parameters
Returns
array
Implementation of
|
public
boolean
|
|