qimall/console/migrations/M221011062533UpdateAndInsterQimallTown.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 *
 * Class M221011062533UpdateAndInsterQimallTown
 */
class M221011062533UpdateAndInsterQimallTown extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = "DELETE FROM `qimall_town` WHERE `district_id` = 2953;";
        $sql.= "INSERT INTO `qimall_town`(`district_id`, `adcode`, `name`, `created_at`, `updated_at`) VALUES ";
        $sql.= "(2953, 620103, '白银路街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '草场街街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '东岗街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '东岗西路街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '伏龙坪街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '皋兰路街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '高新区', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '拱星墩街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '广武门街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '火车站街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '嘉峪关路街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '焦家湾街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '靖远路街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '酒泉路街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '临夏路街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '青白石街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '铁路东村街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '铁路西村街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '团结新村街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '渭源路街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '五泉街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '雁北街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '盐场路街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '雁南街道', 1594557804, 1594557804),";
        $sql.= "(2953, 620103, '张掖路街道', 1594557804, 1594557804);";
        $this->execute($sql);
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        echo "M221011062533UpdateAndInsterQimallTown cannot be reverted.\n";

        return false;
    }

    /*
    // Use up()/down() to run migration code without a transaction.
    public function up()
    {

    }

    public function down()
    {
        echo "M221011062533UpdateAndInsterQimallTown cannot be reverted.\n";

        return false;
    }
    */
}