Nette\Database\Explorer | Nette Database API

class Explorer

The central access point to Nette Database functionality.

Constants

private Drivers

private TypeConverterOptions

Properties

	$onConnect
	$onQuery

Methods

static Explorer

createFromParameters(...$params)

No description

static Explorer

createFromDsn(string $dsn, string|null $username = null, string|null $password = null, array $options = [])

No description

__construct(Driver|string $driver)

No description

void

connect()

No description

void

reconnect()

No description

void

disconnect()

No description

string

getDsn() deprecated

No description

PDO

getPdo() deprecated

No description

Connection

getConnection()

No description

Connection

getSupplementalDriver() deprecated

No description

Engine

getDatabaseEngine()

No description

string

getServerVersion()

No description

Reflection

getReflection()

No description

TypeConverter

getTypeConverter()

No description

Explorer

setRowNormalizer(callable|null $normalizer) deprecated

No description

int|string

getInsertId(string|null $sequence = null)

No description

string

quote(string $string)

No description

void

beginTransaction()

No description

void

commit()

No description

void

rollBack()

No description

mixed

transaction(callable $callback)

No description

Result

query(string $sql, ...$params)

Generates and executes SQL query.

Result

queryArgs(string $sql, array $params) deprecated

No description

array

preprocess(string $sql, ...$params)

No description

SqlLiteral|null

getLastQuery()

No description

string|null

getLastQueryString() deprecated

No description

Row|null

fetch(string $sql, ...$params)

Shortcut for query()->fetch()

array|null

fetchAssoc(string $sql, ...$params)

Shortcut for query()->fetchAssoc()

mixed

fetchField(string $sql, ...$params)

Shortcut for query()->fetchField()

array|null

fetchList(string $sql, ...$params)

Shortcut for query()->fetchList()

array|null

fetchFields(string $sql, ...$params)

Shortcut for query()->fetchList()

array

fetchPairs(string $sql, ...$params)

Shortcut for query()->fetchPairs()

array

fetchAll(string $sql, ...$params)

Shortcut for query()->fetchAll()

static SqlLiteral

literal(string $value, ...$params)

No description

Selection

table(string $table)

No description

Explorer

setCache(Cache $cache)

No description

Cache|null

getCache()

No description

Explorer

setConventions(Conventions $conventions)

No description

Conventions

getConventions()

No description

Structure

getStructure()

No description

Details

at line 51
`static Explorer createFromParameters(...$params)`

No description

Parameters

...$params

Return Value

Explorer

at line 83
`static Explorer createFromDsn(string $dsn, string|null $username = null, string|null $password = null, array $options = [])`

No description

Parameters

string	$dsn
string\|null	$username
string\|null	$password
array	$options

Return Value

Explorer

at line 103
`__construct(Driver|string $driver)`

No description

Parameters

Driver|string

$driver

at line 116
`void connect()`

No description

Return Value

void

at line 132
`void reconnect()`

No description

Return Value

void

at line 139
`void disconnect()`

No description

Return Value

void

at line 146
`string getDsn() deprecated`

deprecated

No description

Return Value

string

at line 153
`PDO getPdo() deprecated`

deprecated use getConnection()->getNativeConnection()

No description

Return Value

PDO

at line 160
`Connection getConnection()`

No description

Return Value

Connection

at line 168
`Connection getSupplementalDriver() deprecated`

deprecated use getConnection()

No description

Return Value

Connection

at line 175
`Engine getDatabaseEngine()`

No description

Return Value

Engine

at line 181
`string getServerVersion()`

No description

Return Value

string

at line 187
`Reflection getReflection()`

No description

Return Value

Reflection

at line 193
`TypeConverter getTypeConverter()`

No description

Return Value

TypeConverter

at line 200
`Explorer setRowNormalizer(callable|null $normalizer) deprecated`

deprecated

No description

Parameters

callable|null

$normalizer

Return Value

Explorer

at line 206
`int|string getInsertId(string|null $sequence = null)`

No description

Parameters

string|null

$sequence

Return Value

int|string

at line 216
`string quote(string $string)`

No description

Parameters

string

$string

Return Value

string

at line 222
`void beginTransaction()`

No description

Return Value

void

at line 232
`void commit()`

No description

Return Value

void

at line 242
`void rollBack()`

No description

Return Value

void

at line 252
`mixed transaction(callable $callback)`

No description

Parameters

callable

$callback

Return Value

mixed

at line 283
`Result query(string $sql, ...$params)`

Generates and executes SQL query.

Parameters

string	$sql
	...$params

Return Value

Result

at line 294
`Result queryArgs(string $sql, array $params) deprecated`

deprecated use query()

No description

Parameters

string	$sql
array	$params

Return Value

Result

at line 305
`array preprocess(string $sql, ...$params)`

No description

Parameters

string	$sql
	...$params

Return Value

array

at line 333
`SqlLiteral|null getLastQuery()`

No description

Return Value

SqlLiteral|null

at line 340
`string|null getLastQueryString() deprecated`

deprecated use getLastQuery()->getSql()

No description

Return Value

string|null

at line 361
`Row|null fetch(string $sql, ...$params)`

Shortcut for query()->fetch()

Parameters

string	$sql
	...$params

Return Value

Row|null

at line 371
`array|null fetchAssoc(string $sql, ...$params)`

Shortcut for query()->fetchAssoc()

Parameters

string	$sql
	...$params

Return Value

array|null

at line 381
`mixed fetchField(string $sql, ...$params)`

Shortcut for query()->fetchField()

Parameters

string	$sql
	...$params

Return Value

mixed

at line 391
`array|null fetchList(string $sql, ...$params)`

Shortcut for query()->fetchList()

