[TASK] Remove SVN auto properties $Id$
[Packages/TYPO3.CMS.git] / t3lib / class.t3lib_pdohelper.php
1 <?php
2 /***************************************************************
3 * Copyright notice
4 *
5 * (c) 2010-2011 Christian Kuhn <lolli@schwarzbu.ch>
6 * All rights reserved
7 *
8 * This script is part of the TYPO3 project. The TYPO3 project is
9 * free software; you can redistribute it and/or modify
10 * it under the terms of the GNU General Public License as published by
11 * the Free Software Foundation; either version 2 of the License, or
12 * (at your option) any later version.
13 *
14 * The GNU General Public License can be found at
15 * http://www.gnu.org/copyleft/gpl.html.
16 * A copy is found in the textfile GPL.txt and important notices to the license
17 * from the author is found in LICENSE.txt distributed with these scripts.
18 *
19 *
20 * This script is distributed in the hope that it will be useful,
21 * but WITHOUT ANY WARRANTY; without even the implied warranty of
22 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
23 * GNU General Public License for more details.
24 *
25 * This copyright notice MUST APPEAR in all copies of the script!
26 ***************************************************************/
27
28 /**
29 * A helper class for handling PDO databases
30 * Backport of FLOW3 class PdoHelper, last synced version: 3528
31 *
32 * @author Karsten Dambekalns <karsten@typo3.org>
33 * @package TYPO3
34 * @subpackage t3lib
35 */
36 class t3lib_PdoHelper {
37
38 /**
39 * Pumps the SQL into the database. Use for DDL only.
40 *
41 * Important: key definitions with length specifiers (needed for MySQL) must
42 * be given as "field"(xyz) - no space between double quote and parenthesis -
43 * so they can be removed automatically.
44 *
45 * @param PDO $databaseHandle
46 * @param string $pdoDriver
47 * @param string $pathAndFilename
48 * @return void
49 * @author Karsten Dambekalns <karsten@typo3.org>
50 */
51 static public function importSql(PDO $databaseHandle, $pdoDriver, $pathAndFilename) {
52 $sql = file($pathAndFilename, FILE_IGNORE_NEW_LINES & FILE_SKIP_EMPTY_LINES);
53
54 // Remove MySQL style key length delimiters (yuck!) if we are not setting up a MySQL db
55 if ($pdoDriver !== 'mysql') {
56 $sql = preg_replace('/"\([0-9]+\)/', '"', $sql);
57 }
58
59 $statement = '';
60 foreach ($sql as $line) {
61 $statement .= ' ' . trim($line);
62 if (substr($statement, -1) === ';') {
63 $databaseHandle->exec($statement);
64 $statement = '';
65 }
66 }
67 }
68 }
69
70 if (defined('TYPO3_MODE') && $GLOBALS['TYPO3_CONF_VARS'][TYPO3_MODE]['XCLASS']['t3lib/class.t3lib_pdohelper.php']) {
71 include_once($GLOBALS['TYPO3_CONF_VARS'][TYPO3_MODE]['XCLASS']['t3lib/class.t3lib_pdohelper.php']);
72 }
73
74 ?>