Fixed bug #15188: Remove default greyed out effect for CEs (Thanks to Steffen Gebert)
[Packages/TYPO3.CMS.git] / t3lib / class.t3lib_pdohelper.php
1 <?php
2 /***************************************************************
3 * Copyright notice
4 *
5 * (c) 2010 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 * @scope prototype
37 */
38 class t3lib_PdoHelper {
39
40 /**
41 * @var PDO
42 */
43 protected $databaseHandle;
44
45 /**
46 * @var string
47 */
48 protected $pdoDriver;
49
50 /**
51 * Construct the helper instance and set up PDO connection.
52 *
53 * @param string $dataSourceName
54 * @param string $user
55 * @param string $password
56 * @author Karsten Dambekalns <karsten@typo3.org>
57 */
58 public function __construct($dataSourceName, $user, $password) {
59 $splitdsn = explode(':', $dataSourceName, 2);
60 $this->pdoDriver = $splitdsn[0];
61
62 $this->databaseHandle = t3lib_div::makeInstance('PDO', $dataSourceName, $user, $password);
63 $this->databaseHandle->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
64 if ($this->pdoDriver === 'mysql') {
65 $this->databaseHandle->exec('SET SESSION sql_mode=\'ANSI_QUOTES\';');
66 }
67 }
68
69 /**
70 * Pumps the SQL into the database. Use for DDL only.
71 *
72 * Important: key definitions with length specifiers (needed for MySQL) must
73 * be given as "field"(xyz) - no space between double quote and parenthesis -
74 * so they can be removed automatically.
75 *
76 * @param string $pathAndFilename
77 * @return void
78 * @author Karsten Dambekalns <karsten@typo3.org>
79 */
80 public function importSql($pathAndFilename) {
81 $sql = file($pathAndFilename, FILE_IGNORE_NEW_LINES & FILE_SKIP_EMPTY_LINES);
82
83 // Remove MySQL style key length delimiters (yuck!) if we are not setting up a MySQL db
84 if ($this->pdoDriver !== 'mysql') {
85 $sql = preg_replace('/"\([0-9]+\)/', '"', $sql);
86 }
87
88 $statement = '';
89 foreach ($sql as $line) {
90 $statement .= ' ' . trim($line);
91 if (substr($statement, -1) === ';') {
92 $this->databaseHandle->query($statement);
93 $statement = '';
94 }
95 }
96 }
97 }
98
99 if (defined('TYPO3_MODE') && $GLOBALS['TYPO3_CONF_VARS'][TYPO3_MODE]['XCLASS']['t3lib/class.t3lib_pdohelper.php']) {
100 include_once($GLOBALS['TYPO3_CONF_VARS'][TYPO3_MODE]['XCLASS']['t3lib/class.t3lib_pdohelper.php']);
101 }
102
103 ?>