Properties

$name

$name : 

Type

$sql

$sql : 

Type

$definition

$definition : 

Type

$tested

$tested : array

Type

array — : List of params to tested

$attributes

$attributes : 

Type

$error_sql

$error_sql : array

Type

array — : list of errors

Methods

getRequestSql()

getRequestSql() : array|boolean

Get list of request SQL

Returns

array|boolean

getRequestSqlById()

getRequestSqlById(  $id) : array

Get list of request SQL by id request

Parameters

$id

Returns

array

parsingSql()

parsingSql(  $sql) : boolean

Call the parserSQL() method in Tools class Cut the request in table for check it

Parameters

$sql

Returns

boolean

validateParser()

validateParser(  $tab, boolean  $in = false,   $sql) : boolean

Check if the parsing of the SQL request is good or not

Parameters

$tab
boolean $in
$sql

Returns

boolean

validateSql()

validateSql(  $tab,   $in,   $sql) : boolean

Cut the request for check each cutting

Parameters

$tab
$in
$sql

Returns

boolean

getTables()

getTables() : array

Get list of all tables

Returns

array

getAttributesByTable()

getAttributesByTable(  $table) : array

Get list of all attributes by an table

Parameters

$table

Returns

array

cutJoin()

cutJoin(  $attrs,   $from) : array|boolean

Cut an join sentence

Parameters

$attrs
$from

Returns

array|boolean

cutAttribute()

cutAttribute(  $attr,   $from) : array|boolean

Cut an attribute with or without the alias

Parameters

$attr
$from

Returns

array|boolean

returnNameTable()

returnNameTable(boolean  $alias = false,   $tables,   $attr = null) : array|boolean

Get name of table by alias

Parameters

boolean $alias
$tables
$attr

Returns

array|boolean

attributExistInTable()

attributExistInTable(  $attr,   $table) : boolean

Check if an attributes existe in an table

Parameters

$attr
$table

Returns

boolean

testedRequired()

testedRequired(  $tab) : boolean

Check if all required sentence existing

Parameters

$tab

Returns

boolean

testedUnauthorized()

testedUnauthorized(  $tab) : boolean

Check if an unauthorized existing in an array

Parameters

$tab

Returns

boolean

checkedFrom()

checkedFrom(  $from) : boolean

Check a "FROM" sentence

Parameters

$from

Returns

boolean

checkedSelect()

checkedSelect(  $select,   $from, boolean  $in = false) : boolean

Check a "SELECT" sentence

Parameters

$select
$from
boolean $in

Returns

boolean

checkedWhere()

checkedWhere(  $where,   $from,   $sql) : boolean

Check a "WHERE" sentence

Parameters

$where
$from
$sql

Returns

boolean

checkedHaving()

checkedHaving(  $having,   $from) : boolean

Check a "HAVING" sentence

Parameters

$having
$from

Returns

boolean

checkedOrder()

checkedOrder(  $order,   $from) : boolean

Check a "ORDER" sentence

Parameters

$order
$from

Returns

boolean

checkedGroupBy()

checkedGroupBy(  $group,   $from) : boolean

Check a "GROUP BY" sentence

Parameters

$group
$from

Returns

boolean

checkedLimit()

checkedLimit(  $limit) : boolean

Check a "LIMIT" sentence

Parameters

$limit

Returns

boolean