backend/test_db.py

import sqlite3

conn = sqlite3.connect('sentinel.db')
c = conn.cursor()

c.execute("SELECT COUNT(*) FROM student_performance")
print("student_performance rows:", c.fetchone()[0])

c.execute("SELECT COUNT(*) FROM sessions")
print("sessions rows:", c.fetchone()[0])

conn.close()