On Wed, 2008-04-23 at 15:37 +0200, Thomas Guettler wrote: > Hi, > > has some one a script to show the difference between the > running database and one which get created by syncdb? > > Up to now, I used the output of sqlall before and after > a model change. But it would be better to do the > diff of the running database. > > Up to now I do it like this: > > pg_dump -s databasename > running.schema > ./manage.py test myapp # Hit ctrl-c after test database was created. > pg_dump -s test_databasename > test.schema > diff test.schema running.schema > > Maybe something like this be implemented as new management command ...
This sounds like it would be really difficult (complex) to make it work correctly. The output from a database tool is going to include stuff that you don't necessarily care about (e.g. constraints that are auto-created with names in some cases), the table ordering may well be different, models don't necessarily include all the fields in a database table... there's a whole maze of things that could be different. I'm not sure that comparing the output of one tool with the output of an entirely different tool to check for differences is going to be a robust solution. I think your current approach is a lot safer, since you at least understand the expected differences. Regards, Malcolm -- Experience is something you don't get until just after you need it. http://www.pointy-stick.com/blog/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
