Is there a way to "PROGRAM foreign_keys=on" be run on every connect?

[wuranbo]

I have to hack the code, or there is already had.

[wuranbo]

I saw ConnectHook。but，sqlite3.go:init() called sql.Register.And sql.Register same name driver twice cause a panic.So there is no way to override it with my own driver with a hook.And looks like, the hook is not useable at all?

There must be something wrong to me? How can I do?

[mattn]

I'm thinking how may users expect foreign_keys=off.

[wuranbo]

@mattn I think the answer may be no people..........Looks like sqlite3.h has SQLITE_DBCONFIG_ENABLE_FKEY can force all connection be foreign_keys=on, but I am not sure.

[domingues]

I'm doing this:

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

// register an hook to run on each database connection
sql.Register("sqlite3_with_fk",
    &sqlite3.SQLiteDriver{
        ConnectHook: func(conn *sqlite3.SQLiteConn) error {
            _, err = conn.Exec("PRAGMA foreign_keys = ON", nil)
            return err
        },
    })
db, err = sql.Open("sqlite3_with_fk", "db.sqlite3")

[mattn]

fixes by #407