RemoveCloudDBUpdate.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\Cloud;

class RemoveCloudDBUpdate implements \ilDatabaseUpdateSteps
{
    private ?\ilDBInterface $db = null;

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

    public function step_1(): void
    {
        $this->db->dropTable('il_cld_data', false);
    }

    public function step_2(): void
    {
        $q = "SELECT obj_id FROM object_data WHERE type = %s";
        $res = $this->db->queryF($q, ['text'], ['cld']);
        while ($row = $this->db->fetchAssoc($res)) {
            $this->db->manipulateF('DELETE FROM object_data WHERE id = %s', ['integer'], [$row['obj_id']]);
            $this->db->manipulateF('DELETE FROM object_reference WHERE object_id = %s', ['integer'], [$row['obj_id']]);
            // tree?
        }
    }
}