Skip to content

GitLab

and though bugs are the bane of my existence, rest assured the wretched thing will get the best of care here

Merged
Opened by Tillie Kottmann@deletescapeOwner

Create a single table for all senseware node data

Created by: cschloer

https://blocpower.myjetbrains.com/youtrack/issue/DASHB-305

migration script after creating the table:

insert into sensor.senseware_node (created, updated, gateway_id, node_id, space_id, repeater, temperature_probe_1, temperature_probe_2, temperature_probe_3, temperature_probe_4, surface_type, notes, user_created, user_modified)
SELECT created, updated, parent_id as gateway_id, node_id, NULL::int as space_id, False as repeater, Null as temperature_probe_1, Null as temperature_probe_2, Null as temperature_probe_3, Null as temperature_probe_4, node_wall_type as surface_type, notes, user_created, user_modified FROM sensor.apartment_node
 UNION ALL
 SELECT created, updated, parent_id, node_id, NULL::int, False as repeater, temperature_probe_1, temperature_probe_2, temperature_probe_3, temperature_probe_4, Null, notes, user_created, user_modified FROM sensor.boiler_node
  UNION ALL
 SELECT created, updated, parent_id, node_id, NULL::int, True as repeater, Null, Null, Null, Null, Null, notes, user_created, user_modified FROM sensor.repeater_node