Revision e7142db2

b/snf-cyclades-app/synnefo/db/migrations/0091_auto__del_unique_ipaddress_network_address__add_unique_ipaddress_delet.py
1
# -*- coding: utf-8 -*-
2
import datetime
3
from south.db import db
4
from south.v2 import SchemaMigration
5
from django.db import models
6

  
7

  
8
class Migration(SchemaMigration):
9

  
10
    def forwards(self, orm):
11
        # Removing unique constraint on 'IPAddress', fields ['network', 'address']
12
        db.delete_unique('db_ipaddress', ['network_id', 'address'])
13

  
14
        # Adding unique constraint on 'IPAddress', fields ['deleted', 'network', 'address']
15
        db.create_unique('db_ipaddress', ['deleted', 'network_id', 'address'])
16

  
17

  
18
    def backwards(self, orm):
19
        # Removing unique constraint on 'IPAddress', fields ['deleted', 'network', 'address']
20
        db.delete_unique('db_ipaddress', ['deleted', 'network_id', 'address'])
21

  
22
        # Adding unique constraint on 'IPAddress', fields ['network', 'address']
23
        db.create_unique('db_ipaddress', ['network_id', 'address'])
24

  
25

  
26
    models = {
27
        'db.backend': {
28
            'Meta': {'ordering': "['clustername']", 'object_name': 'Backend'},
29
            'clustername': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '128'}),
30
            'ctotal': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
31
            'dfree': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
32
            'disk_templates': ('synnefo.db.fields.SeparatedValuesField', [], {'null': 'True'}),
33
            'drained': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
34
            'dtotal': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
35
            'hash': ('django.db.models.fields.CharField', [], {'max_length': '40'}),
36
            'hypervisor': ('django.db.models.fields.CharField', [], {'default': "'kvm'", 'max_length': '32'}),
37
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
38
            'index': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0', 'unique': 'True'}),
39
            'mfree': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
40
            'mtotal': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
41
            'offline': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
42
            'password_hash': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True', 'blank': 'True'}),
43
            'pinst_cnt': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
44
            'port': ('django.db.models.fields.PositiveIntegerField', [], {'default': '5080'}),
45
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
46
            'username': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True', 'blank': 'True'})
47
        },
48
        'db.backendnetwork': {
49
            'Meta': {'unique_together': "(('network', 'backend'),)", 'object_name': 'BackendNetwork'},
50
            'backend': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'networks'", 'on_delete': 'models.PROTECT', 'to': "orm['db.Backend']"}),
51
            'backendjobid': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True'}),
52
            'backendjobstatus': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
53
            'backendlogmsg': ('django.db.models.fields.TextField', [], {'null': 'True'}),
54
            'backendopcode': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
55
            'backendtime': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(1, 1, 1, 0, 0)'}),
56
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
57
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
58
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
59
            'mac_prefix': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
60
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'backend_networks'", 'on_delete': 'models.PROTECT', 'to': "orm['db.Network']"}),
61
            'operstate': ('django.db.models.fields.CharField', [], {'default': "'PENDING'", 'max_length': '30'}),
62
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
63
        },
64
        'db.bridgepooltable': {
65
            'Meta': {'object_name': 'BridgePoolTable'},
66
            'available_map': ('django.db.models.fields.TextField', [], {'default': "''"}),
67
            'base': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
68
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
69
            'offset': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
70
            'reserved_map': ('django.db.models.fields.TextField', [], {'default': "''"}),
71
            'size': ('django.db.models.fields.IntegerField', [], {})
72
        },
73
        'db.flavor': {
74
            'Meta': {'unique_together': "(('cpu', 'ram', 'disk', 'disk_template'),)", 'object_name': 'Flavor'},
75
            'cpu': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
76
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
77
            'disk': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
78
            'disk_template': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
79
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
80
            'ram': ('django.db.models.fields.IntegerField', [], {'default': '0'})
81
        },
