PHP Class Nette\Database\Context

Author: David Grudl
Inheritance: extends Nette\Object
Show file Open project: nette/database Class Usage Examples

Public Methods

Method Description
__construct ( Connection $connection, Nette\Database\IStructure $structure, Nette\Database\IConventions $conventions = NULL, Nette\Caching\IStorage $cacheStorage = NULL )
beginTransaction ( ) : void
commit ( ) : void
fetch ( $sql, $params ) : Nette\Database\Row Shortcut for query()->fetch()
fetchAll ( $sql, $params ) : array Shortcut for query()->fetchAll()
fetchField ( $sql, $params ) : mixed Shortcut for query()->fetchField()
fetchPairs ( $sql, $params ) : array Shortcut for query()->fetchPairs()
getConnection ( ) : Connection
getConventions ( ) : Nette\Database\IConventions
getInsertId ( $name = NULL ) : string
getStructure ( ) : Nette\Database\IStructure
literal ( $value, $params ) : SqlLiteral
query ( $sql, $params ) : ResultSet Generates and executes SQL query.
queryArgs ( $sql, array $params ) : ResultSet
rollBack ( ) : void
table ( $table ) : Selection

Method Details

__construct() public method

public __construct ( Connection $connection, Nette\Database\IStructure $structure, Nette\Database\IConventions $conventions = NULL, Nette\Caching\IStorage $cacheStorage = NULL )
$connection Connection
$structure Nette\Database\IStructure
$conventions Nette\Database\IConventions
$cacheStorage Nette\Caching\IStorage

beginTransaction() public method

public beginTransaction ( ) : void
return void

commit() public method

public commit ( ) : void
return void

fetch() public method

Shortcut for query()->fetch()
public fetch ( $sql, $params ) : Nette\Database\Row
return Nette\Database\Row

fetchAll() public method

Shortcut for query()->fetchAll()
public fetchAll ( $sql, $params ) : array
return array

fetchField() public method

Shortcut for query()->fetchField()
public fetchField ( $sql, $params ) : mixed
return mixed

fetchPairs() public method

Shortcut for query()->fetchPairs()
public fetchPairs ( $sql, $params ) : array
return array

getConnection() public method

public getConnection ( ) : Connection
return Connection

getConventions() public method

public getConventions ( ) : Nette\Database\IConventions
return Nette\Database\IConventions

getInsertId() public method

public getInsertId ( $name = NULL ) : string
return string

getStructure() public method

public getStructure ( ) : Nette\Database\IStructure
return Nette\Database\IStructure

literal() public static method

public static literal ( $value, $params ) : SqlLiteral
return SqlLiteral

query() public method

Generates and executes SQL query.
public query ( $sql, $params ) : ResultSet
return ResultSet

queryArgs() public method

public queryArgs ( $sql, array $params ) : ResultSet
$params array
return ResultSet

rollBack() public method

public rollBack ( ) : void
return void

table() public method

public table ( $table ) : Selection
return Nette\Database\Table\Selection