Merge ordering and filtering under the same class

[arthurio]

🫱🏻‍🫲🏾 Main contributions

• 📦 Move ordering inside the Filter class and update tests, docs, and examples by @arthurio in 📦 Move ordering inside the Filter class and update tests, docs, and examples #58

✨ Updates

• order_by is now part of the Filter class so that you don't have to manage them separately.
• You can add a validator to restrict which fields can be sortable (returns a 422 if invalid as opposed to 500 before)
• order_by is now a list[str] instead of str that you have to manually parse
• Prevent using twice the same field name for ordering (e.g. can't do ?order_by=name,-name or ?order_by=name,age,name)
• Docs are updated and order_by section has some stuff now
• Added more tests
• You can change the default name (order_by) for ordering by overriding Filter.Constants.ordering_field_name

🚨 Breaking changes

• We now use Constants.model everywhere (instead of model for SQLAlchemy and collection for MongoEngine)
• The Constants class has to inherit from parent or redefine all the fields. (class Constants(Filter.Constants):).
• OrderBy no longer exists, just add order_by: list[str] | None to your filters if you want to add ordering capabilities.

🔗 Dependency updates

• Bump requests from 2.28.0 to 2.28.1 by @dependabot in Bump requests from 2.28.0 to 2.28.1 #40
• Bump ujson from 5.2.0 to 5.4.0 by @dependabot in Bump ujson from 5.2.0 to 5.4.0 #43
• Bump typing-extensions from 4.2.0 to 4.3.0 by @dependabot in Bump typing-extensions from 4.2.0 to 4.3.0 #41
• Bump python-lsp-server from 1.4.1 to 1.5.0 by @dependabot in Bump python-lsp-server from 1.4.1 to 1.5.0 #47
• Bump pytest-asyncio from 0.18.3 to 0.19.0 by @dependabot in Bump pytest-asyncio from 0.18.3 to 0.19.0 #54
• Bump mongoengine from 0.24.1 to 0.24.2 by @dependabot in Bump mongoengine from 0.24.1 to 0.24.2 #51
• Bump pudb from 2022.1.1 to 2022.1.2 by @dependabot in Bump pudb from 2022.1.1 to 2022.1.2 #56
• Bump mkdocs-material from 8.3.8 to 8.3.9 by @dependabot in Bump mkdocs-material from 8.3.8 to 8.3.9 #42
• Bump mkdocs from 1.3.0 to 1.3.1 by @dependabot in Bump mkdocs from 1.3.0 to 1.3.1 #57
• Bump faker from 13.14.0 to 13.15.0 by @dependabot in Bump faker from 13.14.0 to 13.15.0 #44
• Bump types-setuptools from 57.4.18 to 63.2.1 by @dependabot in Bump types-setuptools from 57.4.18 to 63.2.1 #53
• Bump pre-commit from 2.19.0 to 2.20.0 by @dependabot in Bump pre-commit from 2.19.0 to 2.20.0 #45
• Bump mypy from 0.961 to 0.971 by @dependabot in Bump mypy from 0.961 to 0.971 #55
• Bump fastapi from 0.78.0 to 0.79.0 by @dependabot in Bump fastapi from 0.78.0 to 0.79.0 #50
• Bump sqlalchemy-utils from 0.38.2 to 0.38.3 by @dependabot in Bump sqlalchemy-utils from 0.38.2 to 0.38.3 #48

Full Changelog: v0.0.4...v0.1.0

---

This discussion was created from the release Merge ordering and filtering under the same class.