diff options
Diffstat (limited to 'example')
| -rw-r--r-- | example/extension/extension.go | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/example/extension/extension.go b/example/extension/extension.go index d4b8fdb..f58ea3a 100644 --- a/example/extension/extension.go +++ b/example/extension/extension.go @@ -10,8 +10,9 @@ import ( func main() { sql.Register("sqlite3_with_extensions", &sqlite3.SQLiteDriver{ - EnableLoadExtension: true, - ConnectHook: nil, + Extensions: []string{ + "sqlite3_mod_regexp.dll", + }, }) db, err := sql.Open("sqlite3_with_extensions", ":memory:") @@ -20,11 +21,15 @@ func main() { } defer db.Close() - _, err = db.Exec("select load_extension('sqlite3_mod_regexp.dll')") + // Force db to make a new connection in pool + // by putting the original in a transaction + tx, err := db.Begin() if err != nil { log.Fatal(err) } + defer tx.Commit() + // New connection works (hopefully!) rows, err := db.Query("select 'hello world' where 'hello world' regexp '^hello.*d$'") if err != nil { log.Fatal(err) |