debug_query2.py 500 Bytes

Edit Raw Blame History

import sqlite3

plain = '/data/data/com.termux/files/home/EnMicroMsg.db.decrypted.db'
conn = sqlite3.connect(plain)
conn.row_factory = sqlite3.Row

rows = conn.execute(
    "SELECT msgId, talker, content, isSend, type FROM message WHERE msgId > 0 ORDER BY msgId DESC LIMIT 3"
).fetchall()

print('Latest 3 messages (DESC):')
for r in rows:
    print('  ', dict(r))

# Reversed (chronological order)
print('\nReversed (chronological):')
for r in reversed(rows):
    print('  ', dict(r))

conn.close()