Class SqlBuilder

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

Object

SqlBuilder

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

Methods summary
`public`	# `__construct( $tableName, Connection $connection, IReflection $reflection )`
`public`	# `buildInsertQuery( )`
`public`	# `buildUpdateQuery( )`
`public`	# `buildDeleteQuery( )`
`public`	# `importConditions( SqlBuilder $builder )`
`public`	# `addSelect( $columns )`
`public`	# `getSelect( )`
`public`	# `addWhere( $condition, $parameters = array() )`
`public`	# `getConditions( )`
`public`	# `addOrder( $columns )`
`public`	# `getOrder( )`
`public`	# `setLimit( $limit, $offset )`
`public`	# `getLimit( )`
`public`	# `getOffset( )`
`public`	# `setGroup( $columns, $having )`
`public`	# `getGroup( )`
`public`	# `getHaving( )`
`public string`	# `buildSelectQuery( list $columns = NULL )` Returns SQL query. Returns SQL query. Parameters `$columns` `list` of columns Returns `string`
`public`	# `getParameters( )`
`protected`	# `buildJoins( $val, $inner = FALSE )`
`protected`	# `buildConditions( )`
`protected`	# `buildTopClause( )`
`protected`	# `tryDelimite( $s )`
`protected`	# `removeExtraTables( $expression )`

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

Properties summary
`protected string`	`$tableName`		#
`protected 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()`	# 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 Object
`$reflection`