Coverage for check_messages.py: 0%

1import sqlite3 

2conn = sqlite3.connect('db.sqlite3') 

3c = conn.cursor() 

4 

5# Check messages by folder 

6c.execute("SELECT folder_id, COUNT(*) FROM email_emailmessage GROUP BY folder_id") 

7print("Messages by folder:", c.fetchall()) 

8 

9# Check total messages 

10c.execute("SELECT COUNT(*) FROM email_emailmessage") 

11print("Total messages:", c.fetchone()[0]) 

12 

13# Check messages in INBOX (folder_id=1) 

14c.execute("SELECT COUNT(*) FROM email_emailmessage WHERE folder_id=1 AND is_draft=0 AND is_sent=0") 

15print("Inbox messages:", c.fetchone()[0])