GeminiLabs\SiteReviews\Migrations\Migrate_7_1_0::migrateDatabase()

Complexity

Conditions	8
Paths	20

Size

Total Lines	31
Code Lines	21

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

<?php
    public function migrateDatabase(): void
    {
        $indexedColumns = [
            'is_approved',
            'is_flagged',
        ];
        $indexes = glsr(Database::class)->dbGetResults(
            glsr(Query::class)->sql("SHOW INDEXES FROM table|ratings")
        );
        $isDirty = false;
        foreach ($indexedColumns as $column) {
            $indexExists = false;
            foreach ($indexes as $index) {
                if ("glsr_ratings_{$column}_index" === $index->Key_name && $column === $index->Column_name) {
                    $indexExists = true;
                    break;
                }
            }
            if ($indexExists) {
                continue;
            }
            $sql = glsr(Query::class)->sql("
                ALTER TABLE table|ratings ADD INDEX glsr_ratings_{$column}_index ({$column})
            ");
            if (false === glsr(Database::class)->dbQuery($sql)) {
                $isDirty = true;
                glsr_log()->error("The ratings table could not be altered, the [is_approved] index was not added.");
            }
        }
        if (!$isDirty) {
            update_option(glsr()->prefix.'db_version', '1.4');
        }