X-Git-Url: https://git.mdrn.pl/redakcja.git/blobdiff_plain/fc7a60feb9496c250cd1e8ca3db8c74267790047..51d914bc0007135058a61623a2d057d2a7626a28:/apps/toolbar/models.py?ds=sidebyside diff --git a/apps/toolbar/models.py b/apps/toolbar/models.py index 8d123fd1..04146223 100644 --- a/apps/toolbar/models.py +++ b/apps/toolbar/models.py @@ -14,6 +14,26 @@ class ButtonGroup(models.Model): def __unicode__(self): return self.name + +#class ButtonGroupManager(models.Manager): +# +# def with_buttons(self): +# from django.db import connection +# cursor = connection.cursor() +# cursor.execute(""" +# SELECT g.name, g.slug, CONCAT(b.slug), +# FROM toolbar_buttongroup as g LEFT JOIN toolbar_button as b +# +# WHERE p.id = r.poll_id +# GROUP BY 1, 2, 3 +# ORDER BY 3 DESC""") +# result_list = [] +# for row in cursor.fetchall(): +# p = self.model(id=row[0], question=row[1], poll_date=row[2]) +# p.num_responses = row[3] +# result_list.append(p) +# return result_list + class Button(models.Model): label = models.CharField(max_length=32) slug = models.SlugField(unique=True) #unused @@ -33,7 +53,7 @@ class Button(models.Model): group = models.ManyToManyField(ButtonGroup) class Meta: - ordering = ('label',) + ordering = ('slug',) verbose_name, verbose_name_plural = _('button'), _('buttons') def hotkey_code(self):