Django :在Django 1.9版本中为app重新创建所有表

Question

我尝试过使用./manage.py e.py迁移app_name零命令，这是提议的，但是在运行pythonmanage.py迁移测试应用程序之后，我仍然会继续获取错误。我的最后一个解决方案是转到mysql拖放整个db。

Operations to perform:
  Apply all migrations: testapp
Running migrations:
  Rendering model states... DONE
  Applying testapp.0001_initial...Traceback (most recent call last):
  File "manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "C:\Python27\lib\site-packages\django-1.9.7-py2.7.egg\django\core\management\__init__.py", line 353,
_line
    utility.execute()
  File "C:\Python27\lib\site-packages\django-1.9.7-py2.7.egg\django\core\management\__init__.py", line 345,
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "C:\Python27\lib\site-packages\django-1.9.7-py2.7.egg\django\core\management\base.py", line 348, in
    self.execute(*args, **cmd_options)
  File "C:\Python27\lib\site-packages\django-1.9.7-py2.7.egg\django\core\management\base.py", line 399, in
    output = self.handle(*args, **options)
  File "C:\Python27\lib\site-packages\django-1.9.7-py2.7.egg\django\core\management\commands\migrate.py", l
    executor.migrate(targets, plan, fake=fake, fake_initial=fake_initial)
  File "C:\Python27\lib\site-packages\django-1.9.7-py2.7.egg\django\db\migrations\executor.py", line 92, in
    self._migrate_all_forwards(plan, full_plan, fake=fake, fake_initial=fake_initial)
  File "C:\Python27\lib\site-packages\django-1.9.7-py2.7.egg\django\db\migrations\executor.py", line 121, i
    state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
  File "C:\Python27\lib\site-packages\django-1.9.7-py2.7.egg\django\db\migrations\executor.py", line 198, i
    state = migration.apply(state, schema_editor)
  File "C:\Python27\lib\site-packages\django-1.9.7-py2.7.egg\django\db\migrations\migration.py", line 123,
    operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
  File "C:\Python27\lib\site-packages\django-1.9.7-py2.7.egg\django\db\migrations\operations\models.py", li
rds
    schema_editor.create_model(model)
  File "C:\Python27\lib\site-packages\django-1.9.7-py2.7.egg\django\db\backends\base\schema.py", line 284,
    self.execute(sql, params or None)
  File "C:\Python27\lib\site-packages\django-1.9.7-py2.7.egg\django\db\backends\base\schema.py", line 110,
    cursor.execute(sql, params)
  File "C:\Python27\lib\site-packages\django-1.9.7-py2.7.egg\django\db\backends\utils.py", line 79, in exec
    return super(CursorDebugWrapper, self).execute(sql, params)
  File "C:\Python27\lib\site-packages\django-1.9.7-py2.7.egg\django\db\backends\utils.py", line 64, in exec
    return self.cursor.execute(sql, params)
  File "C:\Python27\lib\site-packages\django-1.9.7-py2.7.egg\django\db\utils.py", line 95, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "C:\Python27\lib\site-packages\django-1.9.7-py2.7.egg\django\db\backends\utils.py", line 62, in exec
    return self.cursor.execute(sql)
  File "C:\Python27\lib\site-packages\django-1.9.7-py2.7.egg\django\db\backends\mysql\base.py", line 112, i
    return self.cursor.execute(query, args)
  File "C:\Python27\lib\site-packages\MySQLdb\cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
django.db.utils.OperationalError: (1050, "Table 'testapp_cinfo' already exists")

Answer 1

您正在应用初始迁移，这意味着您正在创建该应用程序表的第一个版本。

但是数据库中已经有了该表，这样就可以伪造初始迁移。

python manage.py migrate --fake-initial

在Django 1.8中添加了要迁移的假初始标志。以前，Django总是自动伪造--如果检测到存在表，就应用初始迁移。

但是请注意，这只给出了两件事情：

1. 你没有改变你的模型，因为你做了他们的表(你有)。
2. 您尚未手动编辑数据库。

所以你也不能假装。

• 我想使用当前的数据库 如果您有您以前的未更改版本的testapp的初始迁移文件与迁移(非初始)文件与您的更改，您可以使用它们进行迁移。 首先伪造初始迁移，然后应用更改(这现在可能比较棘手，因为还必须截断存储迁移数据的django_migrations表)
• 我可以从头开始- 没有问题(删除数据库)，因为它是初始迁移，这就是它们的目的-创建DB/Table。

Answer 2

如果数据库中已经有表，请尝试./manage.py flush清除所有数据。刷新在整个db上执行SQL。

如果要删除数据库，请删除mysql。创建另一个具有相同名称的mysql db。然后运行./manage.py makemigrations，然后运行./manage.py migrate来重新创建db中的表。