com.zepben.evolve.database.sqlite.cim.upgrade.changesets.ChangeSet45.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 2022 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 changeSet45() = ChangeSet(
    45,
    listOf(
        `Create new columns on existing tables`,
        `Create switch_info table`,
        `Create current_relay_info table`,
        `Create current_relays table`,
        `Create protection_equipment_protected_switches table`,
    )
)

@Suppress("ObjectPropertyName")
private val `Create new columns on existing tables` = Change(
    listOf(
        "ALTER TABLE breakers ADD switch_info_mrid TEXT NULL;",
        "ALTER TABLE disconnectors ADD switch_info_mrid TEXT NULL;",
        "ALTER TABLE fuses ADD switch_info_mrid TEXT NULL;",
        "ALTER TABLE jumpers ADD switch_info_mrid TEXT NULL;",
        "ALTER TABLE load_break_switches ADD switch_info_mrid TEXT NULL;",
        "ALTER TABLE reclosers ADD switch_info_mrid TEXT NULL;",

        "ALTER TABLE breakers ADD rated_current INTEGER NULL;",
        "ALTER TABLE disconnectors ADD rated_current INTEGER NULL;",
        "ALTER TABLE fuses ADD rated_current INTEGER NULL;",
        "ALTER TABLE jumpers ADD rated_current INTEGER NULL;",
        "ALTER TABLE load_break_switches ADD rated_current INTEGER NULL;",
        "ALTER TABLE reclosers ADD rated_current INTEGER NULL;",

        "ALTER TABLE breakers ADD breaking_capacity INTEGER NULL;",
        "ALTER TABLE load_break_switches ADD breaking_capacity INTEGER NULL;",
        "ALTER TABLE reclosers ADD breaking_capacity INTEGER NULL;",

        "ALTER TABLE breakers ADD in_transit_time NUMBER NULL;",
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

@Suppress("ObjectPropertyName")
private val `Create switch_info table` = Change(
    listOf(
        """
        CREATE TABLE switch_info (
            mrid TEXT NOT NULL,
            name TEXT NOT NULL,
            description TEXT NOT NULL,
            num_diagram_objects INTEGER NOT NULL,
            rated_interrupting_time NUMBER NULL
        );
        """.trimIndent(),
        "CREATE UNIQUE INDEX switch_info_mrid ON switch_info (mrid);",
        "CREATE INDEX switch_info_name ON switch_info (name);"
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

@Suppress("ObjectPropertyName")
private val `Create current_relay_info table` = Change(
    listOf(
        """
        CREATE TABLE current_relay_info (
            mrid TEXT NOT NULL,
            name TEXT NOT NULL,
            description TEXT NOT NULL,
            num_diagram_objects INTEGER NOT NULL,
            curve_setting TEXT NULL
        );
        """.trimIndent(),
        "CREATE UNIQUE INDEX current_relay_info_mrid ON current_relay_info (mrid);",
        "CREATE INDEX current_relay_info_name ON current_relay_info (name);"
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

@Suppress("ObjectPropertyName")
private val `Create current_relays table` = Change(
    listOf(
        """
        CREATE TABLE current_relays (
            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,
            relay_delay_time NUMBER NULL,
            protection_kind TEXT NOT NULL,
            current_limit_1 NUMBER NULL,
            inverse_time_flag BOOLEAN NULL,
            time_delay_1 NUMBER NULL,
            current_relay_info_mrid TEXT NULL
        );
        """.trimIndent(),
        "CREATE UNIQUE INDEX current_relays_mrid ON current_relays (mrid);",
        "CREATE INDEX current_relays_name ON current_relays (name);"
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

@Suppress("ObjectPropertyName")
private val `Create protection_equipment_protected_switches table` = Change(
    listOf(
        """
        CREATE TABLE protection_equipment_protected_switches (
            protection_equipment_mrid TEXT NOT NULL,
            protected_switch_mrid TEXT NOT NULL
        );
        """.trimIndent(),
        """
        CREATE UNIQUE INDEX protection_equipment_protected_switches_protection_equipment_mrid_protected_switch_mrid
        ON protection_equipment_protected_switches (protection_equipment_mrid, protected_switch_mrid);
        """.trimIndent(),
        "CREATE INDEX protection_equipment_protected_switches_protection_equipment_mrid ON protection_equipment_protected_switches (protection_equipment_mrid);",
        "CREATE INDEX protection_equipment_protected_switches_protected_switch_mrid ON protection_equipment_protected_switches (protected_switch_mrid);"
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)