Return recent db_events, newest first. If *event* is given, only rows matching that event type are returned.
(self, event: str | None = None, limit: int = 50)
| 322 | self._conn.commit() |
| 323 | |
| 324 | def get_events(self, event: str | None = None, limit: int = 50) -> list[dict]: |
| 325 | """Return recent db_events, newest first. |
| 326 | |
| 327 | If *event* is given, only rows matching that event type are returned. |
| 328 | """ |
| 329 | if event: |
| 330 | rows = self._conn.execute( |
| 331 | "SELECT id, timestamp, event, metadata FROM db_events " |
| 332 | "WHERE event = ? ORDER BY id DESC LIMIT ?", |
| 333 | (event, limit), |
| 334 | ).fetchall() |
| 335 | else: |
| 336 | rows = self._conn.execute( |
| 337 | "SELECT id, timestamp, event, metadata FROM db_events " |
| 338 | "ORDER BY id DESC LIMIT ?", |
| 339 | (limit,), |
| 340 | ).fetchall() |
| 341 | return [ |
| 342 | { |
| 343 | "id": r["id"], |
| 344 | "timestamp": r["timestamp"], |
| 345 | "event": r["event"], |
| 346 | "metadata": json.loads(r["metadata"]), |
| 347 | } |
| 348 | for r in rows |
| 349 | ] |
| 350 | |
| 351 | def _discover_manpage_suggestions( |
| 352 | self, |
no outgoing calls