1 files changed, 14 insertions, 0 deletions
diff --git a/packages/meshbay-node/src/meshbay_node/indexer/cache.py b/packages/meshbay-node/src/meshbay_node/indexer/cache.py
index 6c87f40..5e328ef 100644
--- a/packages/meshbay-node/src/meshbay_node/indexer/cache.py
+++ b/packages/meshbay-node/src/meshbay_node/indexer/cache.py
@@ -23,6 +23,7 @@ only daemon.py's wiring changed.
 """
 
 import logging
+import os
 import time
 from dataclasses import dataclass
 from pathlib import Path
@@ -191,6 +192,19 @@ class IndexCache:
             row = await cur.fetchone()
         return row[0] if row else 0
 
+    async def sample_under(self, directory: str, limit: int) -> list[tuple[str, int, float]]:
+        """Up to `limit` cached files under `directory`, as (path, size, mtime).
+
+        A prefix compared with `substr`, not `LIKE`: `_` and `%` are wildcards
+        there, and both are ordinary in a folder name.
+        """
+        prefix = directory.rstrip("/\\") + os.sep
+        async with self._db.execute(
+                "SELECT path, size, mtime FROM files WHERE substr(path, 1, ?) = ? LIMIT ?",
+                (len(prefix), prefix, limit)) as cur:
+            rows = await cur.fetchall()
+        return [(row[0], row[1], row[2]) for row in rows]
+
     async def all_paths(self) -> list[str]:
         """Every cached path, for a caller that decides staleness itself —
         this cache has no notion of which paths are still claimed by a