<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class TaskSr55737 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute("CREATE TABLE manutencao.bkp_email_proponente AS
                            SELECT id
                                 , ds_email_proponente
                              FROM seguro.proponentes
                                 ;
                      ");

        $builder = $this->getQueryBuilder();
        $builder->update('seguro.proponentes')
                ->set('ds_email_proponente', NULL)
                ->where(['id' > 1])
                ->execute();
    }

    public function down(): void
    {
        $this->execute("UPDATE seguro.proponentes
                           SET ds_email_proponente = bkp_email_proponente.ds_email_proponente
                          FROM manutencao.bkp_email_proponente
                         WHERE bkp_email_proponente.id = proponentes.id
                             ;
                       ");
        
        $this->table('manutencao.bkp_email_proponente')
             ->drop()
             ->save();
    }
}