Protocol.py: enable orderby results

[dcorpataux]

The protocol should support orderby and sort order. Controllers should be able to set the orderby field when calling Protocol.index().

Therefore, Protocol.index signature should be:

index(self, request, response, format='json', filter=None, orderby=None, asc=True)

[fredj]

Note: by default, SA does not generate ordering for any query unless explicitly configured. (see http://www.sqlalchemy.org/docs/05/documentation.html#advdatamapping_mapper_orderby)

[fredj]

first sketch ...

[fredj]

(In [1169]) allow to specify the order_by (see #249)

[fredj]

don't use a default order_by

[elemoine]

• If _def_order_by I think we should be more careful and check that request.paramssort? actually refers to an existing column, possibly with:

col = request.params['sort']
if col in self.__table__.c.keys()

• In _def_order_by, I'd rather go with order_by variable initialized to None and a single return statement

• We talked about having "sort" being an alias to "order_by" ("order_by" overrides "sort"), currently the order_by param isn't supported, can you add that?

Once done, go ahead and commit.

[fredj]

(In [1221]) enable order_by in server protocol. r=elemoine (close #249)