aboutsummaryrefslogtreecommitdiff
path: root/_example/vtable/main.go
diff options
context:
space:
mode:
Diffstat (limited to '_example/vtable/main.go')
-rw-r--r--_example/vtable/main.go38
1 files changed, 0 insertions, 38 deletions
diff --git a/_example/vtable/main.go b/_example/vtable/main.go
deleted file mode 100644
index aad8dda..0000000
--- a/_example/vtable/main.go
+++ /dev/null
@@ -1,38 +0,0 @@
-package main
-
-import (
- "database/sql"
- "fmt"
- "log"
-
- "github.com/mattn/go-sqlite3"
-)
-
-func main() {
- sql.Register("sqlite3_with_extensions", &sqlite3.SQLiteDriver{
- ConnectHook: func(conn *sqlite3.SQLiteConn) error {
- return conn.CreateModule("github", &githubModule{})
- },
- })
- db, err := sql.Open("sqlite3_with_extensions", ":memory:")
- if err != nil {
- log.Fatal(err)
- }
- defer db.Close()
-
- _, err = db.Exec("create virtual table repo using github(id, full_name, description, html_url)")
- if err != nil {
- log.Fatal(err)
- }
-
- 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)
- }
-}