jacobwegner/data-recovery-README.md

## data-recovery-README.md

      
    Raw
  

              data-recovery-README.md
            
          
    I was looking for a way to revert data deleted by mistake from the Django admin.
I reverse-engineered how Django's admin builds the list of objects displayed on the "Are you sure?"
confirmation page.
Given a single obj or list of objs, the script included in this gist will:

Use the NestedObjects utility to determine the objects that would be deleted
Pass those objects to Django's JSON serializer
Write the objects to adeleted-objects fixture

This allowed me to:

Restore a database locally to a time before the object was deleted
Generate the fixture
Apply the fixture to the database to restore data


## script.py
from django.core import serializers
from django.contrib.admin.utils import NestedObjects
from django.db import models, transaction, router

# assuming `obj` is the model instance for deletion:

objs = [obj]
using = router.db_for_write(obj._meta.model)
collector = NestedObjects(using=using)
collector.collect(objs)


def get_objects_callback():
    for qs in collector.data.values():
        for obj in qs:
            yield obj


output_format = "json"
with open("deleted-objects.json", "w") as f:
    serializers.serialize(output_format, get_objects_callback(), indent=2,
            use_natural_foreign_keys=True,
            use_natural_primary_keys=True,
            stream=f)
	from django.core import serializers
	from django.contrib.admin.utils import NestedObjects
	from django.db import models, transaction, router

	# assuming `obj` is the model instance for deletion:

	objs = [obj]
	using = router.db_for_write(obj._meta.model)
	collector = NestedObjects(using=using)
	collector.collect(objs)


	def get_objects_callback():
	for qs in collector.data.values():
	for obj in qs:
	yield obj


	output_format = "json"
	with open("deleted-objects.json", "w") as f:
	serializers.serialize(output_format, get_objects_callback(), indent=2,
	use_natural_foreign_keys=True,
	use_natural_primary_keys=True,
	stream=f)