<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2011161335 extends AbstractMigration
{
    public function up(): void
    {
        $builder = $this->getQueryBuilder();
        $builder->update('sinistro.avisos')
                ->set('id_status', 28)
                ->where(['id' => 84727, 'id_proposta' => 444027])
                ->execute();
        $delete = $this->getQueryBuilder();
        $delete->delete('sinistro.avisos_log_mudanca_status')
               ->where(['id_aviso' => 84727, 'id' => 569])
               ->execute();
    }

    public function down(): void
    {
        $builder = $this->getQueryBuilder();
        $builder->update('sinistro.avisos')
                ->set('id_status', '168')
                ->where(['id' => 84727, 'id_proposta' => 444027])
                ->execute();
        $table = $this->table('sinistro.avisos_log_mudanca_status');
        $singleRow = [
                       'id_usuario_criacao' => 1854
                     , 'dt_criacao' => '2020-11-16 10:21:06-03'
                     , 'id' => 569
                     , 'id_aviso' => 84727
                     , 'id_status_antigo' => 28
                     , 'id_status_novo' => 168
        ];
        $table->insert($singleRow)
              ->saveData();
    }
}