{"id":6364,"date":"2023-01-11T08:19:15","date_gmt":"2023-01-11T08:19:15","guid":{"rendered":"https:\/\/www.pythontutorial.net\/?page_id=6364"},"modified":"2023-01-19T01:45:52","modified_gmt":"2023-01-19T01:45:52","slug":"django-loaddata","status":"publish","type":"page","link":"https:\/\/www.pythontutorial.net\/django-tutorial\/django-loaddata\/","title":{"rendered":"Django loaddata"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you’ll learn how to use the Django loaddata<\/code> command to provide initial data for models.<\/p>\n\n\n\n

Introduction to the Django loaddata command #<\/a><\/h2>\n\n\n\n

The Django loaddata<\/code> command allows you to load data from a file into the database. Typically, you use the dumpdata<\/code> command to export data from a database and use the loaddata<\/code> command to import data from the file into the same or another database.<\/p>\n\n\n\n

The following shows the syntax of the loaddata<\/code> command:<\/p>\n\n\n

python manage.py loaddata fixture_name<\/code><\/span>Code language:<\/span> Python<\/span> (<\/span>python<\/span>)<\/span><\/small><\/pre>\n\n\n
A fixture is a collection of data files that Django will use to import into a database.<\/p>\n\n\n\n
By convention, Django will look for the fixtures in the fixtures<\/code> directory under each app and import data from them.<\/p>\n\n\n\n
For example, the following shows the fixtures directory and hr.json<\/code> file in the hr<\/code> application of the project:<\/p>\n\n\n
\u251c\u2500\u2500 admin.py\n\u251c\u2500\u2500 apps.py\n\u251c\u2500\u2500 fixtures\n|  \u2514\u2500\u2500 hr.json\n...<\/code><\/span>Code language:<\/span> Python<\/span> (<\/span>python<\/span>)<\/span><\/small><\/pre>\n\n\n
The following shows the excerpt of the hr.json<\/code> file:<\/p>\n\n\n
[\n  {\n    \"model\"<\/span>: \"hr.contact\"<\/span>,\n    \"pk\"<\/span>: 1<\/span>,\n    \"fields\"<\/span>: {\n      \"phone\"<\/span>: \"40812345678\"<\/span>,\n      \"address\"<\/span>: \"101 N 1st Street, San Jose, CA\"<\/span>\n    }\n  },\n  {\n    \"model\"<\/span>: \"hr.contact\"<\/span>,\n    \"pk\"<\/span>: 2<\/span>,\n    \"fields\"<\/span>: {\n      \"phone\"<\/span>: \"4081111111\"<\/span>,\n      \"address\"<\/span>: \"202 N 1st Street, San Jose, CA\"<\/span>\n    }\n  },\n...<\/code><\/span>Code language:<\/span> Python<\/span> (<\/span>python<\/span>)<\/span><\/small><\/pre>\n\n\n
To load the hr.json<\/code> to the database, you use the following loaddata<\/code> command:<\/p>\n\n\n
python manage.py loaddata hr.json<\/code><\/span>Code language:<\/span> Python<\/span> (<\/span>python<\/span>)<\/span><\/small><\/pre>\n\n\n
Fixture directory settings #<\/a><\/h2>\n\n\n\n
By default, Django finds the data files in the fixtures<\/code> directory inside each app. To specify additional directories that contain the fixture files, you can set them in the FIXTURE_DIRS<\/code> list in the settings.py<\/code> file:<\/p>\n\n\n
FIXTURE_DIRS = ['path\/to\/fixtures\/dir'<\/span>, 'path\/to\/fixtures\/dir2'<\/span>]<\/code><\/span>Code language:<\/span> Python<\/span> (<\/span>python<\/span>)<\/span><\/small><\/pre>\n\n\n
Loading sample HR data using the Django loaddata command #<\/a><\/h2>\n\n\n\n
We’ll use the loaddata<\/code> command to load data from fixtures for the HR<\/code> application of the Django project.<\/p>\n\n\n\n
First, download the project source code and extract it to a directory:<\/p>\n\n\n\n
Download the Django ORM project<\/a><\/p>\n\n\n\n
The hr\/fixtures<\/code> directory has the data.json<\/code> file that contains sample HR data.<\/p>\n\n\n\n
Second, run the loaddata<\/code> command to load data from the data.json<\/code> file:<\/p>\n\n\n
python<\/span> manage<\/span>.py<\/span> loaddata<\/span> data<\/span>.json<\/span><\/code><\/span>Code language:<\/span> CSS<\/span> (<\/span>css<\/span>)<\/span><\/small><\/pre>\n\n\n
It should output something like this:<\/p>\n\n\n
Installed 471<\/span> object(s) from<\/span> 1<\/span> fixture(s)<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
Summary #<\/a><\/h2>\n\n\n\n
    \n
  • Use the Django loaddata<\/code> command to load data from fixtures into the database.<\/li>\n<\/ul>\n
    \n\t
    \n\t\t
    Was this tutorial helpful ?<\/div>\n\t\t
    \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
    \n\t\t
    \n\t\t\t
    <\/div>\n\t\t\t