ilCertificateDatabaseUpdateSteps Class Reference

Inheritance diagram for ilCertificateDatabaseUpdateSteps:

Collaboration diagram for ilCertificateDatabaseUpdateSteps:

Public Member Functions
	prepare (ilDBInterface $db)
	step_1 ()
	step_2 ()
	step_3 ()
	step_4 ()
	step_5 ()
	step_6 ()
	step_7 ()
	step_8 ()
	step_9 ()
Public Member Functions inherited from ilDatabaseUpdateSteps
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...

Protected Attributes
ilDBInterface	$db

Detailed Description

Definition at line 21 of file class.ilCertificateDatabaseUpdateSteps.php.

Member Function Documentation

prepare()

ilCertificateDatabaseUpdateSteps::prepare

(

ilDBInterface

$db

)

Definition at line 25 of file class.ilCertificateDatabaseUpdateSteps.php.

References $db.

                                              : void
    {
        $this->db = $db;
    }

step_1()

ilCertificateDatabaseUpdateSteps::step_1

(

)

Definition at line 30 of file class.ilCertificateDatabaseUpdateSteps.php.

                            : void
    {
        if ($this->db->tableExists('il_cert_template') && $this->db->tableColumnExists('il_cert_template', 'certificate_content_bu')) {
            $this->db->dropTableColumn('il_cert_template', 'certificate_content_bu');
        }
        if ($this->db->tableExists('il_cert_user_cert') && $this->db->tableColumnExists('il_cert_user_cert', 'certificate_content_bu')) {
            $this->db->dropTableColumn('il_cert_user_cert', 'certificate_content_bu');
        }
    }

step_2()

ilCertificateDatabaseUpdateSteps::step_2

(

)

Definition at line 40 of file class.ilCertificateDatabaseUpdateSteps.php.

                            : void
    {
        if ($this->db->tableExists('il_cert_template') && $this->db->tableColumnExists('il_cert_template', 'certificate_content_backup')) {
            $this->db->dropTableColumn('il_cert_template', 'certificate_content_backup');
        }
        if ($this->db->tableExists('il_cert_user_cert') && $this->db->tableColumnExists('il_cert_user_cert', 'certificate_content_backup')) {
            $this->db->dropTableColumn('il_cert_user_cert', 'certificate_content_backup');
        }
    }

step_3()

ilCertificateDatabaseUpdateSteps::step_3

(

)

Definition at line 50 of file class.ilCertificateDatabaseUpdateSteps.php.

                            : void
    {
        if ($this->db->tableExists('il_cert_bgtask_migr')) {
            $this->db->dropTable('il_cert_bgtask_migr');
        }
    }

step_4()

ilCertificateDatabaseUpdateSteps::step_4

(

)

Definition at line 57 of file class.ilCertificateDatabaseUpdateSteps.php.

                            : void
    {
        if ($this->db->tableExists('il_cert_user_cert') && $this->db->tableColumnExists('il_cert_user_cert', 'user_id')) {
            $this->db->renameTableColumn('il_cert_user_cert', 'user_id', 'usr_id');
        }
    }

step_5()

ilCertificateDatabaseUpdateSteps::step_5

(

)

Definition at line 64 of file class.ilCertificateDatabaseUpdateSteps.php.

                            : void
    {
        if (
            $this->db->tableExists('il_cert_template') &&
            !$this->db->indexExistsByFields('il_cert_template', ['background_image_path', 'currently_active'])
        ) {
            $this->db->addIndex('il_cert_template', ['background_image_path', 'currently_active'], 'i5');
        }

        if (
            $this->db->tableExists('il_cert_user_cert') &&
            !$this->db->indexExistsByFields('il_cert_user_cert', ['background_image_path', 'currently_active'])
        ) {
            $this->db->addIndex('il_cert_user_cert', ['background_image_path', 'currently_active'], 'i7');
        }
    }

step_6()

ilCertificateDatabaseUpdateSteps::step_6

(

)

Definition at line 81 of file class.ilCertificateDatabaseUpdateSteps.php.

References ilDBConstants\T_TEXT.

                            : void
    {
        if ($this->db->tableExists('il_cert_user_cert') &&
            !$this->db->tableColumnExists('il_cert_user_cert', 'certificate_id')) {
            $this->db->addTableColumn('il_cert_user_cert', 'certificate_id', [
                'type' => ilDBConstants::T_TEXT,
                'length' => 64,
                'notnull' => false,
            ]);
        }
    }

