From 4818bc542611b3ab554824fece8a071b0ac6307b Mon Sep 17 00:00:00 2001 From: adamdottv <2363879+adamdottv@users.noreply.github.com> Date: Thu, 29 May 2025 15:41:13 -0500 Subject: wip: refactoring tui --- internal/db/connect.go | 68 -------------------------------------------------- 1 file changed, 68 deletions(-) delete mode 100644 internal/db/connect.go (limited to 'internal/db/connect.go') diff --git a/internal/db/connect.go b/internal/db/connect.go deleted file mode 100644 index d90a57178..000000000 --- a/internal/db/connect.go +++ /dev/null @@ -1,68 +0,0 @@ -package db - -import ( - "database/sql" - "fmt" - "os" - "path/filepath" - - _ "github.com/ncruces/go-sqlite3/driver" - _ "github.com/ncruces/go-sqlite3/embed" - - "github.com/sst/opencode/internal/config" - "log/slog" - - "github.com/pressly/goose/v3" -) - -func Connect() (*sql.DB, error) { - dataDir := config.Get().Data.Directory - if dataDir == "" { - return nil, fmt.Errorf("data.dir is not set") - } - if err := os.MkdirAll(dataDir, 0o700); err != nil { - return nil, fmt.Errorf("failed to create data directory: %w", err) - } - dbPath := filepath.Join(dataDir, "opencode.db") - // Open the SQLite database - db, err := sql.Open("sqlite3", dbPath) - if err != nil { - return nil, fmt.Errorf("failed to open database: %w", err) - } - - // Verify connection - if err = db.Ping(); err != nil { - db.Close() - return nil, fmt.Errorf("failed to connect to database: %w", err) - } - - // Set pragmas for better performance - pragmas := []string{ - "PRAGMA foreign_keys = ON;", - "PRAGMA journal_mode = WAL;", - "PRAGMA page_size = 4096;", - "PRAGMA cache_size = -8000;", - "PRAGMA synchronous = NORMAL;", - } - - for _, pragma := range pragmas { - if _, err = db.Exec(pragma); err != nil { - slog.Error("Failed to set pragma", pragma, err) - } else { - slog.Debug("Set pragma", "pragma", pragma) - } - } - - goose.SetBaseFS(FS) - - if err := goose.SetDialect("sqlite3"); err != nil { - slog.Error("Failed to set dialect", "error", err) - return nil, fmt.Errorf("failed to set dialect: %w", err) - } - - if err := goose.Up(db, "migrations"); err != nil { - slog.Error("Failed to apply migrations", "error", err) - return nil, fmt.Errorf("failed to apply migrations: %w", err) - } - return db, nil -} -- cgit v1.2.3