Question 184569 in Telegram API Question posted in
A comprehensive official documentation can be found here.

Telegram – Django ORM Q and Async

I’m using django with Telegram Bot

If i need to make ORM Query, i can do it like that

    all_offers = await sync_to_async(Offers.objects.filter, thread_sensitive=True)(
        status      = True,
    )

but not i need to make more difficult query with Q function like that

    all_offers = await sync_to_async(Offers.objects.filter, thread_sensitive=True)(
        status      = True,
        Q(some_field="1")|Q(another_field=2),
    )

SyntaxError: positional argument follows keyword argument

How it can be solved?

Tags:

2

Answers


  1. 0

    as the error says, you can not place positional parameters after keyword ones, so you should put the Q object first:

    all_offers = await sync_to_async(Offers.objects.filter, thread_sensitive=True)(
    Q(some_field='1') | Q(another_field=2),
    status=True,
)

    Using an asynchronous filter however does not make much sense: .filter() is lazy: that means that you only construct a QuerySet asynchronously, not fetch the records themselves in an asynchronous manner. The reason there is no .afilter(…), .aannotate(…), etc. is because these do not generate a query, only produce a new QuerySet that might (or will not) eventually make a database query.

    You can make use of an async for when you enumerate over the queryset. For more information, see the Asynchronous support section of the documentation.

    Login or Signup to reply.
  2. 0 
    await sync_to_async(Region.objects.filter)(Q(title__icontains=region).first)()

    is correct?

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search