Django dump data for a single model?

Question

Can I perform a dumpdata in Django on just a single model, rather than the whole app, and if so, how?

For an app it would be:

python manage.py dumpdata myapp

However, I want some specific model, such as "myapp.mymodel" to be dumped. The reason being, I have some huge, 3 million records plus, datasets in the same app that I would not like dumped.

I find your question not easy to understand. You want to load an SQL dump into your database? Or you want to do some sort of toString() on and instance of a model? — Leonard Ehrenfried, Jul 11 '09 at 06:42

score 286 · Accepted Answer · edited Oct 17 '16 at 00:09

286

As of version 1.1 and greater, the Django dumpdata management command allows you to dump data from individual tables:

./manage.py dumpdata myapp1 myapp2.my_model

You can also separate multiple apps and models on the command line. Here's the canonical definition:

django-admin dumpdata [app_label[.ModelName] [app_label[.ModelName] ...]]

edited Oct 17 '16 at 00:09

the Tin Man

155,156
41
207
295

answered Jul 11 '09 at 07:19

simplyharsh

33,714
12
61
70

19

gath, didn't understood the negative vote on post which is almost 2 years old. Moreover above code worked fine even with v1.1 . New features in new releases doesn't make older answers invalid. – simplyharsh May 17 '11 at 14:01
1

And how do I add this data at another instance of the app?. – aguilarpgc Jun 23 '16 at 17:00
4

To make human readable json use flag `--indent 4` after `dumpdata` – Valery Ramusik Jun 03 '19 at 06:53

score 112 · Answer 2 · edited Oct 17 '16 at 00:10

112

As noted, you can't do this through a manage.py command in Django 1.0. However you could use a script to export the JSON file, and load it using loaddata:

from django.core import serializers
from myproject.myapp import models
data = serializers.serialize("json", models.MyModel.objects.all())
out = open("mymodel.json", "w")
out.write(data)
out.close()

edited Oct 17 '16 at 00:10

the Tin Man

155,156
41
207
295

answered Jul 11 '09 at 10:51

dar

6,423
7
32
42

7

This is a great script because you can get even more granular if you'd like. If you instead do a .filter(...) on line three above you can dump just the specific records you want. – Gringo Suave Jun 07 '11 at 03:18

score 12 · Answer 3 · answered Feb 09 '21 at 06:11

A specific model to a specific file:

python manage.py dumpdata app_label.ModelName > specific_file.json

and to load it to another app: first move or copy the file to the app where you want process it, then:

python manage.py loaddata specific_file.json

score 11 · Answer 4 · answered Aug 07 '17 at 20:10

Take all data into json format from django model.

Syntax:

python manage.py dumpdata app_name.model_name

For example dumping data from group_permission model which reside in default auth app in django.

python manage.py dumpdata auth.group_permission

For output take a look on console.

score 6 · Answer 5 · edited Nov 19 '14 at 10:35

6

I think you had the solution in your question. You can dump an individual model like this:

./manage.py dumpdata myapp.my_model

edited Nov 19 '14 at 10:35

AlvaroAV

9,687
10
56
86

answered Jul 11 '09 at 06:59

Harold

4,939
1
18
15

i tried it before posting. had no luck. i'm in django 1.0. also tried myapp.models.mymodel? – nategood Jul 11 '09 at 07:09

score 5 · Answer 6 · answered May 20 '15 at 21:32

For success I had to say it twice, and specify the model two times, like:

./manage.py dumpdata myapp2.my_model myapp2.my_model

If I only said

./manage.py dumpdata myapp2 myapp2.my_model

I got flooded with all the models in myapp2, despite the fact that I specified my_model.

score 1 · Answer 7 · answered Apr 15 '12 at 21:26

1

I've created a management command the generate a fixture on a per model basis. Fixtures can be generated by running:

./manage generate_fixtures app.model.MyModel --file=dump/MyModel.json

code at: https://gist.github.com/2394883

answered Apr 15 '12 at 21:26

Jonas Geiregat

4,803
3
40
58

score 1 · Answer 8 · answered Jul 11 '09 at 07:34

1

As a workaround you could make another app and copy the model but point it to the existing table with the db_table meta option. Then you could just dump the models you copied into the new app. You existing app wouldn't be affected.

answered Jul 11 '09 at 07:34

Ogre Codes

17,293
1
15
24

score 1 · Answer 9 · answered Nov 19 '19 at 06:19

1

To write it on specific file:

python manage.py dumpdata app_label.ModelName app_label.ModelName2 > fixtures/specic.json

answered Nov 19 '19 at 06:19

Nikko

1,231
1
19
41

score 1 · Answer 10 · answered Oct 02 '20 at 09:04

If you want to dump only the specified objects of a model, you can use the --pks optional argument for the dumpdata command.

--pks PRIMARY_KEYS Outputs only the objects specified by a comma separated list of primary keys. This is only available when dumping one model. By default, all the records of the model are output.

score 1 · Answer 11 · edited Mar 10 '21 at 19:52

For newbies in Django and Python like me, this might be useful:

if you want to only dump a single row (of, obviously, a single table) and you have for example the app "merchant" and the model is also named "Merchant", and you usually import it using a fully qualified name like this: merchant.models.Merchant; do not even try to use this name. The syntax is as follows:

# only dumps the merchant with id = 123, pretty printed
python manage.py dumpdata merchant.Merchant --pks 123 --indent 2

score 0 · Answer 12 · answered May 13 '22 at 10:05

For DUMPING data out of the specific model for specific APP.

If we take EXAMPLE where we have in a MAIN PROJECT (We go call it project) and in this MAIN PROJECT we have two (02) others applications (We go call each app like this APP1 and APP2) we can do like that

python manage.py dumpdata APP1.name_of_model >APP1/fixtures/name_of_model .json
python manage.py dumpdata APP2.name_of_model >APP2/fixtures/name_of_model .json

Django dump data for a single model?

12 Answers12

Linked