Function TestParseWhereCommand

parser/parser_test.go:156–244

(t *testing.T)

}

func TestParseWhereCommand(t *testing.T) {
	firstExpression := 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"},
	}

	secondExpression := 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.EQUAL, Literal: "EQUAL"},
	}

	thirdExpression := ast.ContainExpression{
		Left: ast.Identifier{Token: token.Token{Type: token.IDENT, Literal: "colName3"}},
		Right: []ast.Anonymitifier{
			{Token: token.Token{Type: token.LITERAL, Literal: "1"}},
			{Token: token.Token{Type: token.LITERAL, Literal: "2"}},
		},
		Contains: true,
	}

	fourthExpression := ast.ContainExpression{
		Left: ast.Identifier{Token: token.Token{Type: token.IDENT, Literal: "colName4"}},
		Right: []ast.Anonymitifier{
			{Token: token.Token{Type: token.IDENT, Literal: "one"}},
			{Token: token.Token{Type: token.IDENT, Literal: "two"}},
		},
		Contains: false,
	}

	fifthExpression := ast.ConditionExpression{
		Left:      ast.Identifier{Token: token.Token{Type: token.IDENT, Literal: "colName5"}},
		Right:     ast.Anonymitifier{Token: token.Token{Type: token.NULL, Literal: "NULL"}},
		Condition: token.Token{Type: token.EQUAL, Literal: "EQUAL"},
	}

	tests := []struct {
		input              string
		expectedExpression ast.Expression
	}{
		{
			input:              "SELECT * FROM TBL WHERE colName1 EQUAL 'fda';",
			expectedExpression: firstExpression,
		},
		{
			input:              "SELECT * FROM TBL WHERE colName2 EQUAL 6462389;",
			expectedExpression: secondExpression,
		},
		{
			input:              "SELECT * FROM TBL WHERE colName3 IN (1, 2);",
			expectedExpression: thirdExpression,
		},
		{
			input:              "SELECT * FROM TBL WHERE colName4 NOTIN ('one', 'two');",
			expectedExpression: fourthExpression,
		},
		{