4562384438

Build Type

push

github

Committed by Aleksandr Ivanov

Commit Message

Fix build status badge display

Run Details

635 of 1200 relevant lines covered (52.92%)

5.65 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

0.0

/src/Database/Metadata/Firebird.php

<?php

/*
 * This file is part of DbUnit.
 *
 * (c) Sebastian Bergmann <sebastian@phpunit.de>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

namespace PHPUnit\DbUnit\Database\Metadata;

/**
 * Provides functionality to retrieve meta data from a Firebird database.
 */
class Firebird extends AbstractMetadata
{
    /**
     * The command used to perform a TRUNCATE operation.
     *
     * @var string
     */
    protected $truncateCommand = 'DELETE FROM';

    /**
     * Returns an array containing the names of all the tables in the database.
     *
     * @return array
     */
    public function getTableNames()
    {
        $query = "
            SELECT DISTINCT
                TABLE_NAME
            FROM INFORMATION_SCHEMA.TABLES
            WHERE
                TABLE_TYPE='BASE TABLE' AND
                TABLE_SCHEMA = ?
            ORDER BY TABLE_NAME
        ";

        $query = "
            select
              RDB$RELATION_NAME as TABLE_NAME
            from RDB$RELATIONS
            where
              ((RDB$RELATION_TYPE = 0) or
               (RDB$RELATION_TYPE is null)) and
              (RDB$SYSTEM_FLAG = 0)
            order by (RDB$RELATION_NAME)
        ";

        $statement = $this->pdo->prepare($query);
        $statement->execute([$this->getSchema()]);

        $tableNames = [];

        while ($tableName = $statement->fetchColumn(0)) {
            $tableNames[] = $tableName;
        }

        return $tableNames;
    }

    /**
     * Returns an array containing the names of all the columns in the
     * $tableName table,
     *
     * @param string $tableName
     *
     * @return array
     */
    public function getTableColumns($tableName)
    {
        if (!isset($this->columns[$tableName])) {
            $this->loadColumnInfo($tableName);
        }

        return $this->columns[$tableName];
    }

    /**
     * Returns an array containing the names of all the primary key columns in
     * the $tableName table.
     *
     * @param string $tableName
     *
     * @return array
     */
    public function getTablePrimaryKeys($tableName)
    {
        if (!isset($this->keys[$tableName])) {
            $this->loadColumnInfo($tableName);
        }

        return $this->keys[$tableName];
    }

    /**
     * Returns the schema for the connection.
     *
     * @return string
     */
    public function getSchema()
    {
        if (empty($this->schema)) {
            return 'public';
        }

        return $this->schema;
    }

    /**
     * Returns true if the rdbms allows cascading
     *
     * @return bool
     */
    public function allowsCascading()
    {
        return false;
    }

    /**
     * Returns a quoted schema object. (table name, column name, etc)
     *
     * @param string $object
     *
     * @return string
     */
    public function quoteSchemaObject($object)
    {
        return $object; //firebird does not allow object quoting
    }

