Here's something I wrote to export database contents from a django application into the Django database API format.

It's certainly not going to do all the work for you - in particular you'll need to reorder things to make sure things that Django wants to be objects (i.e. Foreign Keys) are instantiated before the related object gets made.

Hope this helps someone somewhere.

PLAIN TEXT
PYTHON:
  1. #!/usr/bin/env python
  2. """
  3. Script to export data from a Django database and generate
  4. the appropriate django DB-API commands
  6. Make sure you run it from the same directory as your settings.py
  8. NOTE: it does NOT handle relationships yet, so, you'll need to take the output
  9. and hand edit it to make sure that anything that Django needs as an object,
  10. gets instantiated first
  12. (c) Simon Greenhill / dev@simon.net.nz / http://simon.net.nz
  14. Version: 0.00001
  15. """
  16.  
  17. debug = False # just a debug flag to spit out what we're doing.
  18.  
  19. import sys
  20.  
  21. from django.core.management import setup_environ
  22.  
  23. try:
  24. import settings
  25. except ImportError:
  26. print "You don't appear to have a settings file in this directory!"
  27. print "Please run this from inside a project directory"
  28. sys.exit()
  29.  
  30. setup_environ(settings)
  31.  
  32. from django.db import models
  33.  
  34. # do model imports
  35. print """
  36. ###############################################################
  37. #                                                             #
  38. #   Model imports                                             #
  39. #                                                             #
  40. ###############################################################
  41. """
  42.  
  43. for app in models.get_apps():
  44. for model in app.models.get_models():
  45. print "from %s import %s" % ( app.__name__, model._meta.object_name )
  46.  
  47. # what apps we've done
  48. seen = []
  49. for app in models.get_apps():
  50. for model in app.models.get_models():
  51. if model not in seen:
  52. print
  53. print "# %s.%s " % (app.__name__, model._meta.object_name)
  54. print
  55.  
  56. if debug:
  57. print "#\t", model
  58.  
  59. for row in model.objects.iterator():
  60.  
  61. if debug:
  62. print "#\t\t",row
  63.  
  64. attrs = []
  65. for col in row._meta.fields:
  66. key = col.name
  67. value = getattr(row, key)
  68. if col.get_internal_type() == 'ForeignKey':
  69. ###print key, 'bork bork bork'
  70. pass
  71.  
  72. # if it's numeric, we don't need to quote it.
  73. if isinstance(value,int) or isinstance(value,float):
  74. pass
  75. # if it's a string...
  76. elif isinstance(value,str):
  77. # ... and it's got a quote mark or new line in it, then triple-quote it.
  78. if value.find('"')> 0 or value.find("\n")> 0:
  79. value = '"""%s"""' % value
  80. # ... otherwise single quote it.
  81. else:
  82. value = '"%s"' % value
  83. # don't know what it is, but single quote it
  84. else:
  85. value = '"%s"' % value
  86.  
  87. attrs.append( '%s=%s' % ( key, value ) )
  88.  
  89. if debug:
  90. print "#\t\t\t", key, getattr(row, key)
  91.  
  92. print """%s(%s).save()""" % ( model._meta.object_name, ', '.join(attrs) )
  93.  
  94. seen.append(model)

Update 19/01/2007: limodou has written a far superior export solution here.

--Simon