anki_opencc.py

import sqlite3
import sys
from datetime import datetime

import opencc

if len(sys.argv) < 2:
    quit("Usage:  python3 " + sys.argv[0] + " PATH_TO_anki2_FILE")
else:
    ANKI2_PATH = sys.argv[1]

con = sqlite3.connect(ANKI2_PATH)
cur = con.cursor()
converter = opencc.OpenCC("s2twp.json")

ids = []
old_text = []
new_text = []

for row in cur.execute("select id, flds from notes where 1"):
    ids.append(row[0])
    old_text.append(row[1])
    new_text.append(converter.convert(row[1]))

for key, nt in enumerate(new_text):
    print(key)
    cur.execute(
        "update notes set flds=:new_text, mod=:now where id=:id;",
        {"new_text": nt, "id": ids[key], "now": int(
            datetime.now().timestamp())},
    )
con.commit()

print("done")