1. class
  2. Neos
  3. \
  4. Utility
  5. \
  6. PdoHelper

PdoHelper

abstract class PdoHelper (View source)

A helper class for handling PDO databases

Methods

static void
importSql(PDO $databaseHandle, string $pdoDriver, string $pathAndFilename, array $replacePairs = [])

Pumps the SQL into the database. Use for DDL only.

Details

at line 39
static void importSql(PDO $databaseHandle, string $pdoDriver, string $pathAndFilename, array $replacePairs = [])

Pumps the SQL into the database. Use for DDL only.

The given $pathAndFilename is expanded to check for a driver-specific SQL file to import, so "/some/path/to/mysql.statements.sql" is checked and used if "/some/path/to/statements.sql" is passed and $pdoDriver is "mysql". Otherwise the given file is used.

Important: key definitions with length specifiers (needed for MySQL) must be given as "field"(xyz) - no space between double quote and parenthesis - so they can be removed automatically. This is not done for driver-specific SQL, though.

Parameters

PDO $databaseHandle
string $pdoDriver
string $pathAndFilename
array $replacePairs

every key in this array will be replaced with the corresponding value in the loaded SQL (example: ['###CACHE_TABLE_NAME###' => 'caches', '###TAGS_TABLE_NAME###' => 'tags'])

Return Value

void