Export data of purewriter time machine 导出纯纯写作时光机数据

purewriter-message.py

# unpack file.pwb and get the db file
# edit $your-sqlite-db-file to yours path
# use pipe to export to txt

import sqlite3, datetime, json


conn = sqlite3.connect("your-sqlite-db-file")
conn.row_factory = sqlite3.Row
cur = conn.cursor()

query = "SELECT content, createdTime FROM UserMessage ORDER BY createdTime"
rows = cur.execute(query).fetchall()
msgs = [dict(row) for row in rows]
conn.close()

for msg in msgs:
    timestamp = msg["createdTime"]
    timestamp = datetime.datetime.fromtimestamp(timestamp / 1000.0)
    timestamp = timestamp.strftime("%Y-%m-%d %H:%M:%S")
    print(f"\n[{timestamp}]")
    json_string = msg["content"].decode("utf-8")
    json_data = json.loads(json_string)
    print(json_data["text"])