<?php

use Phalcon\Mvc\Model\Migration;

class TopikKeluhanBansosMigration_336  extends Migration
{
    public function up()
    {
        $this->down();

        self::$connection->execute("
            UPDATE jaga.topik_diskusi_bansos SET deleted_at = '". date('Y-m-d H:m:s') ."' WHERE deskripsi = 'Bansos - Bantuan yang diterima kualitasnya jelek';
        ");

        self::$connection->execute("
            INSERT INTO jaga.topik_diskusi_bansos (deskripsi, created_at, type)
            VALUES
            ('Bansos - Bantuan Presiden Produktif Usaha Mikro (Bansos UMKM)', now(), 'BANSOS');
            
            SELECT setval(pg_get_serial_sequence('topik_diskusi_bansos', 'id'), coalesce(max(id),0) + 1, false) FROM jaga.topik_diskusi_bansos;
        ");
    }

    public function down()
    {
        self::$connection->execute("
            UPDATE jaga.topik_diskusi_bansos SET deleted_at = NULL WHERE deskripsi = 'Bansos - Bantuan yang diterima kualitasnya jelek';
        ");

        self::$connection->execute("
            DELETE FROM jaga.topik_diskusi_bansos WHERE deskripsi LIKE 'Bansos - Bantuan Presiden Produktif Usaha Mikro (Bansos UMKM)';
            
            SELECT setval(pg_get_serial_sequence('topik_diskusi_bansos', 'id'), coalesce(max(id),0) + 1, false) FROM jaga.topik_diskusi_bansos;
        ");
    }
}