Django创建db视图，并在参数之间进行乘法，取平均值并按时间分组

from django.db import models
from django.db.models import F, Sum, Avg
from django.db.models.functions import TruncDate
from django.db.models.expressions import RawSQL

class MyModel(models.Model):
    time = models.DateTimeField()
    value1 = models.IntegerField()
    value2 = models.IntegerField()

    @classmethod
    def create_db_view(cls):
        queryset = cls.objects.annotate(
            result=F('value1') * F('value2'),
            date=TruncDate('time')
        ).values('date').annotate(
            average=Avg('result')
        )
        sql = queryset.query.get_compiler('default').as_sql()[0]
        view_name = 'my_view'
        create_view_sql = f'CREATE VIEW {view_name} AS {sql}'
        with connection.cursor() as cursor:
            cursor.execute(create_view_sql)