• Home
• com.zepben
• evolve-sdk
• 0.23.0
• source code
• ChangeSet49.kt

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

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

/*
 * Copyright 2024 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 changeSet49() = ChangeSet(
    49,
    listOf(
        `Create distance_relays table`,
        `Create protection_relay_schemes table`,
        `Create protection_relay_systems table`,
        `Create voltage_relays table`,
        `Create grounds table`,
        `Create ground_disconnectors table`,
        `Create series_compensators table`,
        `Create protection_relay_function_thresholds table`,
        `Create protection_relay_function_time_limits table`,
        `Create protection_relay_functions_protected_switches`,
        `Create protection_relay_functions_sensors table`,
        `Create protection_relay_schemes_protection_relay_functions`,
        `Rename column current_relay_info_mrid to relay_info_mrid in reclose_delays table`,
        `Rename table current_relay_info to relay_info and add column reclose_fast`,
        `Add model and reclosing columns to current_relays and rename column current_relay_info_mrid to relay_info_mrid`,
        `Add function_mrid column to fuses table`,
        `Add rated_current column to tap_changer_controls table`,
        `Drop protection_equipment_protected_switched table`
    )
)

@Suppress("ObjectPropertyName")
private val `Create distance_relays table` = Change(
    listOf(
        """CREATE TABLE distance_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,
            model TEXT NULL,
            reclosing BOOLEAN NULL,
            relay_delay_time NUMBER NULL,
            protection_kind TEXT NOT NULL,
            directable BOOLEAN NULL,
            power_direction TEXT NOT NULL,
            relay_info_mrid TEXT NULL,
            backward_blind NUMBER NULL,
            backward_reach NUMBER NULL,
            backward_reactance NUMBER NULL,
            forward_blind NUMBER NULL,
            forward_reach NUMBER NULL,
            forward_reactance NUMBER NULL,
            operation_phase_angle1 NUMBER NULL,
            operation_phase_angle2 NUMBER NULL,
            operation_phase_angle3 NUMBER NULL
        );""".trimIndent(),
        "CREATE UNIQUE INDEX distance_relays_mrid ON distance_relays (mrid);",
        "CREATE INDEX distance_relays_name ON distance_relays (name);"
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

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

@Suppress("ObjectPropertyName")
private val `Create protection_relay_systems table` = Change(
    listOf(
        """CREATE TABLE protection_relay_systems (
            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,
            commissioned_date TEXT NULL,
            protection_kind TEXT NOT NULL
        );""".trimIndent(),
        "CREATE UNIQUE INDEX protection_relay_systems_mrid ON protection_relay_systems (mrid);",
        "CREATE INDEX protection_relay_systems_name ON protection_relay_systems (name);"
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

@Suppress("ObjectPropertyName")
private val `Create voltage_relays table` = Change(
    listOf(
        """CREATE TABLE voltage_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,
            model TEXT NULL,
            reclosing BOOLEAN NULL,
            relay_delay_time NUMBER NULL,
            protection_kind TEXT NOT NULL,
            directable BOOLEAN NULL,
            power_direction TEXT NOT NULL,
            relay_info_mrid TEXT NULL
        );""".trimIndent(),
        "CREATE UNIQUE INDEX voltage_relays_mrid ON voltage_relays (mrid);",
        "CREATE INDEX voltage_relays_name ON voltage_relays (name);"
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

@Suppress("ObjectPropertyName")
private val `Create grounds table` = Change(
    listOf(
        """CREATE TABLE grounds (
            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,
            commissioned_date TEXT NULL,
            base_voltage_mrid TEXT NULL
        );""".trimIndent(),
        "CREATE UNIQUE INDEX grounds_mrid ON grounds (mrid);",
        "CREATE INDEX grounds_name ON grounds (name);"
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

@Suppress("ObjectPropertyName")
private val `Create ground_disconnectors table` = Change(
    listOf(
        """CREATE TABLE ground_disconnectors (
            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,
            commissioned_date TEXT NULL,
            base_voltage_mrid TEXT NULL,
            normal_open INTEGER NOT NULL,
            open INTEGER NOT NULL,
            rated_current INTEGER NULL,
            switch_info_mrid TEXT NULL
        );""".trimIndent(),
        "CREATE UNIQUE INDEX ground_disconnectors_mrid ON ground_disconnectors (mrid);",
        "CREATE INDEX ground_disconnectors_name ON ground_disconnectors (name);"
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

@Suppress("ObjectPropertyName")
private val `Create series_compensators table` = Change(
    listOf(
        """CREATE TABLE series_compensators (
            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,
            commissioned_date TEXT NULL,
            base_voltage_mrid TEXT NULL,
            r NUMBER NULL,
            r0 NUMBER NULL,
            x NUMBER NULL,
            x0 NUMBER NULL,
            varistor_rated_current INTEGER NULL,
            varistor_voltage_threshold INTEGER NULL
        );""".trimIndent(),
        "CREATE UNIQUE INDEX series_compensators_mrid ON series_compensators (mrid);",
        "CREATE INDEX series_compensators_name ON series_compensators (name);"
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

@Suppress("ObjectPropertyName")
private val `Create protection_relay_function_thresholds table` = Change(
    listOf(
        """CREATE TABLE protection_relay_function_thresholds (
            protection_relay_function_mrid TEXT NOT NULL,
            sequence_number INTEGER NOT NULL,
            unit_symbol TEXT NOT NULL,
            value NUMBER NOT NULL,
            name TEXT NULL
        );""".trimIndent(),
        """CREATE UNIQUE INDEX protection_relay_function_thresholds_protection_relay_function_mrid_sequence_number
            ON protection_relay_function_thresholds (protection_relay_function_mrid, sequence_number);""".trimIndent(),
        """CREATE INDEX protection_relay_function_thresholds_protection_relay_function_mrid
            ON protection_relay_function_thresholds (protection_relay_function_mrid);""".trimIndent()
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

@Suppress("ObjectPropertyName")
private val `Create protection_relay_function_time_limits table` = Change(
    listOf(
        """CREATE TABLE protection_relay_function_time_limits (
            protection_relay_function_mrid TEXT NOT NULL,
            sequence_number INTEGER NOT NULL,
            time_limit NUMBER NOT NULL
        );""".trimIndent(),
        """CREATE UNIQUE INDEX protection_relay_function_time_limits_protection_relay_function_mrid_sequence_number
            ON protection_relay_function_time_limits (protection_relay_function_mrid, sequence_number);""".trimIndent(),
        """CREATE INDEX protection_relay_function_time_limits_protection_relay_function_mrid
            ON protection_relay_function_time_limits (protection_relay_function_mrid);""".trimIndent()
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

@Suppress("ObjectPropertyName")
private val `Create protection_relay_functions_protected_switches` = Change(
    listOf(
        """CREATE TABLE protection_relay_functions_protected_switches (
            protection_relay_function_mrid TEXT NOT NULL,
            protected_switch_mrid TEXT NOT NULL
        );""".trimIndent(),
        """CREATE UNIQUE INDEX protection_relay_functions_protected_switches_protection_relay_function_mrid_protected_switch_mrid
            ON protection_relay_functions_protected_switches (protection_relay_function_mrid, protected_switch_mrid);""".trimIndent(),
        """CREATE INDEX protection_relay_functions_protected_switches_protection_relay_function_mrid
            ON protection_relay_functions_protected_switches (protection_relay_function_mrid);""".trimIndent(),
        """CREATE INDEX protection_relay_functions_protected_switches_protected_switch_mrid
            ON protection_relay_functions_protected_switches (protected_switch_mrid);""".trimIndent()

    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

@Suppress("ObjectPropertyName")
private val `Create protection_relay_functions_sensors table` = Change(
    listOf(
        """CREATE TABLE protection_relay_functions_sensors (
            protection_relay_function_mrid TEXT NOT NULL,
            sensor_mrid TEXT NOT NULL
        );""".trimIndent(),
        """CREATE UNIQUE INDEX protection_relay_functions_sensors_protection_relay_function_mrid_sensor_mrid
            ON protection_relay_functions_sensors (protection_relay_function_mrid, sensor_mrid);""".trimIndent(),
        """CREATE INDEX protection_relay_functions_sensors_protection_relay_function_mrid
            ON protection_relay_functions_sensors (protection_relay_function_mrid);""".trimIndent(),
        """CREATE INDEX protection_relay_functions_sensors_sensor_mrid
            ON protection_relay_functions_sensors (sensor_mrid);""".trimIndent()
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

@Suppress("ObjectPropertyName")
private val `Create protection_relay_schemes_protection_relay_functions` = Change(
    listOf(
        """CREATE TABLE protection_relay_schemes_protection_relay_functions (
            protection_relay_scheme_mrid TEXT NOT NULL,
            protection_relay_function_mrid TEXT NOT NULL
        );""".trimIndent(),
        """CREATE UNIQUE INDEX protection_relay_schemes_protection_relay_functions_protection_relay_scheme_mrid_protection_relay_function_mrid
            ON protection_relay_schemes_protection_relay_functions (protection_relay_scheme_mrid, protection_relay_function_mrid);""".trimMargin(),
        """CREATE INDEX protection_relay_schemes_protection_relay_functions_protection_relay_scheme_mrid
            ON protection_relay_schemes_protection_relay_functions (protection_relay_scheme_mrid);""".trimIndent(),
        """CREATE INDEX protection_relay_schemes_protection_relay_functions_protection_relay_function_mrid
            ON protection_relay_schemes_protection_relay_functions (protection_relay_function_mrid);""".trimIndent()
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

@Suppress("ObjectPropertyName")
private val `Rename column current_relay_info_mrid to relay_info_mrid in reclose_delays table` = Change(
    listOf(
        "ALTER TABLE reclose_delays RENAME COLUMN current_relay_info_mrid TO relay_info_mrid;",
        "DROP INDEX IF EXISTS reclose_delays_current_relay_info_mrid;",
        "DROP INDEX IF EXISTS reclose_delays_current_relay_info_mrid_sequence_number;",
        "CREATE UNIQUE INDEX reclose_delays_relay_info_mrid_sequence_number ON reclose_delays (relay_info_mrid, sequence_number);",
        "CREATE INDEX reclose_delays_relay_info_mrid ON reclose_delays (relay_info_mrid);"
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

@Suppress("ObjectPropertyName")
private val `Rename table current_relay_info to relay_info and add column reclose_fast` = Change(
    listOf(
        "ALTER TABLE current_relay_info RENAME TO relay_info;",
        "ALTER TABLE relay_info ADD reclose_fast BOOLEAN NULL;",
        "DROP INDEX IF EXISTS current_relay_info_mrid;",
        "DROP INDEX IF EXISTS current_relay_info_name;",
        "CREATE UNIQUE INDEX relay_info_mrid ON relay_info (mrid);",
        "CREATE INDEX relay_info_name ON relay_info (name);"
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

@Suppress("ObjectPropertyName")
private val `Add model and reclosing columns to current_relays and rename column current_relay_info_mrid to relay_info_mrid` = Change(
    listOf(
        "ALTER TABLE current_relays ADD model TEXT NULL;",
        "ALTER TABLE current_relays ADD reclosing BOOLEAN NULL;",
        "ALTER TABLE current_relays RENAME COLUMN current_relay_info_mrid TO relay_info_mrid;"
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

@Suppress("ObjectPropertyName")
private val `Add function_mrid column to fuses table` = Change(
    listOf(
        "ALTER TABLE fuses ADD function_mrid TEXT NULL;"
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

@Suppress("ObjectPropertyName")
private val `Add rated_current column to tap_changer_controls table` = Change(
    listOf(
        "ALTER TABLE tap_changer_controls ADD rated_current NUMBER NULL;"
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)

@Suppress("ObjectPropertyName")
private val `Drop protection_equipment_protected_switched table` = Change(
    listOf(
        "DROP TABLE protection_equipment_protected_switches;"
    ),
    targetDatabases = setOf(DatabaseType.NETWORK_MODEL)
)