PYTHON

django annotate concat string

from django.db.models.functions import Concat
from django.db.models import Value, CharField

class OrderManager(models.Manager):
  def get_queryset(self):
      """Overrides the models.Manager method
         creates another callable field in orders model named 'link'
      """
      qs = super(OrderManager, self).get_queryset()
      .annotate(
        link=Concat(Value("<a href='#'>"), 'order_id', Value('</a>'), output_field=CharField()))
      return qs

class Order(models.Model):
    order_id = models.IntegerField(primary_key=True, null=False)
    # other fields  here 
    objects = OrderManager()