catquery.py


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

DB_SCHEMA =  \
"""
CREATE TABLE IF NOT EXISTS
    events(
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            type TEXT,
            remarks TEXT,
            correspond TEXT
            )
"""

QUERY_INSERT_EVENT = \
"""
INSERT INTO events(type, remarks, correspond) VALUES (?,?,?)

"""

QUERY_COUNT_INTERACTION = \
"""
SELECT correspond, count(correspond)
  FROM events
 GROUP by correspond
"""