    /**
     * Loads column info from a database table.
     *
     * @param string $tableName
     */
    protected function loadColumnInfo($tableName): void
    {
        $this->columns[$tableName] = [];
        $this->keys[$tableName]    = [];

        $columnQuery = '
            SELECT DISTINCT
                COLUMN_NAME, ORDINAL_POSITION
            FROM INFORMATION_SCHEMA.COLUMNS
            WHERE
                TABLE_NAME = ? AND
                TABLE_SCHEMA = ?
            ORDER BY ORDINAL_POSITION
        ';

        $columnQuery = '
            select
              rf.RDB$FIELD_NAME as COLUMN_NAME,
              rf.RDB$FIELD_POSITION as ORDINAL_POSITION
            from RDB$RELATION_FIELDS as rf
            where
              upper(RDB$RELATION_NAME) = upper(?)
            order by
              ORDINAL_POSITION

        ';

        $columnStatement = $this->pdo->prepare($columnQuery);
        $columnStatement->execute([$tableName]);

        while ($columName = $columnStatement->fetchColumn(0)) {
            $this->columns[$tableName][] = $columName;
        }

        $keyQuery = "
            SELECT
                KCU.COLUMN_NAME,
                KCU.ORDINAL_POSITION
            FROM
                INFORMATION_SCHEMA.KEY_COLUMN_USAGE as KCU
            LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS as TC
                ON TC.TABLE_NAME = KCU.TABLE_NAME
            WHERE
                TC.CONSTRAINT_TYPE = 'PRIMARY KEY' AND
                TC.TABLE_NAME = ? AND
                TC.TABLE_SCHEMA = ?
            ORDER BY
                KCU.ORDINAL_POSITION ASC
        ";

        $keyQuery = "
            select
              idseg.rdb\$field_name as COLUMN_NAME,
              idseg.rdb\$field_position as ORDINAL_POSITION,
              rc.rdb\$relation_name as tablename,
              rc.rdb\$constraint_name as pk_name
            from
              RDB\$RELATION_CONSTRAINTS AS rc
                left join
              rdb\$index_segments as idseg on
                (rc.rdb\$index_name = idseg.rdb\$index_name)
            where
              rc.RDB\$CONSTRAINT_TYPE = 'PRIMARY KEY'
              and upper(rc.RDB\$RELATION_NAME) = upper(?)
            order by
              rc.rdb\$constraint_name, idseg.rdb\$field_position
        ";

        $keyStatement = $this->pdo->prepare($keyQuery);
        $keyStatement->execute([$tableName]);

        while ($columName = $keyStatement->fetchColumn(0)) {
            $this->keys[$tableName][] = $columName;
        }
    }
}

