import sqlite3 db = r"F:\水利智学系统\可运行版(解压即用,双击start.bat)\backend\data\shuili_exam.db" c = sqlite3.connect(db) cur = c.cursor() # without is_deleted filter cur.execute("SELECT COUNT(*) FROM flash_cards WHERE TRIM(COALESCE(mnemonic,''))<>''") print("mnemonic_nonempty_all (incl deleted) =", cur.fetchone()[0]) cur.execute("SELECT COUNT(*) FROM flash_cards") print("total_all =", cur.fetchone()[0]) cur.execute("SELECT COUNT(*) FROM flash_cards WHERE COALESCE(is_deleted,0)<>0") print("deleted =", cur.fetchone()[0]) c.close()