PHP Migration::integer方法代码示例

 protected function setupDbData()
 {
     /** @var \yii\db\Connection $db */
     $db = Yii::$app->getDb();
     $migration = new Migration();
     /**
      * Create tables
      **/
     // Company
     $db->createCommand()->createTable('company', ['id' => $migration->primaryKey(), 'name' => $migration->string()->notNull()->unique()])->execute();
     // User
     $db->createCommand()->createTable('user', ['id' => $migration->primaryKey(), 'username' => $migration->string()->notNull()->unique()])->execute();
     // Project
     $db->createCommand()->createTable('project', ['id' => $migration->primaryKey(), 'name' => $migration->string()->notNull(), 'company_id' => $migration->integer()->notNull()])->execute();
     $db->createCommand()->createIndex('company_id-name', 'project', 'company_id,name', true)->execute();
     $db->createCommand()->createTable('link', ['language' => $migration->string(5)->notNull(), 'name' => $migration->string()->notNull(), 'link' => $migration->string()->notNull(), 'link_type_id' => $migration->integer(), 'PRIMARY KEY(language, name)'])->execute();
     $db->createCommand()->createTable('link_type', ['id' => $migration->primaryKey(), 'name' => $migration->string()->notNull()->unique()])->execute();
     $db->createCommand()->createTable('project_link', ['language' => $migration->string(5)->notNull(), 'name' => $migration->string()->notNull(), 'project_id' => $migration->integer()->notNull(), 'PRIMARY KEY(language, name, project_id)'])->execute();
     // Project User
     $db->createCommand()->createTable('project_user', ['project_id' => $migration->integer()->notNull(), 'user_id' => $migration->integer()->notNull(), 'PRIMARY KEY(project_id, user_id)'])->execute();
     // Dummy
     $db->createCommand()->createTable('dummy', ['id' => $migration->primaryKey(), 'parent_id' => $migration->integer()])->execute();
     /**
      * Insert some data
      */
     $db->createCommand()->batchInsert('company', ['id', 'name'], [[1, 'Apple'], [2, 'Microsoft'], [3, 'Google']])->execute();
     $db->createCommand()->batchInsert('user', ['id', 'username'], [[1, 'Steve Jobs'], [2, 'Bill Gates'], [3, 'Tim Cook'], [4, 'Jonathan Ive']])->execute();
     $db->createCommand()->batchInsert('project', ['id', 'name', 'company_id'], [[1, 'Mac OS X', 1], [2, 'Windows 10', 2]])->execute();
     $db->createCommand()->batchInsert('link_type', ['id', 'name'], [[1, 'public'], [2, 'private']])->execute();
     $db->createCommand()->batchInsert('link', ['language', 'name', 'link', 'link_type_id'], [['fr', 'mac_os_x', 'http://www.apple.com/fr/osx/', 1], ['en', 'mac_os_x', 'http://www.apple.com/osx/', 1]])->execute();
     $db->createCommand()->batchInsert('project_link', ['language', 'name', 'project_id'], [['fr', 'mac_os_x', 1], ['en', 'mac_os_x', 1]])->execute();
     $db->createCommand()->batchInsert('project_user', ['project_id', 'user_id'], [[1, 1], [1, 4], [2, 2]])->execute();
 }

 public function getMenu()
 {
     $gitignore = join(DIRECTORY_SEPARATOR, [\Yii::getAlias('@app'), '.gitignore']);
     $array = [["text" => "Copy .htaccess to @app/web", "checked" => true, "disabled" => function (ConsoleCheckBox $item) {
         $dir = [\Yii::getAlias('@app'), 'web', '.htaccess'];
         return file_exists(join(DIRECTORY_SEPARATOR, $dir));
     }, "exec" => function (ConsoleCheckBox $item) {
         $source = [\Yii::getAlias('@vendor'), 'carono', 'yii2-components', 'templates', '.htaccess'];
         $dist = [\Yii::getAlias('@app'), 'web', '.htaccess'];
         return copy(join(DIRECTORY_SEPARATOR, $source), join(DIRECTORY_SEPARATOR, $dist));
     }], ["text" => "Add db.php to @app/.gitignore", "checked" => true, "disabled" => function (ConsoleCheckBox $item) use($gitignore) {
         $lines = explode("\n", file_get_contents($gitignore));
         return array_search('db.php', $lines) || array_search('/config/db.php', $lines);
     }, "exec" => function (ConsoleCheckBox $item) use($gitignore) {
         file_put_contents($gitignore, "\n/config/db.php", FILE_APPEND);
         return true;
     }, "error" => !file_exists($gitignore)], ["text" => "Create currency table", "checked" => true, "disabled" => function (ConsoleCheckBox $item) {
         return (bool) Yii::$app->db->getTableSchema('currency');
     }, "exec" => self::migrate('@carono/migrations/m151216_093214_currency')], ["text" => "Create cities table", "id" => "cities", "checked" => true, "disabled" => (bool) Yii::$app->db->getTableSchema('city'), "exec" => self::migrate('@carono/migrations/m151216_084006_cities')], ["text" => "Create RBAC (@yii/rbac/migrations)", "checked" => true, "disabled" => function (ConsoleCheckBox $item) {
         return (bool) Yii::$app->db->getTableSchema('auth_item');
     }, "exec" => self::migrate('@yii/rbac/migrations')], ["text" => "Create 'file_upload' table", "checked" => true, "disabled" => (bool) Yii::$app->db->getTableSchema('file_upload'), "exec" => self::migrate('@carono/migrations/m151127_104851_file_upload_table')], ["text" => "Create 'company' table (RUS)", "checked" => true, "disabled" => (bool) Yii::$app->db->getTableSchema('company'), "exec" => self::migrate('@carono/migrations/m160222_202733_company')], ["text" => "Create 'User' table", "id" => "user", "checked" => true, "disabled" => (bool) Yii::$app->db->getTableSchema('user'), "exec" => function (ConsoleCheckBox $item) {
         $command = new Migration();
         $table = ['user' => ['id' => $command->primaryKey(), 'login' => $command->string(), 'hash' => $command->string(), 'activation_code' => $command->string(), 'recover_code' => $command->string(), 'last_logon' => $command->dateTime(), 'access_token' => $command->string(), 'created' => $command->dateTime(), 'updated' => $command->dateTime(), 'active' => $command->boolean()->notNull()->defaultValue(false)], 'address' => ['id' => $command->primaryKey(), 'raw' => $command->string(), 'postcode' => $command->string(), 'street' => $command->string(), 'build' => $command->string(), 'structure' => $command->string(), 'flat' => $command->string(), 'registration_date' => $command->date()]];
         if ($item->owner->findById('cities')->value) {
             $table["address"]["city_id"] = [$command->integer(), 'city', 'id'];
         }
         if ($item->findById('photos')->value) {
             $table["user"]["photos"] = [$command->pivot(), 'file_upload', 'id', 'photo_id'];
         }
         if ($item->findById('personal')->value) {
             $table["user"]["personal_id"] = [$command->integer(), 'personal', 'id'];
             $table["personal"] = ['id' => $command->primaryKey(), 'email' => $command->string(), 'first_name' => $command->string(), 'second_name' => $command->string(), 'patronymic' => $command->string(), 'birth_date' => $command->date(), 'sex' => $command->boolean(), 'phone' => $command->string(), 'avatar_id' => [$command->integer(), 'file_upload', 'id'], 'legal_address_id' => [$command->integer(), 'address', 'id'], 'real_address_id' => [$command->integer(), 'address', 'id'], 'updated' => $command->dateTime()];
         } else {
             $table["user"] = array_merge($table["user"], ['email' => $command->string(), 'first_name' => $command->string(), 'second_name' => $command->string(), 'patronymic' => $command->string(), 'birth_date' => $command->date(), 'sex' => $command->boolean(), 'phone' => $command->string(), 'legal_address_id' => [$command->integer(), 'address', 'id'], 'real_address_id' => [$command->integer(), 'address', 'id']]);
         }
         $index = [["user", "login", true], ["user", "access_token", true]];
         $command->upTables($table);
         $command->upFk($command->collectFks($table));
         $command->upIndex($index);
         return true;
     }, "items" => [["id" => "personal", "text" => "User profile as relation", "checked" => true, "inherit" => true], ["id" => "photos", "text" => "Create with photos", "checked" => true, "inherit" => true], ["id" => "user_model", "text" => "Copy default User model", "checked" => false, "exec" => function () {
         $source = [\Yii::getAlias('@vendor'), 'carono', 'yii2-components', 'templates', 'User.php'];
         $dist = [\Yii::getAlias('@app'), 'models', 'User.php'];
         return copy(join(DIRECTORY_SEPARATOR, $source), join(DIRECTORY_SEPARATOR, $dist));
     }]]]];
     return $array;
 }

 /**
  * @param bool|true $autoIncrement
  * @param null $length
  * @param bool|true $unsigned
  * @return string
  */
 public function primary($autoIncrement = true, $length = null, $unsigned = true)
 {
     return parent::integer($length === null ? 10 : $length) . ($unsigned ? ' unsigned' : '') . ' NOT NULL' . ($autoIncrement ? ' AUTO_INCREMENT' : '') . ' PRIMARY KEY';
 }

 /**
  * Create next row migration as ColumnSchemaBuilder
  * @param array $config
  * @return ColumnSchemaBuilder
  */
 protected function buildNextField($config)
 {
     /** @var ColumnSchemaBuilder $row */
     $row = null;
     $length = isset($config['length']) && $config['length'] ? $config['length'] : null;
     $precision = isset($config['precision']) && $config['length'] ? $config['precision'] : null;
     $scale = isset($config['scale']) && $config['length'] ? $config['scale'] : null;
     $this->migrationClass = new Migration(['db' => $this->db]);
     if (!(isset($config['type']) && $config['type'])) {
         throw new \ErrorException("Type field is undefined");
     }
     switch ($config['type']) {
         case Schema::TYPE_PK:
             $row = $this->migrationClass->integer($length);
             break;
         case Schema::TYPE_UPK:
             $row = $this->migrationClass->integer($length);
             break;
         case Schema::TYPE_INTEGER:
             $row = $this->migrationClass->integer($length);
             break;
         case Schema::TYPE_BIGINT:
             $row = $this->migrationClass->bigInteger($length);
             break;
         case Schema::TYPE_BIGPK:
             $row = $this->migrationClass->bigInteger($length);
             break;
         case Schema::TYPE_UBIGPK:
             $row = $this->migrationClass->bigInteger($length);
             break;
         case Schema::TYPE_BINARY:
             $row = $this->migrationClass->binary($length);
             break;
         case Schema::TYPE_CHAR:
             $row = $this->migrationClass->char($length);
             break;
         case Schema::TYPE_TEXT:
             $row = $this->migrationClass->text();
             break;
         case Schema::TYPE_DATE:
             $row = $this->{$this}->migrationClass->date();
             break;
         case Schema::TYPE_DECIMAL:
             $row = $this->migrationClass->decimal($precision, $scale);
             break;
         case Schema::TYPE_DOUBLE:
             $row = $this->migrationClass->double($precision);
             break;
         case Schema::TYPE_FLOAT:
             $row = $this->migrationClass->float($precision);
             break;
         case Schema::TYPE_DATETIME:
             $row = $this->migrationClass->dateTime($precision);
             break;
         case Schema::TYPE_MONEY:
             $row = $this->migrationClass->money($precision, $scale);
             break;
         case Schema::TYPE_SMALLINT:
             $row = $this->migrationClass->smallInteger($length);
             break;
         case Schema::TYPE_TIME:
             $row = $this->migrationClass->time($precision);
             break;
         case Schema::TYPE_TIMESTAMP:
             $row = $this->migrationClass->timestamp($precision);
             break;
         default:
             $row = $this->migrationClass->string($length);
             break;
     }
     if (isset($config['type']) && ($config['type'] == Schema::TYPE_UPK || $config['type'] == Schema::TYPE_UBIGPK) || isset($config['unsigned']) && $config['unsigned']) {
         $row = $row->unsigned();
     }
     if (isset($config['default']) && !empty($config['default'])) {
         $row = $row->defaultValue($config['default']);
     }
     if (isset($config['is_not_null']) && $config['is_not_null']) {
         $row = $row->notNull();
     }
     if (isset($config['comment']) && $config['comment']) {
         $row = $row->comment($config['comment']);
     }
     if (isset($config['isCompositeKey']) && $config['isCompositeKey']) {
         $this->primaryKeys[] = $config['name'];
     }
     $config['related_table'] = isset($config['related_table']) ? trim($config['related_table']) : null;
     $config['related_field'] = isset($config['related_field']) ? trim($config['related_field']) : null;
     if ($config['related_table'] && $config['related_field']) {
         $this->relations[] = ['fk_name' => isset($config['fk_name']) && $config['fk_name'] ? $config['fk_name'] : self::getNameForeignKey($this->tableNameRaw, $config['related_table'], $config['name'], $config['related_field'], 255), 'table_name' => $this->addTablePrefix($this->tableNameRaw), 'field' => $config['name'], 'related_table' => $this->addTablePrefix($config['related_table']), 'related_field' => $config['related_field']];
     }
     return $row;
 }