#!/usr/bin/env python3
"""Cari pesan Bos (role=user) di profil atun tentang 'feed' / 'carousel 10' / 'akhir oktober'."""
import sqlite3, sys, re
db = sys.argv[1]
pola = sys.argv[2] if len(sys.argv) > 2 else "feed"
c = sqlite3.connect(db)
q = """SELECT id, session_id, substr(content,1,300), timestamp FROM messages
       WHERE role='user' AND content LIKE ? ORDER BY id DESC LIMIT 40"""
for row in c.execute(q, (f"%{pola}%",)):
    import datetime
    ts = row[3]
    try:
        ts = datetime.datetime.fromtimestamp(float(ts)).strftime("%d %b %H:%M")
    except Exception:
        pass
    print("-" * 70)
    print(row[0], row[1], "|", ts)
    print(row[2].replace("\n", " "))