PHP Класс Nette\Database\Helpers

Автор: David Grudl

Открытые свойства

Свойство	Тип	Описание
$maxLength		maximum SQL length
$typePatterns	array

Метод	Описание
createDebugPanel ( $connection, $explain = TRUE, $name = NULL )
detectType ( $type ) : string	Heuristic column type detection.
detectTypes ( PDOStatement $statement ) : array	Common column type detection.
dumpResult ( ResultSet $result ) : void	Displays complete result set as HTML table for debug purposes.
dumpSql ( $sql, array $params = NULL, Connection $connection = NULL ) : string	Returns syntax highlighted SQL command.
findDuplicates ( PDOStatement $statement ) : string	Finds duplicate columns in select statement
loadFromFile ( Connection $connection, $file ) : integer	Import SQL dump from file - extremely fast.
toPairs ( array $rows, $key = NULL, $value = NULL ) : array	Reformat source to key -> value pairs.

public static createDebugPanel ( $connection, $explain = TRUE, $name = NULL )

Heuristic column type detection.

public static detectType ( $type ) : string
Результат	string

Common column type detection.

public static detectTypes ( PDOStatement $statement ) : array
$statement	PDOStatement
Результат	array

Displays complete result set as HTML table for debug purposes.

public static dumpResult ( ResultSet $result ) : void
$result	ResultSet
Результат	void

Returns syntax highlighted SQL command.

public static dumpSql ( $sql, array $params = NULL, Connection $connection = NULL ) : string
$params	array
$connection	Connection
Результат	string

Finds duplicate columns in select statement

public static findDuplicates ( PDOStatement $statement ) : string
$statement	PDOStatement
Результат	string

Import SQL dump from file - extremely fast.

public static loadFromFile ( Connection $connection, $file ) : integer
$connection	Connection
Результат	integer	count of commands

Reformat source to key -> value pairs.

public static toPairs ( array $rows, $key = NULL, $value = NULL ) : array
$rows	array
Результат	array

maximum SQL length

public static $maxLength

public static array $typePatterns
Результат	array