diff options
| author | JP Appel <jeanpierre.appel01@gmail.com> | 2025-11-21 20:50:42 -0500 |
|---|---|---|
| committer | JP Appel <jeanpierre.appel01@gmail.com> | 2025-11-21 20:50:42 -0500 |
| commit | 1aad60b49a32b6bced95a251f266799c031ca83e (patch) | |
| tree | 4b156c7f6df11a164a31a5615d30f9cd6f07c44f /pkg/data/db.go | |
| parent | 7383ea149c9444c297e21f21294fd41e67f9c9ff (diff) | |
Update documentation, comments, and tidy codebase
Diffstat (limited to 'pkg/data/db.go')
| -rw-r--r-- | pkg/data/db.go | 20 |
1 files changed, 14 insertions, 6 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 |