Class SqlBuilder

Builds SQL query. SqlBuilder is based on great library NotORM http://www.notorm.com written by Jakub Vrana.

Nette\Object

Nette\Database\Table\SqlBuilder

Namespace: Nette\Database\Table
Author: Jakub Vrana
Author: Jan Skrasek
Located at vendor/nette/nette/Nette/Database/Table/SqlBuilder.php

Methods summary
`public`	# `__construct( mixed $tableName, Nette\Database\Connection $connection, Nette\Database\IReflection $reflection )`
`public`	# `buildInsertQuery( )`
`public`	# `buildUpdateQuery( )`
`public`	# `buildDeleteQuery( )`
`public string`	# `buildSelectQuery( string $columns = NULL )` Returns SQL query. Returns SQL query. Parameters `$columns` `string` list of columns Returns `string`
`public`	# `getParameters( )`
`public`	# `importConditions( Nette\Database\Table\SqlBuilder $builder )`
`public`	# `addSelect( mixed $columns )`
`public`	# `getSelect( )`
`public`	# `addWhere( mixed $condition, mixed $parameters = array() )`
`public`	# `getConditions( )`
`public`	# `addOrder( mixed $columns )`
`public`	# `getOrder( )`
`public`	# `setLimit( mixed $limit, mixed $offset )`
`public`	# `getLimit( )`
`public`	# `getOffset( )`
`public`	# `setGroup( mixed $columns )`
`public`	# `getGroup( )`
`public`	# `setHaving( mixed $having )`
`public`	# `getHaving( )`
`protected`	# `buildSelect( array $columns )`
`protected`	# `parseJoins( mixed & $joins, mixed & $query )`
`public`	# `parseJoinsCb( mixed & $joins, mixed $match )`
`protected`	# `buildQueryJoins( array $joins )`
`protected`	# `buildConditions( )`
`protected`	# `buildQueryEnd( )`
`protected`	# `tryDelimite( mixed $s )`
`protected`	# `addWhereComposition( array $columns, array $parameters )`

Methods inherited from Nette\Object
`__call(), __callStatic(), __get(), __isset(), __set(), __unset(), extensionMethod(), getReflection()`

Properties summary
`protected string`	`$tableName`		#
`protected Nette\Database\IReflection`	`$databaseReflection`		#
`protected string`	`$delimitedTable`		# delimited table name delimited table name
`protected array`	`$select`	`array()`	# of column to select of column to select
`protected array`	`$where`	`array()`	# of where conditions of where conditions
`protected array`	`$conditions`	`array()`	# of where conditions for caching of where conditions for caching
`protected array`	`$parameters`	`array( 'select' => array(), 'where' => array(), 'group' => array(), 'having' => array(), 'order' => array(), )`	# of parameters passed to where conditions of parameters passed to where conditions
`protected array`	`$order`	`array()`	# or columns to order by or columns to order by
`protected integer`	`$limit`	`NULL`	# number of rows to fetch number of rows to fetch
`protected integer`	`$offset`	`NULL`	# first row to fetch first row to fetch
`protected string`	`$group`	`''`	# columns to grouping columns to grouping
`protected string`	`$having`	`''`	# grouping condition grouping condition

Magic properties inherited from Nette\Object
`$reflection`