1/*
2Copyright 2014 SAP SE
3
4Licensed under the Apache License, Version 2.0 (the "License");
5you may not use this file except in compliance with the License.
6You may obtain a copy of the License at
7
8    http://www.apache.org/licenses/LICENSE-2.0
9
10Unless required by applicable law or agreed to in writing, software
11distributed under the License is distributed on an "AS IS" BASIS,
12WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13See the License for the specific language governing permissions and
14limitations under the License.
15*/
16
17package driver_test
18
19import (
20	"database/sql"
21	"database/sql/driver"
22	"fmt"
23	"testing"
24
25	goHdbDriver "github.com/SAP/go-hdb/driver"
26)
27
28func TestConnector(t *testing.T) {
29	dsnConnector, err := goHdbDriver.NewDSNConnector(goHdbDriver.TestDSN)
30	if err != nil {
31		t.Fatal(err)
32	}
33	testConnector(t, dsnConnector)
34
35	basicAuthConnector := goHdbDriver.NewBasicAuthConnector(dsnConnector.Host(), dsnConnector.Username(), dsnConnector.Password())
36	testConnector(t, basicAuthConnector)
37}
38
39func testConnector(t *testing.T, connector driver.Connector) {
40	db := sql.OpenDB(connector)
41	defer db.Close()
42
43	var dummy string
44	err := db.QueryRow("select * from dummy").Scan(&dummy)
45	switch {
46	case err == sql.ErrNoRows:
47		t.Fatal(err)
48	case err != nil:
49		t.Fatal(err)
50	}
51	if dummy != "X" {
52		t.Fatalf("dummy is %s - expected %s", dummy, "X")
53	}
54}
55
56func TestSessionVariables(t *testing.T) {
57	ctor, err := goHdbDriver.NewDSNConnector(goHdbDriver.TestDSN)
58	if err != nil {
59		t.Fatal(err)
60	}
61	// set session variables
62	sv := goHdbDriver.SessionVariables{"k1": "v1", "k2": "v2", "k3": "v3"}
63	if err := ctor.SetSessionVariables(sv); err != nil {
64		t.Fatal(err)
65	}
66
67	// check session variables
68	db := sql.OpenDB(ctor)
69	defer db.Close()
70
71	var val string
72	for k, v := range sv {
73		err := db.QueryRow(fmt.Sprintf("select session_context('%s') from dummy", k)).Scan(&val)
74		switch {
75		case err == sql.ErrNoRows:
76			t.Fatal(err)
77		case err != nil:
78			t.Fatal(err)
79		}
80		if val != v {
81			t.Fatalf("session variable value for %s is %s - expected %s", k, val, v)
82		}
83	}
84}
85