How to parse this Postgresql query into Django

Question

I have this Postgresql query:

select a.code from accounts a where a.code like '0077-7575%' or '0077-7575' like a.code||'%'

At django I am trying to do this:

q = Accounts.objects.filter(Q(code__startswith='0077-7575') | Q('0077-7575'__startswith=code))

The thing is I don't know and can't find a way to translate '0077-7575' like a.code||'%' into django since a.code is the field name... How can I solve this?

Doesnt work is too vague. Specify your issue. Any error? Wrong result like that — JPG
– JPG, Commented Jun 7, 2020 at 17:48
@ArakkalAbu I can't figure it out how to query '0077-7575' like a.code||'%' in Django, keeping in mind a.code is a field. — assembler
– assembler, Commented Jun 7, 2020 at 17:56

Artur Shyshko · Accepted Answer · 2020-06-07 18:10:24Z

1

If i am guessing correctly (that you are trying to check that your field is contained inside '0077-7575', you could try something written in this answer.

Basically you would have to do smth like:

Accounts.objects \ 
  .annotate(querystring=Value('0077-7575', output_field=CharField())) \ 
  .filter(querystring__contains=F('code'))

answered Jun 7, 2020 at 18:10

Artur Shyshko

1636 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to parse this Postgresql query into Django

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related