ILIAS  trunk Revision v11.0_alpha-3011-gc6b235a2e85
RemoveCloudDBUpdate.php
Go to the documentation of this file.
1<?php
2
19declare(strict_types=1);
20
21namespace ILIAS\Cloud;
22
24{
25 private ?\ilDBInterface $db = null;
26
27 public function prepare(\ilDBInterface $db): void
28 {
29 $this->db = $db;
30 }
31
32 public function step_1(): void
33 {
34 $this->db->dropTable('il_cld_data', false);
35 }
36
37 public function step_2(): void
38 {
39 $q = "SELECT obj_id FROM object_data WHERE type = %s";
40 $res = $this->db->queryF($q, ['text'], ['cld']);
41 while ($row = $this->db->fetchAssoc($res)) {
42 $this->db->manipulateF('DELETE FROM object_data WHERE id = %s', ['integer'], [$row['obj_id']]);
43 $this->db->manipulateF('DELETE FROM object_reference WHERE object_id = %s', ['integer'], [$row['obj_id']]);
44 // tree?
45 }
46 }
47}
prepare(\ilDBInterface $db)
Prepare the execution of the steps.
Interface ilDBInterface.
This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Le...
$res
Definition: ltiservices.php:69
$q
Definition: shib_logout.php:23