def annotate_most_recent_scan_error_count(self) -> 'ScanListQuerySet':
return self.annotate(
last_scan__error_count=RawSQL('''
SELECT COUNT("id")
FROM "{ScanError}"
WHERE
"{ScanError}"."scan_id" = "{Site}"."last_scan_id"
'''.format(
Scan=Scan._meta.db_table,
Site=Site._meta.db_table,
ScanError=ScanError._meta.db_table), ()))
评论列表
文章目录