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

Complexity

Conditions	6
Paths	18

Size

Total Lines	27
Code Lines	16

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	1	Features	1

<?php
    public function migrateDatabase(): void
    {
        $isDirty = false;
        $indexes = glsr(Database::class)->dbGetResults(
            glsr(Query::class)->sql("SHOW INDEXES FROM table|ratings")
        );
        $keyNames = wp_list_pluck($indexes, 'Key_name');
        if (!in_array('glsr_ratings_rating_type_is_approved_index', $keyNames)) {
            $sql = glsr(Query::class)->sql("
                ALTER TABLE table|ratings ADD INDEX glsr_ratings_rating_type_is_approved_index (rating,type,is_approved)
            ");
            if (false === glsr(Database::class)->dbQuery($sql)) {
                $isDirty = true;
                glsr_log()->error("The ratings table could not be altered, the [rating_type_is_approved] index was not added.");
            }
        }
        if (!in_array('glsr_ratings_is_flagged_index', $keyNames)) {
            $sql = glsr(Query::class)->sql("
                ALTER TABLE table|ratings ADD INDEX glsr_ratings_is_flagged_index (is_flagged)
            ");
            if (false === glsr(Database::class)->dbQuery($sql)) {
                $isDirty = true;
                glsr_log()->error("The ratings table could not be altered, the [is_flagged] index was not added.");
            }
        }
        if (!$isDirty) {
            update_option(glsr()->prefix.'db_version', '1.4');
        }