/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

4 votes265 views1 answer
Tkinter frame example
Python
15 votes235 views3 answers
Get the current year in python
Python
1 vote261 views1 answer
Wheter tomorrow
Python
0 vote254 views1 answer
Pandas dataframe any along row
Python
0 vote255 views1 answer
Python mouse listener
Python
6 votes256 views2 answers
Decimal in python
Python
0 vote249 views1 answer
Json database python
Python
1 vote247 views3 answers
Isprime python
Python
6 votes249 views2 answers
Delete variable python
Python
0 vote246 views1 answer
Pandas boolean array calculating the average of two columns based on a filter or a 3rd column
Python