Django 搭建CMDB系統(tǒng)完整[4](主菜單、資產(chǎn)數(shù)據(jù)庫表)

修改main_page主菜單

data = [{"accessPath":"","checked":false,"delFlag":0,"parentID":1,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":3,"resourceName":"資產(chǎn)","resourceOrder":0,"resourceType":""},
{"accessPath":"house_list.html","checked":false,"delFlag":0,"parentID":3,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":31,"resourceName":"機(jī)房","resourceOrder":0,"resourceType":""},
{"accessPath":"","checked":false,"delFlag":0,"parentID":3,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":32,"resourceName":"物理服務(wù)器","resourceOrder":0,"resourceType":""},
{"accessPath":"","checked":false,"delFlag":0,"parentID":3,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":33,"resourceName":"虛擬機(jī)","resourceOrder":0,"resourceType":""},
{"accessPath":"","checked":false,"delFlag":0,"parentID":3,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":34,"resourceName":"網(wǎng)絡(luò)設(shè)備","resourceOrder":0,"resourceType":""},
{"accessPath":"","checked":false,"delFlag":0,"parentID":3,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":35,"resourceName":"安全設(shè)備","resourceOrder":0,"resourceType":""},
{"accessPath":"","checked":false,"delFlag":0,"parentID":3,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":36,"resourceName":"存儲設(shè)備","resourceOrder":0,"resourceType":""},
{"accessPath":"","checked":false,"delFlag":0,"parentID":3,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":37,"resourceName":"軟件資產(chǎn)","resourceOrder":0,"resourceType":""},
{"accessPath":"","checked":false,"delFlag":0,"parentID":3,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":38,"resourceName":"廠商","resourceOrder":0,"resourceType":""}, {"accessPath":"","checked":false,"delFlag":0,"parentID":1,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":4,"resourceName":"配置管理","resourceOrder":0,"resourceType":""},
{"accessPath":"","checked":false,"delFlag":0,"parentID":4,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":41,"resourceName":"配置","resourceOrder":0,"resourceType":""},
{"accessPath":"","checked":false,"delFlag":0,"parentID":4,"resourceCode":"","resourceDesc":"","resourceGrade":2,"resourceID":42,"resourceName":"腳本","resourceOrder":0,"resourceType":""}];

生成app

python manage.py startapp cmdbapp
cd cmdbapp

修改cmdbapp views.py

vi views.py

-- coding: utf-8 --

from future import unicode_literals

from django.shortcuts import render,render_to_response

Create your views here.

def main_page(request):
return render_to_response('main_page.html', {'user':request.user })

注冊app

vi /dj/cmdb/settings.py

INSTALLED_APPS = [
'django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'cmdbapp',
]

修改url

from cmdbapp import views

設(shè)計數(shù)據(jù)庫表：機(jī)房、物理服務(wù)器、虛擬機(jī)、網(wǎng)絡(luò)設(shè)備、安全設(shè)備、存儲設(shè)備、軟件資產(chǎn)、廠商

設(shè)計機(jī)房表

-- coding: utf-8 --

from future import unicode_literals

from django.db import models

class Machinaroom(models.Model):
id=models.AutoField(primary_key=True)
name=models.CharField(max_length=200,default=u'機(jī)房')
location=models.CharField(max_length=200,default=u'廈門')
vpnurl=models.URLField()

    def __unicode__(self):
            return self.name

class Server(models.Model):
"""
服務(wù)器信息
"""
machinaroom= models.ForeignKey(Machinaroom)

    hostname = models.CharField(max_length=128, unique=True)
    sn = models.CharField('SN號', max_length=64,null=True,blank=True)
    manufacturer = models.CharField(verbose_name='制造商', max_length=64, null=True, blank=True)
    model = models.CharField('型號', max_length=64, null=True, blank=True)

    manage_ip = models.GenericIPAddressField('管理IP', null=True, blank=True)
    other_ip = models.GenericIPAddressField('其他IP', null=True, blank=True)

    os_platform = models.CharField('系統(tǒng)', max_length=16, null=True, blank=True)
    os_version = models.CharField('系統(tǒng)版本', max_length=16, null=True, blank=True)

    cpu_count = models.IntegerField('CPU個數(shù)', null=True, blank=True)
    cpu_physical_count = models.IntegerField('CPU物理個數(shù)', null=True, blank=True)
    cpu_model = models.CharField('CPU型號', max_length=128, null=True, blank=True)

    memory_model=models.CharField('memory型號', max_length=128, null=True, blank=True)
    memory_size=models.CharField('memory大小',max_length=128, null=True, blank=True)

    status_choices = ((0, '在線'),
                  (1, '已下線'),
                  (2, '未知'),
                  (3, '故障'),
                  (4, '備用'),
                  )
    status = models.SmallIntegerField(choices=status_choices, default=0)

    id =models.AutoField(primary_key=True)
    class Meta:
            verbose_name_plural = "服務(wù)器表"

    def __str__(self):
            return self.hostname

class VirtualMachina(models.Model):
"""虛擬機(jī)信息"""
server= models.ForeignKey(Server)
hostname = models.CharField(max_length=128, unique=True)
manage_ip = models.GenericIPAddressField('管理IP', null=True, blank=True)
other_ip = models.GenericIPAddressField('其他IP', null=True, blank=True)
os_platform = models.CharField('系統(tǒng)', max_length=16, null=True, blank=True)
os_version = models.CharField('系統(tǒng)版本', max_length=16, null=True, blank=True)
cpu_memo = models.CharField('CPU信息',max_length=128, null=True, blank=True)
memory_size=models.CharField('memory大小',max_length=128, null=True, blank=True)

    disk_count=models.CharField('硬盤信息',max_length=200, null=True, blank=True)
    status_choices = ((0, '在線'),
                  (1, '已下線'),
                  (2, '未知'),
                  (3, '故障'),
                  (4, '備用'),
                  )
    status = models.SmallIntegerField(choices=status_choices, default=0)

    id =models.AutoField(primary_key=True)

    def __str__(self):
            return self.hostname

class NetworkDevice(models.Model):
status_choices = ((0, '在線'),
(1, '已下線'),
(2, '未知'),
(3, '故障'),
(4, '備用'),
)
status = models.SmallIntegerField(choices=status_choices, default=0)

    id =models.AutoField(primary_key=True)
    machinaroom= models.ForeignKey(Machinaroom)

    hostname = models.CharField(max_length=128, unique=True)
    port_num = models.SmallIntegerField(u'端口個數(shù)', null=True, blank=True)
    device_detail = models.TextField(u'設(shè)置詳細(xì)配置', null=True, blank=True)
    model = models.CharField(u'型號', max_length=128, null=True, blank=True)
    manage_ip = models.GenericIPAddressField('管理IP', null=True, blank=True)
    other_ip = models.GenericIPAddressField('其他IP', null=True, blank=True)

    class Meta:
            verbose_name = '網(wǎng)絡(luò)設(shè)備'
            verbose_name_plural = "網(wǎng)絡(luò)設(shè)備"
    def __str__(self):
            return self.hostname

class SecurityDevice(models.Model):
status_choices = ((0, '在線'),
(1, '已下線'),
(2, '未知'),
(3, '故障'),
(4, '備用'),
)
status = models.SmallIntegerField(choices=status_choices, default=0)

    id =models.AutoField(primary_key=True)
    machinaroom= models.ForeignKey(Machinaroom)
    type=models.CharField(u'類型', max_length=128)

    hostname = models.CharField(max_length=128, unique=True)
    port_num = models.SmallIntegerField(u'端口個數(shù)', null=True, blank=True)
    device_detail = models.TextField(u'設(shè)置詳細(xì)配置', null=True, blank=True)
    model = models.CharField(u'型號', max_length=128, null=True, blank=True)
    manage_ip = models.GenericIPAddressField('管理IP', null=True, blank=True)
    other_ip = models.GenericIPAddressField('其他IP', null=True, blank=True)
    
    class Meta:
            verbose_name = '安全設(shè)備'
            verbose_name_plural = "安全設(shè)備"
    def __str__(self):
            return self.hostname

class StorageDevice(models.Model):
"""存儲設(shè)備"""
model = models.CharField(u'型號', max_length=128, null=True, blank=True)
machinaroom= models.ForeignKey(Machinaroom)
id =models.AutoField(primary_key=True)
manage_ip = models.GenericIPAddressField('管理IP', null=True, blank=True)
status_choices = ((0, '在線'),
(1, '已下線'),
(2, '未知'),
(3, '故障'),
(4, '備用'),
)
status = models.SmallIntegerField(choices=status_choices, default=0)
disk_memo=models.CharField('容量信息',max_length=200, null=True, blank=True)
memo = models.TextField(u'備注', blank=True, null=True)
class Meta:
verbose_name = '存儲設(shè)備'
verbose_name_plural = "存儲設(shè)備"

    def __str__(self):
            return self.model

class Software(models.Model):
sub_assset_type_choices = (
(0, 'OS'),
(1, '辦公\開發(fā)軟件'),
(2, '業(yè)務(wù)軟件'),

    )
    sub_asset_type = models.SmallIntegerField(choices=sub_assset_type_choices, verbose_name="服務(wù)器類型", default=0)
    license_num = models.IntegerField(verbose_name="授權(quán)數(shù)")
    version = models.CharField(u'軟件/系統(tǒng)版本', max_length=64, help_text=u'eg. CentOS release 6.5 (Final)', unique=True)

    id =models.AutoField(primary_key=True)
    def __str__(self):
            return self.version

    class Meta:
            verbose_name = '軟件/系統(tǒng)'
            verbose_name_plural = "軟件/系統(tǒng)"

class Manufactory(models.Model):
"""廠商"""

    id =models.AutoField(primary_key=True)
    manufactory = models.CharField(u'廠商名稱', max_length=64, unique=True)
    support_num = models.CharField(u'支持電話', max_length=30, blank=True)
    memo = models.CharField(u'備注', max_length=128, blank=True)

    def __str__(self):
            return self.manufactory

    class Meta:
            verbose_name = '廠商'
            verbose_name_plural = "廠商"

同步數(shù)據(jù)庫

python manage.py makemigrations
python manage.py migrate

?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請聯(lián)系作者
【社區(qū)內(nèi)容提示】社區(qū)部分內(nèi)容疑似由AI輔助生成，瀏覽時請結(jié)合常識與多方信息審慎甄別。
平臺聲明：文章內(nèi)容（如有圖片或視頻亦包括在內(nèi)）由作者上傳并發(fā)布，文章內(nèi)容僅代表作者本人觀點(diǎn)，簡書系信息發(fā)布平臺，僅提供信息存儲服務(wù)。

相關(guān)閱讀更多精彩內(nèi)容

友情鏈接更多精彩內(nèi)容