diff options
Diffstat (limited to 'sqlite3_test.go')
-rw-r--r-- | sqlite3_test.go | 128 |
1 files changed, 65 insertions, 63 deletions
diff --git a/sqlite3_test.go b/sqlite3_test.go index 5b4a05f..ec86aef 100644 --- a/sqlite3_test.go +++ b/sqlite3_test.go @@ -580,67 +580,69 @@ func TestTransaction(t *testing.T) { } } -func TestExecer(t *testing.T) { - tempFilename := TempFilename() - db, err := sql.Open("sqlite3", tempFilename) - if err != nil { - t.Fatal("Failed to open database:", err) - } - defer os.Remove(tempFilename) - defer db.Close() - - _, err = db.Exec(` - create table foo (id integer); - insert into foo(id) values(?); - insert into foo(id) values(?); - insert into foo(id) values(?); - `, 1, 2, 3) - if err != nil { - t.Error("Failed to call db.Exec:", err) - } - if err != nil { - t.Error("Failed to call res.RowsAffected:", err) - } -} - -func TestQueryer(t *testing.T) { - tempFilename := TempFilename() - db, err := sql.Open("sqlite3", tempFilename) - if err != nil { - t.Fatal("Failed to open database:", err) - } - defer os.Remove(tempFilename) - defer db.Close() - - _, err = db.Exec(` - create table foo (id integer); - `) - if err != nil { - t.Error("Failed to call db.Query:", err) - } - - rows, err := db.Query(` - insert into foo(id) values(?); - insert into foo(id) values(?); - insert into foo(id) values(?); - select id from foo order by id; - `, 3, 2, 1) - if err != nil { - t.Error("Failed to call db.Query:", err) - } - defer rows.Close() - n := 1 - if rows != nil { - for rows.Next() { - var id int - err = rows.Scan(&id) - if err != nil { - t.Error("Failed to db.Query:", err) - } - if id != n { - t.Error("Failed to db.Query: not matched results") - } - } - } -} +// TODO: Execer & Queryer currently disabled +// https://github.com/mattn/go-sqlite3/issues/82 +//func TestExecer(t *testing.T) { +// tempFilename := TempFilename() +// db, err := sql.Open("sqlite3", tempFilename) +// if err != nil { +// t.Fatal("Failed to open database:", err) +// } +// defer os.Remove(tempFilename) +// defer db.Close() +// +// _, err = db.Exec(` +// create table foo (id integer); +// insert into foo(id) values(?); +// insert into foo(id) values(?); +// insert into foo(id) values(?); +// `, 1, 2, 3) +// if err != nil { +// t.Error("Failed to call db.Exec:", err) +// } +// if err != nil { +// t.Error("Failed to call res.RowsAffected:", err) +// } +//} +// +//func TestQueryer(t *testing.T) { +// tempFilename := TempFilename() +// db, err := sql.Open("sqlite3", tempFilename) +// if err != nil { +// t.Fatal("Failed to open database:", err) +// } +// defer os.Remove(tempFilename) +// defer db.Close() +// +// _, err = db.Exec(` +// create table foo (id integer); +// `) +// if err != nil { +// t.Error("Failed to call db.Query:", err) +// } +// +// rows, err := db.Query(` +// insert into foo(id) values(?); +// insert into foo(id) values(?); +// insert into foo(id) values(?); +// select id from foo order by id; +// `, 3, 2, 1) +// if err != nil { +// t.Error("Failed to call db.Query:", err) +// } +// defer rows.Close() +// n := 1 +// if rows != nil { +// for rows.Next() { +// var id int +// err = rows.Scan(&id) +// if err != nil { +// t.Error("Failed to db.Query:", err) +// } +// if id != n { +// t.Error("Failed to db.Query: not matched results") +// } +// } +// } +//} |