Django: annotate queryset with string

Question

I need to annotate a queryset with strings from dictionary. The dictionary keys come from the model's field called 'field_name'.

I can easily annotate with strings from dictionary using the Value operator:

q = MyModel.objects.annotate(
  new_value=Value(value_dict[key], output_field=CharField()))

And I can get the field value from the model with F expression:

q = MyModel.objects.annotate(new_value=F('field_name'))

Putting them together however fails:

# doesn't work, throws
# KeyError: F(field_name)    
q = MyModel.objects.annotate(
  new_value=Value(value_dict[F('field_name')],
                  output_field=CharField()))

Found this question, which afaiu tries to do the same thing but that solution throws another error:

Unsupported lookup 'field_name' for CharField or join on the field not permitted.

I feel like I'm missing something really obvious here but I just can't get it to work. Any help appreciated.

Well a dictionary does not understand a Django F value, since Python evaluates value_dict[F('field_name')], that thus means it raises an error. You can do this by using a Case(When(..)) ssequence, but I really doubt if this will be an improvement. — willeM_ Van Onsem
– willeM_ Van Onsem, Commented Oct 15, 2018 at 14:53
Case(When( is the idea behind the solution in the linked question. Couldn't get that to work either.. — runs on clozapine
– runs on clozapine, Commented Oct 15, 2018 at 14:58

runs on clozapine · Accepted Answer · 2018-10-15 15:52:22Z

5

Right, just as I thought, a tiny piece was missing. The Case(When(... solution in the linked question worked, I just needed to wrap the dictionary value in Value() operator as follows:

qs = MyModel.objects.annotate(
    new_value=Case(
        *[ When(field_name=k, then=Value(v)) for k,v in value_dict.items() ],
        output_field=CharField()
    )
)

answered Oct 15, 2018 at 15:52

runs on clozapine

1512 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Django: annotate queryset with string

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related