fbx/tx_internal_test.go at main · FirebirdSQL/fbx · GitHub

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 fbx

import (
	"testing"
	"time"

	"github.com/firebirdsql/fbx/fbproto"
	"github.com/stretchr/testify/require"
)

func TestNormalizeTxLockTimeout(t *testing.T) {
	t.Parallel()

	t.Run("zero means default", func(t *testing.T) {
		seconds, err := normalizeTxLockTimeout(0)
		require.NoError(t, err)
		require.Equal(t, 0, seconds)
	})

	t.Run("whole seconds", func(t *testing.T) {
		seconds, err := normalizeTxLockTimeout(7 * time.Second)
		require.NoError(t, err)
		require.Equal(t, 7, seconds)
	})

	t.Run("negative fails", func(t *testing.T) {
		_, err := normalizeTxLockTimeout(-time.Second)
		require.Error(t, err)
	})

	t.Run("fractional seconds are truncated", func(t *testing.T) {
		seconds, err := normalizeTxLockTimeout(1500 * time.Millisecond)
		require.NoError(t, err)
		require.Equal(t, 1, seconds)
	})

	t.Run("range overflow fails", func(t *testing.T) {
		_, err := normalizeTxLockTimeout(32768 * time.Second)
		require.Error(t, err)
	})
}

func TestGetTPB(t *testing.T) {
	t.Parallel()

	t.Run("no options means nil tpb", func(t *testing.T) {
		tpb, err := TxOptions{}.GetTPB()
		require.NoError(t, err)
		require.Nil(t, tpb)
	})

	t.Run("lock timeout only produces tpb", func(t *testing.T) {
		tpb, err := TxOptions{LockTimeout: 7 * time.Second}.GetTPB()
		require.NoError(t, err)
		require.NotNil(t, tpb)
		require.NotEmpty(t, tpb)
	})

	t.Run("access mode only preserves default isolation", func(t *testing.T) {
		tpb, err := TxOptions{AccessMode: ReadOnly}.GetTPB()
		require.NoError(t, err)
		require.Equal(t, []byte{
			fbproto.Isc_tpb_version3,
			fbproto.Isc_tpb_read,
			fbproto.Isc_tpb_wait,
		}, tpb)
	})

	t.Run("isolation only defaults to read write", func(t *testing.T) {
		tpb, err := TxOptions{IsoLevel: RepeatableRead}.GetTPB()
		require.NoError(t, err)
		require.Equal(t, []byte{
			fbproto.Isc_tpb_version3,
			fbproto.Isc_tpb_write,
			fbproto.Isc_tpb_concurrency,
			fbproto.Isc_tpb_wait,
		}, tpb)
	})

	t.Run("unknown access mode fails", func(t *testing.T) {
		_, err := TxOptions{AccessMode: TxAccessMode("bad-mode")}.GetTPB()
		require.ErrorContains(t, err, "unknown transaction access mode")
	})

	t.Run("unknown iso level fails", func(t *testing.T) {
		_, err := TxOptions{IsoLevel: TxIsoLevel("bad-level")}.GetTPB()
		require.ErrorContains(t, err, "unknown transaction iso level")
	})
}