{"id":832,"date":"2022-01-26T23:14:41","date_gmt":"2022-01-26T23:14:41","guid":{"rendered":"https:\/\/zerotobyte.com\/?p=832"},"modified":"2022-01-26T23:26:53","modified_gmt":"2022-01-26T23:26:53","slug":"how-to-reset-the-database-in-django","status":"publish","type":"post","link":"https:\/\/zerotobyte.com\/how-to-reset-the-database-in-django\/","title":{"rendered":"How to Reset the Database in Django?"},"content":{"rendered":"\n<p>As one of the most used frameworks for building web applications, Django provides us with powerful tools to make our development easier and faster. <strong>One of the standard tools of Django web app development is the SQLite3 database<\/strong>. This article will show you how to reset a given database.<\/p>\n\n\n\n<p>Why would You want to reset the database in Django? <\/p>\n\n\n\n<p>In the early development stages, when there is no real data in the database, many database changes can happen. <strong>Often it\u2019s easier to reset the database than to <\/strong><a href=\"https:\/\/zerotobyte.com\/django-data-migrations-how-to-change-data-in-the-database\/\" target=\"_blank\" rel=\"noreferrer noopener\">write custom migration files<\/a>.<\/p>\n\n\n\n<p>First, our SQLite3 database is created by the given parameters in <code>settings.py<\/code>. It defaults:<\/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=\"\">DATABASES = {\n     'default': {\n         'ENGINE': 'django.db.backends.sqlite3',\n         'NAME': BASE_DIR \/ 'db.sqlite3',\n     }\n}<\/pre>\n\n\n\n<p>And db.sqlite3 database is created locally when we apply migrations &#8211; <code>python manage.py migrate<\/code>.<\/p>\n\n\n\n<p>Considering that, I\u2019ll show you a few ways to reset your database in Django:<\/p>\n\n\n\n<ul><li><strong>Manually resetting<\/strong><\/li><li><strong>Using Django commands<\/strong><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"reset-database-in-django-manually\">Reset database in Django manually<\/h2>\n\n\n\n<p>Manually resetting the database requires basic knowledge of project structure and its files.<\/p>\n\n\n\n<p>SQLite3 database requires:<\/p>\n\n\n\n<ul><li><strong>migrations files<\/strong><\/li><li><strong>db.sqlite3 file<\/strong><\/li><\/ul>\n\n\n\n<p>Resetting database in Django consists of 4 steps:<\/p>\n\n\n\n<ol><li><strong>Delete all migrations files<\/strong><\/li><li><strong>Delete db.sqlite3 file<\/strong><\/li><li><strong>Make new migrations files<\/strong> &#8211; <code>python manage.py makemigrations<\/code><\/li><li><strong>Migrate changes<\/strong> &#8211; <code>python manage.py migrate<\/code><\/li><\/ol>\n\n\n\n<p>Certainly, you could use .sh scripts to automatize given steps.<\/p>\n\n\n\n<p>In the following example, we have a project containing two apps, authapp, and bookapp. <strong>This script automizes the above steps.<\/strong><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">rm authapp\/migrations\/00*.py\nrm bookapp\/migrations\/00*.py\nrm db.sqlite3\n\npython3 manage.py makemigrations authapp\npython3 manage.py makemigrations bookapp\npython3 manage.py migrate<\/pre>\n\n\n\n<p>First, we delete all migrations files from both applications, and then we delete db.sqlite3 database. In case of new changes, we run makemigrations <strong>and then migrate changes, creating a new db.sqlite3 database<\/strong>.<\/p>\n\n\n\n<pre class=\"wp-block-verse\"><strong>WARNING<\/strong> - Deleting migration files is bad practice. However, making new migrations and migrating changes is still a better choice than resetting your database.<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"reset-database-in-django-using-commands\">Reset database in Django using commands<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"flush-method\">Flush method<\/h3>\n\n\n\n<p>Another option that does exactly the same is python manage.py flush.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">>>>python manage.py flush\n\nYou have requested a flush of the database.\nThis will IRREVERSIBLY DESTROY all data currently in the \"db.sqlite3\" database,\nand return each table to an empty state.\nAre you sure you want to do this?\n\nType 'yes' to continue, or 'no' to cancel: yes\n<\/pre>\n\n\n\n<p><strong><code>python manage.py flush<\/code> deletes all data in all tables in the database.<\/strong>\u00a0It\u2019s important to know that <strong>flush doesn\u2019t migrate new changes to the database<\/strong>; it only deletes all data. So if you changed your models, you still need to makemigrations and then migrate them to the database.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"migrate-zero-method\">Migrate zero method<\/h3>\n\n\n\n<p><strong><code>python manage.py migrate &lt;app_name> zero<\/code> method is more specifically connected to Django apps. It can revert all migrations related to a specific application in Django.<\/strong><\/p>\n\n\n\n<p>How can this exactly help us reset the database?<\/p>\n\n\n\n<p>Well, in pair with new migration, it rebuilds models from a given app, and therefore, we get new tables without old data.<\/p>\n\n\n\n<p>For example, if we want to reset all data from &lt;example_app>, we need to take the following steps:<\/p>\n\n\n\n<ol><li><code>python manage.py migrate example_app zero<\/code><\/li><li><code>python manage.py migrate example_app<\/code><\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"reset-non-local-database-in-django\">Reset non-local database in Django<\/h2>\n\n\n\n<p><strong>Databases come in all types and forms, so making a universal way to reset them is generally challenging<\/strong>. Both flush and migrate zero methods should work. Still, in the worst-case scenario, you can always delete the database and migrate changes to a new one.<\/p>\n\n\n\n<pre class=\"wp-block-verse\"><strong>NOTE<\/strong> - If your database contains sensitive data, consider using dumpdata and\/or database backups<\/pre>\n\n\n\n<p>Additionally, you can always check <a href=\"https:\/\/docs.djangoproject.com\/en\/4.0\/topics\/migrations\/\" target=\"_blank\" rel=\"noreferrer noopener\">official Django documentation<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"summary\">Summary<\/h2>\n\n\n\n<p>I always find it challenging and tiresome to handle database changes in the early stages of development when data is not important. The early stages include many changes in client requirements and, therefore, a lot of the database changes. That\u2019s why I choose to write this article and share my experiences (and scripts) to help you overcome these obstacles.<\/p>\n\n\n\n<p><strong>Hope you are doing fine and enjoy! <\/strong>\ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As one of the most used frameworks for building web applications, Django provides us with powerful tools to make our &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Reset the Database in Django?\" class=\"read-more button\" href=\"https:\/\/zerotobyte.com\/how-to-reset-the-database-in-django\/#more-832\" aria-label=\"More on How to Reset the Database in Django?\">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>How to Reset the Database in Django? - ZeroToByte<\/title>\n<meta name=\"description\" content=\"Learn 2 different approaches to reset the database in Django, one of the most popular frameworks for creating web applications.\" \/>\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\/how-to-reset-the-database-in-django\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Reset the Database in Django? - ZeroToByte\" \/>\n<meta property=\"og:description\" content=\"Learn 2 different approaches to reset the database in Django, one of the most popular frameworks for creating web applications.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/zerotobyte.com\/how-to-reset-the-database-in-django\/\" \/>\n<meta property=\"og:site_name\" content=\"ZeroToByte\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-26T23:14:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-01-26T23:26:53+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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zerotobyte.com\/how-to-reset-the-database-in-django\/\",\"url\":\"https:\/\/zerotobyte.com\/how-to-reset-the-database-in-django\/\",\"name\":\"How to Reset the Database in Django? - ZeroToByte\",\"isPartOf\":{\"@id\":\"https:\/\/zerotobyte.com\/#website\"},\"datePublished\":\"2022-01-26T23:14:41+00:00\",\"dateModified\":\"2022-01-26T23:26:53+00:00\",\"author\":{\"@id\":\"https:\/\/zerotobyte.com\/#\/schema\/person\/1ff5aa0c2aabf4491b171a0aee7874a3\"},\"description\":\"Learn 2 different approaches to reset the database in Django, one of the most popular frameworks for creating web applications.\",\"breadcrumb\":{\"@id\":\"https:\/\/zerotobyte.com\/how-to-reset-the-database-in-django\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zerotobyte.com\/how-to-reset-the-database-in-django\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zerotobyte.com\/how-to-reset-the-database-in-django\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zerotobyte.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Reset the Database in Django?\"}]},{\"@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":"How to Reset the Database in Django? - ZeroToByte","description":"Learn 2 different approaches to reset the database in Django, one of the most popular frameworks for creating web applications.","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\/how-to-reset-the-database-in-django\/","og_locale":"en_US","og_type":"article","og_title":"How to Reset the Database in Django? - ZeroToByte","og_description":"Learn 2 different approaches to reset the database in Django, one of the most popular frameworks for creating web applications.","og_url":"https:\/\/zerotobyte.com\/how-to-reset-the-database-in-django\/","og_site_name":"ZeroToByte","article_published_time":"2022-01-26T23:14:41+00:00","article_modified_time":"2022-01-26T23:26:53+00:00","author":"Manuel Matosevic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Manuel Matosevic","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zerotobyte.com\/how-to-reset-the-database-in-django\/","url":"https:\/\/zerotobyte.com\/how-to-reset-the-database-in-django\/","name":"How to Reset the Database in Django? - ZeroToByte","isPartOf":{"@id":"https:\/\/zerotobyte.com\/#website"},"datePublished":"2022-01-26T23:14:41+00:00","dateModified":"2022-01-26T23:26:53+00:00","author":{"@id":"https:\/\/zerotobyte.com\/#\/schema\/person\/1ff5aa0c2aabf4491b171a0aee7874a3"},"description":"Learn 2 different approaches to reset the database in Django, one of the most popular frameworks for creating web applications.","breadcrumb":{"@id":"https:\/\/zerotobyte.com\/how-to-reset-the-database-in-django\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zerotobyte.com\/how-to-reset-the-database-in-django\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/zerotobyte.com\/how-to-reset-the-database-in-django\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zerotobyte.com\/"},{"@type":"ListItem","position":2,"name":"How to Reset the Database in Django?"}]},{"@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\/832"}],"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=832"}],"version-history":[{"count":13,"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/posts\/832\/revisions"}],"predecessor-version":[{"id":846,"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/posts\/832\/revisions\/846"}],"wp:attachment":[{"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/media?parent=832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/categories?post=832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zerotobyte.com\/wp-json\/wp\/v2\/tags?post=832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}