User: Alf Magne Kalleland Date: 22.12.12

package LudoDB
author Alf Magne Kalleland

 Methods

Constructs new SQL handler for given LudoDBModel or LudoDBCollection.

__construct(\LudoDBObject $obj) 

Parameters

Clear limit of returned rows

clearLimit() 

Convert SQL string for prepared statement to standard SQL statement with values escaped(safe values).

fromPrepared($sql, array $params) : string
Static

Parameters

$sql

$params

array

Returns

string

Return "create" table SQL.

getCreateTableSql() : string

Returns

string

Return "insert" SQL.

getInsertSQL() : mixed

Returns

mixed

Return "select" sql for it's LudoDBObject

getSql() : string

Returns

string

Return "update" SQL.

getUpdateSql() : string

Returns

string

Limit number of rows returned

setLimit($start, null $count) 

Parameters

$start

$count

null

Return columns for "select" sql

getColumns() : string

Returns

string

Return column names for a colletion

getColumnsForCollectionSQL() : string

Returns

string

Return column names for joined tables.

getColumnsToSelectFromJoins() : string

Returns

string

Return compiled sql from config of LudoDBObject.

getCompiledSql() : string

This will only be called when config of LudoDBModel or LudoDBCollection does not contain any "sql" key/value.

Returns

string

Get "join" for "select" SQL.

getJoins() : string

Returns

string

Get columns for table name in LudoDBModel/LudoDBCollection (my columns)

getMyColumns() : string

Returns

string

Get order by for "select" SQL

getOrderBy() : string

Returns

string

Return "insert" SQL for the PDO adapter (prepared statements)

getPDOInsert($data) : mixed

Parameters

$data

Returns

mixed

Return column name prefixed by tableName.

getTableAndColumn($column) : string

Parameters

$column

Returns

string

Return name of tables involved in "select" SQL

getTables() : string

Returns

string

Return columns to update for "update" SQL.

getUpdatesForSql($updates) : string

Parameters

$updates

Returns

string

Validate arguments

validate() 

 Properties

 

$arguments : array
 

$config : array
 

$configParser : \LudoDBConfigParser
 

$limit : string
 

$obj : \LudoDBObject

 Constants

 

Internal constant representing value of delete columns.

DELETED