Django多數(shù)據(jù)庫配置及逆向生成model教程
更新時間：2020年03月28日 08:52:35 作者：qq_43776053
這篇文章主要介紹了Django多數(shù)據(jù)庫配置及逆向生成model教程，具有很好的參考價值，希望對大家有所幫助。一起跟隨小編過來看看吧
在項目中我們每個app對應(yīng)不同的數(shù)據(jù)庫，其中有一個是從數(shù)據(jù)庫逆向生成model，做個筆記。
1、修改項目的setting.py配置 ：
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql', # 默認用mysql
'NAME': 'bk', # 數(shù)據(jù)庫名 (默認與APP_ID相同)
'USER': 'root', # 你的數(shù)據(jù)庫user
'PASSWORD': 'root', # 你的數(shù)據(jù)庫password
'HOST': 'xxx.xxx.xxx.xxx', # 開發(fā)的時候，使用localhost
'PORT': '3306', # 默認3306
},
'cloudsino_test': {
'ENGINE': 'django.db.backends.mysql', # 默認用mysql
'NAME': 'cloudsino_test', # 數(shù)據(jù)庫名 (默認與APP_ID相同)
'USER': 'root', # 你的數(shù)據(jù)庫user
'PASSWORD': 'root', # 你的數(shù)據(jù)庫password
'HOST': 'xxx.xxx.xxx.xxx', # 開發(fā)的時候，使用localhost
'PORT': '3306', # 默認3306
},
}
# 設(shè)置數(shù)據(jù)庫的路由規(guī)則方法
DATABASE_ROUTERS = ['conf.database_router.DatabaseAppsRouter']
# 設(shè)置APP對應(yīng)的數(shù)據(jù)庫路由表，哪個app要連接哪個數(shù)據(jù)庫，沒有指定會用default那個。
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_MAPPING
DATABASE_MAPPING = DATABASE_APPS_MAPPING
class DatabaseAppsRouter(object):
def db_for_read(self, model, **hints):
""""建議model類型對象從哪一個數(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)該使用哪個數(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īng)該運行則返回True ，如果不應(yīng)該運行則返回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這個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_literals
from django.db import models
class 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'
補充知識：Django使用數(shù)據(jù)庫生成模型類
正常的開發(fā)流程
在models.py中定義模型類，要求繼承自models.Model
把應(yīng)用加入settings.py文件的installed_app項
生成遷移文件
執(zhí)行遷移生成表
使用模型類進行crud操作
使用數(shù)據(jù)庫生成模型類
python manage.py inspectdb > app_name/models.py
例如：
python manage.py inspectdb > booktest/models.py
以上這篇Django多數(shù)據(jù)庫配置及逆向生成model教程就是小編分享給大家的全部內(nèi)容了，希望能給大家一個參考，也希望大家多多支持腳本之家。
您可能感興趣的文章:
- 詳解多線程Django程序耗盡數(shù)據(jù)庫連接的問題
- Django使用多數(shù)據(jù)庫的方法
- Django中數(shù)據(jù)庫的數(shù)據(jù)關(guān)系:一對一,一對多,多對多
- django 多數(shù)據(jù)庫配置教程
- Django app配置多個數(shù)據(jù)庫代碼實例
- django 多數(shù)據(jù)庫及分庫實現(xiàn)方式
- django 鏈接多個數(shù)據(jù)庫 并使用原生sql實現(xiàn)
- Django多數(shù)據(jù)庫的實現(xiàn)過程詳解
- Django多數(shù)據(jù)庫聯(lián)用實現(xiàn)方法解析
- django使用多個數(shù)據(jù)庫的方法實例
相關(guān)文章
本篇內(nèi)容主要是講python在電腦上編輯和運行的幾種不同方式,后面主要是在pycharm中去寫代碼,然后運行,其實還有其他的方式可以在電腦上寫python代碼和運行python代碼,需要的朋友可以參考下2024-08-08
這篇文章主要為大家詳細介紹了python讀取各種文件數(shù)據(jù)方法，具有一定的參考價值，感興趣的小伙伴們可以參考一下2018-12-12
這篇文章主要介紹了python3獲取文件中url內(nèi)容并下載代碼實例,文中通過示例代碼介紹的非常詳細，對大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價值,需要的朋友可以參考下2019-12-12
Python爬蟲實戰(zhàn)之批量下載快手平臺視頻數(shù)據(jù)
讀萬卷書不如行萬里路，學(xué)的扎不扎實要通過實戰(zhàn)才能看出來，本篇文章手把手帶你批量下載快手平臺視頻數(shù)據(jù),大家可以在過程中查缺補漏，看看自己掌握程度怎么樣2021-10-10
這篇文章主要為大家詳細介紹了python實現(xiàn)接口并發(fā)測試腳本，具有一定的參考價值，感興趣的小伙伴們可以參考一下2019-06-06
本篇文章主要介紹了Python模擬登陸實現(xiàn)代碼，這里整理了詳細的代碼,具有一定的參考價值，感興趣的小伙伴們可以參考一下2017-06-06
這篇文章主要介紹了10 分鐘快速入門 Python3的教程，小編覺得挺不錯的，現(xiàn)在分享給大家，也給大家做個參考。一起跟隨小編過來看看吧2019-01-01
這篇文章主要為大家詳細介紹了python批量修改文件編碼格式的方法，具有一定的參考價值，感興趣的小伙伴們可以參考一下2018-05-05
Python2 Selenium元素定位的實現(xiàn)(8種)
這篇文章主要介紹了Python2 Selenium元素定位的實現(xiàn)，小編覺得挺不錯的，現(xiàn)在分享給大家，也給大家做個參考。一起跟隨小編過來看看吧2019-02-02
這篇文章主要介紹了python如何實現(xiàn)遞歸轉(zhuǎn)非遞歸，幫助大家更好的理解和學(xué)習(xí)使用python，感興趣的朋友可以了解下2021-02-02