5
* Copyright (c) 2002-2010, Sebastian Bergmann <sb@sebastian-bergmann.de>.
8
* Redistribution and use in source and binary forms, with or without
9
* modification, are permitted provided that the following conditions
12
* * Redistributions of source code must retain the above copyright
13
* notice, this list of conditions and the following disclaimer.
15
* * Redistributions in binary form must reproduce the above copyright
16
* notice, this list of conditions and the following disclaimer in
17
* the documentation and/or other materials provided with the
20
* * Neither the name of Sebastian Bergmann nor the names of his
21
* contributors may be used to endorse or promote products derived
22
* from this software without specific prior written permission.
24
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
25
* "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
26
* LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
27
* FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
28
* COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
29
* INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
30
* BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
31
* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
32
* CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
33
* LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
34
* ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
35
* POSSIBILITY OF SUCH DAMAGE.
39
* @author Mike Lively <m@digitalsandwich.com>
40
* @copyright 2002-2010 Sebastian Bergmann <sb@sebastian-bergmann.de>
41
* @license http://www.opensource.org/licenses/bsd-license.php BSD License
42
* @link http://www.phpunit.de/
43
* @since File available since Release 3.2.0
46
require_once 'PHPUnit/Framework.php';
47
require_once 'PHPUnit/Util/Filter.php';
48
require_once 'PHPUnit/Extensions/Database/DB/MetaData/InformationSchema.php';
50
PHPUnit_Util_Filter::addFileToFilter(__FILE__, 'PHPUNIT');
53
* Provides functionality to retrieve meta data from a PostgreSQL database.
57
* @author Mike Lively <m@digitalsandwich.com>
58
* @copyright 2002-2010 Sebastian Bergmann <sb@sebastian-bergmann.de>
59
* @license http://www.opensource.org/licenses/bsd-license.php BSD License
60
* @version Release: 3.4.14
61
* @link http://www.phpunit.de/
62
* @since Class available since Release 3.2.0
64
class PHPUnit_Extensions_Database_DB_MetaData_PgSQL extends PHPUnit_Extensions_Database_DB_MetaData
68
* Returns an array containing the names of all the tables in the database.
72
public function getTableNames()
77
FROM INFORMATION_SCHEMA.TABLES
79
TABLE_TYPE='BASE TABLE' AND
84
$statement = $this->pdo->prepare($query);
85
$statement->execute(array($this->getSchema()));
87
$tableNames = array();
88
while ($tableName = $statement->fetchColumn(0)) {
89
$tableNames[] = $tableName;
96
* Returns an array containing the names of all the columns in the
99
* @param string $tableName
102
public function getTableColumns($tableName)
104
if (!isset($this->columns[$tableName])) {
105
$this->loadColumnInfo($tableName);
108
return $this->columns[$tableName];
112
* Returns an array containing the names of all the primary key columns in
113
* the $tableName table.
115
* @param string $tableName
118
public function getTablePrimaryKeys($tableName)
120
if (!isset($this->keys[$tableName])) {
121
$this->loadColumnInfo($tableName);
124
return $this->keys[$tableName];
128
* Loads column info from a database table.
130
* @param string $tableName
132
protected function loadColumnInfo($tableName)
134
$this->columns[$tableName] = array();
135
$this->keys[$tableName] = array();
139
COLUMN_NAME, ORDINAL_POSITION
140
FROM INFORMATION_SCHEMA.COLUMNS
144
ORDER BY ORDINAL_POSITION
147
$columnStatement = $this->pdo->prepare($columnQuery);
148
$columnStatement->execute(array($tableName, $this->getSchema()));
150
while ($columName = $columnStatement->fetchColumn(0)) {
151
$this->columns[$tableName][] = $columName;
159
INFORMATION_SCHEMA.KEY_COLUMN_USAGE as KCU
160
LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS as TC
161
ON TC.TABLE_NAME = KCU.TABLE_NAME
163
TC.CONSTRAINT_TYPE = 'PRIMARY KEY' AND
164
TC.TABLE_NAME = ? AND
167
KCU.ORDINAL_POSITION ASC
170
$keyStatement = $this->pdo->prepare($keyQuery);
171
$keyStatement->execute(array($tableName, $this->getSchema()));
173
while ($columName = $keyStatement->fetchColumn(0)) {
174
$this->keys[$tableName][] = $columName;
179
* Returns the schema for the connection.
183
public function getSchema()
185
if (empty($this->schema)) {
188
return $this->schema;
193
* Returns true if the rdbms allows cascading
197
public function allowsCascading()
b'\\ No newline at end of file'