forked from godror/godror
-
Notifications
You must be signed in to change notification settings - Fork 1
/
orahlp_test.go
149 lines (128 loc) · 2.99 KB
/
orahlp_test.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
// Copyright 2017, 2020 The Godror Authors
//
//
// SPDX-License-Identifier: UPL-1.0 OR Apache-2.0
package godror_test
import (
"context"
"database/sql"
"reflect"
"testing"
"time"
godror "github.com/godror/godror"
"github.com/google/go-cmp/cmp"
)
func TestMapToSlice(t *testing.T) {
for i, tc := range []struct {
in, await string
params []interface{}
}{
{
`SELECT NVL(MAX(F_dazon), :dazon) FROM T_spl_level
WHERE (to_char(CURRENT_DATE, 'HH:MM') = '00:42' AND F_spl_azon = :lev_azon OR --:lev_azon OR
F_ssz = 0 AND F_lev_azon = /*:lev_azon*/:lev_azon)`,
`SELECT NVL(MAX(F_dazon), :1) FROM T_spl_level
WHERE (to_char(CURRENT_DATE, 'HH:MM') = '00:42' AND F_spl_azon = :2 OR --:lev_azon OR
F_ssz = 0 AND F_lev_azon = /*:lev_azon*/:3)`,
[]interface{}{"dazon", "lev_azon", "lev_azon"},
},
{
`INSERT INTO PERSON(NAME) VALUES('hello') RETURNING ID INTO :ID`,
`INSERT INTO PERSON(NAME) VALUES('hello') RETURNING ID INTO :1`,
[]interface{}{"ID"},
},
{
`DECLARE
i1 PLS_INTEGER;
i2 PLS_INTEGER;
v001 BRUNO.DB_WEB_ELEKTR.KOTVENY_REC_TYP;
BEGIN
v001.dijkod := :p002#dijkod;
DB_web.sendpreoffer_31101(p_kotveny=>v001);
:p002#dijkod := v001.dijkod;
END;
`,
`DECLARE
i1 PLS_INTEGER;
i2 PLS_INTEGER;
v001 BRUNO.DB_WEB_ELEKTR.KOTVENY_REC_TYP;
BEGIN
v001.dijkod := :1;
DB_web.sendpreoffer_31101(p_kotveny=>v001);
:2 := v001.dijkod;
END;
`,
[]interface{}{"p002#dijkod", "p002#dijkod"},
},
} {
got, params := godror.MapToSlice(tc.in, func(s string) interface{} { return s })
d := cmp.Diff(tc.await, got)
if d != "" {
t.Errorf("%d. diff:\n%s", i, d)
}
if !reflect.DeepEqual(params, tc.params) {
t.Errorf("%d. params: got\n\t%#v,\nwanted\n\t%#v.", i, params, tc.params)
}
}
}
func TestConnPool(t *testing.T) {
ctx, cancel := context.WithTimeout(testContext("ConnPool"), 10*time.Second)
defer cancel()
p := godror.NewConnPool(testDb, 2)
defer p.Close()
var savedC1 *sql.Conn
func() {
c1, err := p.Conn(ctx)
if err != nil {
t.Fatal(err)
}
if err = c1.Close(); err != nil {
t.Fatal(err)
}
if c1, err = p.Conn(ctx); err != nil {
t.Fatal(err)
}
if err = c1.PingContext(ctx); err != nil {
t.Fatal(err)
}
savedC1 = c1.Conn
c2, err := p.Conn(ctx)
if err != nil {
t.Fatal(err)
}
defer c2.Close()
if c1 == c2 {
t.Fatal("c1==c2")
}
old := c2.Conn
if err := c2.Close(); err != nil {
t.Fatal(err)
}
if c2, err = p.Conn(ctx); err != nil {
t.Fatal(err)
}
if c2.Conn != old {
t.Errorf("re-acquire got %p wanted %p", c2.Conn, old)
}
defer c2.Close()
old = nil
_ = old
c3, err := p.Conn(ctx)
if err != nil {
t.Fatal(err)
}
defer c3.Close()
if err = c3.PingContext(ctx); err != nil {
t.Error(err)
}
}()
if err := savedC1.PingContext(ctx); err != nil {
t.Error(err)
}
if err := p.Close(); err != nil {
t.Fatal(err)
}
if err := savedC1.PingContext(ctx); err == nil {
t.Log("connection should be closed after the pool is closed, but works")
}
}