class.ilWikiDBUpdateSteps.php

Go to the documentation of this file.

<?php

namespace ILIAS\Wiki\Setup;

class ilWikiDBUpdateSteps implements \ilDatabaseUpdateSteps
{
    protected \ilDBInterface $db;

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

    public function step_1(): void
    {
        $db = $this->db;
        foreach (["int_links", "ext_links", "footnotes", "num_ratings", "num_words", "avg_rating", "deleted"] as $field) {
            $db->modifyTableColumn('wiki_stat_page', $field, array(
                'type' => 'integer',
                'length' => 4,
                'notnull' => true,
                'default' => 0
            ));
        }
    }

    public function step_2(): void
    {
        $db = $this->db;
        foreach (["num_chars"] as $field) {
            $db->modifyTableColumn('wiki_stat_page', $field, array(
                'type' => 'integer',
                'length' => 8,
                'notnull' => true,
                'default' => 0
            ));
        }
    }

    public function step_3(): void
    {
        $db = $this->db;
        foreach (["num_pages", "del_pages", "avg_rating"] as $field) {
            $db->modifyTableColumn('wiki_stat', $field, array(
                'type' => 'integer',
                'length' => 4,
                'notnull' => true,
                'default' => 0
            ));
        }
    }
}