Class Helpers

Database helpers.

Namespace: Nette\Database
Author: David Grudl
Located at Database/Helpers.php

Methods summary
`public static`	# `dumpResult( Nette\Database\Statement $statement )` Displays complete result set as HTML table for debug purposes. Displays complete result set as HTML table for debug purposes.
`public static string`	# `dumpSql( string $sql )` Returns syntax highlighted SQL command. Returns syntax highlighted SQL command. Parameters `$sql` `string` Returns `string`
`public static integer`	# `loadFromFile( Nette\Database\Connection $connection, $file )` Import SQL dump from file - extremely fast. Import SQL dump from file - extremely fast. Returns `integer` count of commands

Properties summary
`public static array`	`$typePatterns`	`array( '^_' => IReflection::FIELD_TEXT, // PostgreSQL arrays 'BYTEA\|BLOB\|BIN' => IReflection::FIELD_BINARY, 'TEXT\|CHAR\|POINT\|INTERVAL' => IReflection::FIELD_TEXT, 'YEAR\|BYTE\|COUNTER\|SERIAL\|INT\|LONG\|SHORT\|^TINY$' => IReflection::FIELD_INTEGER, 'CURRENCY\|REAL\|MONEY\|FLOAT\|DOUBLE\|DECIMAL\|NUMERIC\|NUMBER' => IReflection::FIELD_FLOAT, '^TIME$' => IReflection::FIELD_TIME, 'TIME' => IReflection::FIELD_DATETIME, // DATETIME, TIMESTAMP 'DATE' => IReflection::FIELD_DATE, 'BOOL' => IReflection::FIELD_BOOL, )`	#