/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

34 votes109 views6 answers
Simple flask app
Python
10 votes87 views2 answers
Rotation turtle python
Python
0 vote140 views2 answers
Go to python
Python
0 vote92 views1 answer
Fibonacci sequence in python 2.7
Python
0 vote111 views1 answer
Djago get settings
Python
1 vote105 views1 answer
Flask return error response
Python
1 vote99 views1 answer
Adding variable in python
Python
6 votes94 views6 answers
Pandas drop missing values for any column
Python
0 vote91 views1 answer
Select features and label from df
Python
18 votes111 views6 answers
Strptime
Python