[TOC] >[success] # ORM 數量查詢的三種方式 >[danger] ##### 正向查找 數量 ~~~ @override_settings(DEBUG=True) def test_filter(self): categories = Categroy.objects.filter(owner__username="wang").count() print(categories) pp(connection.queries) ~~~ >[danger] ##### 反向查找，不推薦 * 通過關聯表，但 ForeignKey 關系是通過被關聯表查詢 ~~~ @override_settings(DEBUG=True) def test_filter(self): # categories = Categroy.objects.filter(owner__username="wang").count() user = User.objects.filter(username="wang") user = user[0] print(user.categroy_set.count()) pp(connection.queries) ~~~ >[danger]#### 反向查找可以使用 annotate(cate_count=Count('categroy')) 中的cate_count 是起別名，不是特定屬性 <a href="https://yiyibooks.cn/xx/Django_1.11.6/topics/db/aggregation.html">更多<a> ~~~ @override_settings(DEBUG=True) def test_filter(self): # categories = Categroy.objects.filter(owner__username="wang").count() from django.db.models import Count user = User.objects.filter(username="wang").annotate(cate_count=Count('categroy')) user = user[0] print(user.cate_count) pp(connection.queries) ~~~