Function TestParseSelectCommand

parser/parser_test.go:126–154

(t *testing.T)

}

func TestParseSelectCommand(t *testing.T) {
	tests := []struct {
		input             string
		expectedTableName string
		expectedSpaces    []ast.Space
		expectedDistinct  bool
	}{
		{"SELECT * FROM TBL;", "TBL", []ast.Space{{ColumnName: token.Token{Type: token.ASTERISK, Literal: "*"}}}, false},
		{"SELECT ONE, TWO, THREE FROM TBL;", "TBL", []ast.Space{{ColumnName: token.Token{Type: token.IDENT, Literal: "ONE"}}, {ColumnName: token.Token{Type: token.IDENT, Literal: "TWO"}}, {ColumnName: token.Token{Type: token.IDENT, Literal: "THREE"}}}, false},
		{"SELECT DISTINCT * FROM TBL;", "TBL", []ast.Space{{ColumnName: token.Token{Type: token.ASTERISK, Literal: "*"}}}, true},
	}

	for testIndex, tt := range tests {
		lexer := lexer.RunLexer(tt.input)
		parserInstance := New(lexer)
		sequences, err := parserInstance.ParseSequence()
		if err != nil {
			t.Fatalf("[%d] Got error from parser: %s", testIndex, err)
		}

		if len(sequences.Commands) != 1 {
			t.Fatalf("[%d] sequences does not contain 1 statements. got=%d", testIndex, len(sequences.Commands))
		}

		if !testSelectStatement(t, sequences.Commands[0], tt.expectedTableName, tt.expectedSpaces, tt.expectedDistinct) {
			return
		}
	}
}

func TestParseWhereCommand(t *testing.T) {
	firstExpression := ast.ConditionExpression{