<?php

use Phalcon\Mvc\Model\Migration;

class InsertRoleSpiMigration_562 extends Migration {
    public function up() {
        self::$connection->execute("
            insert into jaga.scopes (name, label, description) values ('spi.observer_rtl', 'View data SPI RTL', 'Lihat data RTL dari KLPD');
            insert into jaga.roles (name, label, description) values ('spi_observer_rtl', 'Observer RTL SPI', 'Administrator Observer untuk data RTL SPI');
            insert into jaga.roles_scopes (role_id, scope_id) values ((select id from jaga.roles where name = 'spi_observer_rtl' limit 1), (select id from jaga.scopes where name = 'spi.observer_rtl' limit 1));
        ");
    }

    public function down() {
        self::$connection->execute("
            delete from jaga.roles_scopes where role_id = (select id from jaga.roles where name = 'spi_observer_rtl' limit 1) and scope_id = (select id from jaga.scopes where name = 'spi.observer_rtl' limit 1);
            delete from jaga.scopes where name = 'spi.observer_rtl';
            delete from jaga.roles where name = 'spi_observer_rtl';
        ");
    }
}