gitlab.com/vegasq/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  }