82
        'db.ipaddress': {
83
            'Meta': {'unique_together': "(('network', 'address', 'deleted'),)", 'object_name': 'IPAddress'},
84
            'address': ('django.db.models.fields.CharField', [], {'max_length': '64'}),
85
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
86
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
87
            'floating_ip': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
88
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
89
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'ips'", 'on_delete': 'models.PROTECT', 'to': "orm['db.Network']"}),
90
            'nic': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'ips'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['db.NetworkInterface']"}),
91
            'serial': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'ips'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['db.QuotaHolderSerial']"}),
92
            'subnet': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'ips'", 'on_delete': 'models.PROTECT', 'to': "orm['db.Subnet']"}),
93
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
94
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '128', 'db_index': 'True'})
95
        },
96
        'db.ipaddresslog': {
97
            'Meta': {'object_name': 'IPAddressLog'},
98
            'active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
99
            'address': ('django.db.models.fields.CharField', [], {'max_length': '64', 'db_index': 'True'}),
100
            'allocated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
101
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
102
            'network_id': ('django.db.models.fields.IntegerField', [], {}),
103
            'released_at': ('django.db.models.fields.DateTimeField', [], {'null': 'True'}),
104
            'server_id': ('django.db.models.fields.IntegerField', [], {})
105
        },
106
        'db.ippooltable': {
107
            'Meta': {'object_name': 'IPPoolTable'},
108
            'available_map': ('django.db.models.fields.TextField', [], {'default': "''"}),
109
            'base': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
110
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
111
            'offset': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
112
            'reserved_map': ('django.db.models.fields.TextField', [], {'default': "''"}),
113
            'size': ('django.db.models.fields.IntegerField', [], {}),
114
            'subnet': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'ip_pools'", 'null': 'True', 'on_delete': 'models.PROTECT', 'to': "orm['db.Subnet']"})
115
        },
116
        'db.macprefixpooltable': {
117
            'Meta': {'object_name': 'MacPrefixPoolTable'},
118
            'available_map': ('django.db.models.fields.TextField', [], {'default': "''"}),
119
            'base': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
120
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
121
            'offset': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
122
            'reserved_map': ('django.db.models.fields.TextField', [], {'default': "''"}),
123
            'size': ('django.db.models.fields.IntegerField', [], {})
124
        },
125
        'db.network': {
126
            'Meta': {'object_name': 'Network'},
127
            'action': ('django.db.models.fields.CharField', [], {'default': 'None', 'max_length': '32', 'null': 'True'}),
128
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
129
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'db_index': 'True'}),
130
            'drained': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
131
            'external_router': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
132
            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
133
            'floating_ip_pool': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
134
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
135
            'link': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
136
            'mac_prefix': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
137
            'machines': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['db.VirtualMachine']", 'through': "orm['db.NetworkInterface']", 'symmetrical': 'False'}),
138
            'mode': ('django.db.models.fields.CharField', [], {'max_length': '16', 'null': 'True'}),
139
            'name': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
140
            'public': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'db_index': 'True'}),
141
            'serial': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'network'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['db.QuotaHolderSerial']"}),
142
            'state': ('django.db.models.fields.CharField', [], {'default': "'PENDING'", 'max_length': '32'}),
143
            'tags': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True'}),
144
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
145
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True', 'db_index': 'True'})
146
        },
147
        'db.networkinterface': {
148
            'Meta': {'object_name': 'NetworkInterface'},
149
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
150
            'device_owner': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True'}),
151
            'firewall_profile': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
152
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
153
            'index': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
154
            'mac': ('django.db.models.fields.CharField', [], {'max_length': '32', 'unique': 'True', 'null': 'True'}),
155
            'machine': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'null': 'True', 'on_delete': 'models.PROTECT', 'to': "orm['db.VirtualMachine']"}),
156
            'name': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '128', 'null': 'True'}),
157
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'on_delete': 'models.PROTECT', 'to': "orm['db.Network']"}),
158
            'security_groups': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['db.SecurityGroup']", 'null': 'True', 'symmetrical': 'False'}),
159
            'state': ('django.db.models.fields.CharField', [], {'default': "'ACTIVE'", 'max_length': '32'}),
160
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
161
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '128', 'db_index': 'True'})
162
        },
