/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

2 votes139 views1 answer
Filter a column in pandas by list of values
Python
0 vote173 views1 answer
Python split string with a seperator
Python
0 vote157 views1 answer
Numpy convert true false to 0 1
Python
0 vote159 views1 answer
Delete python text after 1 sec
Python
0 vote143 views1 answer
Webdriver.ChromeOptions()
Python
0 vote163 views1 answer
Virtual mic with python
Python
1 vote209 views1 answer
Django update increment
Python Django
0 vote174 views1 answer
Blender Python perspective camaera
Python
3 votes151 views5 answers
Python get attributes of object
Python
-1 vote151 views2 answers
Find common values in different dataframes pandas
Python