Packages

  • Nette
    • Application
      • Diagnostics
      • Responses
      • Routers
      • UI
    • Caching
      • Storages
    • ComponentModel
    • Config
      • Adapters
      • Extensions
    • Database
      • Diagnostics
      • Drivers
      • Reflection
      • Table
    • DI
      • Diagnostics
    • Diagnostics
    • Forms
      • Controls
      • Rendering
    • Http
    • Iterators
    • Latte
      • Macros
    • Loaders
    • Localization
    • Mail
    • Reflection
    • Security
      • Diagnostics
    • Templating
    • Utils
      • PhpGenerator
  • NetteModule
  • None
  • PHP

Classes

  • Connection
  • DatabaseHelpers
  • Row
  • SqlLiteral
  • SqlPreprocessor
  • Statement

Interfaces

  • IReflection
  • ISupplementalDriver
  • Overview
  • Package
  • Class
  • Tree

Class DatabaseHelpers

Database helpers.

Package: Nette\Database
Author: David Grudl
Located at Database/Helpers.php
Methods summary
public static
# dumpResult( 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( Connection $connection, $file )

Import SQL dump from file - extreme fast.

Import SQL dump from file - extreme fast.

Parameters

$connection
string
filename
$file

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' => IReflection::FIELD_TEXT, 'YEAR|BYTE|COUNTER|SERIAL|INT|LONG' => 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|BIT' => IReflection::FIELD_BOOL, )
#
Nette Framework 2.0.0 (for PHP 5.2, un-prefixed) API API documentation generated by ApiGen 2.7.0