telemetry/sql/mock-data.sql

INSERT INTO maplog.campaign(name, description, from_time, to_time) VALUES ('Test Campaign', 'Description of the Test Campaign', '2023-01-01 12:00:00.400922 +00:00', '2024-01-01 12:00:00.400922 +00:00');

INSERT INTO maplog.unit_type(unit_type_id, type_name, description) VALUES ('X', 'Telemetry', 'Mobile Telemetry Unit');

INSERT INTO maplog.unit(unit_id, imei, unit_type_id, description) VALUES (1000, '867648041484898', 'X',  'Testing Telemetry unit');

INSERT INTO maplog.unit_to_campaign(camp_id, unit_id, from_time, to_time) SELECT campaign_id, 1000, from_time, to_time FROM maplog.campaign;

INSERT INTO maplog.phenomenon(phenomenon_name, uom) VALUES ('Default phenomenon', 'no UOM');

INSERT INTO maplog.sensor(sensor_id, sensor_name, sensor_type_id, phenomenon_id) VALUES (360200000, 'IO Property 66', 66, 1);
INSERT INTO maplog.sensor(sensor_id, sensor_name, sensor_type_id, phenomenon_id) VALUES (360300000, 'IO Property 239', 239, 1);
INSERT INTO maplog.sensor(sensor_id, sensor_name, sensor_type_id, phenomenon_id) VALUES (360400000, 'IO Property 67', 67, 1);
INSERT INTO maplog.sensor(sensor_id, sensor_name, sensor_type_id, phenomenon_id) VALUES (360500000, 'IO Property 24', 24, 1);
INSERT INTO maplog.sensor(sensor_id, sensor_name, sensor_type_id, phenomenon_id) VALUES (360700000, 'IO Property 78', 78, 1);