Django ORM: Many-to-Many Relationship with Through Model Not Saving Correctly
I've searched everywhere and can't find a clear answer. I'm refactoring my project and I'm stuck on something that should probably be simple..... I'm working on a Django project and have set up a many-to-many relationship using a through model. My models are set up correctly, but when I try to save a new instance, the intermediate model entries aren't being created. Here are my models: ```python from django.db import models class Author(models.Model): name = models.CharField(max_length=100) class Book(models.Model): title = models.CharField(max_length=200) authors = models.ManyToManyField(Author, through='Authorship') class Authorship(models.Model): author = models.ForeignKey(Author, on_delete=models.CASCADE) book = models.ForeignKey(Book, on_delete=models.CASCADE) contribution = models.CharField(max_length=200) ``` When I try to save a new book with authors, I do it like this: ```python # Creating instances of Author author1 = Author.objects.create(name='Author One') author2 = Author.objects.create(name='Author Two') # Creating a new Book instance book = Book(title='New Book') book.save() # Attempting to create the Authorship instances Authorship.objects.create(book=book, author=author1, contribution='Main Writer') Authorship.objects.create(book=book, author=author2, contribution='Co-Writer') ``` However, when I check the database, it seems like the `Authorship` entries are not being saved. I don't see any errors when I run this code. I've also tried wrapping the `Authorship` creations in a transaction block, but that didn't help either: ```python from django.db import transaction with transaction.atomic(): Authorship.objects.create(book=book, author=author1, contribution='Main Writer') Authorship.objects.create(book=book, author=author2, contribution='Co-Writer') ``` I verified that the `book` and `author` objects are being created correctly, but it seems like the through table isn’t getting populated. Am I missing something? Is there a specific setting I need to check in my Django settings or is there a common pitfall with many-to-many relationships that I'm not considering? I'm using Django 4.2 and PostgreSQL 14. I'm working on a API that needs to handle this. Has anyone else encountered this? For context: I'm using Python on CentOS. My team is using Python for this desktop app. This is my first time working with Python stable. I'd love to hear your thoughts on this.