MyEMS/myems

-- NOTE: this script is DANGEROUS and may cause data loss so it is for advanced users only
-- NOTE: before running this script, you should stop the myems-normalization service and myems-aggregation service
-- NOTE  after running this script, you should start the myems-normalization service and myems-aggregation service

TRUNCATE TABLE myems_energy_db.tbl_combined_equipment_input_category_hourly;
TRUNCATE TABLE myems_energy_db.tbl_combined_equipment_input_item_hourly;
TRUNCATE TABLE myems_energy_db.tbl_combined_equipment_output_category_hourly;
TRUNCATE TABLE myems_energy_db.tbl_energy_storage_container_charge_hourly;
TRUNCATE TABLE myems_energy_db.tbl_energy_storage_container_discharge_hourly;
TRUNCATE TABLE myems_energy_db.tbl_energy_storage_power_station_charge_hourly;
TRUNCATE TABLE myems_energy_db.tbl_energy_storage_power_station_discharge_hourly;
TRUNCATE TABLE myems_energy_db.tbl_equipment_input_category_hourly;
TRUNCATE TABLE myems_energy_db.tbl_equipment_input_item_hourly;
TRUNCATE TABLE myems_energy_db.tbl_equipment_output_category_hourly;
TRUNCATE TABLE myems_energy_db.tbl_meter_hourly;
TRUNCATE TABLE myems_energy_db.tbl_microgrid_charge_hourly;
TRUNCATE TABLE myems_energy_db.tbl_microgrid_discharge_hourly;
TRUNCATE TABLE myems_energy_db.tbl_microgrid_evcharger_hourly;
TRUNCATE TABLE myems_energy_db.tbl_microgrid_grid_buy_hourly;
TRUNCATE TABLE myems_energy_db.tbl_microgrid_grid_sell_hourly;
TRUNCATE TABLE myems_energy_db.tbl_microgrid_load_hourly;
TRUNCATE TABLE myems_energy_db.tbl_microgrid_photovoltaic_hourly;
-- NOTE: if you truncate tbl_offline_meter_hourly, the offline meter files should be reuploaded
-- TRUNCATE TABLE myems_energy_db.tbl_offline_meter_hourly;
TRUNCATE TABLE myems_energy_db.tbl_shopfloor_input_category_hourly;
TRUNCATE TABLE myems_energy_db.tbl_shopfloor_input_item_hourly;
TRUNCATE TABLE myems_energy_db.tbl_space_input_category_hourly;
TRUNCATE TABLE myems_energy_db.tbl_space_input_item_hourly;
TRUNCATE TABLE myems_energy_db.tbl_space_output_category_hourly;
TRUNCATE TABLE myems_energy_db.tbl_store_input_category_hourly;
TRUNCATE TABLE myems_energy_db.tbl_store_input_item_hourly;
TRUNCATE TABLE myems_energy_db.tbl_tenant_input_category_hourly;
TRUNCATE TABLE myems_energy_db.tbl_tenant_input_item_hourly;
TRUNCATE TABLE myems_energy_db.tbl_virtual_meter_hourly;

TRUNCATE TABLE myems_billing_db.tbl_combined_equipment_input_category_hourly;
TRUNCATE TABLE myems_billing_db.tbl_combined_equipment_input_item_hourly;
TRUNCATE TABLE myems_billing_db.tbl_combined_equipment_output_category_hourly;
TRUNCATE TABLE myems_billing_db.tbl_energy_storage_container_charge_hourly;
TRUNCATE TABLE myems_billing_db.tbl_energy_storage_container_discharge_hourly;
TRUNCATE TABLE myems_billing_db.tbl_energy_storage_power_station_charge_hourly;
TRUNCATE TABLE myems_billing_db.tbl_energy_storage_power_station_discharge_hourly;
TRUNCATE TABLE myems_billing_db.tbl_equipment_input_category_hourly;
TRUNCATE TABLE myems_billing_db.tbl_equipment_input_item_hourly;
TRUNCATE TABLE myems_billing_db.tbl_equipment_output_category_hourly;
TRUNCATE TABLE myems_billing_db.tbl_meter_hourly;
TRUNCATE TABLE myems_billing_db.tbl_microgrid_charge_hourly;
TRUNCATE TABLE myems_billing_db.tbl_microgrid_discharge_hourly;
TRUNCATE TABLE myems_billing_db.tbl_microgrid_evcharger_hourly;
TRUNCATE TABLE myems_billing_db.tbl_microgrid_grid_buy_hourly;
TRUNCATE TABLE myems_billing_db.tbl_microgrid_grid_sell_hourly;
TRUNCATE TABLE myems_billing_db.tbl_microgrid_load_hourly;
TRUNCATE TABLE myems_billing_db.tbl_microgrid_photovoltaic_hourly;
TRUNCATE TABLE myems_billing_db.tbl_offline_meter_hourly;
TRUNCATE TABLE myems_billing_db.tbl_shopfloor_input_category_hourly;
TRUNCATE TABLE myems_billing_db.tbl_shopfloor_input_item_hourly;
TRUNCATE TABLE myems_billing_db.tbl_space_input_category_hourly;
TRUNCATE TABLE myems_billing_db.tbl_space_input_item_hourly;
TRUNCATE TABLE myems_billing_db.tbl_space_output_category_hourly;
TRUNCATE TABLE myems_billing_db.tbl_store_input_category_hourly;
TRUNCATE TABLE myems_billing_db.tbl_store_input_item_hourly;
TRUNCATE TABLE myems_billing_db.tbl_tenant_input_category_hourly;
TRUNCATE TABLE myems_billing_db.tbl_tenant_input_item_hourly;
TRUNCATE TABLE myems_billing_db.tbl_virtual_meter_hourly;

TRUNCATE TABLE myems_carbon_db.tbl_combined_equipment_input_category_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_combined_equipment_input_item_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_combined_equipment_output_category_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_energy_storage_container_charge_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_energy_storage_container_discharge_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_energy_storage_power_station_charge_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_energy_storage_power_station_discharge_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_equipment_input_category_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_equipment_input_item_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_equipment_output_category_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_meter_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_microgrid_charge_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_microgrid_discharge_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_microgrid_evcharger_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_microgrid_grid_buy_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_microgrid_grid_sell_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_microgrid_load_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_microgrid_photovoltaic_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_offline_meter_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_shopfloor_input_category_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_shopfloor_input_item_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_space_input_category_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_space_input_item_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_space_output_category_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_store_input_category_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_store_input_item_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_tenant_input_category_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_tenant_input_item_hourly;
TRUNCATE TABLE myems_carbon_db.tbl_virtual_meter_hourly;