django 使用 dbfirst 重写 inspectdb 命令（comments 转化成 verbose_name）

前言

在django比较常用的方式是根据orm类生成数据库的表，今天我们要介绍的是通过数据库中的表生成orm类

一、使用inspectdb

一般通过 inspectdb 命令实现dbfirst ,常规操作我们生成的类是这样的:

class BLicenceinfo(models.Model):
    id = models.BigAutoField(primary_key=True)
    field_locked = models.IntegerField(db_column='_Locked')  # Field name made lowercase. Field renamed because it started with '_'.
    field_delete = models.IntegerField(db_column='_Delete')  # Field name made lowercase. Field renamed because it started with '_'.
    mlid = models.CharField(db_column='MLID', max_length=50)  # Field name made lowercase.
    zbid = models.CharField(db_column='ZBID', max_length=100, blank=True, null=True)  # Field name made lowercase.
    createter = models.CharField(db_column='Createter', max_length=100, blank=True, null=True)  # Field name made lowercase.
    createtime = models.DateTimeField(db_column='CreateTime', blank=True, null=True)  # Field name made lowercase.
    modifiers = models.CharField(db_column='Modifiers', max_length=100, blank=True, null=True)  # Field name made lowercase.
    modificationtime = models.DateTimeField(db_column='ModificationTime', blank=True, null=True)  # Field name made lowercase.
    nowstatus = models.CharField(db_column='NowStatus', max_length=50, blank=True, null=True)  # Field name made lowercase.
    enterpriseslistid = models.CharField(db_column='EnterprisesListID', max_length=50, blank=True, null=True)  # Field name made lowercase.
    licenceid = models.CharField(db_column='LicenceId', max_length=50)  # Field name made lowercase.
    licencename = models.CharField(db_column='LicenceName', max_length=50)  # Field name made lowercase.
    licencetype = models.CharField(db_column='LicenceType', max_length=50)  # Field name made lowercase.
    required = models.IntegerField(db_column='Required')  # Field name made lowercase.
    expiredate = models.IntegerField(db_column='ExpireDate')  # Field name made lowercase.
    promisedatet = models.IntegerField(db_column='PromiseDatet', blank=True, null=True)  # Field name made lowercase.
    mnemoniccode = models.CharField(db_column='MnemonicCode', max_length=50, blank=True, null=True)  # Field name made lowercase.
    field_sortkey = models.DecimalField(db_column='_SortKey', max_digits=24, decimal_places=14)  # Field name made lowercase. Field renamed because it started with '_'.

    class Meta:
        managed = False
        db_table = 'B_LicenceInfo'
        unique_together = (('enterpriseslistid', 'licenceid'),)

但是这并不是我们想要的东西，我要把mysql 列名备注生成verbose_name

二、使用步骤

1.引入文件 在app下加入这个文件

2.文件的内容有一个 commands 文件夹，里面包含了inspectdb.py 文件

这个inspectdb.py 文件就是我们要修改的类。

3.实现思路 

修改文件中的 handle_inspection 方法 代码如下