Revision d0411c0a

b/snf-cyclades-app/synnefo/db/migrations/0037_network_migration.py
3 3
from south.db import db
4 4
from south.v2 import DataMigration
5 5
from django.db import models
6
from synnefo.db.models import BridgePool
6
from synnefo import settings
7

  
8
def get_available_bridge(orm):
9
    try:
10
        entry = orm.BridgePool.objects.filter(available=True)[0]
11
        entry.available = False
12
        entry.save()
13
        return entry
14
    except IndexError:
15
        try:
16
            last = orm.BridgePool.objects.order_by('-index')[0]
17
            index = last.index + 1
18
        except IndexError:
19
            index = 1
20

  
21
        if index <= settings.PRIVATE_PHYSICAL_VLAN_MAX_NUMBER:
22
            create_bridge = orm.BridgePool.objects.create
23
            return create_bridge(index=index,
24
                                 value=value_from_index(index),
25
                                 available=False)
26
        raise Exception('Pool of bridges exhausted. Can not'
27
                        ' allocate bridge')
28

  
29
def value_from_index(index):
30
    return settings.PRIVATE_PHYSICAL_VLAN_BRIDGE_PREFIX + str(index)
7 31

  
8 32
class Migration(DataMigration):
9 33
    
......
26 50
            else:
27 51
                network.dhcp = False
28 52
                network.type = 'PRIVATE_PHYSICAL_VLAN'
29
                bridge = BridgePool.get_available()
53
                entry = get_available_bridge(orm)
54
                bridge = entry
30 55
                network.netlink = bridge.value
31 56

  
32 57
            network.save()
b/snf-cyclades-app/synnefo/db/migrations/0043_encrypt_passwords.py
3 3
from south.db import db
4 4
from south.v2 import DataMigration
5 5
from django.db import models
6
from synnefo.db.models import Backend
6

  
7
try:
8
    from synnefo.db.aes_encrypt import encrypt_db_charfield as encrypt
9
    from synnefo.db.aes_encrypt import decrypt_db_charfield as decrypt
10
except ImportError:
11
    encrypt = None
12
    decrypt = None
7 13

  
8 14
class Migration(DataMigration):
9 15
    
10 16
    def forwards(self, orm):
11 17
        "Write your forwards methods here."
12
        for backend in Backend.objects.all():
13
            # Dummy update password in order to be encrypted
14
            password = backend.password
15
            backend.password = password
16
            backend.save()
18
        if encrypt and decrypt:
19
            for backend in orm.Backend.objects.all():
20
                # Dummy update password in order to be encrypted
21
                password = decrypt(backend.password_hash)
22
                backend.password_hash = encrypt(password)
23
                backend.save()
24
        else:
25
            pass
17 26
    
18 27
    
19 28
    def backwards(self, orm):
b/snf-cyclades-app/synnefo/db/migrations/0047_auto__chg_field_networkinterface_mac__add_unique_networkinterface_mac_.py
18 18
        db.add_column('db_backend', 'index', self.gf('django.db.models.fields.PositiveIntegerField')(default=0, unique=True), keep_default=False)
19 19

  
20 20
        # Changing field 'Network.mac_prefix'
21
        db.alter_column('db_network', 'mac_prefix', self.gf('django.db.models.fields.CharField')(max_length=32))
21
        db.alter_column('db_network', 'mac_prefix',self.gf('django.db.models.fields.CharField')(default='', max_length=32, null=True))
22 22

  
23 23
        # Adding field 'BackendNetwork.mac_prefix'
24 24
        db.add_column('db_backendnetwork', 'mac_prefix', self.gf('django.db.models.fields.CharField')(default='', max_length=32), keep_default=False)
......
111 111
            'gateway6': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True'}),
112 112
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
113 113
            'link': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True'}),
114
            'mac_prefix': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '32'}),
114
            'mac_prefix': ('django.db.models.fields.CharField', [], {'default':
115
                "''", 'max_length': '32', 'null':'True'}),
115 116
            'machines': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['db.VirtualMachine']", 'through': "orm['db.NetworkInterface']", 'symmetrical': 'False'}),
116 117
            'name': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
