Files
pages/internal/store/projection_metadata_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

73 lines
2.3 KiB
Go

package store
import (
"database/sql"
"encoding/json"
"fmt"
"strings"
"testing"
)
func TestProjectionMetadataCacheValidationAndEviction(t *testing.T) {
database, err := sql.Open("sqlite", ":memory:")
if err != nil {
t.Fatal(err)
}
t.Cleanup(func() { _ = database.Close() })
st := &Store{DB: database}
if err := st.EnsureEventJobsSchema(); err != nil {
t.Fatal(err)
}
if err := st.EnsureProjectionMetadataSchema(); err != nil {
t.Fatal(err)
}
entry := ProjectionMetadata{DocumentHash: strings.Repeat("a", 64), Kind: "pdf", Version: 1, Payload: json.RawMessage(`{"status":"ready","pdf_pages":3}`), UpdatedAtMS: 10000}
for _, change := range []func(*ProjectionMetadata){
func(e *ProjectionMetadata) { e.DocumentHash = "../../unsafe" },
func(e *ProjectionMetadata) { e.Version = 0 },
func(e *ProjectionMetadata) { e.Kind = "arbitrary" },
func(e *ProjectionMetadata) { e.Payload = json.RawMessage(`{`) },
func(e *ProjectionMetadata) {
e.Payload = json.RawMessage(`"` + strings.Repeat("x", MaxProjectionMetadataBytes) + `"`)
},
} {
bad := entry
change(&bad)
if err := st.SaveProjectionMetadata(bad); err == nil {
t.Fatal("invalid cache entry accepted")
}
}
if err := st.SaveProjectionMetadata(entry); err != nil {
t.Fatal(err)
}
if _, err := st.GetProjectionMetadata(entry.DocumentHash, "pdf", 2); err != sql.ErrNoRows {
t.Fatalf("cache reused a different parser version: %v", err)
}
// Seed a legacy oversized cache without paying a prune on each insertion.
tx, err := database.Begin()
if err != nil {
t.Fatal(err)
}
for index := range maxProjectionCacheRecords + 10 {
if _, err := tx.Exec(`INSERT INTO projection_metadata(document_hash,kind,version,payload,updated_at_ms)
VALUES(?,'archive',1,'{}',?)`, fmt.Sprintf("%064x", index), index); err != nil {
_ = tx.Rollback()
t.Fatal(err)
}
}
if err := tx.Commit(); err != nil {
t.Fatal(err)
}
if err := st.SaveProjectionMetadata(entry); err != nil {
t.Fatal(err)
}
var count int
if err := database.QueryRow(`SELECT COUNT(*) FROM projection_metadata`).Scan(&count); err != nil || count != maxProjectionCacheRecords {
t.Fatalf("cache record cap: %d %v", count, err)
}
got, err := st.GetProjectionMetadata(entry.DocumentHash, "pdf", 1)
if err != nil || string(got.Payload) != string(entry.Payload) {
t.Fatalf("new cache result was evicted: %+v %v", got, err)
}
}