/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

0 vote375 views1 answer
Selenium press tab python
Python
5 votes367 views1 answer
UnicodeDecodeError: 'charmap' codec can't decode byte 0x9e in position 3359: character maps to <undefined>
Python
0 vote360 views1 answer
Remove hh:mm:ss from pandas dataframe column
Python
6 votes312 views3 answers
Print text on turtle screen
Python
3 votes371 views1 answer
2x + 9y = -7 6x - 3y = 9
Python
0 vote352 views1 answer
Matplotlib scatter increase marker size
Python
0 vote382 views1 answer
"api_view" is not defined django
Python Django
1 vote373 views1 answer
Stack overflow python ip check
Python
0 vote356 views1 answer
How to set text in qdateedit pyqt5
Python
1 vote362 views1 answer
Import CSV Files into R Using fread() method
Python