link multiple files to model

Hi,

I have a question about one-to-many relations in models

What is best to use? ForeignKey of many to ManyToManyField?

I want to attach files to a model. 

The ForeignKey is easy to use. 

class Feed(models.Model):

    user=models.ForeignKey(User, on_delete=models.CASCADE, related_name='feeds')

    text=models.TextField(blank=False, max_length=500)

class FeedFile(models.Model):

    file = models.FileField(upload_to="files/%Y/%m/%d")

    feed = models.ForeignKey(Feed, on_delete=models.CASCADE, related_name='files')

But retrieving all objects (for a listview) with all files included the object is challenging. I

 tried subqueries, prefetch_related...

How can I do this?

AllFeeds = Feed.objects.all() 

the manytomany-solution:

class Feed(models.Model):

    user=models.ForeignKey(User, on_delete=models.CASCADE, related_name='feeds')

    text=models.TextField(blank=False, max_length=500)

    files=models.ManyToManyField(FeedFile)

class FeedFile(models.Model):

    file = models.FileField(upload_to="files/%Y/%m/%d")

Is not so intuitive for the user, but I can get the correct queryset.

Any advise on good practise?

Bart

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/e9ff73b1-bf2f-462a-98f3-da46793c54da%40googlegroups.com.