Function TestExpressionToSQL

runtime/metricsview/query_expression_sql_test.go:7–221

(t *testing.T)

)

func TestExpressionToSQL(t *testing.T) {
	tests := []struct {
		name    string
		e       *Expression
		want    string
		wantErr bool
	}{
		{
			name: "empty expression",
			e:    nil,
			want: "",
		},
		{
			name: "name expression",
			e:    &Expression{Name: "foo"},
			want: "foo",
		},
		{
			name: "complex name expression",
			e:    &Expression{Name: "foo \" $.%&/' bar"},
			want: `"foo "" $.%&/' bar"`,
		},
		{
			name: "value expression",
			e:    &Expression{Value: 42},
			want: "42",
		},
		{
			name: "subquery expression",
			e: &Expression{Subquery: &Subquery{
				Dimension: Dimension{Name: "dim"},
				Measures:  []Measure{{Name: "count"}},
				Having: &Expression{Condition: &Condition{
					Operator: OperatorEq,
					Expressions: []*Expression{
						{Name: "count"},
						{Value: 10},
					},
				}},
			}},
			want: "(SELECT dim FROM metrics_view HAVING count = 10)",
		},
		{
			name: "condition expression",
			e: &Expression{
				Condition: &Condition{
					Operator: OperatorEq,
					Expressions: []*Expression{
						{Name: "foo"},
						{Value: 42},
					},
				},
			},
			want: "foo = 42",
		},
		{
			name: "and expression",
			e: &Expression{