Merge pull request #73 from cookieo9/extlist

Change extension loading mechanism to use a string list of extensions

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)