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

Explorer

class Explorer

Database explorer.

Methods

__construct(Connection $connection, Structure $structure, Conventions $conventions = null, IStorage $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 $sequence = null)

No description

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

Generates and executes SQL query.

ResultSet
queryArgs(string $sql, array $params)

No description

Selection
table(string $table)

No description

Connection
getConnection()

No description

IStructure
getStructure()

No description

Conventions
getConventions()

No description

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

Shortcut for query()->fetch()

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

Shortcut for query()->fetchField()

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

Shortcut for query()->fetchFields()

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

Details

at line 36
__construct(Connection $connection, Structure $structure, Conventions $conventions = null, IStorage $cacheStorage = null)

Parameters

Connection $connection
Structure $structure
Conventions $conventions
IStorage $cacheStorage

at line 49
void beginTransaction()

Return Value

void

at line 55
void commit()

Return Value

void

at line 61
void rollBack()

Return Value

void

at line 70
mixed transaction(callable $callback)

Parameters

callable $callback

Return Value

mixed

at line 76
string getInsertId(string $sequence = null)

Parameters

string $sequence

Return Value

string

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

Generates and executes SQL query.

Parameters

string $sql
...$params

Return Value

ResultSet

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

Parameters

string $sql
array $params

Return Value

ResultSet

at line 97
Selection table(string $table)

Parameters

string $table

Return Value

Selection

at line 103
Connection getConnection()

Return Value

Connection

at line 109
IStructure getStructure()

Return Value

IStructure

at line 115
Conventions getConventions()

Return Value

Conventions

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

Shortcut for query()->fetch()

Parameters

string $sql
...$params

Return Value

Row|null

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

Shortcut for query()->fetchField()

Parameters

string $sql
...$params

Return Value

mixed

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

Shortcut for query()->fetchFields()

Parameters

string $sql
...$params

Return Value

array|null

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

Shortcut for query()->fetchPairs()

Parameters

string $sql
...$params

Return Value

array

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

Shortcut for query()->fetchAll()

Parameters

string $sql
...$params

Return Value

array

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

Parameters

string $value
...$params

Return Value

SqlLiteral

Traits

SmartObject
Strict class for better experience.