欧美bbbwbbbw肥妇,免费乱码人妻系列日韩,一级黄片

Django多數(shù)據(jù)庫(kù)配置及逆向生成model教程

 更新時(shí)間：2020年03月28日 08:52:35   作者：qq_43776053  
這篇文章主要介紹了Django多數(shù)據(jù)庫(kù)配置及逆向生成model教程，具有很好的參考價(jià)值，希望對(duì)大家有所幫助。一起跟隨小編過(guò)來(lái)看看吧

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

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

DATABASES = {
 'default': {
  'ENGINE': 'django.db.backends.mysql', # 默認(rèn)用mysql
  'NAME': 'bk',      # 數(shù)據(jù)庫(kù)名 (默認(rèn)與APP_ID相同)
  'USER': 'root',      # 你的數(shù)據(jù)庫(kù)user
  'PASSWORD': 'root',      # 你的數(shù)據(jù)庫(kù)password
  'HOST': 'xxx.xxx.xxx.xxx',     # 開(kāi)發(fā)的時(shí)候，使用localhost
  'PORT': '3306',      # 默認(rèn)3306
 },
 'cloudsino_test': {
   'ENGINE': 'django.db.backends.mysql', # 默認(rèn)用mysql
   'NAME': 'cloudsino_test',      # 數(shù)據(jù)庫(kù)名 (默認(rèn)與APP_ID相同)
   'USER': 'root',      # 你的數(shù)據(jù)庫(kù)user
   'PASSWORD': 'root',      # 你的數(shù)據(jù)庫(kù)password
   'HOST': 'xxx.xxx.xxx.xxx',     # 開(kāi)發(fā)的時(shí)候，使用localhost
   'PORT': '3306',      # 默認(rèn)3306
  },
}

# 設(shè)置數(shù)據(jù)庫(kù)的路由規(guī)則方法
DATABASE_ROUTERS = ['conf.database_router.DatabaseAppsRouter']

# 設(shè)置APP對(duì)應(yīng)的數(shù)據(jù)庫(kù)路由表，哪個(gè)app要連接哪個(gè)數(shù)據(jù)庫(kù)，沒(méi)有指定會(huì)用default那個(gè)。
DATABASE_APPS_MAPPING = {
 # example:
 #'app_name':'database_name',
 'home_application': 'cloudsino_test',
 'cmdb': 'default',
}

2、新建database_router.py：

在與setting.py文件同級(jí)的目錄下新建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類型對(duì)象從哪一個(gè)數(shù)據(jù)庫(kù)讀取."""
  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類型對(duì)象的寫(xiě)入操作應(yīng)該使用哪個(gè)數(shù)據(jù)庫(kù)"""
  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，如果路由無(wú)法判斷則返回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ù)庫(kù)上運(yùn)行。如果操作應(yīng)該運(yùn)行則返回True ，如果不應(yīng)該運(yùn)行則返回False，如果路由無(wú)法判斷則返回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來(lái)逆向生成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_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'

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

正常的開(kāi)發(fā)流程

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

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

生成遷移文件

執(zhí)行遷移生成表

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

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

python manage.py inspectdb > app_name/models.py

例如：

python manage.py inspectdb > booktest/models.py

以上這篇Django多數(shù)據(jù)庫(kù)配置及逆向生成model教程就是小編分享給大家的全部?jī)?nèi)容了，希望能給大家一個(gè)參考，也希望大家多多支持腳本之家。

相關(guān)文章

  • Python編輯和運(yùn)行的四種方式

    Python編輯和運(yùn)行的四種方式

    本篇內(nèi)容主要是講python在電腦上編輯和運(yùn)行的幾種不同方式,后面主要是在pycharm中去寫(xiě)代碼,然后運(yùn)行,其實(shí)還有其他的方式可以在電腦上寫(xiě)python代碼和運(yùn)行python代碼,需要的朋友可以參考下
    2024-08-08
  • python讀取各種文件數(shù)據(jù)方法解析

    python讀取各種文件數(shù)據(jù)方法解析

    這篇文章主要為大家詳細(xì)介紹了python讀取各種文件數(shù)據(jù)方法，具有一定的參考價(jià)值，感興趣的小伙伴們可以參考一下
    2018-12-12
  • python3獲取文件中url內(nèi)容并下載代碼實(shí)例

    python3獲取文件中url內(nèi)容并下載代碼實(shí)例

    這篇文章主要介紹了python3獲取文件中url內(nèi)容并下載代碼實(shí)例,文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友可以參考下
    2019-12-12
  • Python爬蟲(chóng)實(shí)戰(zhàn)之批量下載快手平臺(tái)視頻數(shù)據(jù)

    Python爬蟲(chóng)實(shí)戰(zhàn)之批量下載快手平臺(tái)視頻數(shù)據(jù)

    讀萬(wàn)卷書(shū)不如行萬(wàn)里路，學(xué)的扎不扎實(shí)要通過(guò)實(shí)戰(zhàn)才能看出來(lái)，本篇文章手把手帶你批量下載快手平臺(tái)視頻數(shù)據(jù),大家可以在過(guò)程中查缺補(bǔ)漏，看看自己掌握程度怎么樣
    2021-10-10
  • python實(shí)現(xiàn)接口并發(fā)測(cè)試腳本

    python實(shí)現(xiàn)接口并發(fā)測(cè)試腳本

    這篇文章主要為大家詳細(xì)介紹了python實(shí)現(xiàn)接口并發(fā)測(cè)試腳本，具有一定的參考價(jià)值，感興趣的小伙伴們可以參考一下
    2019-06-06
  • Python模擬登陸實(shí)現(xiàn)代碼

    Python模擬登陸實(shí)現(xiàn)代碼

    本篇文章主要介紹了Python模擬登陸實(shí)現(xiàn)代碼，這里整理了詳細(xì)的代碼,具有一定的參考價(jià)值，感興趣的小伙伴們可以參考一下
    2017-06-06
  • 10 分鐘快速入門(mén) Python3的教程

    10 分鐘快速入門(mén) Python3的教程

    這篇文章主要介紹了10 分鐘快速入門(mén) Python3的教程，小編覺(jué)得挺不錯(cuò)的，現(xiàn)在分享給大家，也給大家做個(gè)參考。一起跟隨小編過(guò)來(lái)看看吧
    2019-01-01
  • python批量修改文件編碼格式的方法

    python批量修改文件編碼格式的方法

    這篇文章主要為大家詳細(xì)介紹了python批量修改文件編碼格式的方法，具有一定的參考價(jià)值，感興趣的小伙伴們可以參考一下
    2018-05-05
  • Python2 Selenium元素定位的實(shí)現(xiàn)(8種)

    Python2 Selenium元素定位的實(shí)現(xiàn)(8種)

    這篇文章主要介紹了Python2 Selenium元素定位的實(shí)現(xiàn)，小編覺(jué)得挺不錯(cuò)的，現(xiàn)在分享給大家，也給大家做個(gè)參考。一起跟隨小編過(guò)來(lái)看看吧
    2019-02-02
  • python如何實(shí)現(xiàn)遞歸轉(zhuǎn)非遞歸

    python如何實(shí)現(xiàn)遞歸轉(zhuǎn)非遞歸

    這篇文章主要介紹了python如何實(shí)現(xiàn)遞歸轉(zhuǎn)非遞歸，幫助大家更好的理解和學(xué)習(xí)使用python，感興趣的朋友可以了解下
    2021-02-02

最新評(píng)論