selectFromTableWithWhereAndOrderBy - Return Table containing all values requested by SelectCommand, filtered by WhereCommand and sorted by OrderByCommand
(selectCommand *ast.SelectCommand, whereCommand *ast.WhereCommand, orderByCommand *ast.OrderByCommand, table *Table)
| 423 | // selectFromTableWithWhereAndOrderBy - Return Table containing all values requested by SelectCommand, |
| 424 | // filtered by WhereCommand and sorted by OrderByCommand |
| 425 | func (engine *DbEngine) selectFromTableWithWhereAndOrderBy(selectCommand *ast.SelectCommand, whereCommand *ast.WhereCommand, orderByCommand *ast.OrderByCommand, table *Table) (*Table, error) { |
| 426 | filteredTable, err := engine.getFilteredTable(table, whereCommand, false, selectCommand.Name.GetToken().Literal) |
| 427 | |
| 428 | if err != nil { |
| 429 | return nil, err |
| 430 | } |
| 431 | |
| 432 | emptyTable := getCopyOfTableWithoutRows(table) |
| 433 | |
| 434 | sortedTable, err := engine.getSortedTable(orderByCommand, filteredTable, emptyTable, selectCommand.Name.GetToken().Literal) |
| 435 | |
| 436 | if err != nil { |
| 437 | return nil, err |
| 438 | } |
| 439 | |
| 440 | return engine.selectFromProvidedTable(selectCommand, sortedTable) |
| 441 | } |
| 442 | |
| 443 | // selectFromTableWithOrderBy - Return Table containing all values requested by SelectCommand and sorted by OrderByCommand |
| 444 | func (engine *DbEngine) selectFromTableWithOrderBy(selectCommand *ast.SelectCommand, orderByCommand *ast.OrderByCommand, table *Table) (*Table, error) { |
no test coverage detected