Function TestSelectWithOrderByCommand

parser/parser_test.go:323–358

(t *testing.T)

}

func TestSelectWithOrderByCommand(t *testing.T) {
	input := "SELECT * FROM tableName ORDER BY colName1 DESC;"
	expectedSortPattern := ast.SortPattern{
		ColumnName: token.Token{Type: token.IDENT, Literal: "colName1"},
		Order:      token.Token{Type: token.DESC, Literal: "DESC"},
	}
	expectedOrderByCommand := ast.OrderByCommand{
		Token:        token.Token{Type: token.ORDER, Literal: "ORDER"},
		SortPatterns: []ast.SortPattern{expectedSortPattern},
	}
	expectedTableName := "tableName"
	expectedSpaces := []ast.Space{{ColumnName: token.Token{Type: token.ASTERISK, Literal: "*"}}}

	lexer := lexer.RunLexer(input)
	parserInstance := New(lexer)
	sequences, err := parserInstance.ParseSequence()
	if err != nil {
		t.Fatalf("Got error from parser: %s", err)
	}

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

	selectCommand := sequences.Commands[0].(*ast.SelectCommand)

	if !testSelectStatement(t, selectCommand, expectedTableName, expectedSpaces, false) {
		return
	}

	if !selectCommand.HasOrderByCommand() {
		t.Fatalf("sequences does not contain where command")
	}

	testOrderByCommands(t, expectedOrderByCommand, selectCommand.OrderByCommand)
}

func TestSelectWithLimitCommand(t *testing.T) {
	input := "SELECT * FROM tableName LIMIT 5;"