Migrations¶

$ bin/cake bake migration CreateProducts name:string description:text created modified

* o nome da migração que você irá gerar (``CreateProducts`` por exemplo)
* as colunas da tabela que serão adicionadas ou removidas na migração
(``name:string description:text created modified`` no nosso caso)

$ bin/cake migrations create MyCustomMigration

$ bin/cake bake migration CreateProducts name:string description:text created modified

<?php
use Migrations\AbstractMigration;

class CreateProducts extends AbstractMigration
{
    /**
     * Change Method.
     *
     * More information on this method is available here:
     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
     * @return void
     */
    public function change()
    {
        $table = $this->table('products');
        $table->addColumn('name', 'string', [
            'default' => null,
            'limit' => 255,
            'null' => false,
        ]);
        $table->addColumn('description', 'text', [
            'default' => null,
            'null' => false,
        ]);
        $table->addColumn('created', 'datetime', [
            'default' => null,
            'null' => false,
        ]);
        $table->addColumn('modified', 'datetime', [
            'default' => null,
            'null' => false,
        ]);
        $table->create();
    }
}

$ bin/cake bake migration AddPriceToProducts price:decimal

<?php
use Migrations\AbstractMigration;

class AddPriceToProducts extends AbstractMigration
{
    public function change()
    {
        $table = $this->table('products');
        $table->addColumn('price', 'decimal')
              ->update();
    }
}

$ bin/cake bake migration AddNameIndexToProducts name:string:index

<?php
use Migrations\AbstractMigration;

class AddNameIndexToProducts extends AbstractMigration
{
    public function change()
    {
        $table = $this->table('products');
        $table->addColumn('name', 'string')
              ->addIndex(['name'])
              ->update();
    }
}

$ bin/cake bake migration AddFullDescriptionToProducts full_description:string[60]

<?php
use Migrations\AbstractMigration;

class AddFullDescriptionToProducts extends AbstractMigration
{
    public function change()
    {
        $table = $this->table('products');
        $table->addColumn('full_description', 'string', [
            'default' => null,
            'limit' => 60,
            'null' => false,
        ])
        ->update();
    }
}

<?php
use Migrations\AbstractMigration;

class AlterPriceFromProducts extends AbstractMigration
{
    public function change()
    {
        $table = $this->table('products');
        $table->changeColumn('name', 'float');
        $table->update();
    }
}

$ bin/cake bake migration RemovePriceFromProducts price

<?php
use Migrations\AbstractMigration;

class RemovePriceFromProducts extends AbstractMigration
{
    public function change()
    {
        $table = $this->table('products');
        $table->removeColumn('price');
    }
}

# Executa todas as migrações
$ bin/cake migrations migrate

# Execute uma migração específica utilizando a opção ``--target`` ou ``-t``
# O valor é um timestamp que serve como prefixo para cada migração::
$ bin/cake migrations migrate -t 20150103081132

# Por padrão, as migrações ficam no diretório **config/Migrations**. Você
# pode especificar um diretório utilizando a opção ``--source`` ou ``-s``.
# O comando abaixo executa as migrações no diretório **config/Alternate**
$ bin/cake migrations migrate -s Alternate

# Você pode executar as migrações de uma conexão diferente da ``default``
# utilizando a opção ``--connection`` ou ``-c``.
$ bin/cake migrations migrate -c my_custom_connection

# Migrações também podem ser executadas para plugins. Simplesmente utilize
# a opção ``--plugin`` ou ``-p``
$ bin/cake migrations migrate -p MyAwesomePlugin

# Você pode desfazer uma migração anterior utilizando o
# comando ``rollback``::
$ bin/cake migrations rollback

# Você também pode passar a versão da migração para voltar
# para uma versão específica::
$ bin/cake migrations rollback -t 20150103081132

$ bin/cake migrations status

$ bin/cake migrations status --format json

$ bin/cake migrations mark_migrated

$ bin/cake migrations mark_migrated --target=20151016204000

$ bin/cake migrations mark_migrated --target=20151016204000 --exclude

$ bin/cake migrations mark_migrated --target=20151016204000 --only

$ bin/cake migrations mark_migrated

$ bin/cake migrations mark_migrated all

# This will create a ArticlesSeed.php file in the directory config/Seeds of your application
# By default, the table the seed will try to alter is the "tableized" version of the seed filename
$ bin/cake bake seed Articles

# You specify the name of the table the seed files will alter by using the ``--table`` option
$ bin/cake bake seed Articles --table my_articles_table

# You can specify a plugin to bake into
$ bin/cake bake seed Articles --plugin PluginName

# You can specify an alternative connection when generating a seeder.
$ bin/cake bake seed Articles --connection connection

$ bin/cake bake seed --data Articles

# Exportará apenas as 10 primeiras linhas encontradas
$ bin/cake bake seed --data --limit 10 Articles

# Exportará apenas os campos `id`, `title` e `excerpt`
$ bin/cake bake seed --data --fields id,title,excerpt Articles

# Without parameters, the seed subcommand will run all available seeders
# in the target directory, in alphabetical order.
$ bin/cake migrations seed

# You can specify only one seeder to be run using the `--seed` option
$ bin/cake migrations seed --seed ArticlesSeed

# You can run seeders from an alternative directory
$ bin/cake migrations seed --source AlternativeSeeds

# You can run seeders from a plugin
$ bin/cake migrations seed --plugin PluginName

# You can run seeders from a specific connection
$ bin/cake migrations seed --connection connection

<?php
use Migrations\AbstractMigration;

class CreateProductsTable extends AbstractMigration
{
    public function change()
    {
        $table = $this->table('products', ['id' => false, 'primary_key' => ['id']]);
        $table
              ->addColumn('id', 'uuid')
              ->addColumn('name', 'string')
              ->addColumn('description', 'text')
              ->create();
    }
}

<?php
use Migrations\AbstractMigration;

class CreateProductsTable extends AbstractMigration
{

    public bool $autoId = false;

    public function up()
    {
        $table = $this->table('products');
        $table
            ->addColumn('id', 'integer', [
                'autoIncrement' => true,
                'limit' => 11
            ])
            ->addPrimaryKey('id')
            ->addColumn('name', 'string')
            ->addColumn('description', 'text')
            ->create();
    }
}

<?php
use Migrations\AbstractMigration;

class CreateCategoriesTable extends AbstractMigration
{
    public function change()
    {
        $table = $this
            ->table('categories', [
                'collation' => 'latin1_german1_ci'
            ])
            ->addColumn('title', 'string', [
                'default' => null,
                'limit' => 255,
                'null' => false,
            ])
            ->create();
    }
}

$ bin/cake schema_cache clear