diff options
Diffstat (limited to 'internal')
| -rw-r--r-- | internal/app/command.go | 2 | ||||
| -rw-r--r-- | internal/autogen/manualgen.go (renamed from internal/autogenerate/manualgen.go) | 0 | ||||
| -rw-r--r-- | internal/db/schema_initialisation.go | 4 | ||||
| -rw-r--r-- | internal/db/setup.go | 14 |
4 files changed, 15 insertions, 5 deletions
diff --git a/internal/app/command.go b/internal/app/command.go index 5c32ba2..f2c55ef 100644 --- a/internal/app/command.go +++ b/internal/app/command.go @@ -6,7 +6,7 @@ import ( const ( AppName = "rafta" - AppUsage = "Really, Another Freaking Todo App?!" + AppUsage = "Really, Another F*cking Todo App?!" ) var version = "COMPILED" diff --git a/internal/autogenerate/manualgen.go b/internal/autogen/manualgen.go index a3480c4..a3480c4 100644 --- a/internal/autogenerate/manualgen.go +++ b/internal/autogen/manualgen.go diff --git a/internal/db/schema_initialisation.go b/internal/db/schema_initialisation.go index 3963786..2dfc163 100644 --- a/internal/db/schema_initialisation.go +++ b/internal/db/schema_initialisation.go @@ -88,7 +88,7 @@ var schemaDefinitions = [...]struct { // genDB creates a new database at path using the expected schema definitions. func genDB(ctx context.Context, path string) (*sql.DB, error) { - db, err := sql.Open("sqlite3", path) + db, err := sql.Open("sqlite", path+opts()) if err != nil { slog.ErrorContext(ctx, "failed to create DB", "error", err) return nil, err @@ -125,6 +125,6 @@ func genDB(ctx context.Context, path string) (*sql.DB, error) { return nil, err } - slog.InfoContext(ctx, "created new blank DB wit h valid schema", "path", path) + slog.InfoContext(ctx, "created new blank DB with valid schema", "path", path) return db, nil } diff --git a/internal/db/setup.go b/internal/db/setup.go index 038334a..ff56233 100644 --- a/internal/db/setup.go +++ b/internal/db/setup.go @@ -10,7 +10,7 @@ import ( "strings" "time" - _ "github.com/mattn/go-sqlite3" + _ "modernc.org/sqlite" ) var ( @@ -73,7 +73,7 @@ func Setup(ctx context.Context, path string) (*Store, error) { return new(db) } - db, err := sql.Open("sqlite3", path+opts()) + db, err := sql.Open("sqlite", path+opts()) if err != nil { slog.ErrorContext(ctx, "failed to open DB", "error", err) backupFile(ctx, path) @@ -84,6 +84,16 @@ func Setup(ctx context.Context, path string) (*Store, error) { return new(db) } + _, err = db.Exec("PRAGMA foreign_keys = ON") + if err != nil { + return nil, err + } + + _, err = db.Exec("PRAGMA journal_mode=WAL") + if err != nil { + return nil, err + } + // Run integrity check. var integrity string if err = db.QueryRow("PRAGMA integrity_check;").Scan(&integrity); err != nil || integrity != "ok" { |