-
Notifications
You must be signed in to change notification settings - Fork 0
/
q_functions_test.go
46 lines (40 loc) · 1.07 KB
/
q_functions_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
package dal
import (
"github.com/stretchr/testify/assert"
"testing"
)
func TestSumAs(t *testing.T) {
expression := Field("id")
alias := "c1"
sumAs := SumAs(expression, alias)
assert.Equal(t, alias, sumAs.Alias)
assert.Equal(t, "SUM(id) AS c1", sumAs.String())
}
func TestCountAs(t *testing.T) {
expression := Field("id")
alias := "c1"
countAs := CountAs(expression, alias)
assert.Equal(t, alias, countAs.Alias)
assert.Equal(t, "COUNT(id) AS c1", countAs.String())
}
func TestMinAs(t *testing.T) {
expression := Field("id")
alias := "c1"
minAs := MinAs(expression, alias)
assert.Equal(t, alias, minAs.Alias)
assert.Equal(t, "MIN(id) AS c1", minAs.String())
}
func TestMaxAs(t *testing.T) {
expression := Field("id")
alias := "c1"
maxAs := MaxAs(expression, alias)
assert.Equal(t, alias, maxAs.Alias)
assert.Equal(t, "MAX(id) AS c1", maxAs.String())
}
func TestAverageAs(t *testing.T) {
expression := Field("id")
alias := "c1"
averageAs := AverageAs(expression, alias)
assert.Equal(t, alias, averageAs.Alias)
assert.Equal(t, "AVG(id) AS c1", averageAs.String())
}