Add between as a usable operator
This PR aims to expose the between() operator present in SQLAlchemy.
While the conjunction of lte and gte operators can suffice when dealing with numerical columns this opens the possibility of using the operator also on textual and date columns with a single operator.
The proposed implementation asks the user to input a list, the first two element are considered the right and left sides of the queried interval. If more than two elements are present they are simply ignored.
Deploy Preview for fastapi-filter ready!
| Name | Link |
|---|---|
| Latest commit | a2e98b9e2fca2e407aaa44a3c9ee6916266b7c99 |
| Latest deploy log | https://app.netlify.com/sites/fastapi-filter/deploys/6613e71a6673e00008eeef0f |
| Deploy Preview | https://deploy-preview-551--fastapi-filter.netlify.app |
| Preview on mobile | Toggle QR Code...Use your smartphone camera to open QR code link. |
To edit notification comments on pull requests, go to your Netlify site configuration.
Codecov Report
All modified and coverable lines are covered by tests :white_check_mark:
Project coverage is 100.00%. Comparing base (
e0f2fa8) to head (a2e98b9).
Additional details and impacted files
@@ Coverage Diff @@
## main #551 +/- ##
=========================================
Coverage 100.00% 100.00%
=========================================
Files 6 6
Lines 193 196 +3
=========================================
+ Hits 193 196 +3
| Files | Coverage Ξ | |
|---|---|---|
| fastapi_filter/contrib/sqlalchemy/filter.py | 100.00% <100.00%> (ΓΈ) |