flask-smorest-sqlalchemy-odata 0.1.8

Odata filtering and sorting with flask-smorest

Odata filtering for Flask-Smorest with Flask-Sqlalchemy

Add odata-like filtering and sorting on top of flask-smorest functionality

Usage

The primary use case is as a wrapper around the flask-smorest Blueprint class. It will add the odata filter and orderby query params and apply them to the returned model from a MethodView.

from http import HTTPStatus
from flask_smorest import Api, Page
from flask.views import MethodView

from odata import Blueprint

api = Api(app)


class CursorPage(Page):
    @property
    def item_count(self):
        return self.collection.count()


resources = Blueprint(
    'resources',
    __name__,
    url_prefix='/',
    description='root resources',
)

@resources.route('/user')
class User(MethodView):

    @resources.response(HTTPStatus.OK, schemas.User(many=True))
    @resources.paginate(CursorPage)
    @resources.odata(db.session)
    def get(self):
        return models.User

api.register_blueprint(resources)

It will also add docs so the params will appear in Swagger/Redoc.

Features

Filter operators

Multiple filter operations can be joined with 'and'. 'or' functionality still work in progress.

Operator Name	Syntax	Examples
Contains	contains(field,'value')	contains(description,'middle of a sentence')
Equal	field eq value	id eq 1 isActive eq true isActive eq false serialNumber eq null description eq 'very specific'
Not Equal	field ne value	isActive ne true
In	field in (comma,separated,values)	id in (1,3) username in ("user1", "user2")
Starts with	startswith(field,'value')	startswith(preamble,'We the people')
Ends with	endswith(field,'value')	endswith(preamble,'United States of America.')
Greater than	field gt value	fingers gt 5 created gt 2020-01-05T00:00:00
Less than	field lt value	fingers lt 5
Greater than or equal to	field ge value	fingers ge 5
Less than or equal to	field le value	fingers le 5

Filter by joined properties

It is possible to filter by a joined property, even if that property isn't returned in the payload. Use a forward-slash (/) to indicate a join.

For example: /user?filter=roles/name eq "admin" would return all users that have a related role with name 'admin'.

Works for one-to-many and many-to-many.

Ordering

Use the orderby query parameter to sort by a top-level property or joined property, ascending or descending.

Examples:

• /user?orderby=id
• /user?orderby=id desc
• /user?orderby=supervisor/username

AND / OR

Filters can be combined with either and or or. Currently, order of operations cannot be controlled if they are mixed together.

Examples:

• isActive eq true or isActive eq flase
• createdTime ge 2021-01-01T00:00:00 and createdTime le 2021-02-01T23:59:59 and userId eq 1