使用pysqlcipher3处理微信数据库

1
2

brew install sqlcipher
pip install rotki-pysqlcipher3

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

import pandas as pd
import pysqlcipher3.dbapi2 as sqlite

key = '0x68*********************************'
chat_table = 'Chat_******************************'

db= sqlite.connect('WeChatDB/msg_1.db')
db_cursor = db.cursor()
db_cursor.execute(f"PRAGMA key='x''{key[2:]}''';")  
db_cursor.execute("PRAGMA cipher_compatibility=3;")
db_cursor.execute("PRAGMA cipher_page_size=1024;")
db_cursor.execute("PRAGMA kdf_iter=64000;")
db_cursor.execute("PRAGMA cipher_hmac_algorithm=HMAC_SHA1;")
db_cursor.execute("PRAGMA cipher_kdf_algorithm=PBKDF2_HMAC_SHA1;")


resoverall = db_cursor.execute(f"SELECT * FROM {chat_table};")
data_list = resoverall.fetchall()
table_df = pd.DataFrame(data_list)
table_df.columns = [i[0]for i in resoverall.description]