Django在代码更改后获取syncdbsqlall语句进行更新-Djangogetsyncdbsqlallstatementtoupdateaftercodechanges

Trying to see the SQL that syncdb would generate at the current moment in time.

试图查看syncdb将在当前时刻生成的SQL。

After several searches the answer wasn't readily apparent -- I know you can use:

经过几次搜索,答案并不明显 - 我知道你可以使用:

python manage.py syncdb --sqlall

returns:

Create the database tables for all apps in INSTALLED_APPS whose tables haven't already been created.

How can I output the changes that have happened for the entire database if the code has changed at all?

如果代码发生了变化,如何输出整个数据库发生的更改?

Is there a way to generate all of the SQL for all of the apps that need syncdb'ing at this time? Or need I just explicitly state each app? I'm not looking for all of the SQL for the entire site, just for the changes that would be implemented by a syncdb.

有没有办法为所有需要syncdb'ing的应用程序生成所有SQL?或者我需要明确说明每个应用程序?我不是在寻找整个站点的所有SQL,只是针对syncdb实现的更改。

I've got several apps that need sql generated to describe the changes. I could explicitly list them, but is there a way for syncdb to figure this out for me ?

我有几个应用程序需要生成sql来描述更改。我可以明确地列出它们,但是syncdb有没有办法为我解决这个问题?

2 个解决方案

./manage.py sqlall 

./manage.py sql 

sudo pip install django-extensions

INSTALLED_APPS = (
    ...
    'django_extensions',
    ...
)

python manage.py sqldiff -a

python manage.py sqlall {app_label}