gitlab.com/jakobvarmose/sqlite@v1.0.0/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 //+build go1.8 6 7 package sqlite // import "modernc.org/sqlite" 8 9 import ( 10 "database/sql" 11 "os" 12 "reflect" 13 "testing" 14 ) 15 16 func TestNamedParameters(t *testing.T) { 17 dir, db := tempDB(t) 18 defer func() { 19 db.Close() 20 os.RemoveAll(dir) 21 }() 22 23 _, err := db.Exec(` 24 create table t(s1 varchar(32), s2 varchar(32), s3 varchar(32), s4 varchar(32)); 25 insert into t values(?, @aa, $aa, @bb); 26 `, "1", sql.Named("aa", "one"), sql.Named("bb", "two")) 27 28 if err != nil { 29 t.Fatal(err) 30 } 31 32 rows, err := db.Query("select * from t") 33 if err != nil { 34 t.Fatal(err) 35 } 36 37 rec := make([]string, 4) 38 for rows.Next() { 39 if err := rows.Scan(&rec[0], &rec[1], &rec[2], &rec[3]); err != nil { 40 t.Fatal(err) 41 } 42 } 43 44 w := []string{"1", "one", "one", "two"} 45 if !reflect.DeepEqual(rec, w) { 46 t.Fatal(rec, w) 47 } 48 }