From e6e9453a024dff943ea52b4fb588f2cf7fec509b Mon Sep 17 00:00:00 2001
From: 简律纯 <i@jyunko.cn>
Date: Mon, 26 Feb 2024 13:21:50 +0800
Subject: refactor(command): 命令词法解析器 (#82)
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

* refactor(command): 重构命令路由

* feat(lua): 包装异步方法`self.event.reply` => `msg:echo`

* feat(lua): 包装异步输入流方法`self.event.ask` => `msg:ask`

* 'Refactored by Sourcery' (#83)

Co-authored-by: Sourcery AI <>

* feat(Token|Lexer): 添加`Token`与`Lexer`类

* refactor(Lexer): 词法分析器添加`advance`方法

* chore: lint code

* refactor: sync gensokyo adapter

* feat: Cli parser (#85)

* feat(cli): 添加`Cli`类，解析命令行参数

* fix: 修复错误的`dest`与`action`

* feat(cli): 实现`install_package` 与 `build_template`

* feat(cli): 实现`-c|--config`指令配置镜像常量等

* feat(cli): 使用高效率的异步网络库`aiohttp`

* fix(cli): `TYPE_CHECKING` with partially module `typing`

* refactor!: examples, tests, src... rewrite in rust

---------

Co-authored-by: sourcery-ai[bot] <58596630+sourcery-ai[bot]@users.noreply.github.com>
---
 tests/test_sqlite3.py | 97 +++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 97 insertions(+)
 create mode 100644 tests/test_sqlite3.py

(limited to 'tests')

diff --git a/tests/test_sqlite3.py b/tests/test_sqlite3.py
new file mode 100644
index 0000000..92b0f59
--- /dev/null
+++ b/tests/test_sqlite3.py
@@ -0,0 +1,97 @@
+import sqlite3
+
+class BottlePlugin:
+    def __init__(self):
+        self.conn = sqlite3.connect('bottles.db')
+        self.cursor = self.conn.cursor()
+        self.create_table()
+
+    def create_table(self):
+        self.cursor.execute('''
+            CREATE TABLE IF NOT EXISTS bottles (
+                id INTEGER PRIMARY KEY AUTOINCREMENT,
+                message TEXT NOT NULL,
+                sender TEXT NOT NULL,
+                receiver TEXT NOT NULL,
+                status INTEGER DEFAULT 0
+            );
+        ''')
+        self.cursor.execute('''
+            CREATE TABLE IF NOT EXISTS comments (
+                id INTEGER PRIMARY KEY AUTOINCREMENT,
+                bottle_id INTEGER NOT NULL,
+                comment TEXT NOT NULL
+            );
+        ''')
+        self.cursor.execute('''
+            CREATE TABLE IF NOT EXISTS likes (
+                id INTEGER PRIMARY KEY AUTOINCREMENT,
+                bottle_id INTEGER NOT NULL,
+                user TEXT NOT NULL
+            );
+        ''')
+        self.conn.commit()
+
+    def throw_bottle(self, message, sender):
+        self.cursor.execute("INSERT INTO bottles (message, sender, receiver) VALUES (?, ?, '')", (message, sender))
+        self.conn.commit()
+
+    def pick_bottle(self, receiver):
+        self.cursor.execute("SELECT id, message, sender FROM bottles WHERE receiver='' OR receiver=? ORDER BY RANDOM() LIMIT 1", (receiver,))
+        row = self.cursor.fetchone()
+        if row is None:
+            return None
+        bottle_id, message, sender = row
+        self.cursor.execute("UPDATE bottles SET receiver=? WHERE id=?", (receiver, bottle_id))
+        self.conn.commit()
+        return {'id': bottle_id, 'message': message, 'sender': sender}
+
+    def add_comment(self, bottle_id, comment):
+        self.cursor.execute("INSERT INTO comments (bottle_id, comment) VALUES (?, ?)", (bottle_id, comment))
+        self.conn.commit()
+
+    def get_comments(self, bottle_id):
+        self.cursor.execute("SELECT comment FROM comments WHERE bottle_id=?", (bottle_id,))
+        rows = self.cursor.fetchall()
+        return [row[0] for row in rows]
+
+    def like_bottle(self, bottle_id, user):
+        self.cursor.execute("INSERT INTO likes (bottle_id, user) VALUES (?, ?)", (bottle_id, user))
+        self.conn.commit()
+
+    def get_likes(self, bottle_id):
+        self.cursor.execute("SELECT user FROM likes WHERE bottle_id=?", (bottle_id,))
+        rows = self.cursor.fetchall()
+        return [row[0] for row in rows]
+
+    def clear_bottles(self):
+        self.cursor.execute("DELETE FROM bottles")
+        self.cursor.execute("DELETE FROM comments")
+        self.cursor.execute("DELETE FROM likes")
+        self.conn.commit()
+
+
+
+
+plugin = BottlePlugin()
+
+# 扔一个漂流瓶
+plugin.throw_bottle('Hello, world!', 'Alice')
+
+# 捡一个漂流瓶
+bottle = plugin.pick_bottle('Bob')
+if bottle is not None:
+    print(bottle)
+
+# 添加评论
+plugin.add_comment(1, 'Nice message!')
+comments = plugin.get_comments(1)
+print(comments)
+
+# 点赞
+plugin.like_bottle(1, 'Charlie')
+likes = plugin.get_likes(1)
+print(likes)
+
+# 清空漂流瓶
+# plugin.clear_bottles()
\ No newline at end of file
-- 
cgit v1.2.3-70-g09d2