DVDoug\DB\MSSQLPDODatabase::getIndexes()

Complexity

Conditions	5
Paths	9

Size

Total Lines	47
Code Lines	18

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	30

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function getIndexes($aDatabase, $aTable): array
    {
        $indexes = [];
        $SQL = 'SELECT ind.name AS INDEX_NAME,
                     col.name AS COLUMN_NAME
              FROM sys.indexes ind
                   JOIN sys.index_columns ic
                     ON ind.object_id = ic.object_id
                        AND ind.index_id = ic.index_id
                   JOIN sys.columns col
                     ON ic.object_id = col.object_id
                        AND ic.column_id = col.column_id
                   JOIN sys.tables t
                     ON ind.object_id = t.object_id
                   JOIN sys.schemas s
                     ON t.schema_id = s.schema_id
             WHERE ind.is_primary_key = 0
                   AND s.name = :database
                   AND t.name = :table_name
             ORDER BY ind.name ASC, ic.index_column_id ASC';
        $statement = $this->prepare($SQL);
        $statement->bindParamToValue(':database', $aDatabase);
        $statement->bindParamToValue(':table_name', $aTable);
        $statement->execute();

        $result = $statement->fetchAssoc(true, true);

        foreach ($result as $index => $columnList) {
            $index = substr($index, 0, 64);
            $indexes[$index] = [];
            foreach ($columnList as $col) {
                $indexes[$index][] = $col['COLUMN_NAME'];
            }
        }

        /*
         * Subtract PK if any
         */
        $PK = $this->getPrimaryKey($aDatabase, $aTable);
        foreach ($indexes as $name => $columns) {
            if ($PK === $columns) {
                unset($indexes[$name]);
                break;
            }
        }

        return $indexes;
    }