How To Corrupt An SQLite Database File<\/a><\/li>\n<\/ul>\n\u6703\u9020\u6210\u8cc7\u6599\u5eab\u640d\u58de\u7684\u539f\u56e0\u5927\u90e8\u5206\u7684\u662f\u540c\u6642\u5beb\u5165\u3002\u6240\u4ee5\u958b\u767c\u81ea\u5df1\u6e2c\u8a66\u6642\u4e00\u5207\u6b63\u5e38\uff0c\u4e0a\u7dda\u5c31\u6703\u51fa\u554f\u984c\u3002<\/p>\n
--<\/p>\n
\u4fee\u5fa9<\/h2>\n \u5c0e\u51fa\u8cc7\u6599<\/p>\n
sqlite3.exe Game.db .dump > dump.sql<\/pre>\n\u5efa\u7acb\u65b0\u8cc7\u6599\u5eab\u53ca\u532f\u5165\u8cc7\u6599<\/p>\n
sqlite3.exe Game.db < dump.sql<\/pre>\n\u4f7f\u7528\u4e92\u52d5\u6a21\u5f0f<\/p>\n
sqlite3.exe Game.db\r\nsqlite>.read dump.sql\r\nsqlite>.quit<\/pre>\n--<\/p>\n
Python \u591a\u7dda\u7a0b\u8cc7\u6599\u5eab\u5beb\u5165\u4f47\u5217\u55ae\u4e00\u5beb\u5165<\/h2>\n app.py<\/p>\n
# App.py \u4e3b\u8981\u90e8\u5206\r\nimport queue\r\n...\r\n\r\nclass App:\r\n def __init__(self):\r\n self.environment = 'company'\r\n self.rs = None\r\n self.cursor = None\r\n self.client = None\r\n self.room_play = {}\r\n\r\n # === DB\u76f8\u95dc ===\r\n self.db_queue = queue.Queue()\r\n self.db_writer_running = True\r\n self.db_lock = threading.Lock()\r\n self.conn = self._init_db_conn()\r\n\r\n threading.Thread(target=self._db_writer_thread, daemon=True).start()\r\n\r\n def _init_db_conn(self):\r\n if self.environment == 'company':\r\n conn = sqlite3.connect('Game.db', isolation_level=None, check_same_thread=False)\r\n else:\r\n conn = sqlite3.connect('\/dev\/shm\/EquationHiLow.sqlite3', isolation_level=None, check_same_thread=False)\r\n conn.row_factory = sqlite3.Row\r\n return conn\r\n\r\n def db_connect(self):\r\n # \u53ea\u7528\u65bc SELECT\r\n return self.conn.cursor()\r\n\r\n def execute_db(self, sql, params=None):\r\n self.db_queue.put((sql, params or {}))\r\n\r\n def _db_writer_thread(self):\r\n while self.db_writer_running:\r\n try:\r\n sql, params = self.db_queue.get()\r\n with self.db_lock:\r\n self.conn.execute(sql, params)\r\n self.conn.commit()\r\n except Exception as e:\r\n logging.error(f\"[DB Write Error] {e}\")\r\n<\/pre>\n <\/p>\n
db.py<\/p>\n
def run(client, self, j):\r\n cursor_select = self.db_connect()\r\n\r\n room_number = 0\r\n i = 0\r\n while i < 10:\r\n room_number = random.randint(100000, 999999)\r\n\r\n sql = \"SELECT * FROM Room WHERE RoomId=:RoomId\"\r\n cursor_select.execute(sql, {'RoomId': room_number})\r\n room = cursor_select.fetchone()\r\n\r\n if not room:\r\n break\r\n i += 1\r\n\r\n try:\r\n sql = \"SELECT * FROM Room WHERE OwnerId=:OwnerId\"\r\n cursor_select.execute(sql, {'OwnerId': j['user_id']})\r\n room = cursor_select.fetchone()\r\n\r\n if room:\r\n # \u6e05\u7406\u4f7f\u7528\u8005\u820a\u8cc7\u6599\uff08\u900f\u904e queue \u5beb\u5165\uff09\r\n self.execute_db(\"DELETE FROM Room WHERE OwnerId=:OwnerId\", {'OwnerId': j['user_id']})\r\n self.execute_db(\"DELETE FROM RoomStatus WHERE RoomId=:RoomId\", {'RoomId': room['RoomId']})\r\n self.execute_db(\"DELETE FROM Player WHERE RoomId=:RoomId\", {'RoomId': room['RoomId']})\r\n\r\n self.execute_db(\r\n \"INSERT INTO Room (RoomId, Name, OwnerId, Status) VALUES (:RoomId, :Name, :OwnerId, 0)\",\r\n {\r\n 'RoomId': room_number,\r\n 'Name': j['name'],\r\n 'OwnerId': j['user_id'],\r\n }\r\n )\r\n\r\n self.execute_db(\r\n \"INSERT INTO RoomStatus (RoomId, `Order`, People) VALUES (:RoomId, 1, :People)\",\r\n {\r\n 'RoomId': room_number,\r\n 'People': int(j['people']),\r\n }\r\n )\r\n\r\n except Exception as e:\r\n logging.error(e)\r\n\r\n send_command = {\r\n \"command\": 'create_room_ok',\r\n }\r\n send_command = str(json.dumps(send_command))\r\n client.publish('EquationHiLow\/' + j['user_id'], send_command.encode())\r\n\r\n # \u547c\u53eb get_lobby \u66f4\u65b0\r\n get_lobby_run(client, self, j)\r\n<\/pre>\n <\/p>\n
--<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> 704 total views, 2 views today<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
-- \u70ba\u4ec0\u9ebc\uff1f How To ...<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> 704 total views, 2 views today<\/p>\n<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[352],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/7548"}],"collection":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7548"}],"version-history":[{"count":14,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/7548\/revisions"}],"predecessor-version":[{"id":14385,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/7548\/revisions\/14385"}],"wp:attachment":[{"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7548"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7548"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.hoyo.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}