CODEWITHSUNDEEP
djangodjango-rest-framework
Narthe
Narthe

Reputation: 491

Django rest framework serializer with field from related table

I have the following models:

class Workflow(models.Model):
    name = models.CharField(max_length=200)


class Task(models.Model):
    name = models.CharField(max_length=200)


class TaskParameter(models.Model):
    default_value = models.CharField(max_length=1000, null=True)
    name = models.CharField(max_length=200)
    task = models.ForeignKey(Task, related_name='parameters', on_delete=models.CASCADE, null=True)


class WorkflowTask(models.Model):
    task = models.ForeignKey(Task, on_delete=models.CASCADE)
    workflow = models.ForeignKey(Workflow, related_name='workflow_tasks', on_delete=models.CASCADE, null=True)


class WorkflowTaskParameter(models.Model):
    value = models.CharField(max_length=1000)
    workflow_task = models.ForeignKey(WorkflowTask, on_delete=models.CASCADE, related_name='workflow_task_parameters', null=True)
    task_parameter = models.ForeignKey(TaskParameter, on_delete=models.CASCADE, related_name='+')

So basically what i try to do is having workflows that contain tasks (Using the WorkflowTask association table), and those tasks have parameters (TaskParameter). Those parameters have a default value but i want to be able to override this default value with another one (that's what the WorkflowTaskParameter table is for).

And here are my serializers :

class TaskParameterSerializer(serializers.ModelSerializer):
    class Meta:
        model = TaskParameter
        fields = ('name', 'default_value')

class WorkflowTaskParameterSerializer(serializers.ModelSerializer):
    name = serializers.StringRelatedField(many=False) # here i want the name from the associated TaskParameter

    class Meta:
        model = WorkflowTaskParameter
        fields = ('name', 'value')

class WorkflowTaskSerializer(serializers.ModelSerializer):
    task = serializers.StringRelatedField(many=False)
    workflow_task_parameters = WorkflowTaskParameterSerializer(many=True, read_only=True)

    class Meta:
        model = WorkflowTask
        fields = ('task', 'workflow_task_parameters')

class WorkflowSerializer(serializers.ModelSerializer):
    workflow_tasks = WorkflowTaskSerializer(many=True, read_only=True)

    class Meta:
        model = Workflow
        fields = ('name', 'workflow_tasks')

I'm almost getting the result i want :

  {
    "name": "MyWorkflow",
    "workflow_tasks": [
      {
        "task": "MyTask",
        "workflow_task_parameters": [
          {
            // missing the task parameter name here
            "value": "myoverridedvalue"
          }
        ]
      }
    ]
  }

As mentionned in comments, why is the task parameter name not appearing in the result even though i put a "name" StringRelatedfield in the WorkflowTaskParameterSerializer ? Is it a design problem ?

Upvotes: 3

Views: 3422

Answers (1)

a_k_v
a_k_v

Reputation: 1608

Change it as

name = serializers.CharField(source='task_parameter.name')

Upvotes: 4

Related Questions