/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

28 votes284 views3 answers
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xa5 in position 10: invalid start byte
Python
1 vote294 views2 answers
Save timestamp python
Python
2 votes318 views1 answer
Python how to make an array of ones
Python
0 vote294 views1 answer
How to search on wikipedia with python and speak the result
Python
7 votes314 views3 answers
Subtract list from list python
Python
2 votes311 views1 answer
Load custom font pygame
Python
0 vote284 views1 answer
Filtrar en python/how to filter in python
Python
11 votes296 views4 answers
Sorted python lambda
Python
30 votes301 views1 answer
Python generate folder if it not exist
Python
26 votes314 views2 answers
Random picker in python
Python