DualOptInDatabaseUpdateSteps.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
namespace ILIAS\Registration\DualOptIn\Setup;
 
use ILIAS\Data\UUID\Factory as UUIDFactory;
 
class DualOptInDatabaseUpdateSteps implements \ilDatabaseUpdateSteps
{
    protected \ilDBInterface $db;
 
    public function prepare(\ilDBInterface $db): void
    {
        $this->db = $db;
    }
 
    public function step_1(): void
    {
        if ($this->db->tableExists('reg_dual_opt_in')) {
            return;
        }
 
        $fields = [
            'id' => [
                'type' => \ilDBConstants::T_TEXT,
                'length' => 36,
                'fixed' => true,
                'notnull' => true,
            ],
            'usr_id' => [
                'type' => \ilDBConstants::T_INTEGER,
                'length' => 8,
                'notnull' => true
            ],
            'reg_hash' => [
                'type' => \ilDBConstants::T_TEXT,
                'length' => 16,
                'fixed' => true,
                'notnull' => true
            ],
            'creation_date' => [
                'type' => \ilDBConstants::T_INTEGER,
                'length' => 8,
                'notnull' => true
            ]
        ];
 
        $this->db->createTable('reg_dual_opt_in', $fields);
        $this->db->addPrimaryKey('reg_dual_opt_in', ['id']);
    }
 
    public function step_2(): void
    {
        if (!$this->db->tableExists('usr_data') ||
            !$this->db->tableColumnExists('usr_data', 'reg_hash')) {
            return;
        }
 
        $res = $this->db->query(
            <<<SQL
            SELECT ud.usr_id, ud.reg_hash, ud.create_date
            FROM usr_data ud
            INNER JOIN object_data od ON od.obj_id = ud.usr_id
            WHERE ud.reg_hash IS NOT NULL AND ud.reg_hash <> ''
SQL
        );
 
        while ($row = $res->fetchRow(\ilDBConstants::FETCHMODE_OBJECT)) {
            $this->db->manipulateF(
                'INSERT INTO reg_dual_opt_in (id, usr_id, reg_hash, creation_date) VALUES (%s, %s, %s, %s)',
                [
                    \ilDBConstants::T_TEXT,
                    \ilDBConstants::T_INTEGER,
                    \ilDBConstants::T_TEXT,
                    \ilDBConstants::T_INTEGER
                ],
                [
                    (new UUIDFactory())->uuid4(),
                    $row->usr_id,
                    $row->reg_hash,
                    (new \DateTimeImmutable($row->create_date, new \DateTimeZone('UTC')))->getTimestamp()
                ]
            );
        }
    }
 
    public function step_3(): void
    {
        if (!$this->db->tableExists('usr_data') ||
            !$this->db->tableColumnExists('usr_data', 'reg_hash')) {
            return;
        }
 
        $this->db->dropTableColumn('usr_data', 'reg_hash');
    }
 
    public function step_4(): void
    {
        if ($this->db->tableExists('reg_dual_opt_in') &&
            !$this->db->indexExistsByFields('reg_dual_opt_in', ['reg_hash'])) {
            $this->db->addIndex('reg_dual_opt_in', ['reg_hash'], 'i1');
        }
 
        if ($this->db->tableExists('reg_dual_opt_in') &&
            !$this->db->indexExistsByFields('reg_dual_opt_in', ['usr_id'])) {
            $this->db->addIndex('reg_dual_opt_in', ['usr_id'], 'i2');
        }
    }
}