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  }