hretic hretic - 1 year ago 102
Python Question

Django ORM : how can i see last executed query on fly

so lets say we have a simple query using django orm

filterd = User.objects.exclude(id = ).filter(username=data['username'] )

this is suppose to return some objects but it returns none !
obviously i'm doing something wrong as i' not comfortable with django ORM yet , so i'll help alot to know what query is exactly executed in this line

i've searched around i found this


but i get

AttributeError: type object 'filter' has no attribute 'query'

i guess filter is None when no object is returned so ... what should i do ?

Answer Source


from django.db import connection as conn
filterd = User.objects.exclude(id =['username'] )
# to execute query
print filterd
print conn.queries
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download