step_7()

ilCertificateDatabaseUpdateSteps::step_7

(

)

Definition at line 93 of file class.ilCertificateDatabaseUpdateSteps.php.

References ilDBConstants\T_TEXT.

                            : void
    {
        if ($this->db->tableExists('il_cert_user_cert') &&
            $this->db->tableColumnExists('il_cert_user_cert', 'certificate_id')) {

            try {
                $this->db->dropUniqueConstraint('il_cert_user_cert', 'c1');
            } catch (ilDatabaseException|PDOException) {
                // Nothing to do
            }

            $this->db->manipulateF(
                'UPDATE il_cert_user_cert SET certificate_id = %s WHERE certificate_id IS NULL',
                [ilDBConstants::T_TEXT],
                ['-']
            );

            $this->db->modifyTableColumn('il_cert_user_cert', 'certificate_id', [
                'type' => ilDBConstants::T_TEXT,
                'length' => 64,
                'notnull' => true,
                'default' => '-'
            ]);
        }
    }

step_8()

ilCertificateDatabaseUpdateSteps::step_8

(

)

Definition at line 119 of file class.ilCertificateDatabaseUpdateSteps.php.

References $res, ILIAS\Repository\int(), and ilDBConstants\T_TEXT.

                            : void
    {
        $query = 'SELECT COUNT(*) cnt FROM il_cert_user_cert WHERE certificate_id = ' .
            $this->db->quote('-', ilDBConstants::T_TEXT);
        $res = $this->db->query($query);
        $num = (int) $this->db->fetchAssoc($res)['cnt'];
        if ($num === 0) {
            $this->db->addUniqueConstraint('il_cert_user_cert', ['certificate_id'], 'c1');
        }
    }

Here is the call graph for this function:

step_9()

ilCertificateDatabaseUpdateSteps::step_9

(

)

Definition at line 130 of file class.ilCertificateDatabaseUpdateSteps.php.

References $res, and ilDBConstants\T_TEXT.

                            : void
    {
        if (
            $this->db->tableExists('il_cert_user_cert')
        ) {
            $this->db->addTableColumn(
                'il_cert_user_cert',
                'background_image_ident',
                [
                    'type' => ilDBConstants::T_TEXT,
                    'length' => 255,
                    'notnull' => false,
                ]
            );

            $this->db->addTableColumn(
                'il_cert_user_cert',
                'thumbnail_image_ident',
                [
                    'type' => ilDBConstants::T_TEXT,
                    'length' => 255,
                    'notnull' => false,
                ]
            );
        }

        if (
            $this->db->tableExists('il_cert_template')
        ) {
            $this->db->addTableColumn(
                'il_cert_template',
                'background_image_ident',
                [
                    'type' => ilDBConstants::T_TEXT,
                    'length' => 255,
                    'notnull' => false,
                ]
            );

            $this->db->addTableColumn(
                'il_cert_template',
                'thumbnail_image_ident',
                [
                    'type' => ilDBConstants::T_TEXT,
                    'length' => 255,
                    'notnull' => false,
                ]
            );
        }

        $res = $this->db->query(
            'SELECT value FROM settings WHERE keyword = ' .
            $this->db->quote('defaultImageFileName', ilDBConstants::T_TEXT) . ' AND module = ' .
            $this->db->quote('certificate', ilDBConstants::T_TEXT)
        );
        $row = $this->db->fetchAssoc($res);
        $defaultImageFileName = $row['value'] ?? '';

        $this->db->manipulate(
            'DELETE FROM settings WHERE keyword = ' .
            $this->db->quote('defaultImageFileName', ilDBConstants::T_TEXT) . ' AND module = ' .
            $this->db->quote('certificate', ilDBConstants::T_TEXT)
        );
        $this->db->insert('settings', [
            'module' => [ilDBConstants::T_TEXT, 'certificate'],
            'keyword' => [ilDBConstants::T_TEXT, 'cert_bg_image'],
            'value' => [ilDBConstants::T_TEXT, $defaultImageFileName],
        ]);
    }

Field Documentation

$db

ilDBInterface ilCertificateDatabaseUpdateSteps::$db

protected

Definition at line 23 of file class.ilCertificateDatabaseUpdateSteps.php.

Referenced by prepare().

---

The documentation for this class was generated from the following file:

• components/ILIAS/Certificate/classes/Setup/class.ilCertificateDatabaseUpdateSteps.php