Fixed bug #17150: Workspaces non-admin user cannot send to next stage (Thanks to...
[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 * @version $Id$
36 */
37 class t3lib_PdoHelper {
38
39 /**
40 * Pumps the SQL into the database. Use for DDL only.
41 *
42 * Important: key definitions with length specifiers (needed for MySQL) must
43 * be given as "field"(xyz) - no space between double quote and parenthesis -
44 * so they can be removed automatically.
45 *
46 * @param PDO $databaseHandle
47 * @param string $pdoDriver
48 * @param string $pathAndFilename
49 * @return void
50 * @author Karsten Dambekalns <karsten@typo3.org>
51 */
52 static public function importSql(PDO $databaseHandle, $pdoDriver, $pathAndFilename) {
53 $sql = file($pathAndFilename, FILE_IGNORE_NEW_LINES & FILE_SKIP_EMPTY_LINES);
54
55 // Remove MySQL style key length delimiters (yuck!) if we are not setting up a MySQL db
56 if ($pdoDriver !== 'mysql') {
57 $sql = preg_replace('/"\([0-9]+\)/', '"', $sql);
58 }
59
60 $statement = '';
61 foreach ($sql as $line) {
62 $statement .= ' ' . trim($line);
63 if (substr($statement, -1) === ';') {
64 $databaseHandle->exec($statement);
65 $statement = '';
66 }
67 }
68 }
69 }
70
71 if (defined('TYPO3_MODE') && $GLOBALS['TYPO3_CONF_VARS'][TYPO3_MODE]['XCLASS']['t3lib/class.t3lib_pdohelper.php']) {
72 include_once($GLOBALS['TYPO3_CONF_VARS'][TYPO3_MODE]['XCLASS']['t3lib/class.t3lib_pdohelper.php']);
73 }
74
75 ?>