Django - South - 有没有办法查看它运行的 SQL?
问题描述
这就是我想要做的.
在带有开发数据库的开发服务器上开发 Django 项目.当我更改模型时，根据需要运行南迁移.
Develop a Django project on a development server with a development database. Run the south migrations as necessary when I change the model.
保存每次迁移的 SQL，并在我准备好部署时将其应用到生产服务器.
Save the SQL from each migration, and apply those to the production server when I'm ready to deploy.
South这样的事情可能吗?(我也很好奇其他人在使用 Django 时如何让您的开发数据库更改生产)
Is such a thing possible with South? (I'd also be curious what others do to get your development database changes on production when working with Django)
解决方案
你至少可以检查执行 manage.py migrate --db-dry-run --verbosity=2 生成的sql.这不会对数据库做任何事情，并且会显示所有的 sql.不过，我仍然会进行备份，安全总比抱歉好.
You can at least inspect the sql generated by doing manage.py migrate --db-dry-run --verbosity=2. This will not do anything to the database and will show all the sql. I would still make a backup though, better safe than sorry.
相关文章