PHP Class Nette\Database\Helpers

Author: David Grudl
Afficher le fichier Open project: nette/database Class Usage Examples

Méthodes publiques

Свойство Type Description
$maxLength maximum SQL length
$typePatterns array

Méthodes publiques

Méthode Description
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.

Method Details

createDebugPanel() public static méthode

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

detectType() public static méthode

Heuristic column type detection.
public static detectType ( $type ) : string
Résultat string

detectTypes() public static méthode

Common column type detection.
public static detectTypes ( PDOStatement $statement ) : array
$statement PDOStatement
Résultat array

dumpResult() public static méthode

Displays complete result set as HTML table for debug purposes.
public static dumpResult ( ResultSet $result ) : void
$result ResultSet
Résultat void

dumpSql() public static méthode

Returns syntax highlighted SQL command.
public static dumpSql ( $sql, array $params = NULL, Connection $connection = NULL ) : string
$params array
$connection Connection
Résultat string

findDuplicates() public static méthode

Finds duplicate columns in select statement
public static findDuplicates ( PDOStatement $statement ) : string
$statement PDOStatement
Résultat string

loadFromFile() public static méthode

Import SQL dump from file - extremely fast.
public static loadFromFile ( Connection $connection, $file ) : integer
$connection Connection
Résultat integer count of commands

toPairs() public static méthode

Reformat source to key -> value pairs.
public static toPairs ( array $rows, $key = NULL, $value = NULL ) : array
$rows array
Résultat array

Property Details

$maxLength public_oe static_oe property

maximum SQL length
public static $maxLength

$typePatterns public_oe static_oe property

public static array $typePatterns
Résultat array