在SQL中查看Django查询

Question

我有以下django问题：

entries = Catalog.objects.exclude(
                              itunes_pulldown_error_status = ITUNES_PULLDOWN_APPLE_INTERNAL_ERROR, date_last_updated_affiliate__lte = now-datetime.timedelta(hours=48)
                         ).exclude(
                            itunes_pulldown_error_status = ITUNES_PULLDOWN_NO_CONTENT_FOUND, date_last_updated_affiliate__lte = now-datetime.timedelta(days=7)
                         ).filter(
                              provider__premiere_can_view_provider=True, platform_id='ITUNES'
                        ).filter(
                              Q(date_last_updated_transporter__isnull=True)
                             |Q(date_last_updated_affiliate__gte=F('date_last_updated_transporter'))
                        ).extra(
                            where=['apple_id mod %s=%s' % (divisor, remainder)]
                        ).distinct()[:1000]

如何查看这个查询在pythonshell中生成的SQL？你知道吗

Answer 1

您可以通过执行以下操作查看生成的SQL：

>>> entries = Catalog.objets.exclude(...)
>>> print entries.query