gitlab.com/CoiaPrant/sqlite3@v1.19.1/sqlite_go18_test.go (about) 1 // Copyright 2017 The Sqlite Authors. All rights reserved. 2 // Use of this source code is governed by a BSD-style 3 // license that can be found in the LICENSE file. 4 5 //go:build go1.8 6 // +build go1.8 7 8 package sqlite // import "gitlab.com/CoiaPrant/sqlite3" 9 10 import ( 11 "database/sql" 12 "os" 13 "reflect" 14 "testing" 15 ) 16 17 func TestNamedParameters(t *testing.T) { 18 dir, db := tempDB(t) 19 defer func() { 20 db.Close() 21 os.RemoveAll(dir) 22 }() 23 24 _, err := db.Exec(` 25 create table t(s1 varchar(32), s2 varchar(32), s3 varchar(32), s4 varchar(32)); 26 insert into t values(?, @aa, $aa, @bb); 27 `, "1", sql.Named("aa", "one"), sql.Named("bb", "two")) 28 29 if err != nil { 30 t.Fatal(err) 31 } 32 33 rows, err := db.Query("select * from t") 34 if err != nil { 35 t.Fatal(err) 36 } 37 38 rec := make([]string, 4) 39 for rows.Next() { 40 if err := rows.Scan(&rec[0], &rec[1], &rec[2], &rec[3]); err != nil { 41 t.Fatal(err) 42 } 43 } 44 45 w := []string{"1", "one", "one", "two"} 46 if !reflect.DeepEqual(rec, w) { 47 t.Fatal(rec, w) 48 } 49 }