Helpers
class Helpers
Database helpers.
Properties
static | $maxLength | maximum SQL length |
|
static | $typePatterns |
Methods
static void
static string
dumpSql(string $sql, array|null $params = null, Connection|null $connection = null)
Returns syntax highlighted SQL command.
static array
static string
static array
static int
loadFromFile(Connection $connection, string $file, callable|null $onProgress = null)
Import SQL dump from file - extremely fast.
static ConnectionPanel|null
createDebugPanel(Connection $connection, bool $explain, string $name, Bar $bar, BlueScreen $blueScreen)
deprecated
No description
static ConnectionPanel|null
initializeTracy(Connection $connection, bool $addBarPanel = false, string $name = '', bool $explain = true, Bar|null $bar = null, BlueScreen|null $blueScreen = null)
deprecated
No description
static array
toPairs(array $rows, string|int|null $key = null, string|int|null $value = null)
Reformat source to key -> value pairs.
static string
Details
at line 32
static void
dumpResult(ResultSet $result)
Displays complete result set as HTML table for debug purposes.
at line 79
static string
dumpSql(string $sql, array|null $params = null, Connection|null $connection = null)
Returns syntax highlighted SQL command.
at line 158
static array
detectTypes(PDOStatement $statement)
Common column type detection.
at line 174
static string
detectType(string $type)
deprecated
deprecated
No description
at line 181
static array
normalizeRow(array $row, ResultSet $resultSet)
deprecated
deprecated
No description
at line 192
static int
loadFromFile(Connection $connection, string $file, callable|null $onProgress = null)
Import SQL dump from file - extremely fast.
at line 238
static ConnectionPanel|null
createDebugPanel(Connection $connection, bool $explain, string $name, Bar $bar, BlueScreen $blueScreen)
deprecated
deprecated
No description
at line 252
static ConnectionPanel|null
initializeTracy(Connection $connection, bool $addBarPanel = false, string $name = '', bool $explain = true, Bar|null $bar = null, BlueScreen|null $blueScreen = null)
deprecated
deprecated
No description
at line 269
static array
toPairs(array $rows, string|int|null $key = null, string|int|null $value = null)
Reformat source to key -> value pairs.
at line 305
static string
findDuplicates(ResultDriver $result)
Finds duplicate columns in select statement
Traits
StaticClass