# -*- coding: utf-8 -*-

from __future__ import unicode_literals

from django.db import models

class UserType(models.Model):

    caption = models.CharField(max_length=32)

class User(models.Model):

    name = models.CharField(max_length=32)

    age = models.IntegerField()

    user_type = models.ForeignKey('UserType', to_field='id')

class Host(models.Model):

    envid = models.CharField(max_length=32, db_index=True)

    ip = models.GenericIPAddressField(protocol='both', max_length=32, db_index=True)

    port = models.CharField(max_length=32)

    username = models.CharField(max_length=32)

    password = models.CharField(max_length=32)

    item = models.ForeignKey(to='TestItem', to_field='id')

class TestItem(models.Model):

    item = models.CharField(max_length=32)

    versionNum = models.CharField(max_length=32)

class Application(models.Model):

    name = models.CharField(max_length=32)

    r = models.ManyToManyField('Host')

# 方式一：自定义关系表

class Host(models.Model):

    nid = models.AutoField(primary_key=True)

    hostname = models.CharField(max_length=32, db_index=True)

    ip = models.GenericIPAddressField(protocol="ipv4", db_index=True)

    port = models.IntegerField()

    b = models.ForeignKey(to="Business", to_field='id')

# 10

class Application(models.Model):

    name = models.CharField(max_length=32)

# 2

class HostToApp(models.Model):

    hobj = models.ForeignKey(to='Host', to_field='nid')

    aobj = models.ForeignKey(to='Application', to_field='id')

# HostToApp.objects.create(hobj_id=1,aobj_id=2)

# 方式二：自动创建关系表

class Host(models.Model):

    nid = models.AutoField(primary_key=True)

    hostname = models.CharField(max_length=32, db_index=True)

    ip = models.GenericIPAddressField(protocol="ipv4", db_index=True)

    port = models.IntegerField()

    b = models.ForeignKey(to="Business", to_field='id')

# 10

class Application(models.Model):

    name = models.CharField(max_length=32)

    r = models.ManyToManyField("Host")

# 无法直接对第三张表进行操作

obj = Application.objects.get(id=1)

obj.name

# 第三张表操作

obj.r.add(1)

obj.r.add(2)

obj.r.add(2, 3, 4)

obj.r.add(*[1, 2, 3, 4])

obj.r.remove(1)

obj.r.remove(2, 4)

obj.r.remove(*[1, 2, 3])

obj.r.clear()

obj.r.set([3, 5, 7])

# 所有相关的主机对象“列表” QuerySet

obj.r.all()