diff options
author | mattn <mattn.jp@gmail.com> | 2016-11-04 23:24:02 +0900 |
---|---|---|
committer | GitHub <noreply@github.com> | 2016-11-04 23:24:02 +0900 |
commit | f4e49e6484de6dd3ffaf25eb103de03118732782 (patch) | |
tree | 8b893ca791939e310bd0eb741efbc55654ac9c50 /sqlite3_go18_test.go | |
parent | remove -Wno-c99-extension (diff) | |
parent | separate test (diff) | |
download | golite-f4e49e6484de6dd3ffaf25eb103de03118732782.tar.gz golite-f4e49e6484de6dd3ffaf25eb103de03118732782.tar.xz |
Merge pull request #348 from mattn/ping
new go1.8 feature
Diffstat (limited to 'sqlite3_go18_test.go')
-rw-r--r-- | sqlite3_go18_test.go | 49 |
1 files changed, 49 insertions, 0 deletions
diff --git a/sqlite3_go18_test.go b/sqlite3_go18_test.go new file mode 100644 index 0000000..bc8aa4e --- /dev/null +++ b/sqlite3_go18_test.go @@ -0,0 +1,49 @@ +// Copyright (C) 2014 Yasuhiro Matsumoto <mattn.jp@gmail.com>. +// +// Use of this source code is governed by an MIT-style +// license that can be found in the LICENSE file. +// +build go1.8 + +package sqlite3 + +import ( + "database/sql" + "os" + "testing" +) + +func TestNamedParams(t *testing.T) { + tempFilename := TempFilename(t) + defer os.Remove(tempFilename) + db, err := sql.Open("sqlite3", tempFilename) + if err != nil { + t.Fatal("Failed to open database:", err) + } + defer db.Close() + + _, err = db.Exec(` + create table foo (id integer, name text, extra text); + `) + if err != nil { + t.Error("Failed to call db.Query:", err) + } + + _, err = db.Exec(`insert into foo(id, name, extra) values(:id, :name, :name)`, sql.Param(":name", "foo"), sql.Param(":id", 1)) + if err != nil { + t.Error("Failed to call db.Exec:", err) + } + + row := db.QueryRow(`select id, extra from foo where id = :id and extra = :extra`, sql.Param(":id", 1), sql.Param(":extra", "foo")) + if row == nil { + t.Error("Failed to call db.QueryRow") + } + var id int + var extra string + err = row.Scan(&id, &extra) + if err != nil { + t.Error("Failed to db.Scan:", err) + } + if id != 1 || extra != "foo" { + t.Error("Failed to db.QueryRow: not matched results") + } +} |