Wich reference for filter like : repo.list_and_count(YourTable.name.is_(None))

[karmic sable]

Hello guys,

Do you know where I can fin filters used by litestar on repo/services/... using methods like is_, ...

I understand SQLA select with where clauses methods ex: select(Table).join(...).where(), but don't find how to convert them into filters.

Actually i override statement using where conditions instead of using filters cause I can't find a doc that list all methods.

Plus, when should I use statement instead of filter ?

Have a sunny day

[forest mural]

Notes for Wich reference for filter like : repo.list_and_count(YourTable.name.is_(None))

At your assistance

@karmic sable

No Response?

If no response in a reasonable time, ping @Member.

Closing

To close, type !solve or byte solve.

MCVE

Please include an MCVE so that we can reproduce your issue locally.

[compact hinge]

The "filters" are provided by SQLAlchemy, and are what you get when doing something like Table.column == <some value>. You can just pass these directly into the repo methods: repo.list_and_count(Table.column == "foo")

[karmic sable]

i got it using kwargs but if I want to create more complex filters applyed on related field (M2M , ...) ? I would apply theses on create too (for example a user that can reuse ressource that he only own by his id)

[karmic sable]

for exemple in this case (fullstack) :

            filters.append(
                TeamModel.id.in_(select(TeamMemberModel.team_id).where(TeamMemberModel.user_id == current_user.id)),  # type: ignore[arg-type]
            )

If I understand correctly, I should call wich fields should be filtred as column.field.condition ?

so if I want to convert :

        results, total = await profile_service.list_and_count(
            *filters,
            statement=select(Profile)
            .join(Profile.owners)
            .where(User.id == current_user.id),
        )

            Profile.id.in_(
                select(Profile.id)
                .join(Profile.owners)
                .where(User.id == current_user.id)
            )

owners reference table of users, it is right approach ?
Then, how can I use them on get ? to restrict the get to certain data ?

[turbid gyro]

https://github.com/cofin/litestar-fullstack/blob/main/src/app/domain/teams/controllers/teams.py#L48

[inner tartan]

src/app/domain/teams/controllers/teams.py line 48

async def list_teams(

[turbid gyro]

I'm prettty sure this is what you are looking for

[karmic sable]

Yup, i get this bloc of code here @turbid gyro

Just wanna know if there are some doc that I can follow to understand well how can I use the differents parameters to make my filter and beter understand them

Plus, in wich case should i use Statement instead of filters ?

[turbid gyro]

OK, i've got a usage doc PR that's in draft status now. It tries to cover as many usage scenarios as possible.

I'll drop a use case where you might want a custom statement shortly.

[turbid gyro]

https://docs.sqlalchemy.org/en/20/orm/queryguide/columns.html#using-load-only-on-related-objects-and-collections

Here's an example where you should use statement instead of filters

there are few things other than options and execution_options that can get get used in some statements

those are good candidates to for a statement override