catquery.py


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

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 (?,?,?)

"""