interactions based on intimacy

1 files changed, 25 insertions, 0 deletions

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;
+"""