com.zepben.evolve.database.sqlite.cim.upgrade.changesets.ChangeSet46.kt Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of evolve-sdk Show documentation

SDK for interaction with the evolve platform

There is a newer version: 0.24.0rc1

/*
 * Copyright 2023 Zeppelin Bend Pty Ltd
 *
 * This Source Code Form is subject to the terms of the Mozilla Public
 * License, v. 2.0. If a copy of the MPL was not distributed with this
 * file, You can obtain one at https://mozilla.org/MPL/2.0/.
 */

package com.zepben.evolve.database.sqlite.cim.upgrade.changesets

import com.zepben.evolve.database.sqlite.cim.upgrade.Change
import com.zepben.evolve.database.sqlite.cim.upgrade.ChangeSet
import com.zepben.evolve.database.paths.DatabaseType

internal fun changeSet46() = ChangeSet(
    46,
    listOf(
        `Make potential_transformers type non-null`
    )
)

// Non-null columns cannot be added to existing tables without specifying a default, which cannot be removed later.
// This has the side effect of allowing the field to be unspecified when inserting new entries, unlike other non-null fields in our schema.
// This is why an entire new table is created instead, with the values from the old table copied over.
// We can revisit this when SQLite adds proper support for ALTER COLUMN.
@Suppress("ObjectPropertyName")
private val `Make potential_transformers type non-null` = Change(
    listOf(
        """
        CREATE TABLE potential_transformers_new (
            mrid TEXT NOT NULL,
            name TEXT NOT NULL,
            description TEXT NOT NULL,
            num_diagram_objects INTEGER NOT NULL,
            location_mrid TEXT NULL,
            num_controls INTEGER NOT NULL,
            normally_in_service BOOLEAN,
            in_service BOOLEAN,
            terminal_mrid TEXT NULL,
            potential_transformer_info_mrid TEXT NULL,
            type TEXT NOT NULL
        );
        """.trimIndent(),
        """
        INSERT INTO potential_transformers_new
        SELECT 
            mrid,
            name,
            description,
            num_diagram_objects,
            location_mrid,
            num_controls,
            normally_in_service,
            in_service,
            terminal_mrid,
            potential_transformer_info_mrid,
            IFNULL(type, 'UNKNOWN')
        FROM potential_transformers;
        """.trimIndent(),
        "DROP TABLE potential_transformers;",
        "ALTER TABLE potential_transformers_new RENAME TO potential_transformers;",
        "CREATE UNIQUE INDEX potential_transformers_mrid ON potential_transformers (mrid);",
        "CREATE INDEX potential_transformers_name ON potential_transformers (name);"
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)