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 ()
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.

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

References $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');
        }
    }

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:

• Services/Certificate/classes/Setup/class.ilCertificateDatabaseUpdateSteps.php