RS
Size: a a a
RS
AS
AS
BE
DT
BE
DT
l
qs.values('href').annotate(dcount=Count('href')).filter(dcount=1).values_list('href', flat=True)
).order_by('-pk')DT
l
l
DT
BE
PZ
PZ
class Category(MPTTModel):
parent_category = TreeForeignKey(
'self',
verbose_name=_("Parent Category"),
null=True,
blank=True,
on_delete=models.CASCADE,
related_name='subcategories',
)
Category.objects.exclude(subcategories=None).filter(parent_category=None)
PZ
In [11]: str(Category.objects.exclude(subcategories=None).filter(parent_category=None).query)
Out[11]: 'SELECT "main_category"."id", "main_category"."created", "main_category"."modified", "main_category"."company_id", "main_category"."name", "main_category"."info", "main_category"."parent_category_id", "main_category"."lft", "main_category"."rght", "main_category"."tree_id", "main_category"."level" FROM "main_category" WHERE (NOT ("main_category"."id" IN (SELECT U0."id" FROM "main_category" U0 LEFT OUTER JOIN "main_category" U1 ON (U0."id" = U1."parent_category_id") WHERE U1."id" IS NULL)) AND "main_category"."parent_category_id" IS NULL) ORDER BY "main_category"."tree_id" ASC, "main_category"."lft" ASC'
J
BE
class Category(MPTTModel):
parent_category = TreeForeignKey(
'self',
verbose_name=_("Parent Category"),
null=True,
blank=True,
on_delete=models.CASCADE,
related_name='subcategories',
)
Category.objects.exclude(subcategories=None).filter(parent_category=None)
PZ
Т