postgresql jsonField save dict

Using Django Using the ORM
1 
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
         ...

DBMS: PostgreSQL (Version 14.4 (Ubuntu 14.4-1.pgdg20.04+1))
Case sensitive: normal form=lower, delimited form=exact
Driver: PostgreSQL JDBC Driver (version 42.2.5, JDBC4.2)

postgresql jsonfield save data like it
{“a”: “b”}

jango default jsonField get data is dict

image
image1536×499 96.8 KB

This is how I currently solve it.

class CustomJsonField(models.JSONField):
    def from_db_value(self, value, expression, connection):
        if isinstance(value, dict):
            return value
        return super().from_db_value(value, expression, connection)

Is it possible to consider solving it this way?

        if isinstance(expression, KeyTransform) and not isinstance(value, str):
            return value
        try:
            # PostgreSQL database save json return dict
+            if isinstance(value, dict):
+                return value
            return json.loads(value, cls=self.decoder)
        except json.JSONDecodeError:
            return value
2

There’s not much of a description here of the issue you’re facing.

Can you provide more details about what the problem is that you’re having and are trying to solve?

3

image
image1821×768 169 KB

My solution was to inherit JSONField

class CustomJsonField(models.JSONField):
    def from_db_value(self, value, expression, connection):
        if isinstance(value, dict):
            return value
        return super().from_db_value(value, expression, connection)