{"id":969,"date":"2022-02-20T11:33:02","date_gmt":"2022-02-20T11:33:02","guid":{"rendered":"https:\/\/zerotobyte.com\/?p=969"},"modified":"2022-02-20T12:17:32","modified_gmt":"2022-02-20T12:17:32","slug":"django-many-to-many-relationship-explained","status":"publish","type":"post","link":"https:\/\/zerotobyte.com\/django-many-to-many-relationship-explained\/","title":{"rendered":"Django Many To Many Relationship Explained"},"content":{"rendered":"\n<p>Frequently most challenging part of creating scalable and reliable applications in web development is making a good database schema. Often entities can contain shared data and could not be represented with the classic OneToMany relationship explained in <a href=\"https:\/\/zerotobyte.com\/complete-guide-to-django-foreignkey\/\" target=\"_blank\" rel=\"noreferrer noopener\">the ForeignKey article<\/a>. That\u2019s why Django has built-in tools to help us represent ManyToMany relationships.<\/p>\n\n\n\n<p>What is Many To Many relationship? <br><strong>Many to Many is a way of connecting entities with one additional table (associative table). Associative table points to entities it connects. The associative table contains primary keys of entities it connects and additional optional parameters.<\/strong><\/p>\n\n\n\n<p>Django Many To Many relationship can be easily represented in 2 different ways that we will cover in this article:<\/p>\n\n\n\n<ul><li><strong>Using <code>ManyToManyField<\/code><\/strong><\/li><li><strong>Using two <code>OneToManyFields (ForeignKey)<\/code><\/strong><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"django-many-to-many-relationship-using-manytomanyfield\">Django Many To Many relationship using ManyToManyField<\/h2>\n\n\n\n<p>Django ManyToManyField is a field that helps you create many to many relationships in Django. It\u2019s also the most obvious and fastest way.<\/p>\n\n\n\n<p>ManyToManyField syntax is as follows:<\/p>\n\n\n\n<p><strong><code>class ManyToManyField(to, **options)<\/code><\/strong><\/p>\n\n\n\n<ul><li><code>to<\/code>&nbsp; &#8211; Related model class<\/li><li><code>**options<\/code> &#8211; optional arguments explained in <a href=\"https:\/\/docs.djangoproject.com\/en\/4.0\/ref\/models\/fields\/#manytomany-arguments\" target=\"_blank\" rel=\"noreferrer noopener\">official Django documentation<\/a><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"manytomanyfield-in-database\">ManyToManyField in Database<\/h3>\n\n\n\n<p><strong>ManyToManyField between two models creates a third table in the database. That table contains the primary key of both models.<\/strong><\/p>\n\n\n\n<p>Let\u2019s check out the following models in which we assume that the Book can have multiple Authors:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">class Author(models.Model):\n   first_name = models.CharField(max_length=512)\n   last_name = models.CharField(max_length=512)\n\n\nclass Book(models.Model):\n   title = models.CharField(max_length=512)\n   authors = models.ManyToManyField(Author)<\/pre>\n\n\n\n<p><strong>Often, developers are confused in what model to put ManyToManyField. From the database point of view, it doesn\u2019t matter.<\/strong> <strong>Tables are equally connected no matter where you place it. <\/strong>But Django admin and ORM have slight changes in behavior.<\/p>\n\n\n\n<p>Django admin interface adds a widget for choosing related objects to a model where ManyToManyField is set. In other words, it requires adding referenced objects first. For our example, you could choose authors only when adding books, but not another way around.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zerotobyte.com\/wp-content\/uploads\/2022\/02\/django-many-to-many-01.webp\" alt=\"Django-admin ManyToManyField representation.\" class=\"wp-image-970\" width=\"739\" height=\"313\"\/><\/figure>\n\n\n\n<p>After migrating the above models to the database, we get the following database schema:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zerotobyte.com\/wp-content\/uploads\/2022\/02\/django-many-to-many-02.webp\" alt=\"Django ManyToManyField database schema.\" class=\"wp-image-971\" width=\"739\" height=\"432\"\/><\/figure>\n\n\n\n<p>Our associate table contains book_id and author_id referencing objects from connected tables.<\/p>\n\n\n\n<p>For example, let\u2019s check out the book \u201cThe Talisman\u201d written by Stephen King and Peter Straub.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">>>> from app.models import Author, Book\n>>> a1 = Author(first_name=\"Stephen\", last_name=\"King\")\n>>> a2 = Author(first_name=\"Peter\", last_name=\"Straub\")\n>>> a1.save()\n>>> a2.save()\n\n>>> b1 = Book(title=\"The Talisman\")\n>>> b1.save()  # Can\u2019t associate book with authors if it is not yet saved!\n>>> b1.authors.add(a1, a2)<\/pre>\n\n\n\n<p>Here we can see a few crucial steps. Firstly we create two authors, both of them have to be saved (if we don\u2019t save it, <code>ValueError<\/code> appears because the object still doesn\u2019t have id value). Then we create Book, Book also needs to be saved, or <code>ValueError<\/code> appears. Only then, we access the authors&#8217; field using Django ORM and add both authors, affecting the book_authors table.<\/p>\n\n\n\n<pre class=\"wp-block-verse\"><strong>NOTE<\/strong> - Multiple many to many relations can be created using the ManyRelatedManager object and its add() method.<\/pre>\n\n\n\n<p>Our database looks like this:<\/p>\n\n\n\n<p><strong>app_author<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>id<\/strong><\/td><td><strong>first_name<\/strong><\/td><td><strong>last_name<\/strong><\/td><\/tr><tr><td>1<\/td><td>Stephen<\/td><td>King<\/td><\/tr><tr><td>2<\/td><td>Peter<\/td><td>Straub<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>app_book<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>id<\/strong><\/td><td><strong>title<\/strong><\/td><\/tr><tr><td>1<\/td><td>The Talisman<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Last but not least, table that connects these two tables, book_authors table. Django by default names this table in format <strong>&lt;model_name>_&lt;many_to_many_field_name><\/strong>. Its columns are named <strong>&lt;model_name>_id<\/strong> by default.<\/p>\n\n\n\n<p><strong>app_book_author<\/strong> <\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>id<\/strong><\/td><td><strong>book_id<\/strong><\/td><td><strong>author_id<\/strong><\/td><\/tr><tr><td>1<\/td><td>1<\/td><td>1<\/td><\/tr><tr><td>2<\/td><td>1<\/td><td>2<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Now we can see how data is connected. In this example, the first row represents Book with id=1 and Author with id=1. Row two represents Book with id=1 and Author with id=2. This way of saving resolves the problem of duplicate data in Book or Author tables.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"manytomanyfield-orm\">ManyToManyField ORM<\/h3>\n\n\n\n<p>Django provides powerful tools to query models. That tool is called ORM (object-relational mapping). Django ORM is a tool used to write queries using Python instead of SQL. Python queries are eventually translated to SQL that then queries the database.<\/p>\n\n\n\n<p>In the following examples I\u2019ll show you some of the queries over ManyToManyField:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># We can use lookups on many to many field\n>>> Book.objects.filter(authors__id=1)\n&lt;QuerySet [&lt;Book: Book object (1)>]>\n\n# This equals above example\n>>> Book.objects.filter(authors=1)\n&lt;QuerySet [&lt;Book: Book object (1)>]>\n\n# Fetching all Authors connected to Book\n>>> Book.objects.get(id=1).authors.all()\n&lt;QuerySet [&lt;Author: Author object (1)>, &lt;Author: Author object (2)>]>\n\n# Removing book_authors connections from b1 \n>>> b1.authors.clear()\n\n# Removing a1 from book_authors table connected to b1\n>>> b1.authors.remove(a1)<\/pre>\n\n\n\n<pre class=\"wp-block-verse\"><strong>NOTE<\/strong> - Documentation on more operations can be found in <a href=\"https:\/\/docs.djangoproject.com\/en\/4.0\/topics\/db\/examples\/many_to_many\/\" target=\"_blank\" rel=\"noreferrer noopener\">official Django documentation on many-to-many relationships<\/a>.<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"django-many-to-many-relationship-using-foreignkey\">Django Many To Many relationship using ForeignKey<\/h2>\n\n\n\n<p>Many To Many relationships and representative associative table consists of ForeignKeys, Django only made it easier to implement it with ManyToManyField. <strong>Implementing many to many relationship with ForeignKeys requires manual implementation, but it gives us more implementation possibilities such as adding more fields.<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-verse\"><strong>NOTE<\/strong> - ForeignKey is explained in the <a href=\"https:\/\/zerotobyte.com\/complete-guide-to-django-foreignkey\/\" target=\"_blank\" rel=\"noreferrer noopener\">Complete guide to Django ForeignKey<\/a>, and it\u2019s recommended to understand its usage before continuing reading!<\/pre>\n\n\n\n<p>ForeignKey in Django represents one-to-many relationships, so how can we use it to make many-to-many relationships?<\/p>\n\n\n\n<p>First, let\u2019s define models.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">class Author(models.Model):\n   first_name = models.CharField(max_length=512)\n   last_name = models.CharField(max_length=512)\n\n\nclass Book(models.Model):\n   title = models.CharField(max_length=512)\n\n\nclass BookAuthor(models.Model):\n   author = models.ForeignKey(Author, on_delete=models.CASCADE)\n   book = models.ForeignKey(Book, on_delete=models.CASCADE)<\/pre>\n\n\n\n<p>We had to define one more model in our models.py file. BookAuthor table in the database is automatically created when we define ManyToManyField. <\/p>\n\n\n\n<p><strong>Using ForeignKey implementation, we must manually define two ForeignKey fields<\/strong>, one connecting table to Author and one connecting table to Book. With these connections, we managed to recreate many-to-many relationship using ForeignKey.<\/p>\n\n\n\n<p>Why use ForeignKey instead of ManyToManyField? <br><strong>ForeignKey implementation of many-to-many relationship allows us to add extra fields into our model.<\/strong> For example, maybe we would need to keep track of the word count of every Author in the Book they wrote. This requires an additional field in the BookAuthor connection. With manual implementation, we would simply rewrite the BookAuthor model:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">class BookAuthor(models.Model):\n   author = models.ForeignKey(Author, on_delete=models.CASCADE)\n   book = models.ForeignKey(Book, on_delete=models.CASCADE)\n   word_count = models.IntegerField()<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"summary\">Summary<\/h2>\n\n\n\n<p>Many to Many relationships are industry standards and are widely used in relational databases. It\u2019s necessary to master this concept to become a good web developer. Since Django helps us a lot, we need to know how to use these basic concepts to make suitable, functional web applications with the complex database schema.<\/p>\n\n\n\n<p>I hope this article helped you! \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Frequently most challenging part of creating scalable and reliable applications in web development is making a good database schema. Often &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Django Many To Many Relationship Explained\" class=\"read-more button\" href=\"https:\/\/zerotobyte.com\/django-many-to-many-relationship-explained\/#more-969\" aria-label=\"More on Django Many To Many Relationship Explained\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[8],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Django Many To Many Relationship Explained - ZeroToByte<\/title>\n<meta name=\"description\" content=\"Learn to create many to many relationships in Django using multiple methods and built-in tools described in this article!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/zerotobyte.com\/django-many-to-many-relationship-explained\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Django Many To Many Relationship Explained - ZeroToByte\" \/>\n<meta property=\"og:description\" content=\"Learn to create many to many relationships in Django using multiple methods and built-in tools described in this article!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/zerotobyte.com\/django-many-to-many-relationship-explained\/\" \/>\n<meta property=\"og:site_name\" content=\"ZeroToByte\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-20T11:33:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-20T12:17:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/zerotobyte.com\/wp-content\/uploads\/2022\/02\/django-many-to-many-01.webp\" \/>\n<meta name=\"author\" content=\"Manuel Matosevic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Manuel Matosevic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zerotobyte.com\/django-many-to-many-relationship-explained\/\",\"url\":\"https:\/\/zerotobyte.com\/django-many-to-many-relationship-explained\/\",\"name\":\"Django Many To Many Relationship Explained - ZeroToByte\",\"isPartOf\":{\"@id\":\"https:\/\/zerotobyte.com\/#website\"},\"datePublished\":\"2022-02-20T11:33:02+00:00\",\"dateModified\":\"2022-02-20T12:17:32+00:00\",\"author\":{\"@id\":\"https:\/\/zerotobyte.com\/#\/schema\/person\/1ff5aa0c2aabf4491b171a0aee7874a3\"},\"description\":\"Learn to create many to many relationships in Django using multiple methods and built-in tools described in this article!\",\"breadcrumb\":{\"@id\":\"https:\/\/zerotobyte.com\/django-many-to-many-relationship-explained\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zerotobyte.com\/django-many-to-many-relationship-explained\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zerotobyte.com\/django-many-to-many-relationship-explained\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zerotobyte.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Django Many To Many Relationship Explained\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zerotobyte.com\/#website\",\"url\":\"https:\/\/zerotobyte.com\/\",\"name\":\"ZeroToByte\",\"description\":\"Become a Better Dev!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zerotobyte.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zerotobyte.com\/#\/schema\/person\/1ff5aa0c2aabf4491b171a0aee7874a3\",\"name\":\"Manuel Matosevic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zerotobyte.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e1b521f2dc00628f06c0cc77451013b6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e1b521f2dc00628f06c0cc77451013b6?s=96&d=mm&r=g\",\"caption\":\"Manuel Matosevic\"},\"sameAs\":[\"http:\/\/zerotobyte.com\"],\"url\":\"https:\/\/zerotobyte.com\/author\/manuelmatosevic\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Django Many To Many Relationship Explained - ZeroToByte","description":"Learn to create many to many relationships in Django using multiple methods and built-in tools described in this article!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zerotobyte.com\/django-many-to-many-relationship-explained\/","og_locale":"en_US","og_type":"article","og_title":"Django Many To Many Relationship Explained - ZeroToByte","og_description":"Learn to create many to many relationships in Django using multiple methods and built-in tools described in this article!","og_url":"https:\/\/zerotobyte.com\/django-many-to-many-relationship-explained\/","og_site_name":"ZeroToByte","article_published_time":"2022-02-20T11:33:02+00:00","article_modified_time":"2022-02-20T12:17:32+00:00","og_image":[{"url":"https:\/\/zerotobyte.com\/wp-content\/uploads\/2022\/02\/django-many-to-many-01.webp"}],"author":"Manuel Matosevic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Manuel Matosevic","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zerotobyte.com\/django-many-to-many-relationship-explained\/","url":"https:\/\/zerotobyte.com\/django-many-to-many-relationship-explained\/","name":"Django Many To Many Relationship Explained - ZeroToByte","isPartOf":{"@id":"https:\/\/zerotobyte.com\/#website"},"datePublished":"2022-02-20T11:33:02+00:00","dateModified":"2022-02-20T12:17:32+00:00","author":{"@id":"https:\/\/zerotobyte.com\/#\/schema\/person\/1ff5aa0c2aabf4491b171a0aee7874a3"},"description":"Learn to create many to many relationships in Django using multiple methods and built-in tools described in this article!","breadcrumb":{"@id":"https:\/\/zerotobyte.com\/django-many-to-many-relationship-explained\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zerotobyte.com\/django-many-to-many-relationship-explained\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/zerotobyte.com\/django-many-to-many-relationship-explained\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zerotobyte.com\/"},{"@type":"ListItem","position":2,"name":"Django Many To Many Relationship Explained"}]},{"@type":"WebSite","@id":"https:\/\/zerotobyte.com\/#website","url":"https:\/\/zerotobyte.com\/","name":"ZeroToByte","description":"Become a Better Dev!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zerotobyte.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zerotobyte.com\/#\/schema\/person\/1ff5aa0c2aabf4491b171a0aee7874a3","name":"Manuel Matosevic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zerotobyte.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e1b521f2dc00628f06c0cc77451013b6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e1b521f2dc00628f06c0cc77451013b6?s=96&d=mm&r=g","caption":"Manuel Matosevic"},"sameAs":["http:\/\/zerotobyte.com"],"url":"https:\/\/zerotobyte.com\/author\/manuelmatosevic\/"}]}},"_links":{"self":[{"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/posts\/969"}],"collection":[{"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/comments?post=969"}],"version-history":[{"count":17,"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/posts\/969\/revisions"}],"predecessor-version":[{"id":990,"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/posts\/969\/revisions\/990"}],"wp:attachment":[{"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/media?parent=969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/categories?post=969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/tags?post=969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}