1 files changed, 35 insertions, 0 deletions
diff --git a/internal/cli/cmd_query.go b/internal/cli/cmd_query.go
new file mode 100644
index 0000000..a22aeb4
--- /dev/null
+++ b/internal/cli/cmd_query.go
@@ -0,0 +1,35 @@
+package cli
+
+import (
+	"context"
+	"flag"
+	"fmt"
+	"os"
+
+	"codeberg.org/snonux/goprecords/internal/goprecords"
+	"codeberg.org/snonux/goprecords/internal/storage"
+)
+
+func runQuery(args []string) error {
+	fs := flag.NewFlagSet("query", flag.ExitOnError)
+	dbPath := fs.String("db", "goprecords.db", "SQLite database path")
+	rf := goprecords.RegisterReportFlags(fs)
+	if err := fs.Parse(args); err != nil {
+		return err
+	}
+	ctx := context.Background()
+	db, err := storage.Open(ctx, *dbPath)
+	if err != nil {
+		return fmt.Errorf("open db: %w", err)
+	}
+	defer db.Close()
+	aggregates, err := goprecords.LoadAggregates(ctx, db)
+	if err != nil {
+		return fmt.Errorf("load: %w", err)
+	}
+	cfg, err := rf.Parse()
+	if err != nil {
+		return err
+	}
+	return goprecords.WriteReports(os.Stdout, aggregates, cfg)
+}