18 lines
532 B
Python
18 lines
532 B
Python
|
import sqlite3
|
||
|
|
import sys
|
||
|
|
|
||
|
|
def check_db(path):
|
||
|
|
print(f"Checking: {path}")
|
||
|
|
try:
|
||
|
|
conn = sqlite3.connect(path)
|
||
|
|
c = conn.cursor()
|
||
|
|
c.execute("SELECT COUNT(*) FROM QuizQuestions WHERE category = ?", ("파생상품투자권유자문인력",))
|
||
|
|
count = c.fetchone()[0]
|
||
|
|
print(f" Count of '파생상품투자권유자문인력': {count}")
|
||
|
|
conn.close()
|
||
|
|
except Exception as e:
|
||
|
|
print(f" Error: {e}")
|
||
|
|
|
||
|
|
check_db(r"./qple_quiz.db")
|
||
|
|
check_db(r"./qple_quiz.db.bak_before_restore")
|