diff options
| author | Tianhao Wang <shrik3@riseup.net> | 2023-03-29 14:27:53 +0200 |
|---|---|---|
| committer | Tianhao Wang <shrik3@riseup.net> | 2023-03-29 14:27:53 +0200 |
| commit | 04c0fd709b868400a826bca05c679a8c4f1abb8d (patch) | |
| tree | c2af369e9b3ec53f011db93350fcc505a31b354c /catquery.py | |
| parent | 7c19ce4ea2c9ae542d743cbdd19e4c0fcf4e3daa (diff) | |
add sqlite3 support
Diffstat (limited to 'catquery.py')
| -rw-r--r-- | catquery.py | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/catquery.py b/catquery.py new file mode 100644 index 0000000..7b3bc5c --- /dev/null +++ b/catquery.py @@ -0,0 +1,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 (?,?,?) + +""" |