From 0b8d97f96dd4db0e50a1cb68a0740a55017c469b Mon Sep 17 00:00:00 2001 From: EuAndreh Date: Wed, 14 Aug 2024 17:31:36 -0300 Subject: git mv _example doc/examples/ --- _example/mod_regexp/extension.go | 43 ---------------------------------------- 1 file changed, 43 deletions(-) delete mode 100644 _example/mod_regexp/extension.go (limited to '_example/mod_regexp/extension.go') diff --git a/_example/mod_regexp/extension.go b/_example/mod_regexp/extension.go deleted file mode 100644 index 61ceb55..0000000 --- a/_example/mod_regexp/extension.go +++ /dev/null @@ -1,43 +0,0 @@ -package main - -import ( - "database/sql" - "fmt" - "github.com/mattn/go-sqlite3" - "log" -) - -func main() { - sql.Register("sqlite3_with_extensions", - &sqlite3.SQLiteDriver{ - Extensions: []string{ - "sqlite3_mod_regexp", - }, - }) - - db, err := sql.Open("sqlite3_with_extensions", ":memory:") - if err != nil { - log.Fatal(err) - } - defer db.Close() - - // 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) - } - defer rows.Close() - for rows.Next() { - var helloworld string - rows.Scan(&helloworld) - fmt.Println(helloworld) - } -} -- cgit v1.2.3