Django - South - 有没有办法查看它运行的 SQL? [英] Django - South - Is There a way to view the SQL it runs?

问题描述

这就是我想要做的.

在带有开发数据库的开发服务器上开发 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.

这篇关于Django - South - 有没有办法查看它运行的 SQL?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！