81 Two Channel Vibration Plus

diff --git a/views.sql b/views.sql
index 8bf643a..7e542ca 100644 (file)
--- a/views.sql
+++ b/views.sql
@@ -91,10 +91,72 @@ select time,
        (json->>'battery_percent')::float as battery_percent,
        (json->'counter')::int as counter
 from eg5120
-where sensor_type = 29;
+where sensor_type = 47;
 ;
 grant select on s_47 to gread ;
 drop table sm_47;
 create table sm_47 as select * from s_47;
 grant select on sm_47 to gread ;
 
+-- 81 Two Channel Vibration Plus
+drop view s_81;
+create view s_81 as
+select time,
+       addr,
+       (json->'sensor_type')::int  as sensor_type,
+       (json->'sensor_name')::text as sensor_name,
+       (json->'sensor_data'->'s1_temperature')::float as s1_temperature,
+       (json->'sensor_data'->'s2_temperature')::float as s2_temperature,
+       (json->'sensor_data'->'x1_max_ACC_G')::float as x1_max_ACC_G,
+       (json->'sensor_data'->'x1_rms_ACC_G')::float as x1_rms_ACC_G,
+       (json->'sensor_data'->'x2_max_ACC_G')::float as x2_max_ACC_G,
+       (json->'sensor_data'->'x2_rms_ACC_G')::float as x2_rms_ACC_G,
+       (json->'sensor_data'->'y1_max_ACC_G')::float as y1_max_ACC_G,
+       (json->'sensor_data'->'y1_rms_ACC_G')::float as y1_rms_ACC_G,
+       (json->'sensor_data'->'y2_max_ACC_G')::float as y2_max_ACC_G,
+       (json->'sensor_data'->'y2_rms_ACC_G')::float as y2_rms_ACC_G,
+       (json->'sensor_data'->'z1_max_ACC_G')::float as z1_max_ACC_G,
+       (json->'sensor_data'->'z1_rms_ACC_G')::float as z1_rms_ACC_G,
+       (json->'sensor_data'->'z2_max_ACC_G')::float as z2_max_ACC_G,
+       (json->'sensor_data'->'z2_rms_ACC_G')::float as z2_rms_ACC_G,
+       (json->'sensor_data'->'x1_peak_one_Hz')::float as x1_peak_one_Hz,
+       (json->'sensor_data'->'x1_peak_two_Hz')::float as x1_peak_two_Hz,
+       (json->'sensor_data'->'x2_peak_one_Hz')::float as x2_peak_one_Hz,
+       (json->'sensor_data'->'x2_peak_two_Hz')::float as x2_peak_two_Hz,
+       (json->'sensor_data'->'y1_peak_one_Hz')::float as y1_peak_one_Hz,
+       (json->'sensor_data'->'y1_peak_two_Hz')::float as y1_peak_two_Hz,
+       (json->'sensor_data'->'y2_peak_one_Hz')::float as y2_peak_one_Hz,
+       (json->'sensor_data'->'y2_peak_two_Hz')::float as y2_peak_two_Hz,
+       (json->'sensor_data'->'z1_peak_one_Hz')::float as z1_peak_one_Hz,
+       (json->'sensor_data'->'z1_peak_two_Hz')::float as z1_peak_two_Hz,
+       (json->'sensor_data'->'z2_peak_one_Hz')::float as z2_peak_one_Hz,
+       (json->'sensor_data'->'z2_peak_two_Hz')::float as z2_peak_two_Hz,
+       (json->'sensor_data'->'x1_peak_three_Hz')::float as x1_peak_three_Hz,
+       (json->'sensor_data'->'x2_peak_three_Hz')::float as x2_peak_three_Hz,
+       (json->'sensor_data'->'y1_peak_three_Hz')::float as y1_peak_three_Hz,
+       (json->'sensor_data'->'y2_peak_three_Hz')::float as y2_peak_three_Hz,
+       (json->'sensor_data'->'z1_peak_three_Hz')::float as z1_peak_three_Hz,
+       (json->'sensor_data'->'z2_peak_three_Hz')::float as z2_peak_three_Hz,
+       (json->'sensor_data'->'x1_displacement_mm')::float as x1_displacement_mm,
+       (json->'sensor_data'->'x1_velocity_mm_sec')::float as x1_velocity_mm_sec,
+       (json->'sensor_data'->'x2_displacement_mm')::float as x2_displacement_mm,
+       (json->'sensor_data'->'x2_velocity_mm_sec')::float as x2_velocity_mm_sec,
+       (json->'sensor_data'->'y1_displacement_mm')::float as y1_displacement_mm,
+       (json->'sensor_data'->'y1_velocity_mm_sec')::float as y1_velocity_mm_sec,
+       (json->'sensor_data'->'y2_displacement_mm')::float as y2_displacement_mm,
+       (json->'sensor_data'->'y2_velocity_mm_sec')::float as y2_velocity_mm_sec,
+       (json->'sensor_data'->'z1_displacement_mm')::float as z1_displacement_mm,
+       (json->'sensor_data'->'z1_velocity_mm_sec')::float as z1_velocity_mm_sec,
+       (json->'sensor_data'->'z2_displacement_mm')::float as z2_displacement_mm,
+       (json->'sensor_data'->'z2_velocity_mm_sec')::float as z2_velocity_mm_sec,
+       (json->>'battery')::float as bettery,
+       (json->>'battery_percent')::float as battery_percent,
+       (json->'counter')::int as counter
+from eg5120
+where sensor_type = 81;
+;
+grant select on s_81 to gread ;
+drop table sm_81;
+create table sm_81 as select * from s_81;
+grant select on sm_81 to gread ;
+