mirror of
https://github.com/pandorafuture/wx-cli.git
synced 2026-09-01 04:01:20 +00:00
pandorafuture
96ccbbdc3d
WeChat macOS database decryption and query tool, supporting key extraction, message querying, full-text search, conversation export, real-time monitoring, media handling, and HTTP server mode with REST API and SSE.
18 lines
932 B
SQL
18 lines
932 B
SQL
-- Fixture 05: zstd-compressed message content
|
|
-- Tests the zstd decode path when wcdb_ct=4 and message_content is a zstd blob.
|
|
-- local_type = (5 << 32) | 49 = 21474836529
|
|
-- The blob is zstd-compressed XML:
|
|
-- <msg><appmsg><title>Test Article Link</title><des>This is a test article description for snapshot testing</des><url>https://example.com/test-article</url><type>5</type></appmsg></msg>
|
|
|
|
INSERT INTO fixture_messages (sort_seq, server_id, local_type, sender, talker, create_time, message_content, wcdb_ct)
|
|
VALUES (
|
|
500,
|
|
900005,
|
|
21474836529,
|
|
'wxid_test_alice',
|
|
'wxid_test_bob',
|
|
1700000500,
|
|
X'28b52ffd045825040092c81a1b80356d034158e9946ec229cdfe6a05625208b283f83689948b0d18813c8eeef09090ca018d7956722838a4cc400fa302a0778573379267259857e3f048db0a3997745b0a61496df32e73358af5b5add8d7be489157030f13690fa6c76c2f83f5b5483dbdcd5c308f230c08002743d8ead627a410b047526d5ccadd78225e5be419f2b045',
|
|
4
|
|
);
|