在項(xiàng)目中我們每個(gè)app對應(yīng)不同的數(shù)據(jù)庫，其中有一個(gè)是從數(shù)據(jù)庫逆向生成model，做個(gè)筆記。

1、修改項(xiàng)目的setting.py配置 ：

DATABASES = { ’default’: { ’ENGINE’: ’django.db.backends.mysql’, # 默認(rèn)用mysql ’NAME’: ’bk’, # 數(shù)據(jù)庫名 (默認(rèn)與APP_ID相同) ’USER’: ’root’, # 你的數(shù)據(jù)庫user ’PASSWORD’: ’root’, # 你的數(shù)據(jù)庫password ’HOST’: ’xxx.xxx.xxx.xxx’, # 開發(fā)的時(shí)候，使用localhost ’PORT’: ’3306’, # 默認(rèn)3306 }, ’cloudsino_test’: { ’ENGINE’: ’django.db.backends.mysql’, # 默認(rèn)用mysql ’NAME’: ’cloudsino_test’, # 數(shù)據(jù)庫名 (默認(rèn)與APP_ID相同) ’USER’: ’root’, # 你的數(shù)據(jù)庫user ’PASSWORD’: ’root’, # 你的數(shù)據(jù)庫password ’HOST’: ’xxx.xxx.xxx.xxx’, # 開發(fā)的時(shí)候，使用localhost ’PORT’: ’3306’, # 默認(rèn)3306 },}# 設(shè)置數(shù)據(jù)庫的路由規(guī)則方法DATABASE_ROUTERS = [’conf.database_router.DatabaseAppsRouter’]# 設(shè)置APP對應(yīng)的數(shù)據(jù)庫路由表，哪個(gè)app要連接哪個(gè)數(shù)據(jù)庫，沒有指定會用default那個(gè)。DATABASE_APPS_MAPPING = { # example: #’app_name’:’database_name’, ’home_application’: ’cloudsino_test’, ’cmdb’: ’default’,}

2、新建database_router.py：

在與setting.py文件同級的目錄下新建database_router.py文件：

# -*- coding: utf-8 -*-from settings_development import DATABASE_APPS_MAPPINGDATABASE_MAPPING = DATABASE_APPS_MAPPINGclass DatabaseAppsRouter(object): def db_for_read(self, model, **hints): ''''建議model類型對象從哪一個(gè)數(shù)據(jù)庫讀取.''' if model._meta.app_label in DATABASE_MAPPING: return DATABASE_MAPPING[model._meta.app_label] return None def db_for_write(self, model, **hints): '''建議model類型對象的寫入操作應(yīng)該使用哪個(gè)數(shù)據(jù)庫''' if model._meta.app_label in DATABASE_MAPPING: return DATABASE_MAPPING[model._meta.app_label] return None def allow_relation(self, obj1, obj2, **hints): '''Allow any relation between apps that use the same database. 如果obj1 和obj2 之間應(yīng)該允許關(guān)聯(lián)則返回True，如果應(yīng)該防止關(guān)聯(lián)則返回False，如果路由無法判斷則返回None ''' db_obj1 = DATABASE_MAPPING.get(obj1._meta.app_label) db_obj2 = DATABASE_MAPPING.get(obj2._meta.app_label) if db_obj1 and db_obj2: if db_obj1 == db_obj2: return True else: return False return None def allow_syncdb(self, db, model): '''Make sure that apps only appear in the related database.''' if db in DATABASE_MAPPING.values(): return DATABASE_MAPPING.get(model._meta.app_label) == db elif model._meta.app_label in DATABASE_MAPPING: return False return None def allow_migrate(self, db, app_label, model=None, **hints): ''' Make sure the auth app only appears in the ’auth_db’ database. 定義遷移操作是否允許在別名為db的數(shù)據(jù)庫上運(yùn)行。如果操作應(yīng)該運(yùn)行則返回True ，如果不應(yīng)該運(yùn)行則返回False，如果路由無法判斷則返回None。 ''' if db in DATABASE_MAPPING.values(): return DATABASE_MAPPING.get(app_label) == db elif app_label in DATABASE_MAPPING: return False return None

3.逆向生成model：

在terminal中輸入以下命令，使用名為cloudsino_test的DATABASE來逆向生成model到home_application這個(gè)app的models.py：

python manage.py inspectdb --database=cloudsino_test > home_application/models.py

逆向生成的model：

# This is an auto-generated Django model module.# You’ll have to do the following manually to clean this up:# * Rearrange models’ order# * Make sure each model has one field with primary_key=True# * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the table# Feel free to rename the models, but don’t rename db_table values or field names.## Also note: You’ll have to insert the output of ’django-admin sqlcustom [app_label]’# into your database.from __future__ import unicode_literalsfrom django.db import modelsclass CloudsinoCpuinfo(models.Model): corenumber = models.CharField(max_length=128) frequency = models.CharField(max_length=128) index = models.CharField(max_length=128) manufacturer = models.CharField(max_length=128) name = models.CharField(max_length=128) partnumber = models.CharField(max_length=128) serialnumber = models.CharField(max_length=128) type = models.CharField(max_length=128) device = models.ForeignKey(’CloudsinoDevice’, blank=True, null=True) class Meta: managed = False db_table = ’cloudsino_cpuinfo’class CloudsinoDevice(models.Model): sn = models.CharField(max_length=128) app = models.CharField(max_length=128) business_chargeby1 = models.CharField(max_length=128) business_chargeby2 = models.CharField(max_length=128) chargeby1 = models.CharField(max_length=128) chargeby2 = models.CharField(max_length=128) description = models.CharField(max_length=128) device_status = models.CharField(max_length=128) devicename = models.CharField(max_length=128) field1 = models.CharField(max_length=128) field2 = models.CharField(max_length=128) field3 = models.CharField(max_length=128) field4 = models.CharField(max_length=128) field5 = models.CharField(max_length=128) frame_posiniton = models.CharField(max_length=128) framename = models.CharField(max_length=128) ip = models.CharField(max_length=128) manufacturer = models.CharField(max_length=128) model = models.CharField(max_length=128) os = models.CharField(max_length=128) position_desc = models.CharField(max_length=128) roomarea = models.CharField(max_length=128) roomname = models.CharField(max_length=128) servicetag = models.CharField(max_length=128) shape = models.CharField(max_length=128) specification = models.CharField(max_length=128) subtype = models.CharField(max_length=128) type = models.CharField(max_length=128) ucount = models.CharField(max_length=128) class Meta: managed = False db_table = ’cloudsino_device’class CloudsinoDevicetype(models.Model): name = models.CharField(max_length=128) type = models.CharField(max_length=128) status = models.CharField(max_length=128) class Meta: managed = False db_table = ’cloudsino_devicetype’class CloudsinoDiskinfo(models.Model): bus = models.CharField(max_length=128) formfactor = models.CharField(max_length=128) index = models.CharField(max_length=128) manufacturer = models.CharField(max_length=128) media = models.CharField(max_length=128) name = models.CharField(max_length=128) partnumber = models.CharField(max_length=128) serialnumber = models.CharField(max_length=128) size = models.CharField(max_length=128) speed = models.CharField(max_length=128) type = models.CharField(max_length=128) device = models.ForeignKey(CloudsinoDevice, blank=True, null=True) class Meta: managed = False db_table = ’cloudsino_diskinfo’class CloudsinoFaninfo(models.Model): index = models.CharField(max_length=128) name = models.CharField(max_length=128) partnumber = models.CharField(max_length=128) serialnumber = models.CharField(max_length=128) device = models.ForeignKey(CloudsinoDevice, blank=True, null=True) class Meta: managed = False db_table = ’cloudsino_faninfo’class CloudsinoHbacardinfo(models.Model): name = models.CharField(max_length=128) wwnn = models.CharField(max_length=128) wwpn = models.CharField(max_length=128) fc_switch = models.CharField(max_length=128) switch_port = models.CharField(max_length=128) switch_mac = models.CharField(max_length=128) device = models.ForeignKey(CloudsinoDevice, blank=True, null=True) class Meta: managed = False db_table = ’cloudsino_hbacardinfo’class CloudsinoManageinfo(models.Model): assetcode = models.CharField(max_length=128) department = models.CharField(max_length=128) express_code = models.CharField(max_length=128) service_level = models.CharField(max_length=128) shutdown_level = models.CharField(max_length=128) usage = models.CharField(max_length=128) device = models.ForeignKey(CloudsinoDevice, blank=True, null=True) class Meta: managed = False db_table = ’cloudsino_manageinfo’class CloudsinoManufacturertype(models.Model): name = models.CharField(max_length=128) type = models.CharField(max_length=128) status = models.CharField(max_length=128) class Meta: managed = False db_table = ’cloudsino_manufacturertype’class CloudsinoMemory(models.Model): name = models.CharField(max_length=128) type = models.CharField(max_length=128) frequency = models.CharField(max_length=128) size = models.CharField(max_length=128) manufacturer = models.CharField(max_length=128) partnumber = models.CharField(max_length=128) serialnumber = models.CharField(max_length=128) index = models.CharField(max_length=128) memoryinfo = models.ForeignKey(’CloudsinoMemoryinfo’, blank=True, null=True) class Meta: managed = False db_table = ’cloudsino_memory’class CloudsinoMemoryinfo(models.Model): max_dimmslots = models.CharField(max_length=128) mem_totalsize = models.CharField(max_length=128) memmax_capacitysize = models.CharField(max_length=128) populated_dimmslots = models.CharField(max_length=128) device = models.ForeignKey(CloudsinoDevice, blank=True, null=True) class Meta: managed = False db_table = ’cloudsino_memoryinfo’class CloudsinoNetworkinfo(models.Model): name = models.CharField(max_length=128) type = models.CharField(max_length=128) mac = models.CharField(max_length=128) speed = models.CharField(max_length=128) manufacturer = models.CharField(max_length=128) partnumber = models.CharField(max_length=128) serialnumber = models.CharField(max_length=128) index = models.CharField(max_length=128) device = models.ForeignKey(CloudsinoDevice, blank=True, null=True) class Meta: managed = False db_table = ’cloudsino_networkinfo’class CloudsinoOobnetwork(models.Model): ip = models.CharField(max_length=128) netmask = models.CharField(max_length=128) gateway = models.CharField(max_length=128) mac = models.CharField(max_length=128) ethernet_switch = models.CharField(max_length=128) swith_port = models.CharField(max_length=128) swith_mac = models.CharField(max_length=128) distribution_frame = models.CharField(max_length=128) distribution = models.CharField(max_length=128) device = models.ForeignKey(CloudsinoDevice, blank=True, null=True) class Meta: managed = False db_table = ’cloudsino_oobnetwork’class CloudsinoPciecard(models.Model): name = models.CharField(max_length=128) type = models.CharField(max_length=128) loc = models.CharField(max_length=128) online_state = models.CharField(max_length=128) conntype = models.CharField(max_length=128) bandwidth = models.CharField(max_length=128) speed = models.CharField(max_length=128) manufacturer = models.CharField(max_length=128) partnumber = models.CharField(max_length=128) serialnumber = models.CharField(max_length=128) index = models.CharField(max_length=128) device = models.ForeignKey(CloudsinoDevice, blank=True, null=True) class Meta: managed = False db_table = ’cloudsino_pciecard’class CloudsinoPowerinfo(models.Model): name = models.CharField(max_length=128) type = models.CharField(max_length=128) model = models.CharField(max_length=128) outputpower = models.CharField(max_length=128) manufacturer = models.CharField(max_length=128) partnumber = models.CharField(max_length=128) serialnumber = models.CharField(max_length=128) index = models.CharField(max_length=128) device = models.ForeignKey(CloudsinoDevice, blank=True, null=True) class Meta: managed = False db_table = ’cloudsino_powerinfo’class CloudsinoProductnetwork(models.Model): ip = models.CharField(max_length=128) netmask = models.CharField(max_length=128) gateway = models.CharField(max_length=128) mac = models.CharField(max_length=128) os = models.CharField(max_length=128) remote_type = models.CharField(max_length=128) remote_port = models.CharField(max_length=128) ethernet_switch = models.CharField(max_length=128) swith_port = models.CharField(max_length=128) swith_mac = models.CharField(max_length=128) distribution_frame = models.CharField(max_length=128) distribution = models.CharField(max_length=128) device = models.ForeignKey(CloudsinoDevice, blank=True, null=True) class Meta: managed = False db_table = ’cloudsino_productnetwork’class CloudsinoPurchasewarrantyinfo(models.Model): date_manuf = models.CharField(max_length=128) expiredate = models.CharField(max_length=128) price = models.CharField(max_length=128) purchase_order = models.CharField(max_length=128) purchase_order_name = models.CharField(max_length=128) purchase_supply = models.CharField(max_length=128) serviceagent = models.CharField(max_length=128) warrantyitem = models.CharField(db_column=’warrantyItem’, max_length=128) # Field name made lowercase. warrantyperiod = models.CharField(db_column=’warrantyPeriod’, max_length=128) # Field name made lowercase. warrantystartdate = models.CharField(db_column=’warrantyStartDate’, max_length=128) # Field name made lowercase. warrantytype = models.CharField(db_column=’warrantyType’, max_length=128) # Field name made lowercase. device = models.ForeignKey(CloudsinoDevice, blank=True, null=True) class Meta: managed = False db_table = ’cloudsino_purchasewarrantyinfo’class CloudsinoRaidinfo(models.Model): name = models.CharField(max_length=128) type = models.CharField(max_length=128) cachesize = models.CharField(max_length=128) speed = models.CharField(max_length=128) manufacturer = models.CharField(max_length=128) partnumber = models.CharField(max_length=128) serialnumber = models.CharField(max_length=128) index = models.CharField(max_length=128) device = models.ForeignKey(CloudsinoDevice, blank=True, null=True) class Meta: managed = False db_table = ’cloudsino_raidinfo’class DjangoMigrations(models.Model): app = models.CharField(max_length=255) name = models.CharField(max_length=255) applied = models.DateTimeField() class Meta: managed = False db_table = ’django_migrations’

補(bǔ)充知識：Django使用數(shù)據(jù)庫生成模型類

正常的開發(fā)流程

在models.py中定義模型類，要求繼承自models.Model

把應(yīng)用加入settings.py文件的installed_app項(xiàng)

生成遷移文件

執(zhí)行遷移生成表

使用模型類進(jìn)行crud操作

使用數(shù)據(jù)庫生成模型類

python manage.py inspectdb > app_name/models.py

例如：

python manage.py inspectdb > booktest/models.py

以上這篇Django多數(shù)據(jù)庫配置及逆向生成model教程就是小編分享給大家的全部內(nèi)容了，希望能給大家一個(gè)參考，也希望大家多多支持好吧啦網(wǎng)。