SQLAlchemy filter operators #130

aminalaee · 2021-11-02T20:50:17Z

Closes #14.

Allows usage of SQLAlchemy filter methods in the filter query:

notes = await Note.objects.filter(id__in=[1, 2, 3]).all()

Is the same as:

notes = await Note.objects.filter(Note.columns.id.in_([1, 2, 3])).all()

I also added a shortcut property Model.columns to access SQLAlchemy columns easier. Pretty basic, but should be enough for now.

aminalaee added 4 commits November 2, 2021 22:17

Allow SQLAlchemy query clause in filter method

3754d6d

fix tests

1087b3e

fix filters

0b730d3

uplift coverage

0ae66be

aminalaee force-pushed the sqlalchemy-filter-methods branch from 1a39369 to 0ae66be Compare November 2, 2021 21:18

update tests

cb0c364

aminalaee merged commit 0c0228a into master Nov 4, 2021

aminalaee deleted the sqlalchemy-filter-methods branch November 4, 2021 08:55

Provide feedback