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

Helpers

class Helpers

Database utility functions.

Properties

static $maxLength

maximum SQL length
static $typePatterns

Methods

static void
dumpResult(ResultSet $result)

Displays result set as HTML table.

static string
dumpSql(string $sql, array|null $params = null, Connection|null $connection = null)

Returns syntax highlighted SQL command.

static array
detectTypes(PDOStatement $statement)

Returns column types from result set.

static string
detectType(string $type)

Detects column type from native type.

static array
normalizeRow(array $row, ResultSet $resultSet, $dateTimeClass = Nette\Utils\DateTime::class)

No description

static int
loadFromFile(Connection $connection, string $file, callable|null $onProgress = null)

Imports SQL dump from file.

static ConnectionPanel|null
createDebugPanel(Connection $connection, bool $explain, string $name, Bar $bar, BlueScreen $blueScreen) deprecated

No description

static ConnectionPanel|null
initializeTracy(Connection $connection, bool $addBarPanel = false, string $name = '', bool $explain = true, Bar|null $bar = null, BlueScreen|null $blueScreen = null) deprecated

No description

static array
toPairs(array $rows, string|int|Closure|null $key, string|int|null $value)

Converts rows to key-value pairs.

static string
findDuplicates(PDOStatement $statement)

Returns duplicate columns from result set.

static array
parseColumnType(string $type)

No description

Details

at line 43
 static void dumpResult(ResultSet $result)

Displays result set as HTML table.

Parameters

ResultSet $result

Return Value

void

at line 90
 static string dumpSql(string $sql, array|null $params = null, Connection|null $connection = null)

Returns syntax highlighted SQL command.

Parameters

string $sql
array|null $params
Connection|null $connection

Return Value

string

at line 169
 static array detectTypes(PDOStatement $statement)

Returns column types from result set.

Parameters

PDOStatement $statement

Return Value

array

at line 188
 static string detectType(string $type)

internal  
 

Detects column type from native type.

Parameters

string $type

Return Value

string

at line 205
 static array normalizeRow(array $row, ResultSet $resultSet, $dateTimeClass = Nette\Utils\DateTime::class)

internal  
 

No description

Parameters

array $row
ResultSet $resultSet
$dateTimeClass

Return Value

array

at line 253
 static int loadFromFile(Connection $connection, string $file, callable|null $onProgress = null)

Imports SQL dump from file.

Parameters

Connection $connection
string $file
callable|null $onProgress

Return Value

int

Number of executed commands

Exceptions

FileNotFoundException

at line 299
 static ConnectionPanel|null createDebugPanel(Connection $connection, bool $explain, string $name, Bar $bar, BlueScreen $blueScreen) deprecated

deprecated use Nette\Bridges\DatabaseTracy\ConnectionPanel::initialize()

No description

Parameters

Connection $connection
bool $explain
string $name
Bar $bar
BlueScreen $blueScreen

Return Value

ConnectionPanel|null

at line 312
 static ConnectionPanel|null initializeTracy(Connection $connection, bool $addBarPanel = false, string $name = '', bool $explain = true, Bar|null $bar = null, BlueScreen|null $blueScreen = null) deprecated

deprecated use Nette\Bridges\DatabaseTracy\ConnectionPanel::initialize()

No description

Parameters

Connection $connection
bool $addBarPanel
string $name
bool $explain
Bar|null $bar
BlueScreen|null $blueScreen

Return Value

ConnectionPanel|null

at line 328
 static array toPairs(array $rows, string|int|Closure|null $key, string|int|null $value)

Converts rows to key-value pairs.

Parameters

array $rows
string|int|Closure|null $key
string|int|null $value

Return Value

array

at line 372
 static string findDuplicates(PDOStatement $statement)

Returns duplicate columns from result set.

Parameters

PDOStatement $statement

Return Value

string

at line 393
 static array parseColumnType(string $type)

No description

Parameters

string $type

Return Value

array

Traits

StaticClass