<?php

use Phalcon\Mvc\Model\Migration;

class RoleScopeMcpFaqEditorMigration_507 extends Migration {
    public function up() {
        self::$connection->execute("
            INSERT INTO jaga.roles(name, label, description) VALUES ('faq_korsup_editor', 'Editor FAQ Korsup', 'Editor FAQ Korsup');
        ");

        self::$connection->execute("
            INSERT INTO jaga.scopes(name, label, description) VALUES ('korsup.faq.editor', 'Editor FAQ Korsup', 'Editor FAQ Korsup');
        ");
        self::$connection->execute("
            INSERT INTO jaga.roles_scopes (role_id, scope_id)
                SELECT r.id, s.id
                    FROM jaga.roles r
                    JOIN jaga.scopes s ON r.name = 'faq_korsup_editor' and s.name = 'korsup.faq.editor' ON CONFLICT DO NOTHING;
        ");
    }

    public function down() {
        self::$connection->execute("
            DELETE 
            FROM
            	jaga.roles_scopes 
            WHERE
            	role_id = ( SELECT ID FROM jaga.roles WHERE NAME = 'faq_korsup_editor')
                and scope_id in (SELECT id from jaga.scopes where name = 'korsup.faq.editor');
        ");

        self::$connection->execute("
            DELETE FROM jaga.roles WHERE name = 'faq_korsup_editor';
        ");

        self::$connection->execute("
            DELETE FROM jaga.scopes WHERE name = 'korsup.faq.editor';
        ");
    }
}