From 1aad60b49a32b6bced95a251f266799c031ca83e Mon Sep 17 00:00:00 2001
From: JP Appel <jeanpierre.appel01@gmail.com>
Date: Fri, 21 Nov 2025 20:50:42 -0500
Subject: Update documentation, comments, and tidy codebase

---
 pkg/data/db.go | 20 ++++++++++++++------
 1 file changed, 14 insertions(+), 6 deletions(-)

(limited to 'pkg/data/db.go')

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
-- 
cgit v1.2.3