[QUESTION] How to add MySQL ORDER BY about slim-api-skeleton HOT 3 CLOSED

It is not really a framework, more like a skeleton which can be used for starting new projects. Reading through Zend docs you are correct. TableGateway seems to require a Select object to pass in ORDER BY clause. One way to achieve this would be to alter the all() method in ZendTodoRepository. Something like:

    public function all(array $specification = []): array
    {
        $select = /* Build $select from $specification here. */
        $rowset = $this->table->selectWith($select); 
        return map($rowset, function ($row) {
            return $this->hydrator->hydrate((array) $row, new Todo);
        });
    }

from slim-api-skeleton.

Ok awesome that's what I'll be doing. Was just wondering whether you had that covered. Thanks!

from slim-api-skeleton.

I just recently converted this to Zend TableGateway and have not needed an ORDER BY query yet by myself. But since it is common use case I should find a good way to do it. Or at least mention this in docs.

Thanks for the heads up!

from slim-api-skeleton.