117 118
            'public': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
b/snf-cyclades-app/synnefo/db/migrations/0048_network_mac_prefix.py
3 3
from south.db import db
4 4
from south.v2 import DataMigration
5 5
from django.db import models
6
from synnefo.db.models import MacPrefixPool
6
from synnefo import settings
7

  
8
def get_available_mac_prefix(orm):
9
    try:
10
        entry = orm.MacPrefixPool.objects.filter(available=True)[0]
11
        entry.available = False
12
        entry.save()
13
        return entry
14
    except IndexError:
15
        try:
16
            last = orm.MacPrefixPool.objects.order_by('-index')[0]
17
            index = last.index + 1
18
        except IndexError:
19
            index = 1
20

  
21
        if index <= settings.MAC_POOL_LIMIT:
22
            create_mac_prefix = orm.MacPrefixPool.objects.create
23
            return create_mac_prefix(index=index,
24
                                 value=value_from_index(index),
25
                                 available=False)
26
        raise Exception('Pool of mac_prefixes exhausted. Can not'
27
                        ' allocate mac_prefix.')
28

  
29
def value_from_index(index):
30
    """Convert number to mac prefix
31

  
32
    """
33
    base = settings.MAC_POOL_BASE
34
    a = hex(int(base.replace(":", ""), 16) + index).replace("0x", '')
35
    mac_prefix = ":".join([a[x:x + 2] for x in xrange(0, len(a), 2)])
36
    return mac_prefix
7 37

  
8 38
class Migration(DataMigration):
9 39
    
......
15 45

  
16 46
        for network in orm.Network.objects.order_by('id'):
17 47
            if network.deleted:
18
                network.mac_prefix = 'aa:00:0'
48
                network.mac_prefix = settings.MAC_POOL_BASE
19 49
            else:
20
                mac_prefix = MacPrefixPool.get_available().value
21
                network.mac_prefix = mac_prefix
50
                mac_prefix = get_available_mac_prefix(orm)
51
                network.mac_prefix = mac_prefix.value
22 52
            network.save()
23 53

  
24 54
        for backend_network in orm.BackendNetwork.objects.order_by('id'):
b/snf-cyclades-app/synnefo/db/migrations/0049_not_null_mac_prefix.py
1
# encoding: 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
class Migration(SchemaMigration):
8
    
9
    def forwards(self, orm):
10
        # Changing field 'Network.mac_prefix'
11
        db.alter_column('db_network', 'mac_prefix', self.gf('django.db.models.fields.CharField')(max_length=32, null=False))
12
    
13
    
14
    def backwards(self, orm):
15
        # Changing field 'Network.mac_prefix'
16
        db.alter_column('db_network', 'mac_prefix', self.gf('django.db.models.fields.CharField')(default='', max_length=32, null=True))
17
    
18
    
19
    models = {
20
        'db.backend': {
21
            'Meta': {'object_name': 'Backend'},
22
            'clustername': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '128'}),
23
            'ctotal': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
24
            'dfree': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
25
            'drained': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
26
            'dtotal': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
27
            'hash': ('django.db.models.fields.CharField', [], {'max_length': '40'}),
28
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
29
            'index': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0', 'unique': 'True'}),
30
            'mfree': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
31
            'mtotal': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
32
            'offline': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
33
            'password_hash': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True', 'blank': 'True'}),
34
            'pinst_cnt': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
35
            'port': ('django.db.models.fields.PositiveIntegerField', [], {'default': '5080'}),
36
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
37
            'username': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True', 'blank': 'True'})
38
        },
39
        'db.backendnetwork': {
40
            'Meta': {'object_name': 'BackendNetwork'},
41
            'backend': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'networks'", 'to': "orm['db.Backend']"}),
42
            'backendjobid': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True'}),
43
            'backendjobstatus': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
44
            'backendlogmsg': ('django.db.models.fields.TextField', [], {'null': 'True'}),
45
            'backendopcode': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
46
            'backendtime': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(1, 1, 1, 0, 0)'}),
47
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
48
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
49
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
50
            'mac_prefix': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
51
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'backend_networks'", 'to': "orm['db.Network']"}),
52
            'operstate': ('django.db.models.fields.CharField', [], {'default': "'PENDING'", 'max_length': '30'}),
53
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
54
        },
