/Python/How to write manual querry in drf

How to write manual querry in drf

from django.db import connection

def my_custom_sql(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.fetchone()

    return row

Source: docs.djangoproject.com

Similar codes

8 votes204 views2 answers
What does class meta do in django
Python
10 votes237 views10 answers
Python Program to capitalize a string
Python
1 vote210 views1 answer
Represent NaN with pandas in python
Python
0 vote207 views1 answer
Onetoone vs foreign key django
Python
1 vote265 views1 answer
Django migrate fake zero
Python Django
1 vote150 views1 answer
Python close all figures
Python
0 vote218 views1 answer
Access key through value python
Python
0 vote201 views1 answer
Packing and unpacking in python
Python
105 votes204 views6 answers
Install opencv
Python
1 vote202 views1 answer
Python multiply one column of array by a value
Python