aboutsummaryrefslogtreecommitdiff
path: root/vendor/github.com/mattn/go-sqlite3/_example/hook/hook.go
diff options
context:
space:
mode:
Diffstat (limited to 'vendor/github.com/mattn/go-sqlite3/_example/hook/hook.go')
-rw-r--r--vendor/github.com/mattn/go-sqlite3/_example/hook/hook.go71
1 files changed, 0 insertions, 71 deletions
diff --git a/vendor/github.com/mattn/go-sqlite3/_example/hook/hook.go b/vendor/github.com/mattn/go-sqlite3/_example/hook/hook.go
deleted file mode 100644
index 3059f9e..0000000
--- a/vendor/github.com/mattn/go-sqlite3/_example/hook/hook.go
+++ /dev/null
@@ -1,71 +0,0 @@
-package main
-
-import (
- "database/sql"
- "github.com/mattn/go-sqlite3"
- "log"
- "os"
-)
-
-func main() {
- sqlite3conn := []*sqlite3.SQLiteConn{}
- sql.Register("sqlite3_with_hook_example",
- &sqlite3.SQLiteDriver{
- ConnectHook: func(conn *sqlite3.SQLiteConn) error {
- sqlite3conn = append(sqlite3conn, conn)
- return nil
- },
- })
- os.Remove("./foo.db")
- os.Remove("./bar.db")
-
- destDb, err := sql.Open("sqlite3_with_hook_example", "./foo.db")
- if err != nil {
- log.Fatal(err)
- }
- defer destDb.Close()
- destDb.Ping()
-
- _, err = destDb.Exec("create table foo(id int, value text)")
- if err != nil {
- log.Fatal(err)
- }
- _, err = destDb.Exec("insert into foo values(1, 'foo')")
- if err != nil {
- log.Fatal(err)
- }
- _, err = destDb.Exec("insert into foo values(2, 'bar')")
- if err != nil {
- log.Fatal(err)
- }
- _, err = destDb.Query("select * from foo")
- if err != nil {
- log.Fatal(err)
- }
- srcDb, err := sql.Open("sqlite3_with_hook_example", "./bar.db")
- if err != nil {
- log.Fatal(err)
- }
- defer srcDb.Close()
- srcDb.Ping()
-
- bk, err := sqlite3conn[1].Backup("main", sqlite3conn[0], "main")
- if err != nil {
- log.Fatal(err)
- }
-
- _, err = bk.Step(-1)
- if err != nil {
- log.Fatal(err)
- }
- _, err = destDb.Query("select * from foo")
- if err != nil {
- log.Fatal(err)
- }
- _, err = destDb.Exec("insert into foo values(3, 'bar')")
- if err != nil {
- log.Fatal(err)
- }
-
- bk.Finish()
-}