55
        'db.bridgepool': {
56
            'Meta': {'object_name': 'BridgePool'},
57
            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}),
58
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
59
            'index': ('django.db.models.fields.IntegerField', [], {'unique': 'True'}),
60
            'value': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '128'})
61
        },
62
        'db.flavor': {
63
            'Meta': {'unique_together': "(('cpu', 'ram', 'disk', 'disk_template'),)", 'object_name': 'Flavor'},
64
            'cpu': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
65
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
66
            'disk': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
67
            'disk_template': ('django.db.models.fields.CharField', [], {'default': "'drbd'", 'max_length': '32'}),
68
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
69
            'ram': ('django.db.models.fields.IntegerField', [], {'default': '0'})
70
        },
71
        'db.macprefixpool': {
72
            'Meta': {'object_name': 'MacPrefixPool'},
73
            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}),
74
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
75
            'index': ('django.db.models.fields.IntegerField', [], {'unique': 'True'}),
76
            'value': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '128'})
77
        },
78
        'db.network': {
79
            'Meta': {'object_name': 'Network'},
80
            'action': ('django.db.models.fields.CharField', [], {'default': 'None', 'max_length': '32', 'null': 'True'}),
81
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
82
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
83
            'dhcp': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}),
84
            'gateway': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
85
            'gateway6': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True'}),
86
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
87
            'link': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True'}),
88
            'mac_prefix': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
89
            'machines': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['db.VirtualMachine']", 'through': "orm['db.NetworkInterface']", 'symmetrical': 'False'}),
90
            'name': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
91
            'public': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
92
            'reservations': ('django.db.models.fields.TextField', [], {'default': "''"}),
93
            'state': ('django.db.models.fields.CharField', [], {'default': "'PENDING'", 'max_length': '32'}),
94
            'subnet': ('django.db.models.fields.CharField', [], {'default': "'10.0.0.0/24'", 'max_length': '32'}),
95
            'subnet6': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True'}),
96
            'type': ('django.db.models.fields.CharField', [], {'default': "'PRIVATE_PHYSICAL_VLAN'", 'max_length': '50'}),
97
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
98
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True'})
99
        },
100
        'db.networkinterface': {
101
            'Meta': {'object_name': 'NetworkInterface'},
102
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
103
            'dirty': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
104
            'firewall_profile': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
105
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
106
            'index': ('django.db.models.fields.IntegerField', [], {}),
107
            'ipv4': ('django.db.models.fields.CharField', [], {'max_length': '15', 'null': 'True'}),
108
            'ipv6': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
109
            'mac': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '32'}),
110
            'machine': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'to': "orm['db.VirtualMachine']"}),
111
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'to': "orm['db.Network']"}),
112
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
113
        },
114
        'db.virtualmachine': {
115
            'Meta': {'object_name': 'VirtualMachine'},
116
            'action': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
117
            'backend': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'virtual_machines'", 'null': 'True', 'to': "orm['db.Backend']"}),
118
            'backend_hash': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True'}),
119
            'backendjobid': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True'}),
120
            'backendjobstatus': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
121
            'backendlogmsg': ('django.db.models.fields.TextField', [], {'null': 'True'}),
122
            'backendopcode': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
123
            'backendtime': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(1, 1, 1, 0, 0)'}),
124
            'buildpercentage': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
125
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
126
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
127
            'flavor': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Flavor']"}),
128
            'hostid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
129
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
130
            'imageid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
131
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
132
            'operstate': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
133
            'suspended': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
134
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
135
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '100'})
136
        },
137
        'db.virtualmachinemetadata': {
138
            'Meta': {'unique_together': "(('meta_key', 'vm'),)", 'object_name': 'VirtualMachineMetadata'},
139
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
140
            'meta_key': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
141
            'meta_value': ('django.db.models.fields.CharField', [], {'max_length': '500'}),
142
            'vm': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'metadata'", 'to': "orm['db.VirtualMachine']"})
143
        }
144
    }
145
    
146
    complete_apps = ['db']

Also available in: Unified diff