From 40f245e38572c367ae2fbf01bb2a1afa42ec3bd4 Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Tue, 4 Jul 2023 11:09:16 +0200 Subject: [PATCH] find new sensor readings in node-red log --- nl_new.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 nl_new.sql diff --git a/nl_new.sql b/nl_new.sql new file mode 100644 index 0000000..e03f9a2 --- /dev/null +++ b/nl_new.sql @@ -0,0 +1,12 @@ + +create temporary table nl_received as select _id,json->'received' as received from nodelog where json->'received' is not null; + +create temporary table eg_received as select _id,json->'received' as received from eg5120 where json->'received' is not null; + +select count(*) from nl_received where received not in (select received from eg_received) ; + +create table nl_new as select * from nl_received where received not in (select received from eg_received) ; + +select time,mac,addr,"nodeId",json,_id,sensor_type from nodelog where _id in (select _id from nl_new); + +--insert into eg5120 select time,mac,addr,"nodeId",json,sensor_type from nodelog where _id in (select _id from nl_new); -- 2.20.1