/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

12 votes139 views3 answers
How to delete last N columns of dataframe
Python
15 votes128 views3 answers
How to import numpy in python
Python
0 vote121 views1 answer
How to get table schema sql pyodbc
Python
1 vote154 views1 answer
How to Add a overall Title to Seaborn Plots
Python
0 vote150 views1 answer
Lines = paths.read().splitlines()
Python
1 vote170 views1 answer
Python close gile
Python
0 vote132 views1 answer
Python flatten one liner
Python
11 votes126 views1 answer
How to upgrade 3.6 to 3.7 on linux
Python
3 votes126 views1 answer
Hwo much does mano house cost in python
Python
0 vote174 views1 answer
Django or
Python Django