/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 vote188 views1 answer
Python memoization
Python
0 vote188 views1 answer
Django populate database in view
Python
0 vote211 views1 answer
Python flask how to remove last character from string
Python Flask
0 vote179 views1 answer
Pandas to json without index
Python
-1 vote183 views1 answer
How to give values to all users with discord api python grepper
Python
1 vote190 views1 answer
How to append rows to a numpy matrix
Python
10 votes208 views5 answers
Ordered dictionary python
Python
1 vote204 views1 answer
Seconds add zero python
Python
1 vote210 views2 answers
One hot encoding numpy
Python
6 votes195 views2 answers
Django read mesage
Python