Yiisoft\Db\Pgsql\Command::refreshMaterializedView()

Complexity

Conditions	10
Paths	15

Size

Total Lines	32
Code Lines	15

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	110

Importance

Changes

0

<?php
    public function refreshMaterializedView(string $viewName, ?bool $concurrently = null, ?bool $withData = null): void
    {
        if ($concurrently || ($concurrently === null || $withData === null)) {

            $tableSchema = $this->db->getTableSchema($viewName);
            $hasUnique = count($this->db->getSchema()->findUniqueIndexes($tableSchema)) > 0;

It seems like $tableSchema can also be of type null; however, parameter $table of Yiisoft\Db\Schema\SchemaInterface::findUniqueIndexes() does only seem to accept Yiisoft\Db\Schema\TableSchemaInterface, maybe add an additional type check?

            if ($concurrently && !$hasUnique) {
                throw new LogicException('CONCURRENTLY refresh is not allowed without unique index.');
            }

            $concurrently = $hasUnique;
        }

        $sql = 'REFRESH MATERIALIZED VIEW';

        if ($concurrently) {

            if ($withData === false) {
                throw new LogicException('CONCURRENTLY and WITH NO DATA may not be specified together.');
            }

            $sql .= ' CONCURRENTLY';
        }

        $sql .= ' ' . $this->db->getQuoter()->quoteTableName($viewName);

        if (is_bool($withData)) {
            $sql .= ' WITH ' . ($withData ? 'DATA' : 'NO DATA');
        }

        $this->setSql($sql)->execute();
    }