GROUP_CONCAT equivalent in Django

by

You can create your own Aggregate Function (doc)

from django.db.models import Aggregate

class Concat(Aggregate):
    function = 'GROUP_CONCAT'
    template="%(function)s(%(distinct)s%(expressions)s)"

    def __init__(self, expression, distinct=False, **extra):
        super(Concat, self).__init__(
            expression,
            distinct="DISTINCT " if distinct else '',
            output_field=CharField(),
            **extra)

and use it simply as:

query_set = Fruits.objects.values('type').annotate(count=Count('type'),
                       name = Concat('name')).order_by('-count')

I am using django 1.8 and mysql 4.0.3

More Related Contents:

  1. Can I concatenate multiple MySQL rows into one field?
  2. How can I temporarily disable a foreign key constraint in MySQL?
  3. MySQL and GROUP_CONCAT() maximum length
  4. How to use GROUP_CONCAT in a CONCAT in MySQL
  5. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  6. What is the opposite of GROUP_CONCAT in MySQL?
  7. MySQL DISTINCT on a GROUP_CONCAT()
  8. GROUP_CONCAT ORDER BY
  9. GROUP_CONCAT with limit
  10. Problems with contenttypes when loading a fixture in Django
  11. MySQL: Sort GROUP_CONCAT values
  12. How create json format with group-concat mysql?
  13. Django – installing mysqlclient error: mysqlclient 1.3.13 or newer is required; you have 0.9.3
  14. Django MySQL full text search
  15. How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?
  16. What’s the best way to migrate a Django DB from SQLite to MySQL?
  17. How to use django models with foreign keys in different DBs?
  18. How to drop all tables from the database with manage.py CLI in Django?
  19. Database returned an invalid value in QuerySet.dates()
  20. Error installing mysqlclient for python on Ubuntu 18.04
  21. is there a length limit to group_concat or another reason why it would not work on a text field
  22. Trouble with GROUP_CONCAT and Longtext in MySQL
  23. django cannot connect mysql in docker-compose
  24. Creating a “Numbers Table” in MySQL
  25. Rails, MySQL and Snow Leopard
  26. MySQL CONVERT_TZ()
  27. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  28. MySQL: ALTER IGNORE TABLE ADD UNIQUE, what will be truncated?
  29. MySQL – Cannot insert NULL value in column, but I have a default value specified?
  30. Working with INTERVAL and CURDATE in MySQL

Leave a Comment