golang sqlite foreign key example

sqlite_foreign_key.go

package main

import (
	"database/sql"
	_ "github.com/mattn/go-sqlite3"
	"log"
)

func main() {
	db, err := sql.Open("sqlite3", ":memory:")
	if err != nil {
		log.Fatal("Failed to open database:", err)
	}
	defer db.Close()

	execs := []struct {
		stmt       string
		shouldFail bool
	}{
		{stmt: "PRAGMA foreign_keys = ON"},
		{stmt: "CREATE TABLE foo (id TEXT NOT NULL PRIMARY KEY, an_int INTEGER)"},
		{stmt: "CREATE TABLE foo_set(id TEXT NOT NULL PRIMARY KEY,FOREIGN KEY(id)REFERENCES foo(id)ON DELETE RESTRICT)"},
		{stmt: "INSERT INTO foo VALUES ('id000', 10)"},
		{stmt: "INSERT INTO foo VALUES ('idAbc', 11)"},
		{stmt: "INSERT INTO foo_set VALUES ('id000')"},
		{stmt: "INSERT INTO foo_set VALUES ('not a key in foo')", shouldFail: true}, // foreign key
		{stmt: "DELETE FROM foo WHERE id = 'id000'", shouldFail: true}, // foreign key
		{stmt: "DELETE FROM foo WHERE id = 'idAbc'"},
	}
	for _, exec := range execs {
		_, err = db.Exec(exec.stmt)
		hasFailed := err != nil
		if exec.shouldFail != hasFailed {
			expected := "succeed"
			if exec.shouldFail {
				expected = "fail"
			}
			log.Printf("'%s' should have %sed but did not: %s", exec.stmt, expected, err)
		} else if exec.shouldFail {
			log.Printf("'%s' failed as expected: %s", exec.stmt, err)
		}
	}
	log.Println("finis")
}

This is simpler:
sqlite3, err := sql.Open("sqlite3", "file:test.db?_foreign_keys=true")