Parameters

string	$sql
	...$params

Return Value

array|null

at line 401
`array|null fetchFields(string $sql, ...$params)`

Shortcut for query()->fetchList()

Parameters

string	$sql
	...$params

Return Value

array|null

at line 411
`array fetchPairs(string $sql, ...$params)`

Shortcut for query()->fetchPairs()

Parameters

string	$sql
	...$params

Return Value

array

at line 421
`array fetchAll(string $sql, ...$params)`

Shortcut for query()->fetchAll()

Parameters

string	$sql
	...$params

Return Value

array

at line 427
`static SqlLiteral literal(string $value, ...$params)`

No description

Parameters

string	$value
	...$params

Return Value

SqlLiteral

at line 436
`Selection table(string $table)`

No description

Parameters

string

$table

Return Value

Selection

at line 442
`Explorer setCache(Cache $cache)`

No description

Parameters

Cache

$cache

Return Value

Explorer

at line 453
`Cache|null getCache()`

internal

No description

Return Value

Cache|null

at line 459
`Explorer setConventions(Conventions $conventions)`

No description

Parameters

Conventions

$conventions

Return Value

Explorer

at line 470
`Conventions getConventions()`

internal

No description

Return Value

Conventions

at line 477
`Structure getStructure()`

internal

No description

Return Value

Structure

Explorer

Constants

Properties

Methods

Details

at line 51 static Explorer createFromParameters(...$params)

Parameters

Return Value

at line 83 static Explorer createFromDsn(string $dsn, string|null $username = null, string|null $password = null, array $options = [])

Parameters

Return Value

at line 103 __construct(Driver|string $driver)

Parameters

at line 116 void connect()

Return Value

at line 132 void reconnect()

Return Value

at line 139 void disconnect()

Return Value

at line 146 string getDsn() deprecated

Return Value

at line 153 PDO getPdo() deprecated

Return Value

at line 160 Connection getConnection()

Return Value

at line 168 Connection getSupplementalDriver() deprecated

Return Value

at line 175 Engine getDatabaseEngine()

Return Value

at line 181 string getServerVersion()

Return Value

at line 187 Reflection getReflection()

Return Value

at line 193 TypeConverter getTypeConverter()

Return Value

at line 200 Explorer setRowNormalizer(callable|null $normalizer) deprecated

Parameters

Return Value

at line 206 int|string getInsertId(string|null $sequence = null)

Parameters

Return Value

at line 216 string quote(string $string)

Parameters

Return Value

at line 222 void beginTransaction()

Return Value

at line 232 void commit()

Return Value

at line 242 void rollBack()

Return Value

at line 252 mixed transaction(callable $callback)

Parameters

Return Value

at line 283 Result query(string $sql, ...$params)

Parameters

Return Value

at line 294 Result queryArgs(string $sql, array $params) deprecated

Parameters

Return Value

at line 305 array preprocess(string $sql, ...$params)

Parameters

Return Value

at line 333 SqlLiteral|null getLastQuery()

Return Value

at line 340 string|null getLastQueryString() deprecated

Return Value

at line 361 Row|null fetch(string $sql, ...$params)

Parameters

Return Value

at line 371 array|null fetchAssoc(string $sql, ...$params)

Parameters

Return Value

at line 381 mixed fetchField(string $sql, ...$params)

Parameters

Return Value

at line 391 array|null fetchList(string $sql, ...$params)

Parameters

Return Value

at line 401 array|null fetchFields(string $sql, ...$params)

Parameters

at line 51
`static Explorer createFromParameters(...$params)`

at line 83
`static Explorer createFromDsn(string $dsn, string|null $username = null, string|null $password = null, array $options = [])`

at line 103
`__construct(Driver|string $driver)`

at line 116
`void connect()`

at line 132
`void reconnect()`

at line 139
`void disconnect()`

at line 146
`string getDsn() deprecated`

at line 153
`PDO getPdo() deprecated`

at line 160
`Connection getConnection()`

at line 168
`Connection getSupplementalDriver() deprecated`

at line 175
`Engine getDatabaseEngine()`

at line 181
`string getServerVersion()`

at line 187
`Reflection getReflection()`

at line 193
`TypeConverter getTypeConverter()`

at line 200
`Explorer setRowNormalizer(callable|null $normalizer) deprecated`

at line 206
`int|string getInsertId(string|null $sequence = null)`

at line 216
`string quote(string $string)`

at line 222
`void beginTransaction()`

at line 232
`void commit()`

at line 242
`void rollBack()`

at line 252
`mixed transaction(callable $callback)`

at line 283
`Result query(string $sql, ...$params)`

at line 294
`Result queryArgs(string $sql, array $params) deprecated`

at line 305
`array preprocess(string $sql, ...$params)`

at line 333
`SqlLiteral|null getLastQuery()`

at line 340
`string|null getLastQueryString() deprecated`

at line 361
`Row|null fetch(string $sql, ...$params)`

at line 371
`array|null fetchAssoc(string $sql, ...$params)`

at line 381
`mixed fetchField(string $sql, ...$params)`

at line 391
`array|null fetchList(string $sql, ...$params)`

at line 401
`array|null fetchFields(string $sql, ...$params)`

at line 411
`array fetchPairs(string $sql, ...$params)`

at line 421
`array fetchAll(string $sql, ...$params)`

at line 427
`static SqlLiteral literal(string $value, ...$params)`

at line 436
`Selection table(string $table)`

at line 442
`Explorer setCache(Cache $cache)`

at line 453
`Cache|null getCache()`

at line 459
`Explorer setConventions(Conventions $conventions)`

at line 470
`Conventions getConventions()`

at line 477
`Structure getStructure()`