Added session duration metrics with device analytics along with device

analytics metrics in the DB to aggregate and DeviceID abuse prevention

1 files changed, 11 insertions, 0 deletions

diff --git a/query/device_analytics.sql b/query/device_analytics.sql
new file mode 100644
index 0000000..92287af
--- /dev/null
+++ b/query/device_analytics.sql
@@ -0,0 +1,11 @@
+-- name: SetDeviceAnalytics :one
+INSERT INTO device_analytics (
+  device_id, os, arch, term, colorterm
+) VALUES (
+  @device_id, @os, @arch, @term, @colorterm
+)
+ON CONFLICT DO
+UPDATE SET
+  os = EXCLUDED.os, arch = EXCLUDED.arch, term = EXCLUDED.term, colorterm = EXCLUDED.colorterm
+WHERE device_id = EXCLUDED.device_id
+RETURNING *;