class.ilPDFGenerationDB90.php

Go to the documentation of this file.

<?php

class ilPDFGenerationDB90 implements ilDatabaseUpdateSteps
{
    protected ilDBInterface $db;

    public function prepare(ilDBInterface $db): void
    {
        $this->db = $db;
    }

    public function step_1(): void
    {
        if ($this->db->tableExists('pdfgen_conf')) {
            $this->db->dropTable('pdfgen_conf');
        }
    }

    public function step_2(): void
    {
        if ($this->db->tableExists('pdfgen_map')) {
            $this->db->dropTable('pdfgen_map');
        }
    }
    public function step_3(): void
    {
        if ($this->db->tableExists('pdfgen_purposes')) {
            $this->db->dropTable('pdfgen_purposes');
        }
    }

    public function step_4(): void
    {
        if ($this->db->tableExists('pdfgen_renderer')) {
            $this->db->dropTable('pdfgen_renderer');
        }
    }
    public function step_5(): void
    {
        if ($this->db->tableExists('pdfgen_renderer_avail')) {
            $this->db->dropTable('pdfgen_renderer_avail');
        }
    }
    public function step_6(): void
    {
        if ($this->db->tableExists('pdfgen_conf_seq')) {
            $this->db->dropTable('pdfgen_conf_seq');
        }
    }

    public function step_7(): void
    {
        if ($this->db->tableExists('pdfgen_map_seq')) {
            $this->db->dropTable('pdfgen_map_seq');
        }
    }
    public function step_8(): void
    {
        if ($this->db->tableExists('pdfgen_purposes_seq')) {
            $this->db->dropTable('pdfgen_purposes_seq');
        }
    }

    public function step_9(): void
    {
        if ($this->db->tableExists('pdfgen_renderer_seq')) {
            $this->db->dropTable('pdfgen_renderer_seq');
        }
    }
    public function step_10(): void
    {
        if ($this->db->tableExists('pdfgen_renderer_avail_seq')) {
            $this->db->dropTable('pdfgen_renderer_avail_seq');
        }
    }

    public function step_11(): void
    {
        $this->db->manipulateF('DELETE FROM il_object_subobj WHERE subobj = %s',
            array('text'),
            array('pdfg')
        );
    }

    public function step_12(): void
    {
        $this->db->manipulateF('DELETE FROM il_object_def WHERE id = %s',
            array('text'),
            array('pdfg')
        );
    }

    public function step_13(): void
    {
        $res = $this->db->queryF(
            'SELECT obj_id FROM object_data WHERE type = %s AND title = %s',
            array('text', 'text'),
            array('typ', 'pdfg')
        );
        $row = $this->db->fetchAssoc($res);

        if (is_array($row) && isset($row['obj_id'])) {
            $obj_id = $row['obj_id'];

            $this->db->manipulateF(
                'DELETE FROM rbac_ta WHERE typ_id = %s',
                array('integer'),
                array($obj_id)
            );

            $this->db->manipulateF(
                'DELETE FROM object_data WHERE obj_id = %s',
                array('integer'),
                array($obj_id)
            );
        }
    }

    public function step_14(): void
    {
        $this->db->manipulateF('DELETE FROM object_data WHERE type = %s',
            array('text'),
            array('pdfg')
        );
    }
}