Files
Anya Tokugawa c1175d389f Implement Knowledge City platform, organizer and DAV integration
Capture accumulated application, UI, CLI, regression tests and design documentation changes, including task project mapping and default CalDAV list naming.

Keep deployment data, backups, local credentials and build artifacts out of Git. Move the Compose enrollment token to an ignored local environment file.
2026-09-27 14:44:43 +09:00

130 lines
3.6 KiB
Go

package store
import (
"io"
"os"
"strings"
"golang.org/x/net/html"
)
type BrowserEntry struct {
Name string
Path string
ObjectUUID string
IsDir bool
Size int
UpdatedAt int64
ChildCount int
ContentType string
Filename string
DocumentHash string
RevisionUUID string
Title string
}
func firstHTMLHeading(source string) string {
t := html.NewTokenizer(strings.NewReader(source))
in := false
var out strings.Builder
for {
kind := t.Next()
if kind == html.ErrorToken {
if t.Err() == io.EOF {
break
}
break
}
tok := t.Token()
if kind == html.StartTagToken && strings.EqualFold(tok.Data, "h1") {
in = true
continue
}
if kind == html.EndTagToken && strings.EqualFold(tok.Data, "h1") {
break
}
if in && kind == html.TextToken {
out.WriteString(tok.Data)
}
}
return strings.TrimSpace(out.String())
}
func normalizeBrowserPath(p string) string {
p = strings.TrimSpace(p)
if p == "" {
return "/"
}
if !strings.HasPrefix(p, "/") {
p = "/" + p
}
if p != "/" {
p = strings.TrimRight(p, "/")
}
return p
}
func (s *Store) ListBrowserEntries(parent string) ([]BrowserEntry, error) {
domainUUID, err := s.defaultDomainUUID()
if err != nil {
return nil, err
}
return s.ListBrowserEntriesInDomain(domainUUID, parent)
}
func (s *Store) ListBrowserEntriesInDomain(domainUUID, parent string) ([]BrowserEntry, error) {
parent = normalizeBrowserPath(parent)
prefix := strings.TrimRight(parent, "/") + "/"
// Collapse descendants before consulting revisions. A folder listing must
// not rank every revision of every document in the subtree. Binary ranges
// keep prefix matching literal (including %, _) and use the Path index.
rows, err := s.DB.Query(`
WITH relative AS (
SELECT substr(path, length(?) + 1) AS name, object_uuid
FROM paths WHERE domain_uuid=? AND path >= ? AND path < ? AND path != ?
), children AS (
SELECT CASE WHEN instr(name,'/')=0 THEN name ELSE substr(name,1,instr(name,'/')-1) END AS name,
MAX(CASE WHEN instr(name,'/')=0 THEN object_uuid ELSE '' END) AS object_uuid,
MAX(instr(name,'/')>0) AS is_dir,
SUM(instr(name,'/')>0) AS child_count
FROM relative WHERE name != '' GROUP BY 1
)
SELECT c.name,c.object_uuid,c.is_dir,c.child_count,
COALESCE(length(CAST(r.body AS BLOB)),0),COALESCE(r.created_at,0),
COALESCE(r.content_type,''),COALESCE(r.filename,''),
COALESCE(r.document_hash,''),COALESCE(r.uuid,''),
COALESCE(substr(CAST(r.body AS TEXT),1,65536),'')
FROM children c LEFT JOIN revisions r ON r.rowid=(
SELECT head.rowid FROM revisions head
WHERE c.is_dir=0 AND head.object_uuid=c.object_uuid
ORDER BY head.created_at_ms DESC, head.rowid DESC LIMIT 1
)
ORDER BY c.is_dir DESC,c.name ASC
`, prefix, domainUUID, prefix, strings.TrimSuffix(prefix, "/")+"0", parent)
if err != nil {
return nil, err
}
defer rows.Close()
var out []BrowserEntry
for rows.Next() {
var entry BrowserEntry
if err := rows.Scan(&entry.Name, &entry.ObjectUUID, &entry.IsDir, &entry.ChildCount,
&entry.Size, &entry.UpdatedAt, &entry.ContentType, &entry.Filename, &entry.DocumentHash, &entry.RevisionUUID, &entry.Title); err != nil {
return nil, err
}
if !entry.IsDir {
entry.Title = firstHTMLHeading(entry.Title)
}
entry.Path = prefix + entry.Name
if !entry.IsDir && s.DocumentRoot != "" && entry.DocumentHash != "" {
if filename, err := s.DocumentPath(entry.DocumentHash); err == nil {
if info, err := os.Stat(filename); err == nil {
entry.Size = int(info.Size())
}
}
}
out = append(out, entry)
}
return out, rows.Err()
}