/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

3 votes287 views1 answer
Datetime.timedelta months
Python
0 vote300 views1 answer
Codegrepper is cool
Python
8 votes304 views2 answers
Python using webbrowser
Python
1 vote338 views2 answers
Set recursion limit python
Python
1 vote331 views1 answer
Show image in tkinter pillow
Python
0 vote316 views1 answer
Fibonacci sequence generator python
Python
1 vote323 views2 answers
Python string exclude non alphabetical characters
Python
0 vote299 views2 answers
Insert character into string at position x python
Python
0 vote341 views1 answer
Python path from string
Python
1 vote387 views2 answers
Django queryset unique values
Python Django