PHP Classes

File: gii/default_structure/migration.php

Recommend this page to a friend!
  Classes of Insolita   YII2 Migrik   gii/default_structure/migration.php   Download  
File: gii/default_structure/migration.php
Role: Example script
Content type: text/plain
Description: Example script
Class: YII2 Migrik
Create migration files for applications using YII2
Author: By
Last change:
Date: 4 months ago
Size: 2,012 bytes
 

Contents

Class file image Download
<?php
/**
 * This view is used by console/controllers/MigrateController.php
 * The following variables are available in this view:
 */
/** @var $migrationName string the new migration class name
 * @var $tableAlias string table_name
 * @var $tableName string table_name
 * @var array $tableColumns
 * @var array $tableIndexes
 * @var array $tablePk
 * @var insolita\migrik\gii\StructureGenerator $generator
 */

echo "<?php\n";
?>

use yii\db\Schema;
use yii\db\Migration;

class <?= $migrationName ?> extends Migration
{

    public function init()
    {
        $this->db = '<?=$generator->db?>';
        parent::init();
    }

    public function safeUp()
    {
        $tableOptions = '<?=$generator->tableOptions?>';

        $this->createTable(
            '<?= ($generator->usePrefix)?$tableAlias:$tableName ?>',
            [
<?php foreach ($tableColumns as $name => $data) :?>
'<?=$name?>'=> <?=$data;?>,
<?php endforeach;?>
],$tableOptions
        );
<?php if (!empty($tableIndexes) && is_array($tableIndexes)) : ?>
<?php
foreach ($tableIndexes as $name => $data) :?>
<?php
if ($name!='PRIMARY') : ?>
$this->createIndex('<?=$name?>','<?=$tableAlias?>',['<?=implode("','", array_values($data['cols']))?>'],<?=$data['isuniq']?'true':'false'?>);
<?php endif;?>
<?php
endforeach;?>
<?php
endif?>
<?php
if (!empty($tablePk)) : ?>
$this->addPrimaryKey('pk_on_<?=$tableName?>','<?=$tableAlias?>',['<?=implode("','", $tablePk)?>']);
<?php endif?>

    }

    public function safeDown()
    {
<?php if (!empty($tablePk)) : ?>
$this->dropPrimaryKey('pk_on_<?=$tableName?>','<?=$tableAlias?>');
<?php endif?>
<?php
if (!empty($tableIndexes) && is_array($tableIndexes)) : ?>
<?php
foreach ($tableIndexes as $name => $data) :?>
<?php
if ($name!='PRIMARY') : ?>
$this->dropIndex('<?=$name?>', '<?=$tableAlias?>');
<?php endif;?>
<?php
endforeach;?>
<?php
endif?>
$this->dropTable('<?= ($generator->usePrefix)?$tableAlias:$tableName ?>');
    }
}