From a4d86693394ba9b181b5928c1c6e8c31c9bb2b64 Mon Sep 17 00:00:00 2001
From: JP Appel <jeanpierre.appel01@gmail.com>
Date: Mon, 30 Jun 2025 17:18:45 -0400
Subject: Implement compiled query execution

---
 pkg/data/db.go | 62 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 62 insertions(+)

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

diff --git a/pkg/data/db.go b/pkg/data/db.go
index b4b7f90..24a8793 100644
--- a/pkg/data/db.go
+++ b/pkg/data/db.go
@@ -3,9 +3,11 @@ package data
 import (
 	"context"
 	"database/sql"
+	"fmt"
 	"strings"
 
 	"github.com/jpappel/atlas/pkg/index"
+	"github.com/jpappel/atlas/pkg/query"
 	_ "github.com/mattn/go-sqlite3"
 )
 
@@ -202,6 +204,29 @@ func createSchema(db *sql.DB) error {
 		return err
 	}
 
+	_, err = tx.Exec(`
+	CREATE VIEW IF NOT EXISTS Search AS
+	SELECT
+		d.id AS docId,
+		d.path,
+		d.title,
+		d.date,
+		d.fileTime,
+		d.meta,
+		COALESCE(a.name, al.alias) AS author,
+		t.name AS tag
+	FROM Documents d
+	LEFT JOIN DocumentAuthors da ON d.id = da.docId
+	LEFT JOIN Authors a ON da.authorId = a.id
+	LEFT JOIN Aliases al ON a.id = al.authorId
+	LEFT JOIN DocumentTags dt ON d.id = dt.docId
+	LEFT JOIN Tags t ON dt.tagId = t.id
+	`)
+	if err != nil {
+		tx.Rollback()
+		return err
+	}
+
 	return nil
 }
 
@@ -254,3 +279,40 @@ func (q Query) GetDocument(path string) (*index.Document, error) {
 	f := Fill{Path: path, Db: q.db}
 	return f.Get(ctx)
 }
+
+func (q Query) Execute(artifact query.CompilationArtifact) (map[string]*index.Document, error) {
+	ctx := context.TODO()
+	f := FillMany{
+		Db:   q.db,
+		docs: make(map[string]*index.Document),
+		ids:  make(map[string]int),
+	}
+
+	compiledQuery := fmt.Sprintf(`
+	SELECT DISTINCT docId, path, title, date, fileTime, meta
+	FROM Search
+	WHERE %s`, artifact.Query)
+
+	rows, err := q.db.QueryContext(ctx, compiledQuery, artifact.Args...)
+	if err != nil {
+		return nil, err
+	}
+
+	if err := f.documents(ctx, rows); err != nil {
+		rows.Close()
+		return nil, err
+	}
+	rows.Close()
+
+	if err := f.tags(ctx); err != nil {
+		return nil, err
+	}
+	if err := f.links(ctx); err != nil {
+		return nil, err
+	}
+	if err := f.authors(ctx); err != nil {
+		return nil, err
+	}
+
+	return f.docs, nil
+}
-- 
cgit v1.2.3