Skip to content
Teleport

Migration script

  • MySQL
  • Battery power
  • v4 to v5
ALTER TABLE teleport_battery_power
ADD COLUMN power_factor decimal(5, 4) DEFAULT NULL AFTER reactive_power,
ADD COLUMN active_power_setpoint_active_power decimal(23,3) DEFAULT NULL AFTER active_power_setpoint_dispatch_power,
ADD COLUMN active_power_setpoint_charge_to_percentage decimal(23,3) DEFAULT NULL AFTER active_power_setpoint_charge_to_state,
ADD COLUMN setpoints_confirmed_active_power decimal(23,3) DEFAULT NULL AFTER configuration_charge_to_state_percentage,
ADD COLUMN setpoints_confirmed_reactive_power_reactive_power decimal(23,3) DEFAULT NULL AFTER setpoints_confirmed_active_power,
ADD COLUMN setpoints_confirmed_reactive_power_power_factor decimal(5,4) DEFAULT NULL AFTER setpoints_confirmed_reactive_power_reactive_power,
ADD COLUMN setpoints_confirmed_reactive_power_mode varchar(32) DEFAULT NULL AFTER setpoints_confirmed_reactive_power_power_factor,
ADD COLUMN setpoints_confirmed_deliver_fcr decimal(23,3) DEFAULT NULL AFTER setpoints_confirmed_reactive_power_mode,
ADD COLUMN setpoints_confirmed_charge_to_percentage decimal(7,4) DEFAULT NULL AFTER setpoints_confirmed_deliver_fcr,
ADD COLUMN setpoints_desired_active_power_cloud decimal(23,3) DEFAULT NULL AFTER setpoints_confirmed_charge_to_percentage,
ADD COLUMN setpoints_desired_active_power_active_control decimal(23,3) DEFAULT NULL AFTER setpoints_desired_active_power_cloud,
ADD COLUMN setpoints_desired_active_power_grid_operator decimal(23,3) DEFAULT NULL AFTER setpoints_desired_active_power_active_control,
ADD COLUMN setpoints_desired_active_power_modbus_server decimal(23,3) DEFAULT NULL AFTER setpoints_desired_active_power_grid_operator,
ADD COLUMN setpoints_desired_reactive_power_cloud_reactive_power decimal(23,3) DEFAULT NULL AFTER setpoints_desired_active_power_modbus_server,
ADD COLUMN setpoints_desired_reactive_power_cloud_power_factor decimal(5,4) DEFAULT NULL AFTER setpoints_desired_reactive_power_cloud_reactive_power,
ADD COLUMN setpoints_desired_reactive_power_cloud_mode varchar(32) DEFAULT NULL AFTER setpoints_desired_reactive_power_cloud_power_factor,
ADD COLUMN setpoints_desired_reactive_power_grid_operator_reactive_power decimal(23,3) DEFAULT NULL AFTER setpoints_desired_reactive_power_cloud_mode,
ADD COLUMN setpoints_desired_reactive_power_grid_operator_power_factor decimal(5,4) DEFAULT NULL AFTER setpoints_desired_reactive_power_grid_operator_reactive_power,
ADD COLUMN setpoints_desired_reactive_power_grid_operator_mode varchar(32) DEFAULT NULL AFTER setpoints_desired_reactive_power_grid_operator_power_factor,
ADD COLUMN setpoints_desired_charge_to_percentage_cloud decimal(7,4) DEFAULT NULL AFTER setpoints_desired_reactive_power_grid_operator_mode,
ADD COLUMN setpoints_desired_deliver_fcr_cloud decimal(23,3) DEFAULT NULL AFTER setpoints_desired_charge_to_percentage_cloud,
ADD COLUMN setpoints_effective_active_power decimal(23,3) DEFAULT NULL AFTER setpoints_desired_deliver_fcr_cloud,
ADD COLUMN setpoints_effective_reactive_power_reactive_power decimal(23,3) DEFAULT NULL AFTER setpoints_effective_active_power,
ADD COLUMN setpoints_effective_reactive_power_power_factor decimal(5,4) DEFAULT NULL AFTER setpoints_effective_reactive_power_reactive_power,
ADD COLUMN setpoints_effective_reactive_power_mode varchar(32) DEFAULT NULL AFTER setpoints_effective_reactive_power_power_factor;


-- The `configuration` object is deprecated and replaced by `setpoints`.
-- Mappings are applied as follows:
-- `configuration_dispatch_power_active_power` → `setpoints_confirmed_active_power`.
-- `configuration_deliver_fcr_max_rate` → `setpoints_confirmed_deliver_fcr`.
-- `configuration_charge_to_state_percentage` → `setpoints_confirmed_charge_to_percentage`.
-- This transition consolidates configuration parameters into a structured `setpoints_confirmed` object.
-- Following properties are renamed and new columns are created
  -- `active_power_setpoint_dispatch_power` to `active_power_setpoint_active_power`
  -- `active_power_setpoint_charge_to_state` to `active_power_setpoint_charge_to_percentage`
UPDATE teleport_battery_power
SET
  active_power_setpoint_active_power = active_power_setpoint_dispatch_power,
  active_power_setpoint_charge_to_percentage = active_power_setpoint_charge_to_state,
  setpoints_confirmed_active_power = configuration_dispatch_power_active_power,
  setpoints_confirmed_deliver_fcr = configuration_deliver_fcr_max_rate,
  setpoints_confirmed_charge_to_percentage = configuration_charge_to_state_percentage;


ALTER TABLE teleport_battery_power
DROP COLUMN active_power_setpoint_dispatch_power,
DROP COLUMN active_power_setpoint_charge_to_state,
DROP COLUMN configuration_dispatch_power_active_power,
DROP COLUMN configuration_deliver_fcr_max_rate,
DROP COLUMN configuration_charge_to_state_percentage;


ALTER TABLE teleport_battery_power COMMENT = '{"version":5}';