Function TestParseLogicOperatorsInCommand

parser/parser_test.go:807–886

(t *testing.T)

}

func TestParseLogicOperatorsInCommand(t *testing.T) {

	firstExpression := ast.OperationExpression{
		Left: ast.ConditionExpression{
			Left:      ast.Identifier{Token: token.Token{Type: token.IDENT, Literal: "colName1"}},
			Right:     ast.Anonymitifier{Token: token.Token{Type: token.IDENT, Literal: "fda"}},
			Condition: token.Token{Type: token.EQUAL, Literal: "EQUAL"}},
		Right: ast.ConditionExpression{
			Left:      ast.Identifier{Token: token.Token{Type: token.IDENT, Literal: "colName2"}},
			Right:     ast.Anonymitifier{Token: token.Token{Type: token.NULL, Literal: "NULL"}},
			Condition: token.Token{Type: token.EQUAL, Literal: "NOT"}},
		Operation: token.Token{Type: token.AND, Literal: "AND"},
	}

	secondExpression := ast.OperationExpression{
		Left: ast.ConditionExpression{
			Left:      ast.Identifier{Token: token.Token{Type: token.IDENT, Literal: "colName2"}},
			Right:     ast.Anonymitifier{Token: token.Token{Type: token.LITERAL, Literal: "6462389"}},
			Condition: token.Token{Type: token.NOT, Literal: "NOT"}},
		Right: ast.ConditionExpression{
			Left:      ast.Identifier{Token: token.Token{Type: token.IDENT, Literal: "colName1"}},
			Right:     ast.Anonymitifier{Token: token.Token{Type: token.IDENT, Literal: "NULL"}},
			Condition: token.Token{Type: token.EQUAL, Literal: "EQUAL"}},
		Operation: token.Token{Type: token.OR, Literal: "OR"},
	}

	thirdExpression := ast.BooleanExpression{
		Boolean: token.Token{Type: token.TRUE, Literal: "TRUE"},
	}

	fourthExpression := ast.ConditionExpression{
		Left:      ast.Anonymitifier{Token: token.Token{Type: token.IDENT, Literal: "colName1 EQUAL;"}},
		Right:     ast.Anonymitifier{Token: token.Token{Type: token.IDENT, Literal: "colName1 EQUAL;"}},
		Condition: token.Token{Type: token.EQUAL, Literal: "EQUAL"}}

	tests := []struct {
		input              string
		expectedExpression ast.Expression
	}{
		{
			input:              "SELECT * FROM TBL WHERE colName1 EQUAL 'fda' AND colName2 NOT NULL;",
			expectedExpression: firstExpression,
		},
		{
			input:              "SELECT * FROM TBL WHERE colName2 NOT 6462389 OR colName1 EQUAL 'NULL';",
			expectedExpression: secondExpression,
		},
		{
			input:              "SELECT * FROM TBL WHERE TRUE;",
			expectedExpression: thirdExpression,
		},
		{
			input:              "SELECT * FROM TBL WHERE 'colName1 EQUAL;' EQUAL 'colName1 EQUAL;';",
			expectedExpression: fourthExpression,
		},
	}

	for testIndex, tt := range tests {