ntentan\atiaa\descriptors\MysqlDescriptor

Complexity

Total Complexity

6

Size/Duplication

Total Lines	78
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Test Coverage

Coverage

92.59%

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	getForeignKeys()	0	27	1
A	getIndices()	0	8	1
A	getSchemata()	0	18	2
A	hasAutoIncrementingKey()	0	19	2

<?php

/*
 * The MIT License
 *
 * Copyright 2014-2018 James Ekow Abaka Ainooson
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in
 * all copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
 * THE SOFTWARE.
 */

namespace ntentan\atiaa\descriptors;

class MysqlDescriptor extends InformationSchemaDescriptor
{
    protected function getForeignKeys(&$table)
    {
        return $this->driver->query(
            sprintf(
                "SELECT
                    kcu.constraint_name as name,
                    kcu.table_schema as `schema`,
                    kcu.table_name as `table`,
                    kcu.column_name as `column`,
                    kcu.referenced_table_name AS foreign_table,
                    kcu.referenced_table_schema AS foreign_schema,
                    kcu.referenced_column_name AS foreign_column,
                    rc.update_rule as on_update,
                    rc.delete_rule as on_delete
                FROM
                    information_schema.table_constraints AS tc
                    JOIN information_schema.key_column_usage AS kcu
                      ON tc.constraint_name = kcu.constraint_name and tc.table_schema = kcu.table_schema
                    JOIN information_schema.referential_constraints AS rc
                      ON rc.constraint_name = tc.constraint_name and rc.constraint_schema = tc.table_schema
                WHERE constraint_type = 'FOREIGN KEY'
                    AND tc.table_name='%s' AND tc.table_schema='%s' order by kcu.constraint_name, kcu.column_name",
                $table['name'],
                $table['schema']
            )
        );
    }

    protected function getIndices(&$table)
    {
        return $this->driver->query(
            sprintf("SELECT table_name, column_name as `column`,index_name as `name` FROM information_schema.STATISTICS 
            WHERE INDEX_NAME not in (SELECT CONSTRAINT_NAME FROM information_schema.KEY_COLUMN_USAGE)
            AND table_name = '%s' and table_schema = '%s' order by index_name, column_name", $table['name'], $table['schema'])
        );
    }

    protected function getSchemata()
    {
        $defaultSchema = $this->driver->getDefaultSchema();
        if ($defaultSchema == '') {
            $schemata = $this->driver->query(
                "select schema_name as name from information_schema.schemata
                where schema_name <> 'information_schema' order by schema_name"
            );
        } else {
            $schemata = [
                [
                    'name' => $defaultSchema,
                ],
            ];
        }

        return $schemata;
    }

    protected function hasAutoIncrementingKey(&$table)
    {
        $auto = false;
        $found = $this->driver->query(
            sprintf(
                "select column_name as name
                from information_schema.columns
                where table_name = '%s' and table_schema='%s' and extra = 'auto_increment'",
                $table['name'],
                $table['schema']
            )
        );

        if (count($found) > 0) {
            $auto = true;
        }

        return $auto;
    }
}