Django models.py 表结构数据更新后应用到数据库中

Django models.py 表结构数据更新后应用到数据库中

如下，数据表新增字段：

# arch_center/models.py

class BaseArch(AbstractBaseModel):
  	...
    x86_tag = models.CharField("x86 架构版本", max_length=100, null=False, default='')
    x86_sha256 = models.CharField("x86 架构sha256值", max_length=100, null=False, default='')
    aarch64_tag = models.CharField("aarch64 架构版本", max_length=100, null=False, default='')
    aarch64_sha256 = models.CharField("aarch64 架构sha256值", max_length=100, null=False, default='')
    sw64_tag = models.CharField("sw64 架构版本", max_length=100, null=False, default='')
    sw64_sha256 = models.CharField("sw64 架构sha256值", max_length=100, null=False, default='')

    class Meta:
        db_table = "base_arch"
        verbose_name_plural = "基础镜像表"

未应用之前数据库表结构:

mysql> desc base_arch;
+--------------------+--------------+------+-----+---------+----------------+
| Field              | Type         | Null | Key | Default | Extra          |
+--------------------+--------------+------+-----+---------+----------------+
| id                 | int(11)      | NO   | PRI | NULL    | auto_increment |
| user               | varchar(100) | YES  |     | NULL    |                |
| is_newest          | varchar(100) | NO   |     | NULL    |                |
| is_delete          | varchar(20)  | NO   |     | NULL    |                |
| is_free            | varchar(20)  | NO   |     | NULL    |                |
+--------------------+--------------+------+-----+---------+----------------+
30 rows in set (0.00 sec)

新增操作：

python manage.py makemigrations arch_center

Migrations for 'arch_center':
  0079_auto_20220422_1046.py:
    - Add field aarch64_sha256 to basearch
    - Add field aarch64_tag to basearch
    - Add field sw64_sha256 to basearch
    - Add field sw64_tag to basearch
    - Add field x86_sha256 to basearch
    - Add field x86_tag to basearch

python manage.py migrate

Operations to perform:
  Synchronize unmigrated apps: staticfiles, messages
  Apply all migrations: basearch
Synchronizing apps without migrations:
  Creating tables...
    Running deferred SQL...
  Installing custom SQL...
Running migrations:
  Rendering model states... DONE
  Applying basearch.0079_auto_20220422_1046... OK    

再次查询数据库，成功

mysql> desc basearch;
+-----------------------+--------------+------+-----+---------+----------------+
| Field                 | Type         | Null | Key | Default | Extra          |
+-----------------------+--------------+------+-----+---------+----------------+
| id                    | int(11)      | NO   | PRI | NULL    | auto_increment |
| user                  | varchar(100) | YES  |     | NULL    |                |
| is_newest             | varchar(100) | NO   |     | NULL    |                |
| is_delete             | varchar(20)  | NO   |     | NULL    |                |
| is_free               | varchar(20)  | NO   |     | NULL    |                |
| aarch64_sha256        | varchar(100) | NO   |     | NULL    |                |
| aarch64_tag           | varchar(100) | NO   |     | NULL    |                |
| sw64_sha256           | varchar(100) | NO   |     | NULL    |                |
| sw64_tag              | varchar(100) | NO   |     | NULL    |                |
| x86_sha256            | varchar(100) | NO   |     | NULL    |                |
| x86_tag               | varchar(100) | NO   |     | NULL    |                |
+-----------------------+--------------+------+-----+---------+----------------+
36 rows in set (0.00 sec)

No migrations to apply 问题解决方法

问题来源：删除表，删除迁移文件，再次迁移时报错；
原因是：django_migrations 表中包含迁移记录，数据库会以为你已经迁移了，只需要删除对应数据即可

参考文档：https://blog.csdn.net/weixin_43996959/article/details/103091067