class.ilPortfolioDBUpdateSteps.php

Go to the documentation of this file.

<?php
 
namespace ILIAS\Portfolio\Setup;
 
class ilPortfolioDBUpdateSteps implements \ilDatabaseUpdateSteps
{
    protected \ilDBInterface $db;
 
    public function prepare(\ilDBInterface $db): void
    {
        $this->db = $db;
    }
 
    public function step_1(): void
    {
        $db = $this->db;
        if (!$db->tableExists('prtf_role_assignment')) {
            $fields = [
                'role_id' => [
                    'type' => 'integer',
                    'length' => 4,
                    'notnull' => true,
                    'default' => 0
                ],
                'template_ref_id' => [
                    'type' => 'integer',
                    'length' => 4,
                    'notnull' => true,
                    'default' => 0
                ]
            ];
            $db->createTable('prtf_role_assignment', $fields);
            $db->addPrimaryKey('prtf_role_assignment', ['role_id', 'template_ref_id']);
        }
    }
 
    public function step_2(): void
    {
        $db = $this->db;
        $db->manipulateF(
            "DELETE FROM usr_portfolio_page WHERE " .
              " type = %s",
            ["integer"],
            [2]
        );
    }
}