1:   2:   3:   4:   5:   6:   7:   8:   9:  10:  11:  12:  13:  14:  15:  16:  17:  18:  19:  20:  21:  22:  23:  24:  25:  26:  27:  28:  29:  30:  31:  32:  33:  34:  35:  36:  37:  38:  39:  40:  41:  42:  43:  44:  45:  46:  47:  48:  49:  50:  51:  52:  53:  54:  55:  56:  57:  58:  59:  60:  61:  62:  63:  64:  65:  66:  67:  68:  69:  70:  71:  72:  73:  74:  75:  76:  77:  78:  79:  80:  81:  82:  83:  84:  85:  86:  87:  88:  89:  90:  91:  92:  93:  94:  95:  96:  97:  98:  99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 230: 231: 232: 233: 234: 235: 236: 237: 238: 239: 240: 241: 242: 243: 244: 245: 246: 247: 248: 249: 250: 251: 252: 253: 254: 255: 256: 257: 258: 259: 260: 261: 262: 263: 264: 265: 266: 267: 268: 269: 270: 271: 272: 273: 274: 275: 276: 277: 278: 279: 280: 281: 282: 

<?php

    namespace Inlm\SchemaGenerator\Dumpers;

    use CzProject\SqlGenerator;
    use CzProject\SqlSchema;
    use Inlm\SchemaGenerator\Diffs;
    use Inlm\SchemaGenerator\IDumper;


    abstract class AbstractSqlDumper implements IDumper
    {
        /** @var SqlGenerator\SqlDocument */
        protected $sqlDocument;

        /** @var array */
        protected $_tableAlter = array(
            'table' => NULL,
            'statement' => NULL,
        );


        /**
         * @return void
         */
        public function start()
        {
            $this->sqlDocument = new SqlGenerator\SqlDocument;
        }


        /**
         * @return void
         */
        public function createTable(Diffs\CreatedTable $table)
        {
            $definition = $table->getDefinition();
            $createTable = $this->sqlDocument->createTable($definition->getName());

            $createTable->setComment($definition->getComment());

            foreach ($definition->getOptions() as $option => $value) {
                $createTable->setOption($option, $value);
            }

            foreach ($definition->getColumns() as $column) {
                $createTable->addColumn(
                    $column->getName(),
                    $column->getType(),
                    $column->getParameters(),
                    $column->getOptions()
                )
                    ->setNullable($column->isNullable())
                    ->setAutoIncrement($column->isAutoIncrement())
                    ->setComment($column->getComment());
            }

            foreach ($definition->getIndexes() as $index) {
                $tableIndex = $createTable->addIndex($index->getName(), $index->getType());

                foreach ($index->getColumns() as $indexColumn) {
                    $tableIndex->addColumn(
                        $indexColumn->getName(),
                        $indexColumn->getOrder(),
                        $indexColumn->getLength()
                    );
                }
            }

            foreach ($definition->getForeignKeys() as $foreignKey) {
                $createTable->addForeignKey(
                    $foreignKey->getName(),
                    $foreignKey->getColumns(),
                    $foreignKey->getTargetTable(),
                    $foreignKey->getTargetColumns()
                );
            }
        }


        /**
         * @return void
         */
        public function removeTable(Diffs\RemovedTable $table)
        {
            $this->sqlDocument->dropTable($table->getTableName());
        }


        /**
         * @return void
         */
        public function createTableColumn(Diffs\CreatedTableColumn $column)
        {
            $definition = $column->getDefinition();
            $this->getTableAlter($column->getTableName())
                ->addColumn(
                    $definition->getName(),
                    $definition->getType(),
                    $definition->getParameters(),
                    $definition->getOptions()
                )
                    ->setNullable($definition->isNullable())
                    ->setAutoIncrement($definition->isAutoIncrement())
                    ->setComment($definition->getComment());
        }


        /**
         * @return void
         */
        public function updateTableColumn(Diffs\UpdatedTableColumn $column)
        {
            $definition = $column->getDefinition();
            $this->getTableAlter($column->getTableName())
                ->modifyColumn(
                    $definition->getName(),
                    $definition->getType(),
                    $definition->getParameters(),
                    $definition->getOptions()
                )
                    ->setNullable($definition->isNullable())
                    ->setAutoIncrement($definition->isAutoIncrement())
                    ->setComment($definition->getComment());
        }


        /**
         * @return void
         */
        public function removeTableColumn(Diffs\RemovedTableColumn $column)
        {
            $this->getTableAlter($column->getTableName())
                ->dropColumn($column->getColumnName());
        }


        /**
         * @return void
         */
        public function createTableIndex(Diffs\CreatedTableIndex $index)
        {
            $alter = $this->getTableAlter($index->getTableName());
            $this->addIndex($alter, $index->getDefinition());
        }


        /**
         * @return void
         */
        public function updateTableIndex(Diffs\UpdatedTableIndex $index)
        {
            $alter = $this->getTableAlter($index->getTableName());
            $alter->dropIndex($index->getIndexName());
            $this->addIndex($alter, $index->getDefinition());
        }


        /**
         * @return void
         */
        public function removeTableIndex(Diffs\RemovedTableIndex $index)
        {
            $this->getTableAlter($index->getTableName())
                ->dropIndex($index->getIndexName());
        }


        /**
         * @return void
         */
        public function createForeignKey(Diffs\CreatedForeignKey $foreignKey)
        {
            $alter = $this->getTableAlter($foreignKey->getTableName());
            $this->addForeignKey($alter, $foreignKey->getDefinition());
        }


        /**
         * @return void
         */
        public function updateForeignKey(Diffs\UpdatedForeignKey $foreignKey)
        {
            $alter = $this->getTableAlter($foreignKey->getTableName());
            $alter->dropForeignKey($foreignKey->getForeignKeyName());
            $this->addForeignKey($alter, $foreignKey->getDefinition());
        }


        /**
         * @return void
         */
        public function removeForeignKey(Diffs\RemovedForeignKey $foreignKey)
        {
            $this->getTableAlter($foreignKey->getTableName())
                ->dropForeignKey($foreignKey->getForeignKeyName());
        }


        /**
         * @return void
         */
        public function addTableOption(Diffs\AddedTableOption $option)
        {
            $this->getTableAlter($option->getTableName())
                ->setOption($option->getOption(), $option->getValue());
        }


        /**
         * @return void
         */
        public function updateTableOption(Diffs\UpdatedTableOption $option)
        {
            $this->getTableAlter($option->getTableName())
                ->setOption($option->getOption(), $option->getValue());
        }


        /**
         * @return void
         */
        public function removeTableOption(Diffs\RemovedTableOption $option)
        {
            throw new \Inlm\SchemaGenerator\UnsupportedException('Removing of table options is not supported.');
        }


        /**
         * @return void
         */
        public function updateTableComment(Diffs\UpdatedTableComment $comment)
        {
            $this->getTableAlter($comment->getTableName())
                ->setComment($comment->getComment());
        }


        /**
         * @return void
         */
        protected function addIndex(SqlGenerator\Statements\AlterTable $alter, SqlSchema\Index $definition)
        {
            $index = $alter->addIndex($definition->getName(), $definition->getType());

            foreach ($definition->getColumns() as $column) {
                $index->addColumn($column->getName(), $column->getOrder(), $column->getLength());
            }
        }


        /**
         * @return void
         */
        protected function addForeignKey(SqlGenerator\Statements\AlterTable $alter, SqlSchema\ForeignKey $definition)
        {
            $foreignKey = $alter->addForeignKey(
                $definition->getName(),
                $definition->getColumns(),
                $definition->getTargetTable(),
                $definition->getTargetColumns()
            );
            $foreignKey->setOnUpdateAction($definition->getOnUpdateAction());
            $foreignKey->setOnDeleteAction($definition->getOnDeleteAction());
        }


        /**
         * @param  string
         * @return SqlGenerator\Statements\AlterTable
         */
        protected function getTableAlter($tableName)
        {
            if ($this->_tableAlter['table'] !== $tableName) {
                $this->_tableAlter['table'] = $tableName;
                $this->_tableAlter['statement'] = $this->sqlDocument->alterTable($tableName);
            }

            return $this->_tableAlter['statement'];
        }
    }