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

# Check messages by folder
c.execute("SELECT folder_id, COUNT(*) FROM email_emailmessage GROUP BY folder_id")
print("Messages by folder:", c.fetchall())

# Check total messages
c.execute("SELECT COUNT(*) FROM email_emailmessage")
print("Total messages:", c.fetchone()[0])

# Check messages in INBOX (folder_id=1)
c.execute("SELECT COUNT(*) FROM email_emailmessage WHERE folder_id=1 AND is_draft=0 AND is_sent=0")
print("Inbox messages:", c.fetchone()[0])