TYPO3CMS  8
 All Classes Namespaces Files Functions Variables Pages
PdoHelper.php
Go to the documentation of this file.
1 <?php
2 namespace TYPO3\CMS\Core\Database;
3 
4 /*
5  * This file is part of the TYPO3 CMS project.
6  *
7  * It is free software; you can redistribute it and/or modify it under
8  * the terms of the GNU General Public License, either version 2
9  * of the License, or any later version.
10  *
11  * For the full copyright and license information, please read the
12  * LICENSE.txt file that was distributed with this source code.
13  *
14  * The TYPO3 project - inspiring people to share!
15  */
16 
21 class PdoHelper
22 {
35  public static function importSql(\PDO $databaseHandle, $pdoDriver, $pathAndFilename)
36  {
37  $sql = file($pathAndFilename, FILE_IGNORE_NEW_LINES & FILE_SKIP_EMPTY_LINES);
38  // Remove MySQL style key length delimiters (yuck!) if we are not setting up a MySQL db
39  if (substr($pdoDriver, 0, 5) !== 'mysql') {
40  $sql = preg_replace('/"\\([0-9]+\\)/', '"', $sql);
41  }
42  $statement = '';
43  foreach ($sql as $line) {
44  $statement .= ' ' . trim($line);
45  if (substr($statement, -1) === ';') {
46  $databaseHandle->exec($statement);
47  $statement = '';
48  }
49  }
50  }
51 }
static importSql(\PDO $databaseHandle, $pdoDriver, $pathAndFilename)
Definition: PdoHelper.php:35