Model
class Entity(models.Model):
uuid = models.UUIDField(editable=False, unique=True, default=uuid.uuid4)
institute_name = models.CharField(max_length=100, null=False)
owner_name = models.CharField(max_length=100, null=False)
contact_no = models.CharField(max_length=100, null=False)
email_id = models.CharField(max_length=100, null=False, unique=True)
# required fields for registration
owner_password = models.CharField(max_length=100, null=True)
address = models.CharField(max_length=200, default="")
email_id_verified = models.BooleanField(default=False)
phone_no_verified = models.BooleanField(default=False)
registered_business = models.BooleanField(default=False)
owner_id_details = models.JSONField(default=dict)
registration_details = models.JSONField(default=dict)
is_active = models.BooleanField(default=False)
created_at = models.DateTimeField(auto_now_add=True)
updated_at = models.DateTimeField(auto_now=True)
View
This is the get api for getting entity detail.
class EntityDetailView(APIView):
def get(self, request, id):
entity = get_object_or_404(Entity, uuid=id)
serializer = EntitySerializer(entity)
return Response(serializer.data)
Resulting SQL query
SELECT "entities_entity"."id",
"entities_entity"."uuid",
"entities_entity"."institute_name",
"entities_entity"."owner_name",
"entities_entity"."contact_no",
"entities_entity"."email_id",
"entities_entity"."owner_password",
"entities_entity"."address",
"entities_entity"."email_id_verified",
"entities_entity"."phone_no_verified",
"entities_entity"."registered_business",
"entities_entity"."owner_id_details",
"entities_entity"."registration_details",
"entities_entity"."is_active",
"entities_entity"."created_at",
"entities_entity"."updated_at"
FROM "entities_entity"
WHERE "entities_entity"."uuid" = '68e0956b-c166-4844-8842-51371c385a90'::uuid
LIMIT 21
Why is django adding limit 21 in my resulting SQL Query
I tested it using django debug toolbar
New contributor
Anshul-Dishoriya is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.