Get single QuerySet object from two different models using Django

Viewed 83

My First models

class UserModel(models.Model):
first_name = models.CharField(max_length=20)
last_name = models.CharField(max_length=20)
profile_pic = models.CharField(max_length=50)
gender = models.CharField(max_length=20)
college_name = models.CharField(max_length=50)
user_id = models.CharField(max_length=15, unique=True)
user_password = models.CharField(max_length=15)

class Meta:
    db_table = 'user'

Second Model

class GroupPostCommentsModel(models.Model):
comment_text = models.CharField(max_length=1000)
likes = models.IntegerField(default=0)
time_stamp = models.DateTimeField(auto_now=True)
comment_by_user = models.ForeignKey(UserModel, on_delete=models.CASCADE)
post_id = models.ForeignKey(GroupPostsModel, on_delete=models.CASCADE)

class Meta:
    db_table = 'group_posts_comments'

I want data as follows : [id,first_name, last_name, profile_pic, comment_text, likes]

My Serializer

class GroupPostCommentsSerializerGetInfo(serializers.Serializer):
id = serializers.IntegerField()#it is primary key of GroupPostCommentsModel
comment_text = serializers.CharField(max_length=1000)
likes = serializers.IntegerField(default=0)
time_stamp = serializers.DateTimeField(default='')
first_name = serializers.CharField(max_length=20)# From UserModel
last_name = serializers.CharField(max_length=20)# From UserModel
profile_pic = serializers.ImageField(default='')# From UserModel



first_name, last_name, profile_pic : from UserModel comment_text, likes : from GroupPostCommentsModel

python3 --version Python 3.6.9

Django==3.2.10

I am stuck in the project for a long time please help. :)

0 Answers
Related