Files
pages/internal/store/search_live_test.go
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

71 lines
2.5 KiB
Go

package store_test
import (
"context"
"database/sql"
"net/url"
"os"
"path/filepath"
"testing"
"time"
"pageswiki/internal/store"
)
// This opt-in diagnostic never initializes/migrates a Store or prints Page
// contents, Paths, account information or queries. SQLite itself enforces ro.
func TestSearchReadOnlyDatabase(t *testing.T) {
filename := os.Getenv("PAGESWIKI_SEARCH_DIAGNOSTIC_DB")
if filename == "" {
t.Skip("set PAGESWIKI_SEARCH_DIAGNOSTIC_DB for read-only search timing")
}
absolute, err := filepath.Abs(filename)
if err != nil {
t.Fatal(err)
}
dsn := (&url.URL{Scheme: "file", Path: absolute, RawQuery: url.Values{
"mode": {"ro"}, "_pragma": {"query_only(1)", "busy_timeout(1000)"},
}.Encode()}).String()
database, err := sql.Open("sqlite", dsn)
if err != nil {
t.Fatal(err)
}
defer database.Close()
database.SetMaxOpenConns(1)
ctx, cancel := context.WithTimeout(context.Background(), 15*time.Second)
defer cancel()
var domain string
if err := database.QueryRowContext(ctx, `SELECT uuid FROM domains WHERE enabled=1 ORDER BY id LIMIT 1`).Scan(&domain); err != nil {
t.Fatal(err)
}
st := &store.Store{DB: database}
queries := []string{"wiki", "the", "a", "検索"}
if query := os.Getenv("PAGESWIKI_SEARCH_DIAGNOSTIC_QUERY"); query != "" {
queries = []string{query}
}
for i, query := range queries {
start := time.Now()
results, err := st.SearchPathsInDomainFiltered(ctx, domain, "/", query, 100, func(string) bool { return true })
t.Logf("case=%d rows=%d elapsed=%s error=%v", i, len(results), time.Since(start).Round(time.Millisecond), err)
if err != nil {
t.Errorf("case %d search failed", i)
}
}
if os.Getenv("PAGESWIKI_SEARCH_DIAGNOSTIC_FILTERS") == "1" {
for i, options := range []store.SearchOptions{{FileType: "pdf"}, {FileType: "image"}, {FileType: "archive"}, {FileType: "code"}, {FileType: "other"}, {Extension: "pdf"}} {
start := time.Now()
results, err := st.SearchPathsInDomainWithOptions(ctx, domain, "/", "", 100, func(string) bool { return true }, options)
t.Logf("filter-case=%d rows=%d elapsed=%s error=%v", i, len(results), time.Since(start).Round(time.Millisecond), err)
if err != nil {
t.Errorf("filter case %d search failed", i)
}
}
start := time.Now()
city, err := st.SearchCityInDomain(ctx, domain, "/", "a", 30, func(string) bool { return true }, store.SearchOptions{})
t.Logf("city rows=%d elapsed=%s error=%v", len(city), time.Since(start).Round(time.Millisecond), err)
if err != nil {
t.Error("City metadata search failed")
}
}
}