Function TestSelectWithLimitAndOffsetCommand

parser/parser_test.go:426–465

(t *testing.T)

}

func TestSelectWithLimitAndOffsetCommand(t *testing.T) {
	input := "SELECT * FROM tableName ORDER BY colName1 DESC LIMIT 2 OFFSET 13;"
	expectedLimitCommand := ast.LimitCommand{
		Token: token.Token{Type: token.LIMIT, Literal: "LIMIT"},
		Count: 2,
	}
	expectedOffsetCommand := ast.OffsetCommand{
		Token: token.Token{Type: token.OFFSET, Literal: "OFFSET"},
		Count: 13,
	}
	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.HasLimitCommand() {
		t.Fatalf("select command should have limit command")
	}
	if !selectCommand.HasOffsetCommand() {
		t.Fatalf("select command should have offset command")
	}

	testLimitCommands(t, expectedLimitCommand, selectCommand.LimitCommand)
	testOffsetCommands(t, expectedOffsetCommand, selectCommand.OffsetCommand)
}

func TestSelectWithDefaultInnerJoinCommand(t *testing.T) {
	input := "SELECT tbl.one, tbl2.two FROM tbl JOIN tbl2 ON tbl.one EQUAL tbl2.one;"