class Helpers

Database helpers.

Properties

static int $maxLength
static array $typePatterns

Methods

static void
dumpResult(ResultSet $result)

Displays complete result set as HTML table for debug purposes.

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

Returns syntax highlighted SQL command.

static array
detectTypes(PDOStatement $statement)

Common column type detection.

static string
detectType($type)

Heuristic column type detection.

static int
loadFromFile(Connection $connection, $file)

Import SQL dump from file - extremely fast.

static 
createDebugPanel($connection, $explain = true, $name = null)

No description

static array
toPairs(array $rows, $key = null, $value = null)

Reformat source to key -> value pairs.

static string
findDuplicates(PDOStatement $statement)

Finds duplicate columns in select statement

Details

at line 41
static void dumpResult(ResultSet $result)

Displays complete result set as HTML table for debug purposes.

Parameters

ResultSet $result

Return Value

void

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

Returns syntax highlighted SQL command.

Parameters

$sql
array $params
Connection $connection

Return Value

string

at line 154
static array detectTypes(PDOStatement $statement)

Common column type detection.

Parameters

PDOStatement $statement

Return Value

array

at line 174
static string detectType($type)

internal  
 

Heuristic column type detection.

Parameters

$type

Return Value

string

at line 193
static int loadFromFile(Connection $connection, $file)

Import SQL dump from file - extremely fast.

Parameters

Connection $connection
$file

Return Value

int

count of commands

at line 230
static createDebugPanel($connection, $explain = true, $name = null)

No description

Parameters

$connection
$explain
$name

at line 244
static array toPairs(array $rows, $key = null, $value = null)

Reformat source to key -> value pairs.

Parameters

array $rows
$key
$value

Return Value

array

at line 282
static string findDuplicates(PDOStatement $statement)

Finds duplicate columns in select statement

Parameters

PDOStatement $statement

Return Value

string

Traits

StaticClass