Opened 3 years ago
Last modified 3 years ago
#33424 closed Bug
Jsonfield data being returned as str — at Initial Version
Reported by: | nitishxp | Owned by: | nobody |
---|---|---|---|
Component: | Database layer (models, ORM) | Version: | 3.2 |
Severity: | Normal | Keywords: | Database, Django Cursor |
Cc: | Triage Stage: | Unreviewed | |
Has patch: | no | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description
Hi,
I encountered a bug in raw postgresql query
from django.db.models import JSONField
from django.db import connection
class Job(models.Model):
job_dict = JsonField()
def view(request):
with connection.cursor() as cursor:
cursor.execute("select job_dict from app.job", ())
column_names = [desc[0] for desc in cursor.description]
results = [dict(zip(column_names, row)) for row in cursor.fetchall()]
The given result will have the job_dict column as string instead of dictionary