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
|
package database
import (
"reflect"
"testing"
"git.adyxax.org/adyxax/trains/pkg/model"
"github.com/DATA-DOG/go-sqlmock"
"github.com/stretchr/testify/assert"
"github.com/stretchr/testify/require"
)
func TestCreateSession(t *testing.T) {
// test db setup
db, err := InitDB("sqlite3", "file::memory:?_foreign_keys=on")
require.NoError(t, err)
err = db.Migrate()
require.NoError(t, err)
userReg1 := model.UserRegistration{
Username: "user1",
Password: "user1_pass",
Email: "user1",
}
user1, err := db.CreateUser(&userReg1)
require.NoError(t, err)
user2 := *user1
user2.Id++ // we want a token request for an invalid user id
// Test cases
testCases := []struct {
name string
input *model.User
expectedError interface{}
}{
{"Normal user", user1, nil},
{"A normal user can request multiple tokens", user1, nil},
{"a non existant user id triggers an error", &user2, &QueryError{}},
}
for _, tc := range testCases {
t.Run(tc.name, func(t *testing.T) {
valid, err := db.CreateSession(tc.input)
if tc.expectedError != nil {
require.Error(t, err)
assert.Equalf(t, reflect.TypeOf(err), reflect.TypeOf(tc.expectedError), "Invalid error type. Got %s but expected %s", reflect.TypeOf(err), reflect.TypeOf(tc.expectedError))
require.Nil(t, valid)
} else {
require.NoError(t, err)
assert.NotNil(t, valid)
}
})
}
}
func TestCreateSessionWithSQLMock(t *testing.T) {
// Transaction begin error
dbBeginError, _, err := sqlmock.New()
if err != nil {
t.Fatalf("an error '%s' was not expected when opening a stub database connection", err)
}
defer dbBeginError.Close()
// Transaction commit error
dbCommitError, mockCommitError, err := sqlmock.New()
if err != nil {
t.Fatalf("an error '%s' was not expected when opening a stub database connection", err)
}
defer dbCommitError.Close()
mockCommitError.ExpectBegin()
mockCommitError.ExpectExec(`INSERT INTO`).WillReturnResult(sqlmock.NewResult(1, 1))
// Test cases
testCases := []struct {
name string
db *DBEnv
expectedError interface{}
}{
{"begin transaction error", &DBEnv{db: dbBeginError}, &TransactionError{}},
{"commit transaction error", &DBEnv{db: dbCommitError}, &TransactionError{}},
}
for _, tc := range testCases {
t.Run(tc.name, func(t *testing.T) {
valid, err := tc.db.CreateSession(&model.User{})
if tc.expectedError != nil {
require.Error(t, err)
assert.Equalf(t, reflect.TypeOf(err), reflect.TypeOf(tc.expectedError), "Invalid error type. Got %s but expected %s", reflect.TypeOf(err), reflect.TypeOf(tc.expectedError))
require.Nil(t, valid)
} else {
require.NoError(t, err)
}
})
}
}
|