From 04c0fd709b868400a826bca05c679a8c4f1abb8d Mon Sep 17 00:00:00 2001
From: Tianhao Wang <shrik3@riseup.net>
Date: Wed, 29 Mar 2023 14:27:53 +0200
Subject: add sqlite3 support

---
 catquery.py | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)
 create mode 100644 catquery.py

(limited to 'catquery.py')

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 (?,?,?)
+
+"""
-- 
cgit v1.2.3-70-g09d2