Enable foreign key support in SQLite

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
 }