Can I cache a variable in ModelSchema?

[pyang30]

code like this: I query SomeMode three times to get a OutSchema, Question: Can I cache the 'x' result to reduce db query?

class  OutSchema(ModelSchema):
    out_a: str
    out_b: str,
    out_c: str
    class Config:
         model = M

    @staticmethod
    def resolve_out_a(obj):
            x = SomeModel.objects.get(name=obj.xxx)
            return x.out_a

    @staticmethod
    def resolve_out_b(obj):
            x = SomeModel.objects.get(name=obj.xxx)
            return x.out_b

    @staticmethod
    def resolve_out_c(obj):
            x = SomeModel.objects.get(name=obj.xxx)
            return x.out_c

[vitalik]

@pyang30 well either use builtin django cacheing functions or just cache it as an attrribute on your obj:

class  OutSchema(ModelSchema):
    ...

    @staticmethod
     def get_somemodel_x(obj):
         if not hasattr(obj, '_x'):
             obj._x = SomeModel.objects.get(name=obj.xxx)
         return obj._)x
            
    @staticmethod
    def resolve_out_a(obj):
         return OutSchema.get_somemodel_x(obj).out_a

    @staticmethod
    def resolve_out_b(obj):
         return OutSchema.get_somemodel_x(obj)..out_b

    @staticmethod
    def resolve_out_c(obj):
         return OutSchema.get_somemodel_x(obj)..out_c