Django queryset:如何根据queryset字段过滤RawSQL批注

Question

在Django中可以做这样的事情吗：

MyModel.objects.annotate(
    val=RawSQL(
        "SELECT COUNT(*) FROM another_model_table where some_field= %s",
            (a_field_from_MyModel)
        )
    )

谢谢!

Answer 1

你可以这样做：

MyModel.objects.annotate(
    val=RawSQL(
        """SELECT COUNT(*) FROM another_model_table 
            where some_field=myapp_mymodel.some_field""",
    )
)