163
        'db.quotaholderserial': {
164
            'Meta': {'ordering': "['serial']", 'object_name': 'QuotaHolderSerial'},
165
            'accept': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
166
            'pending': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'db_index': 'True'}),
167
            'resolved': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
168
            'serial': ('django.db.models.fields.BigIntegerField', [], {'primary_key': 'True', 'db_index': 'True'})
169
        },
170
        'db.securitygroup': {
171
            'Meta': {'object_name': 'SecurityGroup'},
172
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
173
            'name': ('django.db.models.fields.CharField', [], {'max_length': '128'})
174
        },
175
        'db.subnet': {
176
            'Meta': {'object_name': 'Subnet'},
177
            'cidr': ('django.db.models.fields.CharField', [], {'max_length': '64'}),
178
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'db_index': 'True'}),
179
            'dhcp': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
180
            'dns_nameservers': ('synnefo.db.fields.SeparatedValuesField', [], {'null': 'True'}),
181
            'gateway': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True'}),
182
            'host_routes': ('synnefo.db.fields.SeparatedValuesField', [], {'null': 'True'}),
183
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
184
            'ipversion': ('django.db.models.fields.IntegerField', [], {'default': '4'}),
185
            'name': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '128', 'null': 'True'}),
186
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'subnets'", 'on_delete': 'models.PROTECT', 'to': "orm['db.Network']"})
187
        },
188
        'db.virtualmachine': {
189
            'Meta': {'object_name': 'VirtualMachine'},
190
            'action': ('django.db.models.fields.CharField', [], {'default': 'None', 'max_length': '30', 'null': 'True'}),
191
            'backend': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'virtual_machines'", 'null': 'True', 'on_delete': 'models.PROTECT', 'to': "orm['db.Backend']"}),
192
            'backend_hash': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True'}),
193
            'backendjobid': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True'}),
194
            'backendjobstatus': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
195
            'backendlogmsg': ('django.db.models.fields.TextField', [], {'null': 'True'}),
196
            'backendopcode': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
197
            'backendtime': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(1, 1, 1, 0, 0)'}),
198
            'buildpercentage': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
199
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
200
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'db_index': 'True'}),
201
            'flavor': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Flavor']", 'on_delete': 'models.PROTECT'}),
202
            'hostid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
203
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
204
            'imageid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
205
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
206
            'operstate': ('django.db.models.fields.CharField', [], {'default': "'BUILD'", 'max_length': '30'}),
207
            'serial': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'virtual_machine'", 'null': 'True', 'on_delete': 'models.SET_NULL', 'to': "orm['db.QuotaHolderSerial']"}),
208
            'suspended': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
209
            'task': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True'}),
210
            'task_job_id': ('django.db.models.fields.BigIntegerField', [], {'null': 'True'}),
211
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
212
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '100', 'db_index': 'True'})
213
        },
214
        'db.virtualmachinediagnostic': {
215
            'Meta': {'ordering': "['-created']", 'object_name': 'VirtualMachineDiagnostic'},
216
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
217
            'details': ('django.db.models.fields.TextField', [], {'null': 'True'}),
218
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
219
            'level': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
220
            'machine': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'diagnostics'", 'to': "orm['db.VirtualMachine']"}),
221
            'message': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
222
            'source': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
223
            'source_date': ('django.db.models.fields.DateTimeField', [], {'null': 'True'})
224
        },
225
        'db.virtualmachinemetadata': {
226
            'Meta': {'unique_together': "(('meta_key', 'vm'),)", 'object_name': 'VirtualMachineMetadata'},
227
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
228
            'meta_key': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
229
            'meta_value': ('django.db.models.fields.CharField', [], {'max_length': '500'}),
230
            'vm': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'metadata'", 'to': "orm['db.VirtualMachine']"})
231
        }
232
    }
233

  
234
    complete_apps = ['db']
b/snf-cyclades-app/synnefo/db/models.py
738 738
            return (not self.nic.machine.deleted)
739 739

  
740 740
    class Meta:
741
        unique_together = ("network", "address")
741
        unique_together = ("network", "address", "deleted")
742 742

  
743 743
    @property
744 744
    def ipversion(self):

Also available in: Unified diff