aboutsummaryrefslogtreecommitdiff
path: root/doc/examples/mod_regexp/extension.go
diff options
context:
space:
mode:
authorEuAndreh <eu@euandre.org>2024-10-01 15:50:33 -0300
committerEuAndreh <eu@euandre.org>2024-10-01 15:50:33 -0300
commitbf67f44cfbc551b644542e25b953566ee383d5bd (patch)
treeac36f31e50850bf1a11b79fc344b4d685fff469c /doc/examples/mod_regexp/extension.go
parenttests/golite.go: Enable slow tests (diff)
downloadgolite-bf67f44cfbc551b644542e25b953566ee383d5bd.tar.gz
golite-bf67f44cfbc551b644542e25b953566ee383d5bd.tar.xz
Turn example files into tests under tests/functional/
Diffstat (limited to 'doc/examples/mod_regexp/extension.go')
-rw-r--r--doc/examples/mod_regexp/extension.go43
1 files changed, 0 insertions, 43 deletions
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)
- }
-}