nkovacs / yii2-table-builder
Table builder migration helper extension for Yii 2
Installs: 36 079
Dependents: 0
Suggesters: 0
Security: 0
Stars: 0
Watchers: 3
Forks: 1
Open Issues: 0
Type:yii2-extension
Requires
- yiisoft/yii2: *
This package is auto-updated.
Last update: 2024-09-25 03:04:30 UTC
README
Table builder migration helper extension for Yii 2
Installation
The preferred way to install this extension is through composer.
Either run
php composer.phar require --prefer-dist nkovacs/yii2-table-builder "*"
or add
"nkovacs/yii2-table-builder": "*"
to the require section of your composer.json
file.
Usage
In order to use this extension, your migrations must extend from \nkovacs\tablebuilder\Migration
.
Once the extension is installed, it will override the migrate command's templateFile property
during application bootstrap process, allowing you to use the extension's Migration class
in newly created migrations, provided you did not override templateFile yourself.
An example migration:
<?php
use yii\db\Schema;
class m140701_113939_test extends \nkovacs\tablebuilder\Migration
{
public $tables;
public function init()
{
parent::init();
$this->tables = [
'{{%table_a}}' => [
'id' => Schema::TYPE_PK,
'name' => Schema::TYPE_STRING,
],
'{{%table_b}}' => [
'id' => Schema::TYPE_PK,
'name' => Schema::TYPE_STRING,
],
'{{%table_c}}' => [
'id' => Schema::TYPE_PK,
'user_id' => [Schema::TYPE_INTEGER, '{{%user}}', 'id', 'delete' => 'SET NULL', 'update' => 'CASCADE'],
'a_id' => [Schema::TYPE_INTEGER, '{{%table_a}}', 'id', 'delete' => 'RESTRICT', 'update' => 'CASCADE'],
'b_id' => [Schema::TYPE_INTEGER, '{{%table_b}}', 'id', 'delete' => 'RESTRICT', 'update' => 'CASCADE'],
'name' => Schema::TYPE_STRING,
],
'{{%table_d}}' => [
'a_id' => [Schema::TYPE_INTEGER, '{{%table_a}}', 'id', 'delete' => 'RESTRICT', 'update' => 'CASCADE'],
'b_id' => [Schema::TYPE_INTEGER, '{{%table_b}}', 'id', 'delete' => 'RESTRICT', 'update' => 'CASCADE'],
['primary' => ['a_id', 'b_id']],
]
];
}
public function up()
{
$this->build($this->tables);
}
public function down()
{
$this->teardown($this->tables);
}
}