Yiisoft\Db\Oracle\DDLQueryBuilder

Complexity

Total Complexity

10

Size/Duplication

Total Lines	63
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes

0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	checkIntegrity()	0	3	1
A	dropCommentFromTable()	0	3	1
A	addForeignKey()	0	17	3
A	renameTable()	0	4	1
A	dropIndex()	0	3	1
A	dropCommentFromColumn()	0	7	1
A	alterColumn()	0	7	1
A	__construct()	0	3	1

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Oracle;

use Yiisoft\Db\Exception\Exception;
use Yiisoft\Db\Exception\NotSupportedException;
use Yiisoft\Db\Query\DDLQueryBuilder as AbstractDDLQueryBuilder;
use Yiisoft\Db\Query\QueryBuilderInterface;

The type Yiisoft\Db\Query\QueryBuilderInterface was not found. Maybe you did not declare it correctly or list all dependencies?

use Yiisoft\Db\Schema\ColumnSchemaBuilder;

This use statement conflicts with another class in this namespace, Yiisoft\Db\Oracle\ColumnSchemaBuilder. Consider defining an alias.

final class DDLQueryBuilder extends AbstractDDLQueryBuilder
{
    public function __construct(private QueryBuilderInterface $queryBuilder)
    {
        parent::__construct($queryBuilder);
    }

    public function addForeignKey(string $name, string $table, array|string $columns, string $refTable, array|string $refColumns, ?string $delete = null, ?string $update = null): string
    {
        $sql = 'ALTER TABLE ' . $this->quoter->quoteTableName($table)

The property quoter does not exist on Yiisoft\Db\Oracle\DDLQueryBuilder. Did you maybe forget to declare it?

            . ' ADD CONSTRAINT ' . $this->quoter->quoteColumnName($name)
            . ' FOREIGN KEY (' . $this->queryBuilder->buildColumns($columns) . ')'
            . ' REFERENCES ' . $this->quoter->quoteTableName($refTable)
            . ' (' . $this->queryBuilder->buildColumns($refColumns) . ')';

        if ($delete !== null) {
            $sql .= ' ON DELETE ' . $delete;
        }

        if ($update !== null) {
            throw new Exception('Oracle does not support ON UPDATE clause.');
        }

        return $sql;
    }

    public function alterColumn(string $table, string $column, ColumnSchemaBuilder|string $type): string
    {
        return 'ALTER TABLE '
            . $this->quoter->quoteTableName($table)

The property quoter does not exist on Yiisoft\Db\Oracle\DDLQueryBuilder. Did you maybe forget to declare it?

            . ' MODIFY '
            . $this->quoter->quoteColumnName($column)
            . ' ' . $this->queryBuilder->getColumnType($type);
    }

    public function checkIntegrity(string $schema = '', string $table = '', bool $check = true): string
    {
        throw new NotSupportedException('Oracle does not support enabling/disabling integrity check.');
    }

    public function dropCommentFromColumn(string $table, string $column): string
    {
        return 'COMMENT ON COLUMN '
            . $this->quoter->quoteTableName($table)

The property quoter does not exist on Yiisoft\Db\Oracle\DDLQueryBuilder. Did you maybe forget to declare it?

            . '.'
            . $this->quoter->quoteColumnName($column)
            . " IS ''";
    }

    public function dropCommentFromTable(string $table): string
    {
        return 'COMMENT ON TABLE ' . $this->quoter->quoteTableName($table) . " IS ''";

The property quoter does not exist on Yiisoft\Db\Oracle\DDLQueryBuilder. Did you maybe forget to declare it?

    }

    public function dropIndex(string $name, string $table): string
    {
        return 'DROP INDEX ' . $this->quoter->quoteTableName($name);

The property quoter does not exist on Yiisoft\Db\Oracle\DDLQueryBuilder. Did you maybe forget to declare it?

    }

    public function renameTable(string $oldName, string $newName): string
    {
        return 'ALTER TABLE ' . $this->quoter->quoteTableName($oldName) . ' RENAME TO ' .

The property quoter does not exist on Yiisoft\Db\Oracle\DDLQueryBuilder. Did you maybe forget to declare it?

            $this->quoter->quoteTableName($newName);
    }
}