表结构

• 商品表
• 店铺表
• 收藏关系表
• 人员表

人收藏商品,人收藏店铺, 收藏的关系保存在 收藏关系表中

models.py

from django.contrib.contenttypes.fields import GenericForeignKey, GenericRelation

from django.contrib.contenttypes.models import ContentType

from django.db import models



# Create your models here.

from accounts.models import Student





class Product(models.Model):

    """商品表"""

    name = models.CharField('商品名称',max_length=64)

    collections = GenericRelation(to="Collection")  # 反向查询



    class Meta:

        db_table = 'product'

        verbose_name = verbose_name_plural = '商品表'





class Store(models.Model):

    """店铺表"""

    name = models.CharField('店铺名称',max_length=64)

    collections = GenericRelation(to="Collection")  # 反向查询



    class Meta:

        db_table = 'store'

        verbose_name = verbose_name_plural = '店铺表'





class Collection(models.Model):

    """收藏表"""

    user = models.ForeignKey(Student,on_delete=models.CASCADE)

    content_type = models.ForeignKey(

        to=ContentType,

        limit_choices_to={

            "model__in": (

                "product",

                "store",

            )

        },

        related_name="collection",

        help_text="不同收藏类型",

        on_delete=models.CASCADE

    )

    object_id = models.IntegerField("关联ID", help_text="关联ID")

    content_object = GenericForeignKey()

    created_at = models.DateTimeField('创建时间',auto_now_add=True)

    updated_at = models.DateTimeField("更新时间",auto_now=True)



    class Meta:

        verbose_name = verbose_name_plural = "收藏记录"

        db_table = 'collection'

view.py 调用测试

def get_user_connect(request):

    student = Student.objects.all()

    for s in student:

        # print(s.id)

        k = s.collection_set.all()

        print(k,s)



        for p in k.filter(content_type__model="product"):

            print(p.content_object.name)

        for s in k.filter(content_type__model="store"):

            print(s.content_object.name)



    return HttpResponse("OK")