2 files changed, 0 insertions, 154 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)
-	}
-}
diff --git a/_example/vtable/vtable.go b/_example/vtable/vtable.go
deleted file mode 100644
index c65535b..0000000
--- a/_example/vtable/vtable.go
+++ /dev/null
@@ -1,116 +0,0 @@
-package main
-
-import (
-	"encoding/json"
-	"fmt"
-	"io/ioutil"
-	"net/http"
-
-	"github.com/mattn/go-sqlite3"
-)
-
-type githubRepo struct {
-	ID          int    `json:"id"`
-	FullName    string `json:"full_name"`
-	Description string `json:"description"`
-	HTMLURL     string `json:"html_url"`
-}
-
-type githubModule struct {
-}
-
-func (m *githubModule) Create(c *sqlite3.SQLiteConn, args []string) (sqlite3.VTab, error) {
-	err := c.DeclareVTab(fmt.Sprintf(`
-		CREATE TABLE %s (
-			id INT,
-			full_name TEXT,
-			description TEXT,
-			html_url TEXT
-		)`, args[0]))
-	if err != nil {
-		return nil, err
-	}
-	return &ghRepoTable{}, nil
-}
-
-func (m *githubModule) Connect(c *sqlite3.SQLiteConn, args []string) (sqlite3.VTab, error) {
-	return m.Create(c, args)
-}
-
-func (m *githubModule) DestroyModule() {}
-
-type ghRepoTable struct {
-	repos []githubRepo
-}
-
-func (v *ghRepoTable) Open() (sqlite3.VTabCursor, error) {
-	resp, err := http.Get("https://api.github.com/repositories")
-	if err != nil {
-		return nil, err
-	}
-	defer resp.Body.Close()
-
-	body, err := ioutil.ReadAll(resp.Body)
-	if err != nil {
-		return nil, err
-	}
-
-	var repos []githubRepo
-	if err := json.Unmarshal(body, &repos); err != nil {
-		return nil, err
-	}
-	return &ghRepoCursor{0, repos}, nil
-}
-
-func (v *ghRepoTable) BestIndex(csts []sqlite3.InfoConstraint, ob []sqlite3.InfoOrderBy) (*sqlite3.IndexResult, error) {
-	used := make([]bool, len(csts))
-	return &sqlite3.IndexResult{
-		IdxNum: 0,
-		IdxStr: "default",
-		Used:   used,
-	}, nil
-}
-
-func (v *ghRepoTable) Disconnect() error { return nil }
-func (v *ghRepoTable) Destroy() error    { return nil }
-
-type ghRepoCursor struct {
-	index int
-	repos []githubRepo
-}
-
-func (vc *ghRepoCursor) Column(c *sqlite3.SQLiteContext, col int) error {
-	switch col {
-	case 0:
-		c.ResultInt(vc.repos[vc.index].ID)
-	case 1:
-		c.ResultText(vc.repos[vc.index].FullName)
-	case 2:
-		c.ResultText(vc.repos[vc.index].Description)
-	case 3:
-		c.ResultText(vc.repos[vc.index].HTMLURL)
-	}
-	return nil
-}
-
-func (vc *ghRepoCursor) Filter(idxNum int, idxStr string, vals []any) error {
-	vc.index = 0
-	return nil
-}
-
-func (vc *ghRepoCursor) Next() error {
-	vc.index++
-	return nil
-}
-
-func (vc *ghRepoCursor) EOF() bool {
-	return vc.index >= len(vc.repos)
-}
-
-func (vc *ghRepoCursor) Rowid() (int64, error) {
-	return int64(vc.index), nil
-}
-
-func (vc *ghRepoCursor) Close() error {
-	return nil
-}