infinitydevphp/yii2-table-builder

Yii2 表格构建器

维护者

详细信息

github.com/infinitydevphp/yii2-table-builder

主页

源代码

问题

安装次数: 191

依赖者: 1

建议者: 0

安全: 0

星标: 2

关注者: 1

分支: 0

公开问题: 0

dev-master 2016-09-19 15:55 UTC

Requires

MIT 4a524ba2f4f6d4506f4f45542512290ce618614a

  • InfinityDevPhp <infinitydevphp.woop@gmail.com>

This package is not auto-updated.

Last update: 2024-09-20 22:07:51 UTC

README

  • 安装
php composer.phar require infinitydevphp/yii2-table-builder "1.0"

字段配置参数

用法

  • 创建表格
<?php 
use infinitydevphp\tableBuilder\TableBuilder;
use \yii\db\Schema;

$class = new TableBuilder([
    'tableName' => 'order',
    'fields' => [
        [
            'name' => 'id',
            'type' => Schema::TYPE_PK,
        ],
        [
            'name' => 'date_created',
            'type' => Schema::TYPE_TIMESTAMP,
        ],
        [
            'name' => 'price',
            'type' => Schema::TYPE_INTEGER,
        ],
        [
            'name' => 'good_id',
            'type' => Schema::TYPE_INTEGER,
        ],
        [
            'name' => 'user_id',
            'type' => Schema::TYPE_INTEGER,
            'length' => 11,
            'related_field' => 'user_id',
            'related_table' => 'order',
        ],
    ],
]);
$resultRelations = $class->runQuery();
  • 从模板创建迁移
$class = new TableBuilderTemplateMigration([
    'tableName' => 'order'
]);
$migrationTemplateString = $class->runQuery();