{"id":1386,"date":"2022-03-19T15:17:45","date_gmt":"2022-03-19T15:17:45","guid":{"rendered":"https:\/\/zerotobyte.com\/?p=1386"},"modified":"2022-03-19T15:17:46","modified_gmt":"2022-03-19T15:17:46","slug":"django-shortcuts-get-or-create-and-update-or-create","status":"publish","type":"post","link":"https:\/\/zerotobyte.com\/django-shortcuts-get-or-create-and-update-or-create\/","title":{"rendered":"Django shortcuts &#8211; get_or_create and update_or_create"},"content":{"rendered":"\n<p>Django shortcuts, <code>get_or_create()<\/code>, and <code>update_or_create()<\/code> methods make our web application development even faster. Django implemented these methods due to easier readability and non-repetitiveness of the code.<\/p>\n\n\n\n<p>What is the get_or_create() method in Django?<br><strong>The <code>get_or_create()<\/code> method is used to get an existing object from the database or create it if it doesn\u2019t exist. The <code>get _or_create()<\/code> method returns a tuple. A first element is an object, and the second one boolean value (created is True, not created is False).<\/strong><\/p>\n\n\n\n<p>What is the update_or_create() method in Django?<br><strong>The <code>update_or_create()<\/code> method is used to update an object from the database if the object exists. If not, the object is created from provided parameters. The <code>update_or_create()<\/code> method returns tuple. A first element is an object, a second one boolean value (created is True, updated is False).<\/strong><\/p>\n\n\n\n<p>Before we dive into examples, we should define our 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=\"\">from django.db import models\n\nclass Author(models.Model):\n    first_name = models.CharField(max_length=512)\n    last_name = models.CharField(max_length=512)\n\nclass Book(models.Model):\n    title = models.CharField(max_length=512)\n    author = models.ForeignKey(Author, on_delete=models.CASCADE)<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Django get_or_create() method<\/h2>\n\n\n\n<p>The <code>get_or_create()<\/code> method is the model Manager method that can receive keyword arguments that represent model fields.<\/p>\n\n\n\n<p><code>get_or_create(defaults=None, **kwargs)<\/code><\/p>\n\n\n\n<ul><li><strong><code>defaults<\/code><\/strong> &#8211; if an object doesn&#8217;t exist, defaults define object fields that are saved into the database.<\/li><li><strong><code>kwargs<\/code><\/strong> &#8211; defines fields used in the lookup for the get method, and if defaults are not defined, the same fields are used to create the method.<\/li><\/ul>\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=\"\">>>> Author.objects.get_or_create(first_name=\"William\", last_name=\"Shakespeare\")\n(&lt;Author: Author object (1)>, True)\n\n>>> Author.objects.get_or_create(first_name=\"William\", last_name=\"Shakespeare\")\n(&lt;Author: Author object (1)>, False)<\/pre>\n\n\n\n<p>We get two same commands but two different outputs. First, when we called <code>get_or_create() <\/code>method &#8216;William Shakespeare&#8217; was not in the database, <code>get_or_create()<\/code> created Author and returned True in tuple providing us information that Author was created. The second time we called the <code>get_or_create()<\/code> method on the same arguments. We were provided with the Author created previously. The created flag is False, providing us information that Author was not created (only fetched from the database).<\/p>\n\n\n\n<p>The authors table in the database looks like this:<\/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>William<\/td><td>Shakespeare<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<pre class=\"wp-block-verse\"><strong>WARNING<\/strong> - If the field that doesn't exist is provided, we get FieldError.<\/pre>\n\n\n\n<p>Now, we can look at the defaults argument that is provided alongside kwargs. As already mentioned, defaults don&#8217;t interfere while getting an object from the database &#8211; but if an object with given arguments doesn&#8217;t exist, defaults argument &#8216;overrides&#8217; arguments and creates an object with given parameters. So let&#8217;s take a look at the following example.<\/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=\"\">>>> Author.objects.get_or_create(first_name=\"William\", last_name=\"Shakespeare\", defaults={\"first_name\": \"Miguel\", \"last_name\": \"de Cervantes\"})\n(&lt;Author: Author object (1)>, False)<\/pre>\n\n\n\n<p>As we can see, &#8216;William Shakespeare&#8217; is already in the database, and no new object is created even though we defined defaults.<\/p>\n\n\n\n<p>What happens if author doesn\u2019t exist?<\/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=\"\">>>> Author.objects.get_or_create(first_name=\"Agatha\", last_name=\"Christie\", defaults={\"first_name\": \"Miguel\", \"last_name\": \"de Cervantes\"})\n(&lt;Author: Author object (2)>, True)<\/pre>\n\n\n\n<p>\u2018Agatha Christie&#8217; was not yet created when calling the <code>get_or_create()<\/code> method in Django. We can see now that the Author object is created. Let&#8217;s check the database.<\/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>William<\/td><td>Shakespeare<\/td><\/tr><tr><td>2<\/td><td>Miguel<\/td><td>de Cervantes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>There is no mention of &#8216;Agatha Christie&#8217;; instead, we have &#8216;Miguel de Cervantes&#8217; Author defined in the defaults argument. So, defaults define object fields when no object is found from the arguments we provided.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Django update_or_create() method<\/h2>\n\n\n\n<p>As the <code>get_or_create()<\/code> method, <code>update_or_create()<\/code> is also the model Manager method, but with a slightly different purpose. The <code>update_or_create()<\/code> updates object if found; if not, it&#8217;s created. The return value is a tuple with two values, object and created boolean flag.<\/p>\n\n\n\n<p><code>update_or_create(defaults=None, **kwargs)<\/code><\/p>\n\n\n\n<ul><li><strong><code>defaults<\/code><\/strong> &#8211; Defines values of fields that should be updated (or created)<\/li><li><strong><code>kwargs<\/code><\/strong> &#8211; Defines fields used in lookup for update method, and if defaults is not defined, same fields are used for creating object.<\/li><\/ul>\n\n\n\n<p>Let\u2019s take a look at the following example:<\/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=\"\">>>> Author.objects.update_or_create(first_name=\"Miguel\", defaults={\"first_name\": \"Agatha\", \"last_name\": \"Christie\"})\n(&lt;Author: Author object (2)>, False)<\/pre>\n\n\n\n<p>This example looked for an object with first_name &#8216;Miguel&#8217;, as we have this Author in our database Django proceeds to iterate over defaults argument key-value pairs and updates given object.<\/p>\n\n\n\n<p>Our database after this change looks like this:<\/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>William<\/td><td>Shakespeare<\/td><\/tr><tr><td>2<\/td><td>Agatha<\/td><td>Christie<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<pre class=\"wp-block-verse\"><strong>WARNING<\/strong> - If defaults is not defined, create method uses provided keyword arguments as fields!<\/pre>\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=\"\">>>> Author.objects.update_or_create(first_name=\"William\", last_name=\"Shakespeare\")\n(&lt;Author: Author object (3)>, True)<\/pre>\n\n\n\n<p>As seen in the example above, we can use <code>update_or_create()<\/code> in Django to create new objects without using the defaults argument. However, this doesn&#8217;t use its purpose because no object will be updated without defaults.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Django shortcuts, get_or_create(), and update_or_create() methods make our web application development even faster. Django implemented these methods due to easier &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Django shortcuts &#8211; get_or_create and update_or_create\" class=\"read-more button\" href=\"https:\/\/zerotobyte.com\/django-shortcuts-get-or-create-and-update-or-create\/#more-1386\" aria-label=\"More on Django shortcuts &#8211; get_or_create and update_or_create\">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 shortcuts - get_or_create and update_or_create - ZeroToByte<\/title>\n<meta name=\"description\" content=\"Django shortcuts can make our development easier, learn how to use get_or_create and update_or_create methods with examples.\" \/>\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-shortcuts-get-or-create-and-update-or-create\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Django shortcuts - get_or_create and update_or_create - ZeroToByte\" \/>\n<meta property=\"og:description\" content=\"Django shortcuts can make our development easier, learn how to use get_or_create and update_or_create methods with examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/zerotobyte.com\/django-shortcuts-get-or-create-and-update-or-create\/\" \/>\n<meta property=\"og:site_name\" content=\"ZeroToByte\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-19T15:17:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-19T15:17:46+00:00\" \/>\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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zerotobyte.com\/django-shortcuts-get-or-create-and-update-or-create\/\",\"url\":\"https:\/\/zerotobyte.com\/django-shortcuts-get-or-create-and-update-or-create\/\",\"name\":\"Django shortcuts - get_or_create and update_or_create - ZeroToByte\",\"isPartOf\":{\"@id\":\"https:\/\/zerotobyte.com\/#website\"},\"datePublished\":\"2022-03-19T15:17:45+00:00\",\"dateModified\":\"2022-03-19T15:17:46+00:00\",\"author\":{\"@id\":\"https:\/\/zerotobyte.com\/#\/schema\/person\/1ff5aa0c2aabf4491b171a0aee7874a3\"},\"description\":\"Django shortcuts can make our development easier, learn how to use get_or_create and update_or_create methods with examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/zerotobyte.com\/django-shortcuts-get-or-create-and-update-or-create\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zerotobyte.com\/django-shortcuts-get-or-create-and-update-or-create\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zerotobyte.com\/django-shortcuts-get-or-create-and-update-or-create\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zerotobyte.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Django shortcuts &#8211; get_or_create and update_or_create\"}]},{\"@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 shortcuts - get_or_create and update_or_create - ZeroToByte","description":"Django shortcuts can make our development easier, learn how to use get_or_create and update_or_create methods with examples.","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-shortcuts-get-or-create-and-update-or-create\/","og_locale":"en_US","og_type":"article","og_title":"Django shortcuts - get_or_create and update_or_create - ZeroToByte","og_description":"Django shortcuts can make our development easier, learn how to use get_or_create and update_or_create methods with examples.","og_url":"https:\/\/zerotobyte.com\/django-shortcuts-get-or-create-and-update-or-create\/","og_site_name":"ZeroToByte","article_published_time":"2022-03-19T15:17:45+00:00","article_modified_time":"2022-03-19T15:17:46+00:00","author":"Manuel Matosevic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Manuel Matosevic","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zerotobyte.com\/django-shortcuts-get-or-create-and-update-or-create\/","url":"https:\/\/zerotobyte.com\/django-shortcuts-get-or-create-and-update-or-create\/","name":"Django shortcuts - get_or_create and update_or_create - ZeroToByte","isPartOf":{"@id":"https:\/\/zerotobyte.com\/#website"},"datePublished":"2022-03-19T15:17:45+00:00","dateModified":"2022-03-19T15:17:46+00:00","author":{"@id":"https:\/\/zerotobyte.com\/#\/schema\/person\/1ff5aa0c2aabf4491b171a0aee7874a3"},"description":"Django shortcuts can make our development easier, learn how to use get_or_create and update_or_create methods with examples.","breadcrumb":{"@id":"https:\/\/zerotobyte.com\/django-shortcuts-get-or-create-and-update-or-create\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zerotobyte.com\/django-shortcuts-get-or-create-and-update-or-create\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/zerotobyte.com\/django-shortcuts-get-or-create-and-update-or-create\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zerotobyte.com\/"},{"@type":"ListItem","position":2,"name":"Django shortcuts &#8211; get_or_create and update_or_create"}]},{"@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\/1386"}],"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=1386"}],"version-history":[{"count":3,"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/posts\/1386\/revisions"}],"predecessor-version":[{"id":1389,"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/posts\/1386\/revisions\/1389"}],"wp:attachment":[{"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/media?parent=1386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/categories?post=1386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/tags?post=1386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}