<?php

use Phalcon\Mvc\Model\Migration;

class InsertstranasinstansitypeMigration_543  extends Migration {
    public function up()
    {
        $host = getenv('DB_HOST_STRANAS_2025');
        $dbname = getenv('DB_NAME_STRANAS_2025');
        $username = getenv('DB_USERNAME_STRANAS_2025');
        $password = getenv('DB_PASSWORD_STRANAS_2025');
        $port = getenv('DB_PORT_STRANAS_2025');

        $dsn = "pgsql:host=$host;port=$port;dbname=$dbname";
        try {
            $pdo = new PDO($dsn, $username, $password);
            $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

            $pdo->exec("
                INSERT INTO stranas.m_jenis_instansi (id, kode_instansi) VALUES (1, 'kementerian lembaga');
                INSERT INTO stranas.m_jenis_instansi (id, kode_instansi) VALUES (2, 'provinsi');
                INSERT INTO stranas.m_jenis_instansi (id, kode_instansi) VALUES (3, 'kabupaten / kota');
            ");
        } catch (PDOException $e) {
            echo 'Connection failed: ' . $e->getMessage();
        }
    }

    public function down()
    {
        $host = getenv('DB_HOST_STRANAS_2025');
        $dbname = getenv('DB_NAME_STRANAS_2025');
        $username = getenv('DB_USERNAME_STRANAS_2025');
        $password = getenv('DB_PASSWORD_STRANAS_2025');
        $port = getenv('DB_PORT_STRANAS_2025');

        $dsn = "pgsql:host=$host;port=$port;dbname=$dbname";
        try {
            $pdo = new PDO($dsn, $username, $password);
            $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

            $pdo->exec("
                DELETE FROM stranas.m_jenis_instansi WHERE id IN (1, 2, 3);
            ");
        } catch (PDOException $e) {
            echo 'Connection failed: ' . $e->getMessage();
        }
    }
}