PdoHelper.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\Core\Database;

class PdoHelper {

    static public function importSql(\PDO $databaseHandle, $pdoDriver, $pathAndFilename) {
        $sql = file($pathAndFilename, FILE_IGNORE_NEW_LINES & FILE_SKIP_EMPTY_LINES);
        // Remove MySQL style key length delimiters (yuck!) if we are not setting up a MySQL db
        if (substr($pdoDriver, 0, 5) !== 'mysql') {
            $sql = preg_replace('/"\\([0-9]+\\)/', '"', $sql);
        }
        $statement = '';
        foreach ($sql as $line) {
            $statement .= ' ' . trim($line);
            if (substr($statement, -1) === ';') {
                $databaseHandle->exec($statement);
                $statement = '';
            }
        }
    }

}