mirror of
https://github.com/tiennm99/goclaw.git
synced 2026-10-12 22:14:37 +00:00
viettranx
35ce8cc2c5
Replace flat paginated document list with collapsible tree view. Backend: two-query-per-level approach (files + DISTINCT deeper paths for virtual folder derivation), path parsing in Go for PG+SQLite compatibility, text_pattern_ops index for prefix range scans. Frontend: VaultTree component with doc_type colored icons, compact single-line nodes, truncate-middle filenames, scope dots, hover tooltip for date. Sidebar expanded to 384px on large screens. Also fixes pre-existing SQLite scanVaultDocRow missing path_basename.
3 lines
126 B
SQL
3 lines
126 B
SQL
CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_vault_docs_path_prefix
|
|
ON vault_documents (tenant_id, path text_pattern_ops);
|