Django Rest Framework complex SQL query

Question

I was asked to create the backend of a project using Django (the frontend is angular). So I thought about using rest framework but I'm a total beginner and raw sql queries are needed for this project. To be more precise it's a complex query that needs many tables: they provided the sql script that I need to use it directly.

My question is does rest framework allow such raw queries (because I was not able to find a tutorial about that) or do I need something else?

Edit for further explanation: I'm I able to return complex queries in rest framework as a GET request for example? Any help is appreciated.

The Django ORM can make very complex queries, you may want to check docs.djangoproject.com/en/4.0/topics/db/queries — Damien Baldy
– Damien Baldy, Commented Jun 30, 2022 at 10:43

Ayman · Accepted Answer · 2022-06-30 10:51:48Z

1

You can use the raw function to make it

Model.objects.raw("WRITE YOUR SQL HERE")

answered Jun 30, 2022 at 10:51

Ayman

3632 silver badges9 bronze badges

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

3 Comments

LA. Over a year ago

Does this work in rest framework? my main problem is how to return the result of the query as a GET request for example

Ayman Over a year ago

this doesn't have any relation with rest framework it's the same as using filter

Ayman Over a year ago

add more details ... what do you want to do?

Abhi · Accepted Answer · 2022-06-30 15:55:07Z

0

You can use cursor connection for direct execute SQL query.

from django.db import connection

def my_query(self):
    with connection.cursor() as cursor:
    cursor.execute("UPDATE bar SET foo = 1 WHERE baz = %s", [self.baz])
    cursor.execute("SELECT foo FROM bar WHERE baz = %s", [self.baz])
    row = cursor.fetchall()

return row

answered Jun 30, 2022 at 15:55

Abhi

779 bronze badges

1 Comment

LA. Over a year ago

Does this work in rest framework? my main problem is how to return the result of the query as a GET request for example

Collectives™ on Stack Overflow

Django Rest Framework complex SQL query

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related