1. class
  2. Nette
  3. \
  4. Database
  5. \
  6. Explorer

Explorer

class Explorer

Provides high-level database layer with ActiveRow pattern.

Methods

__construct(Connection $connection, IStructure $structure, Conventions|null $conventions = null, Storage|null $cacheStorage = null)

No description

void
beginTransaction()

No description

void
commit()

No description

void
rollBack()

No description

mixed
transaction(callable $callback)

No description

string
getInsertId(string|null $sequence = null)

No description

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

Generates and executes SQL query.

ResultSet
queryArgs(string $sql, array $params) deprecated

No description

Selection
table(string $table)

Returns table selection.

Connection
getConnection()

No description

IStructure
getStructure()

No description

Conventions
getConventions()

No description

ActiveRow
createActiveRow(array $data, Selection $selection)

No description

GroupedSelection
createGroupedSelection(Selection $refSelection, string $table, string $column)

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)

Creates SQL literal value.

Details

at line 26
__construct(Connection $connection, IStructure $structure, Conventions|null $conventions = null, Storage|null $cacheStorage = null)

No description

Parameters

Connection $connection
IStructure $structure
Conventions|null $conventions
Storage|null $cacheStorage

at line 36
void beginTransaction()

No description

Return Value

void

at line 42
void commit()

No description

Return Value

void

at line 48
void rollBack()

No description

Return Value

void

at line 54
mixed transaction(callable $callback)

No description

Parameters

callable $callback

Return Value

mixed

at line 60
string getInsertId(string|null $sequence = null)

No description

Parameters

string|null $sequence

Return Value

string

at line 70
ResultSet query(string $sql, ...$params)

Generates and executes SQL query.

Parameters

string $sql
...$params

Return Value

ResultSet

at line 77
ResultSet queryArgs(string $sql, array $params) deprecated

deprecated use query()

No description

Parameters

string $sql
array $params

Return Value

ResultSet

at line 87
Selection table(string $table)

Returns table selection.

Parameters

string $table

Return Value

Selection

at line 93
Connection getConnection()

No description

Return Value

Connection

at line 99
IStructure getStructure()

No description

Return Value

IStructure

at line 105
Conventions getConventions()

No description

Return Value

Conventions

at line 111
ActiveRow createActiveRow(array $data, Selection $selection)

No description

Parameters

array $data
Selection $selection

Return Value

ActiveRow

at line 118
GroupedSelection createGroupedSelection(Selection $refSelection, string $table, string $column)

internal  
 

No description

Parameters

Selection $refSelection
string $table
string $column

Return Value

GroupedSelection

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

Shortcut for query()->fetch()

Parameters

string $sql
...$params

Return Value

Row|null

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

Shortcut for query()->fetchAssoc()

Parameters

string $sql
...$params

Return Value

array|null

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

Shortcut for query()->fetchField()

Parameters

string $sql
...$params

Return Value

mixed

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

Shortcut for query()->fetchList()

Parameters

string $sql
...$params

Return Value

array|null

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

Shortcut for query()->fetchList()

Parameters

string $sql
...$params

Return Value

array|null

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

Shortcut for query()->fetchPairs()

Parameters

string $sql
...$params

Return Value

array

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

Shortcut for query()->fetchAll()

Parameters

string $sql
...$params

Return Value

array

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

Creates SQL literal value.

Parameters

string $value
...$params

Return Value

SqlLiteral