From 9fc768ba08b79ff7a90beca82b5f1e9ae54743da Mon Sep 17 00:00:00 2001 From: AKP Date: Sun, 9 Feb 2025 22:56:16 +0000 Subject: Enable foreign key support in SQLite --- walrss/internal/db/db.go | 5 +++++ 1 file changed, 5 insertions(+) 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 } -- cgit v1.2.3-70-g09d2