Junior — Middle+
Top 10 users with more than five purchases
livecode
Task condition
Based on the provided models, you need to create a list of ten users who have made more than five purchases.
class User(db.Models):
name = models.CharField(
max_length=256,
blank=True,
default="",
verbose_name="Name"
)
class Product(db.Models):
name = models.CharField(
max_length=256,
blank=True,
default="",
verbose_name="Name"
)
price = models.DecimalField()
class Purchase(db.Models):
user = models.ForeignKey(
model=User,
related_name="purchase",
on_delete=models.CASCADE
)
product = models.ForeignKey(
model=Product,
related_name="purchase",
on_delete=models.CASCADE
)
count_products = models.IntegerField(default=1)