From 7b3ef7a4726ba1e76f99b8569767aea5be99a1f5 Mon Sep 17 00:00:00 2001
From: Tianhao Wang <wth@riseup.net>
Date: Thu, 11 Jan 2024 13:50:41 +0000
Subject: interactions based on intimacy

---
 catquery.py | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)

(limited to 'catquery.py')

diff --git a/catquery.py b/catquery.py
index 12921c4..10d5b37 100644
--- a/catquery.py
+++ b/catquery.py
@@ -21,3 +21,28 @@ SELECT correspond, count(correspond)
   FROM events
  GROUP by correspond
 """
+
+
+DB_SCHEMA_INT = \
+"""
+CREATE TABLE IF NOT EXISTS
+    intimacy(
+            correspond TEXT PRIMARY KEY,
+			score INTEGER
+            )
+
+"""
+
+QUERY_UPDATE_INT = \
+"""
+INSERT INTO intimacy(correspond,score)
+  VALUES(?1, 0)
+  ON CONFLICT(correspond) DO UPDATE SET
+	score=score+1
+  WHERE correspond=?2
+"""
+
+QUERY_GET_INT = \
+"""
+SELECT correspond, score FROM intimacy;
+"""
-- 
cgit v1.2.3-70-g09d2