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

Change History (1)

by nitishxp, 3 years ago

Attachment: Django.png added
Note: See TracTickets for help on using tickets.
Back to Top