인프런 커뮤니티 질문&답변

class TbVaResult(models.Model):
    report_id = models.ForeignKey(TbVaReport, on_delete=models.PROTECT, db_column="report_id")
    result_type = models.CharField(max_length=10)
    asset_cd = models.CharField(max_length=20)
    measure_cd = models.CharField(max_length=10)
    result_cd = models.CharField(max_length=10, blank=True, null=True)
    result_desc = models.CharField(max_length=4000, blank=True, null=True)
 
    class Meta:
        db_table = 'tb_va_result'
        unique_together = (('report_id', 'result_type', 'asset_cd', 'measure_cd'),)

위와 같은 model이 있고,

 {
        "report_id": "IS_LX_2023_0010",
        "result_type": "C",
        "asset_cd": "LX001",
        "result": [
            {
                "measure_code": "LX1-01-R",
                "result": "Y",
                "result_code": "LX1-01-SA",
                "result_desc": "root"
            },
            {
                "measure_code": "LX1-03-R",
                "result": "SELF",
                "result_code": "LX1-03-SA",
                "result_desc": "인터뷰"
            }
        ]
    }

이런 데이터를 보내려고 합니다.

serializer를 통해 아래와 같은 데이터를 만들어 테이블(TbVaResult)에 쓰려고 합니다.

{
		"report_id": "IS_LX_2023_0012",
		"result_type": "C",
		"asset_cd": "LX001",
		 "measure_cd": "LX1-01-R",
		 "result_cd": "Y",
		 "result_desc": "root"
	},
	{
		"report_id": "IS_LX_2023_0012",
		"result_type": "C",
		"asset_cd": "LX001",
		"measure_cd": "LX1-03-R",
		"result_cd": "SELF",
		"result_desc": "인터뷰"
	}

views.py

class ResultCreateViewSet(viewsets.ModelViewSet):
    queryset = TbVaResult.objects.all()
    serializer_class = ResultCreateSerializer
    authentication_classes = [JWTAuthentication]
    permission_classes = [IsAuthenticated]

serializers.py

class ResultSerializer(serializers.Serializer):
    measure_cd = serializers.CharField()
    result_cd = serializers.CharField()
    result_desc = serializers.CharField()

class ResultCreateSerializer(serializers.Serializer):
    result = ResultSerializer(many=True)
    report_id = serializers.CharField()
    result_type = serializers.CharField()
    asset_cd = serializers.CharField()

    def create(self, validated_data):
        print('===============================================')
        print('validated_data:', validated_data)
        result_data = validated_data.pop('result')
        print('result_data:', result_data)
        report_id = validated_data.pop('report_id')
        result_type = validated_data.pop('result_type')
        asset_cd = validated_data.pop('asset_cd')

        tb_va_report = TbVaReport.objects.get(report_id=report_id)

        for result_item in result_data:
            measure_cd = result_item.pop('measure_cd')
            result_cd = result_item.pop('result_cd')
            result_desc = result_item.pop('result_desc')

            tb_va_result = TbVaResult.objects.create(
                report_id=tb_va_report,
                result_type=result_type,
                asset_cd=asset_cd,
                measure_cd=measure_cd,
                result_cd=result_cd,
                result_desc=result_desc
            )

        return tb_va_result

"Got AttributeError when attempting to get a value for field result on serializer ResultCreateSerializer." 이런 에러가 발생하네요.

DB에 쓸때 result 가 안들어가는데 어디서 발생되는 에러인지 모르겠습니다.

도움을 부탁드립니다. ㅠㅠ