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]
        );
    }
 
    public function step_3(): void
    {
        $db = $this->db;
 
        $set = $db->query("SELECT * FROM usr_portfolio");
        while ($rec = $db->fetchAssoc($set)) {
            $offline = ($rec["is_online"] == 1) ? 0 : 1;
            $db->update(
                "object_data",
                [
                "offline" => ["integer", $offline]
            ],
                [
                    "obj_id" => ["integer", $rec["id"]],
                    "type" => ["text", "prtf"]
                ]
            );
 
        }
    }
 
}