From 5d0b36cf87ee94c690d11c0beab48f4dadc6fc52 Mon Sep 17 00:00:00 2001 From: JP Appel Date: Sun, 10 Aug 2025 02:30:00 -0400 Subject: Change db schema; remove aliases, add fts5 integration Greatly simplify db schema by removing alias functionality. Create fts5 tables for text search over paths, headings, titles, meta, authors, and links. --- pkg/data/get_test.go | 14 -------------- 1 file changed, 14 deletions(-) (limited to 'pkg/data/get_test.go') diff --git a/pkg/data/get_test.go b/pkg/data/get_test.go index 4cadc76..aa1e43e 100644 --- a/pkg/data/get_test.go +++ b/pkg/data/get_test.go @@ -28,13 +28,6 @@ func singleDoc(t *testing.T) *sql.DB { t.Fatal("err inserting author:", err) } - if _, err := db.Exec(` - INSERT INTO Aliases (authorId, alias) - VALUES (1,"pj"), (1,"JP") - `); err != nil { - t.Fatal("err inserting aliases:", err) - } - if _, err := db.Exec(` INSERT INTO Tags (name) VALUES ("foo"), ("bar"), ("baz"), ("oof") @@ -85,13 +78,6 @@ func multiDoc(t *testing.T) *sql.DB { t.Fatal("err inserting author:", err) } - if _, err := db.Exec(` - INSERT INTO Aliases (authorId, alias) - VALUES (1,"pj"), (1,"JP") - `); err != nil { - t.Fatal("err inserting aliases:", err) - } - if _, err := db.Exec(` INSERT INTO Tags (name) VALUES ("foo"), ("bar"), ("baz"), ("oof") -- cgit v1.2.3