find new sensor readings in node-red log

diff --git a/nl_new.sql b/nl_new.sql
new file mode 100644 (file)
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);