I have a huge but not complex sql query that must convert to django orm query

Question

I have to convert the following sql query but i don't know how to convert it to equal query in django orm I would be very happy if you can :)))

select dialog_messages.*, 
    sender.first_name as sender_first_name,
     sender.last_name as sender_last_name,
     sender.cell_number as sender_cell_number,
     sender.avatar_full_path as sender_avatar_full_path, receiver.first_name as receiver_first_name,
     receiver.first_name as receiver_first_name,
     receiver.last_name as receiver_last_name,
     receiver.cell_number as receiver_cell_number, receiver.avatar_full_path as receiver_avatar_full_path from dialog_messages`` inner join user sender on ``sender``.``user_id`` = dialog_messages``.``sender_id`` inner join user receiver on receiver``.``user_id`` = ``dialog_messages``.``receiver_id`` where `dialog_id`` = ? order by ``dialog_messages``.``id`` desc

You should post your models. Anyway, this answer could help you: https://stackoverflow.com/questions/48128714/how-to-make-an-inner-join-in-django — oz19, Oct 21 '21 at 23:49

score 0 · Accepted Answer · answered Oct 22 '21 at 07:43

You should use select_related (and also look at prefetch_related). You can check the reference at:

In your code, without knowing more about your models I think you could start with something like:

DialogMessage.objects.select_related('sender', 'receiver')

I have a huge but not complex sql query that must convert to django orm query

1 Answers1