sqlalchemy-mixins

sqlalchemy-mixins copied to clipboard

I've been using the SmartQueryMixin and really love how easy it is to add filters to my FastAPI based API based on this simple syntax. However I'm using the Ltree...

kehh

- Issue: https://github.com/absent1706/sqlalchemy-mixins/issues/86

jeandelacruz

Serialization not working to field type **DateTime** or **Time**. ``` class StoreOpeningHour(BaseModel): __tablename__ = 'stores_opening_hours' id = Column(Integer, primary_key=True, autoincrement=True) day = Column(Integer, index=True) hour_open = Column(Time, index=True) hour_close =...

jeandelacruz

Relationship exclude to serializate

2

**I have run into the problem that, exclude to field relation, it does not do so.** First Model ``` class User(BaseModel): id = Column(Integer, primary_key=True, autoincrement=True) name = Column(String(100), index=True)...

jeandelacruz

Hotfix: Add exclude to relations

4

**- I was able to observe that the option to exclude fields from serialization does not work, when they are relations**

jeandelacruz

Improvements, and plans for the future.

15

@michaelbukachi, we should collect all suggestions/thoughts from the community, on which things we should focus on in the future, which features we should implement, and what type of improvements the...

myusko

Commit changes to DB. Fix #53

11

Notes: - Tested manually using MySQL v8.0.21 - Ran all `pytest` test cases. (76/76 passed. 16 warnings)

Shashwat986

Can not be configured use .commit instead .flush

9

Now in project after Model.create(name="zxc") i need use db.session.commit().

galetskiav

Smart querying performing multiple joins

2

I have the following db structure: ```python from sqlalchemy import Column, Integer, String, ForeignKey from sqlalchemy.orm import relationship class Author(BaseModel): __tablename__ = 'author' id = Column(Integer, primary_key=True) first_name = Column(String(255),...

AbdealiLoKo

Add : support for paginate()

2

Currently due to `SmartQueryMixin.where()` and `SmartQueryMixin.sort()` returning an instance of `sqlalchemy.orm.query.Query` they can't be chained together either with each other, or with other future functions. e,g: ``` Post.where(rating__in=[2, 3, 4]).sort('-rating',...

MaxCheetham