import sqlite3 db = r"F:\水利智学系统\可运行版(解压即用,双击start.bat)\backend\data\shuili_exam.db" c = sqlite3.connect(db) cur = c.cursor() cur.execute("SELECT COUNT(*) FROM flash_cards WHERE COALESCE(is_deleted,0)=0 AND TRIM(COALESCE(mnemonic,''))<>''") print("mnemonic_nonempty_active =", cur.fetchone()[0]) cur.execute("SELECT COUNT(*) FROM flash_cards WHERE COALESCE(is_deleted,0)=0") print("total_active =", cur.fetchone()[0]) cur.execute("""SELECT id, substr(COALESCE(mnemonic,''),1,30), substr(COALESCE(knowledge_point,''),1,40) FROM flash_cards WHERE COALESCE(is_deleted,0)=0 AND TRIM(COALESCE(mnemonic,''))<>'' AND TRIM(COALESCE(knowledge_point,''))<>'' LIMIT 3""") print("--- sample mnemonic+KP cards ---") for r in cur.fetchall(): print(r) c.close()