diff options
| author | Tianhao Wang <shrik3@riseup.net> | 2023-03-29 15:30:14 +0200 |
|---|---|---|
| committer | Tianhao Wang <shrik3@riseup.net> | 2023-03-29 15:30:14 +0200 |
| commit | a05d9ccfd06059aef9ebd2608f16fc0953cf5ab1 (patch) | |
| tree | eb28ad77d6ef2b18ce38ba70e42a8087cda29f3f /catquery.py | |
| parent | 04c0fd709b868400a826bca05c679a8c4f1abb8d (diff) | |
count intimacy, untested
Diffstat (limited to 'catquery.py')
| -rw-r--r-- | catquery.py | 7 |
1 files changed, 7 insertions, 0 deletions
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 +""" |