Saving JSON Data in Django Model Field with MySQL

To save this JSON data in a Django model field of type JSONField in MySQL, follow these steps:

1. Import the JSONField from django.db.models.fields.json:

from django.db import models
from django.db.models.fields.json import JSONField

2. Define your model with a JSONField:

class ApprovalRequest(models.Model):
    request_data = JSONField()

3. Create a new instance of your model and set the request_data field to your JSON data:

import json

data = {
    'allowAction': [
        'Approve'
    ],
    'assignmentType': 'Single User',
    'userEntity': [
        {
            'id': 'mailto:alok@getmaxlisteners.com',
            'value': 'Alok'
        }
    ],
    'timeLimit': '5',
    'timeLimitType': 'Hour',
    'completionPolicy': 'Majority of approvers'
}

approval_request = ApprovalRequest.objects.create(request_data=json.dumps(data))

4. To retrieve the JSON data from the database, simply access the request_data field:

approval_request = ApprovalRequest.objects.get(id=1)
data = json.loads(approval_request.request_data)