<?php

use Phinx\Migration\AbstractMigration;

class NewStatus extends AbstractMigration
{
    /**
     * Migrate Up.
     */
    public function up()
    {
        // inserting only one row
        $singleRow = [
            "id"    => 1,
            "name"  => "In Progress"
        ]

        $table = $this->table("status");
        $table->insert($singleRow);
        $table->saveData();

        // inserting multiple rows
        $rows = [
            [
              "id"    => 2,
              "name"  => "Stopped"
            ],
            [
              "id"    => 3,
              "name"  => "Queued"
            ]
        ];

        // this is a handy shortcut
        $this->insert("status", $rows);
    }

    /**
     * Migrate Down.
     */
    public function down()
    {
        $this->execute("DELETE FROM status");
    }
}