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/Oci.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 an Oracle database.
 */
class Oci extends AbstractMetadata
{
    /**
     * No character used to quote schema objects.
     *
     * @var string
     */
    protected $schemaObjectQuoteChar = '';

    /**
     * The command used to perform a TRUNCATE operation.
     *
     * @var string
     */
    protected $truncateCommand = 'TRUNCATE TABLE';

    /**
     * @var array
     */
    protected $columns = [];

    /**
     * @var array
     */
    protected $keys = [];

    /**
     * Returns an array containing the names of all the tables in the database.
     *
     * @return array
     */
    public function getTableNames()
    {
        $tableNames = [];

        $query = "SELECT table_name
                    FROM cat
                   WHERE table_type='TABLE'
                   ORDER BY table_name";

        $result = $this->pdo->query($query);

        while ($tableName = $result->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];
    }

    /**
     * Loads column info from a oracle database.
     *
     * @param string $tableName
     */
    protected function loadColumnInfo($tableName): void
    {
        $ownerQuery    = '';
        $conOwnerQuery = '';
        $tableParts    = $this->splitTableName($tableName);

        $this->columns[$tableName] = [];
        $this->keys[$tableName]    = [];

        if (!empty($tableParts['schema'])) {
            $ownerQuery    = " AND OWNER = '{$tableParts['schema']}'";
            $conOwnerQuery = " AND a.owner = '{$tableParts['schema']}'";
        }

        $query = "SELECT DISTINCT COLUMN_NAME
                    FROM USER_TAB_COLUMNS
                   WHERE TABLE_NAME='" . $tableParts['table'] . "'
                    $ownerQuery
                   ORDER BY COLUMN_NAME";

        $result = $this->pdo->query($query);

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

        $keyQuery = "SELECT b.column_name
                       FROM user_constraints a, user_cons_columns b
                      WHERE a.constraint_type='P'
                        AND a.constraint_name=b.constraint_name
                        $conOwnerQuery
                        AND a.table_name = '" . $tableParts['table'] . "' ";

        $result = $this->pdo->query($keyQuery);

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

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 an Oracle database.
16	*/
17	class Oci extends AbstractMetadata
18	{
19	/**
20	* No character used to quote schema objects.
21	*
22	* @var string
23	*/
24	protected $schemaObjectQuoteChar = '';
25
26	/**
27	* The command used to perform a TRUNCATE operation.
28	*
29	* @var string
30	*/
31	protected $truncateCommand = 'TRUNCATE TABLE';
32
33	/**
34	* @var array
35	*/
36	protected $columns = [];
37
38	/**
39	* @var array
40	*/
41	protected $keys = [];
42
43	/**
44	* Returns an array containing the names of all the tables in the database.
45	*
46	* @return array
47	*/
48	public function getTableNames()
49	{
50	$tableNames = [];	×
51
52	$query = "SELECT table_name	×
53	FROM cat
54	WHERE table_type='TABLE'
55	ORDER BY table_name";	×
56
57	$result = $this->pdo->query($query);	×
58
59	while ($tableName = $result->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	* Loads column info from a oracle database.
102	*
103	* @param string $tableName
104	*/
105	protected function loadColumnInfo($tableName): void
106	{
107	$ownerQuery = '';	×
108	$conOwnerQuery = '';	×
109	$tableParts = $this->splitTableName($tableName);	×
110
111	$this->columns[$tableName] = [];	×
112	$this->keys[$tableName] = [];	×
113
114	if (!empty($tableParts['schema'])) {	×
115	$ownerQuery = " AND OWNER = '{$tableParts['schema']}'";	×
116	$conOwnerQuery = " AND a.owner = '{$tableParts['schema']}'";	×
117	}
118
119	$query = "SELECT DISTINCT COLUMN_NAME	×
120	FROM USER_TAB_COLUMNS
121	WHERE TABLE_NAME='" . $tableParts['table'] . "'	×
122	$ownerQuery	×
123	ORDER BY COLUMN_NAME";	×
124
125	$result = $this->pdo->query($query);	×
126
127	while ($columnName = $result->fetchColumn(0)) {	×
128	$this->columns[$tableName][] = $columnName;	×
129	}
130
131	$keyQuery = "SELECT b.column_name	×
132	FROM user_constraints a, user_cons_columns b
133	WHERE a.constraint_type='P'
134	AND a.constraint_name=b.constraint_name
135	$conOwnerQuery	×
136	AND a.table_name = '" . $tableParts['table'] . "' ";	×
137
138	$result = $this->pdo->query($keyQuery);	×
139
140	while ($columnName = $result->fetchColumn(0)) {	×
141	$this->keys[$tableName][] = $columnName;	×
142	}
143	}
144	}

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