package index
import (
"strings"
"testing"
"craftdesign.group/quarry/internal/artifact"
"craftdesign.group/quarry/internal/markup"
)
func wikiArt(n byte, title, date, user, mime, body string) Parsed {
return Parsed{Hash: strings.Repeat(string([]byte{'a' + n}), 64), Art: &artifact.Artifact{
Type: artifact.Wiki, WikiTitle: title, Date: date, User: user, Mimetype: mime, Body: []byte(body)}}
}
// Fossil's rule for a deleted page is nothing left after leading
// whitespace, not an empty body: the list, the count, the structure and
// the search all ask the one question.
func TestAWhitespaceOnlyWikiPageIsDeletedEverywhere(t *testing.T) {
ix := openIndex(t)
if err := ix.FoldNow([]Parsed{
wikiArt(0, "Blank", "2026-01-01T00:00:00.000", "pat", "", "wombat notes\n"),
wikiArt(1, "Blank", "2026-01-02T00:00:00.000", "pat", "", " \t\r\n\v\f "),
wikiArt(2, "Kept", "2026-01-01T00:00:00.000", "pat", "", "\n wombat too\n"),
}); err != nil {
t.Fatal(err)
}
pages, err := ix.WikiTitles()
if err != nil || len(pages) != 1 || pages[0].Title != "Kept" {
t.Errorf("FAIL: the list holds %+v %v", pages, err)
}
if rs, err := ix.Search("wombat", "wiki", 10); err != nil || len(rs) != 1 || rs[0].Ref != "Kept" {
t.Errorf("FAIL: the search holds %+v %v", rs, err)
}
var live int
if err := ix.db.QueryRow(`SELECT count(*) FROM (SELECT max(date || ' ' || hash), live FROM wiki_edit
GROUP BY title HAVING live = 1)`).Scan(&live); err != nil || live != 1 {
t.Errorf("FAIL: %d live pages by the count's rule: %v", live, err)
}
if st, err := ix.WikiLinks("", func([]byte, bool) []markup.WikiRef { return nil }); err != nil || len(st.Orphans) != 1 || st.Orphans[0] != "Kept" {
t.Errorf("FAIL: the structure holds %+v %v", st, err)
}
if !t.Failed() {
t.Log("ok")
}
}
// A store made before the live column existed learns it from the bodies.
func TestTheLiveColumnIsBackfilledOnAnOldStore(t *testing.T) {
ix := openIndex(t)
if err := ix.FoldNow([]Parsed{
wikiArt(0, "Blank", "2026-01-01T00:00:00.000", "pat", "", " \n"),
wikiArt(1, "Real", "2026-01-01T00:00:00.000", "pat", "", "x"),
}); err != nil {
t.Fatal(err)
}
// Forget what was learned, then run the backfill the migration runs.
if _, err := ix.w.Exec(`UPDATE wiki_edit SET live = 1`); err != nil {
t.Fatal(err)
}
if _, err := ix.w.Exec(`UPDATE wiki_edit SET live = 0
WHERE length(ltrim(CAST(body AS TEXT), ' ' || char(9, 10, 11, 12, 13))) = 0`); err != nil {
t.Fatal(err)
}
var blank, real int
ix.db.QueryRow(`SELECT live FROM wiki_edit WHERE title = 'Blank'`).Scan(&blank)
ix.db.QueryRow(`SELECT live FROM wiki_edit WHERE title = 'Real'`).Scan(&real)
if blank != 0 || real != 1 {
t.Errorf("FAIL: backfill gave Blank=%d Real=%d", blank, real)
}
if !t.Failed() {
t.Log("ok")
}
}
// The search corpus and the page list agree on what a deleted page is.
func TestADeletedWikiPageLeavesSearchAndTheList(t *testing.T) {
ix := openIndex(t)
if err := ix.FoldNow([]Parsed{
wikiArt(0, "Doomed", "2026-01-01T00:00:00.000", "pat", "", "zebrafinch notes\n"),
wikiArt(1, "Kept", "2026-01-01T00:00:00.000", "pat", "", "zebrafinch too\n"),
}); err != nil {
t.Fatal(err)
}
hits := func() []string {
t.Helper()
rs, err := ix.Search("zebrafinch", "wiki", 10)
if err != nil {
t.Fatal(err)
}
var refs []string
for _, r := range rs {
refs = append(refs, r.Ref)
}
return refs
}
if got := hits(); len(got) != 2 {
t.Fatalf("FAIL: before the delete the search found %v", got)
}
if err := ix.FoldNow([]Parsed{wikiArt(2, "Doomed", "2026-01-02T00:00:00.000", "pat", "", "")}); err != nil {
t.Fatal(err)
}
if got := hits(); len(got) != 1 || got[0] != "Kept" {
t.Errorf("FAIL: after the delete the search found %v", got)
}
// By its own title, too: the row must not match on the name alone.
if rs, err := ix.Search("Doomed", "wiki", 10); err != nil || len(rs) != 0 {
t.Errorf("FAIL: the deleted page is found by its title: %v %v", rs, err)
}
pages, err := ix.WikiTitles()
if err != nil {
t.Fatal(err)
}
if len(pages) != 1 || pages[0].Title != "Kept" {
t.Errorf("FAIL: the list holds %+v", pages)
}
// A rebuild from the source tables says the same.
if err := ix.RebuildSearch(); err != nil {
t.Fatal(err)
}
if got := hits(); len(got) != 1 || got[0] != "Kept" {
t.Errorf("FAIL: after a rebuild the search found %v", got)
}
if !t.Failed() {
t.Log("ok")
}
}