From bf67f44cfbc551b644542e25b953566ee383d5bd Mon Sep 17 00:00:00 2001 From: EuAndreh Date: Tue, 1 Oct 2024 15:50:33 -0300 Subject: Turn example files into tests under tests/functional/ --- doc/examples/mod_regexp/extension.go | 43 ------------------------------------ 1 file changed, 43 deletions(-) delete mode 100644 doc/examples/mod_regexp/extension.go (limited to 'doc/examples/mod_regexp/extension.go') diff --git a/doc/examples/mod_regexp/extension.go b/doc/examples/mod_regexp/extension.go deleted file mode 100644 index 61ceb55..0000000 --- a/doc/examples/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