1	<?php
2
3	/*
4	* This file is part of DbUnit.
5	*
6	* (c) Sebastian Bergmann <sebastian@phpunit.de>
7	*
8	* For the full copyright and license information, please view the LICENSE
9	* file that was distributed with this source code.
10	*/
11
12	namespace PHPUnit\DbUnit\Database\Metadata;
13
14	/**
15	* Provides functionality to retrieve meta data from a Firebird database.
16	*/
17	class Firebird extends AbstractMetadata
18	{
19	/**
20	* The command used to perform a TRUNCATE operation.
21	*
22	* @var string
23	*/
24	protected $truncateCommand = 'DELETE FROM';
25
26	/**
27	* Returns an array containing the names of all the tables in the database.
28	*
29	* @return array
30	*/
31	public function getTableNames()
32	{
33	$query = "	×
34	SELECT DISTINCT
35	TABLE_NAME
36	FROM INFORMATION_SCHEMA.TABLES
37	WHERE
38	TABLE_TYPE='BASE TABLE' AND
39	TABLE_SCHEMA = ?
40	ORDER BY TABLE_NAME
41	";	×
42
43	$query = "	×
44	select
45	RDB$RELATION_NAME as TABLE_NAME	×
46	from RDB$RELATIONS	×
47	where
48	((RDB$RELATION_TYPE = 0) or	×
49	(RDB$RELATION_TYPE is null)) and	×
50	(RDB$SYSTEM_FLAG = 0)	×
51	order by (RDB$RELATION_NAME)	×
52	";	×
53
54	$statement = $this->pdo->prepare($query);	×
55	$statement->execute([$this->getSchema()]);	×
56
57	$tableNames = [];	×
58
59	while ($tableName = $statement->fetchColumn(0)) {	×
60	$tableNames[] = $tableName;	×
61	}
62
63	return $tableNames;	×
64	}
65
66	/**
67	* Returns an array containing the names of all the columns in the
68	* $tableName table,
69	*
70	* @param string $tableName
71	*
72	* @return array
73	*/
74	public function getTableColumns($tableName)
75	{
76	if (!isset($this->columns[$tableName])) {	×
77	$this->loadColumnInfo($tableName);	×
78	}
79
80	return $this->columns[$tableName];	×
81	}
82
83	/**
84	* Returns an array containing the names of all the primary key columns in
85	* the $tableName table.
86	*
87	* @param string $tableName
88	*
89	* @return array
90	*/
91	public function getTablePrimaryKeys($tableName)
92	{
93	if (!isset($this->keys[$tableName])) {	×
94	$this->loadColumnInfo($tableName);	×
95	}
96
97	return $this->keys[$tableName];	×
98	}
99
100	/**
101	* Returns the schema for the connection.
102	*
103	* @return string
104	*/
105	public function getSchema()
106	{
107	if (empty($this->schema)) {	×
108	return 'public';	×
109	}
110
111	return $this->schema;	×
112	}
113
114	/**
115	* Returns true if the rdbms allows cascading
116	*
117	* @return bool
118	*/
119	public function allowsCascading()
120	{
121	return false;	×
122	}
123
124	/**
125	* Returns a quoted schema object. (table name, column name, etc)
126	*
127	* @param string $object
128	*
129	* @return string
130	*/
131	public function quoteSchemaObject($object)
132	{
133	return $object; //firebird does not allow object quoting	×
134	}
135
136	/**
137	* Loads column info from a database table.
138	*
139	* @param string $tableName
140	*/
141	protected function loadColumnInfo($tableName): void
142	{
143	$this->columns[$tableName] = [];	×
144	$this->keys[$tableName] = [];	×
145
146	$columnQuery = '	×
147	SELECT DISTINCT
148	COLUMN_NAME, ORDINAL_POSITION
149	FROM INFORMATION_SCHEMA.COLUMNS
150	WHERE
151	TABLE_NAME = ? AND
152	TABLE_SCHEMA = ?
153	ORDER BY ORDINAL_POSITION
154	';	×
155
156	$columnQuery = '	×
157	select
158	rf.RDB$FIELD_NAME as COLUMN_NAME,
159	rf.RDB$FIELD_POSITION as ORDINAL_POSITION
160	from RDB$RELATION_FIELDS as rf
161	where
162	upper(RDB$RELATION_NAME) = upper(?)
163	order by
164	ORDINAL_POSITION
165
166	';	×
167
168	$columnStatement = $this->pdo->prepare($columnQuery);	×
169	$columnStatement->execute([$tableName]);	×
170
171	while ($columName = $columnStatement->fetchColumn(0)) {	×
172	$this->columns[$tableName][] = $columName;	×
173	}
174
175	$keyQuery = "	×
176	SELECT
177	KCU.COLUMN_NAME,
178	KCU.ORDINAL_POSITION
179	FROM
180	INFORMATION_SCHEMA.KEY_COLUMN_USAGE as KCU
181	LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS as TC
182	ON TC.TABLE_NAME = KCU.TABLE_NAME
183	WHERE
184	TC.CONSTRAINT_TYPE = 'PRIMARY KEY' AND
185	TC.TABLE_NAME = ? AND
186	TC.TABLE_SCHEMA = ?
187	ORDER BY
188	KCU.ORDINAL_POSITION ASC
189	";	×
190
191	$keyQuery = "	×
192	select
193	idseg.rdb\$field_name as COLUMN_NAME,
194	idseg.rdb\$field_position as ORDINAL_POSITION,
195	rc.rdb\$relation_name as tablename,
196	rc.rdb\$constraint_name as pk_name
197	from
198	RDB\$RELATION_CONSTRAINTS AS rc
199	left join
200	rdb\$index_segments as idseg on
201	(rc.rdb\$index_name = idseg.rdb\$index_name)
202	where
203	rc.RDB\$CONSTRAINT_TYPE = 'PRIMARY KEY'
204	and upper(rc.RDB\$RELATION_NAME) = upper(?)
205	order by
206	rc.rdb\$constraint_name, idseg.rdb\$field_position
207	";	×
208
209	$keyStatement = $this->pdo->prepare($keyQuery);	×
210	$keyStatement->execute([$tableName]);	×
211
212	while ($columName = $keyStatement->fetchColumn(0)) {	×
213	$this->keys[$tableName][] = $columName;	×
214	}
215	}
216	}

misantron / dbunit / 4562384438

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous