Namespaces

  • Nette
    • Application
      • Diagnostics
      • Responses
      • Routers
      • UI
    • Caching
      • Storages
    • ComponentModel
    • Config
      • Adapters
      • Extensions
    • Database
      • Diagnostics
      • Drivers
      • Reflection
      • Table
    • DI
      • Diagnostics
    • Diagnostics
    • Forms
      • Controls
      • Rendering
    • Http
    • Iterators
    • Latte
      • Macros
    • Loaders
    • Localization
    • Mail
    • Reflection
    • Security
      • Diagnostics
    • Templating
    • Utils
      • PhpGenerator
  • NetteModule
  • none

Classes

  • ActiveRow
  • GroupedSelection
  • Selection
  • SqlBuilder
  • Overview
  • Namespace
  • Class
  • Tree
  • Deprecated
  • Other releases
  • Nette homepage

Class SqlBuilder

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

Nette\Object
Extended by Nette\Database\Table\SqlBuilder
Namespace: Nette\Database\Table
Author: Jakub Vrana
Author: Jan Skrasek
Located at Database/Table/SqlBuilder.php
Methods summary
public
# __construct( $tableName, Nette\Database\Connection $connection, Nette\Database\IReflection $reflection )
public
# buildInsertQuery( )
public
# buildUpdateQuery( )
public
# buildDeleteQuery( )
public
# importConditions( Nette\Database\Table\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 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()
#

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
Nette 2.0 API documentation generated by ApiGen 2.8.0