/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

1 vote289 views1 answer
How to use Python Glob Module
Python
1 vote304 views2 answers
Explode multiple columns pandas
Python
1 vote267 views1 answer
Py 2 exe
Python
0 vote284 views1 answer
Python create a set of class
Python
0 vote266 views1 answer
TypeError at /admin/auth/user/
Python
0 vote310 views1 answer
Python inspect.getsource
Python
4 votes318 views5 answers
Fibonacci function python
Python
5 votes298 views1 answer
Pythagoras calculator
Python
0 vote272 views1 answer
Tensorboard 2.1.0 has requirement grpcio>=1.24.3, but you'll have grpcio 1.15.0 which is incompatible
Python
5 votes258 views1 answer
Python how to skip iteration
Python