From a05d9ccfd06059aef9ebd2608f16fc0953cf5ab1 Mon Sep 17 00:00:00 2001
From: Tianhao Wang <shrik3@riseup.net>
Date: Wed, 29 Mar 2023 15:30:14 +0200
Subject: count intimacy, untested

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

(limited to 'catquery.py')

diff --git a/catquery.py b/catquery.py
index 7b3bc5c..12921c4 100644
--- a/catquery.py
+++ b/catquery.py
@@ -14,3 +14,10 @@ QUERY_INSERT_EVENT = \
 INSERT INTO events(type, remarks, correspond) VALUES (?,?,?)
 
 """
+
+QUERY_COUNT_INTERACTION = \
+"""
+SELECT correspond, count(correspond)
+  FROM events
+ GROUP by correspond
+"""
-- 
cgit v1.2.3-70-g09d2