How to connect django model using foreignkey to a unique object in another model

Question

Please how do I connect a model to a particular object in another model using either onetoonefield or foreignkey.

Example

class Post(models.Model):
    title = models.TextField(max_length=100, null=True)
    caption = models.CharField(max_length=1000)
    photo = models.ImageField(upload_to ='posts', null=True)
    date_posted = models.DateTimeField(default=timezone.now)
    author = models.ForeignKey(User, on_delete=models.CASCADE)
    likes= models.IntegerField(default=0)
    dislikes= models.IntegerField(default=0)
    price = models.DecimalField(max_digits=10, decimal_places=2, null=True)
    digital = models.BooleanField(default=False, null=True, blank=False)
    location = models.PointField(srid=4326, null=True)
    category = models.ForeignKey('Category', null=True, blank=True, on_delete=models.CASCADE)
    slug = models.SlugField(unique=True, null=True)

    def __str__(self):
        return self.title

    @property
    def number_of_comments(self):
        return Comment.objects.filter(post_connected=self).count()


class Comment(models.Model):
    **post_owner = models.OneToOneField(      )** 
    content = models.TextField(max_length=150)
    date_posted = models.DateTimeField(default=timezone.now)
    author = models.ForeignKey(User, on_delete=models.CASCADE)
    post_connected = models.ForeignKey(Post, on_delete=models.CASCADE)

I need to make post_owner in Comment Models, connected to author in Post models and not the entire Post models

Why don't you make the `OneToOneField` to `User` instead of `Post`? — D Malan, Oct 12 '20 at 11:35
Because if i do that it picks the user that comments not the user that owners the post.... See like Author in comment model its to User. Do you understand? — Nelson Kehinde, Oct 12 '20 at 11:37
You need to pass a `related_name` argument to the relationship when you have multiple relationships to one model. See https://stackoverflow.com/questions/543377/how-can-i-have-two-foreign-keys-to-the-same-model-in-django — D Malan, Oct 12 '20 at 12:15

score 1 · Accepted Answer · answered Oct 12 '20 at 11:34

1

assuming you have a comment object you can access its owner using something like this.

comment = Comment.objects.first()
owner = comment.post_connected.author

answered Oct 12 '20 at 11:34

Erfan

163
1
2
13

OKay. I think I understand what you are saying. Let me try that out. – Nelson Kehinde Oct 12 '20 at 11:39

How to connect django model using foreignkey to a unique object in another model

1 Answers1