/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

17 votes272 views4 answers
Pip install python 3
Python
9 votes249 views6 answers
Python sort list
Python
0 vote255 views1 answer
Get the count of each categorical value (0 and 1) in labels
Python
1 vote296 views1 answer
Use sqlalchemy to create sqlite3 database
Python
4 votes262 views1 answer
Drop Rows by Index in dataframe
Python
0 vote245 views1 answer
Crontab python
Python
34 votes233 views6 answers
Class python example
Python
1 vote248 views1 answer
Create period pandas
Python
0 vote269 views2 answers
Set environment variable heroku django
Python
0 vote256 views1 answer
Determinant of 3x3 numpy
Python