Hello, Can you share the initial code with us? This approach seems to be good. Do you have experience on some project?
David Mike H napsal: > Hi all, > > I've been working on a tool to give me an automated way of altering the > schemas on servers I deploy my django applications to. I know about the > schema-evolution branch, but the current approach of that isn't > completely automated and the work seems to have stopped on it. > > The approach I have taken is very simple. Inside each application > installed in your project, you create a migrations module. Inside there > is a list of migrations that need to be applied and an sql directory > that contains the actual migrations themselves. > > For example : > > cms/ > migrations/ > migrator.py -- holds the list of migrations to run, in the order > to run them > sql/ > InstallInitialStructure.sql > AddNewAttributeColumn.sql > ... etc. ... > > So with this approach you would create the initial structure sql file > using the django sql generation, then you would have to produce sql > files for each addition / deletion / merge you need to make. > > The sql directory can have subdirectories named the same as your database > engine if you need an engine specific sql file. > > All that is needed is to copy a migrate.py script into the root of your > project and run 'python migrate.py' - any migrations on any of the > installed applications that have not been run would automatically get > run and a log kept so that migrations do not run twice. > > Does this sound useful to anyone who is doing automated deployments? > > Mike --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
