/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

8 votes225 views5 answers
Find common elements in two lists python
Python
0 vote270 views1 answer
Gevent with flask
Python Flask
0 vote238 views1 answer
Flask server not reloading
Python Flask
6 votes226 views5 answers
How to redirect in django
Python
0 vote222 views1 answer
Convert files from jpg to png and save in a new directory python
Python
0 vote222 views1 answer
Matlab index last element
Python
28 votes220 views3 answers
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xa5 in position 10: invalid start byte
Python
20 votes233 views5 answers
Python replace regex
Python
0 vote230 views1 answer
Numpy get length of list
Python
40 votes225 views6 answers
Add new row to dataframe pandas
Python