aboutsummaryrefslogtreecommitdiff
path: root/_example/mod_vtable/extension.go
diff options
context:
space:
mode:
Diffstat (limited to '_example/mod_vtable/extension.go')
-rw-r--r--_example/mod_vtable/extension.go37
1 files changed, 0 insertions, 37 deletions
diff --git a/_example/mod_vtable/extension.go b/_example/mod_vtable/extension.go
deleted file mode 100644
index f738af6..0000000
--- a/_example/mod_vtable/extension.go
+++ /dev/null
@@ -1,37 +0,0 @@
-package main
-
-import (
- "database/sql"
- "fmt"
- "log"
-
- "github.com/mattn/go-sqlite3"
-)
-
-func main() {
- sql.Register("sqlite3_with_extensions",
- &sqlite3.SQLiteDriver{
- Extensions: []string{
- "sqlite3_mod_vtable",
- },
- })
-
- db, err := sql.Open("sqlite3_with_extensions", ":memory:")
- if err != nil {
- log.Fatal(err)
- }
- defer db.Close()
-
- db.Exec("create virtual table repo using github(id, full_name, description, html_url)")
-
- rows, err := db.Query("select id, full_name, description, html_url from repo")
- if err != nil {
- log.Fatal(err)
- }
- defer rows.Close()
- for rows.Next() {
- var id, fullName, description, htmlURL string
- rows.Scan(&id, &fullName, &description, &htmlURL)
- fmt.Printf("%s: %s\n\t%s\n\t%s\n\n", id, fullName, description, htmlURL)
- }
-}