diff options
| -rw-r--r-- | walrss/internal/db/db.go | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/walrss/internal/db/db.go b/walrss/internal/db/db.go index 1426d79..7d36896 100644 --- a/walrss/internal/db/db.go +++ b/walrss/internal/db/db.go @@ -2,6 +2,7 @@ package db import ( "database/sql" + "fmt" _ "github.com/mattn/go-sqlite3" "github.com/rs/zerolog/log" "github.com/uptrace/bun" @@ -20,6 +21,10 @@ func New(filename string) (*bun.DB, error) { db.SetMaxOpenConns(1) // https://github.com/mattn/go-sqlite3/issues/274#issuecomment-191597862 + if _, err := db.Exec("PRAGMA foreign_keys = ON"); err != nil { + return nil, fmt.Errorf("setting PRAGMA foreign_keys = ON: %w", err) + } + return bun.NewDB(db, sqlitedialect.New()), nil } |