diff options
Diffstat (limited to 'packages/meshbay-node/src/meshbay_node/audit.py')
| -rw-r--r-- | packages/meshbay-node/src/meshbay_node/audit.py | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/packages/meshbay-node/src/meshbay_node/audit.py b/packages/meshbay-node/src/meshbay_node/audit.py index 6346f16..b382107 100644 --- a/packages/meshbay-node/src/meshbay_node/audit.py +++ b/packages/meshbay-node/src/meshbay_node/audit.py @@ -104,6 +104,7 @@ class AuditStore: limit: int = 200, user_id: str | None = None, event: str | None = None, + offset: int = 0, ) -> list[AuditEntry]: conditions = ["timestamp > ?"] params: list = [since] @@ -114,11 +115,12 @@ class AuditStore: conditions.append("event = ?") params.append(event) params.append(limit) + params.append(max(0, offset)) where = " AND ".join(conditions) cursor = await self._db.execute( f"SELECT id, timestamp, user_id, username, ip, event, group_id, detail " - f"FROM audit_log WHERE {where} ORDER BY timestamp DESC LIMIT ?", + f"FROM audit_log WHERE {where} ORDER BY timestamp DESC LIMIT ? OFFSET ?", params, ) rows = await cursor.fetchall() |