Update documentation, comments, and tidy codebase

2 files changed, 15 insertions, 7 deletions

diff --git a/pkg/data/db.go b/pkg/data/db.go
index 7d151e1..56024d3 100644
--- a/pkg/data/db.go
+++ b/pkg/data/db.go
@@ -14,6 +14,20 @@ import (
 	"github.com/mattn/go-sqlite3"
 )
 
+// _ = `
+// CREATE VIEW IF NOT EXISTS search2 AS
+// SELECT
+// 	*
+// FROM Documents d
+// JOIN Documents_fts AS d_fts ON d.id = d_fts.rowid
+//
+// DocumentAuthors AS da
+// JOIN Authors_fts AS a_fts ON da.authorId = a_fts.rowid
+//
+// DocumentTags AS dt
+// JOIN Tags_fts AS t_fts ON dt.tagId = t_fts.rowid
+// `
+
 type Query struct {
 	db *sql.DB
 }
@@ -242,7 +256,6 @@ func createSchema(db *sql.DB, version string) error {
 	)
 	`)
 
-	// FIXME: doesn't set new.id
 	_, err = tx.Exec(`
 	CREATE TRIGGER IF NOT EXISTS trig_ai_authors
 	AFTER INSERT ON Authors
@@ -269,7 +282,6 @@ func createSchema(db *sql.DB, version string) error {
 		return err
 	}
 
-	// FIXME: doesn't set new.id
 	_, err = tx.Exec(`
 	CREATE TRIGGER IF NOT EXISTS trig_au_authors
 	AFTER UPDATE ON Authors
@@ -311,7 +323,6 @@ func createSchema(db *sql.DB, version string) error {
 		return err
 	}
 
-	// FIXME: doesn't set new.id
 	_, err = tx.Exec(`
 	CREATE TRIGGER IF NOT EXISTS trig_au_tags
 	AFTER UPDATE ON Tags
@@ -353,7 +364,6 @@ func createSchema(db *sql.DB, version string) error {
 		return err
 	}
 
-	// FIXME: doesn't set new.id
 	_, err = tx.Exec(`
 	CREATE TRIGGER IF NOT EXISTS trig_au_links
 	AFTER UPDATE ON Links
@@ -369,7 +379,6 @@ func createSchema(db *sql.DB, version string) error {
 		return err
 	}
 
-	// FIXME: doesn't set new.id
 	_, err = tx.Exec(`
 	CREATE TRIGGER IF NOT EXISTS trig_ai_doc
 	AFTER INSERT ON Documents
@@ -396,7 +405,6 @@ func createSchema(db *sql.DB, version string) error {
 		return err
 	}
 
-	// FIXME: doesn't set new.id
 	_, err = tx.Exec(`
 	CREATE TRIGGER IF NOT EXISTS trig_au_doc
 	AFTER UPDATE ON Documents
diff --git a/pkg/data/put_test.go b/pkg/data/put_test.go
index a450196..e4a3c57 100644
--- a/pkg/data/put_test.go
+++ b/pkg/data/put_test.go
@@ -45,7 +45,7 @@ func TestPut_Insert(t *testing.T) {
 			p := data.NewPut(db, tt.doc)
 			gotErr := p.Insert(t.Context())
 			if !errors.Is(gotErr, tt.wantErr) {
-				t.Fatalf("Unexpected error on Insert():, want %v got %v", tt.wantErr, gotErr)
+				t.Fatalf("Unexpected error on Insert(): want %v got %v", tt.wantErr, gotErr)
 			} else if gotErr != nil {
 				return
 			}