Statistics
| Branch: | Tag: | Revision:

root / snf-cyclades-app / synnefo / db / migrations / 0043_encrypt_passwords.py @ 6f011a2d

History | View | Annotate | Download (11.2 kB)

1 30e0ed74 Christos Stavrakakis
# encoding: utf-8
2 30e0ed74 Christos Stavrakakis
import datetime
3 30e0ed74 Christos Stavrakakis
from south.db import db
4 30e0ed74 Christos Stavrakakis
from south.v2 import DataMigration
5 30e0ed74 Christos Stavrakakis
from django.db import models
6 d0411c0a Christos Stavrakakis
7 d0411c0a Christos Stavrakakis
try:
8 d0411c0a Christos Stavrakakis
    from synnefo.db.aes_encrypt import encrypt_db_charfield as encrypt
9 d0411c0a Christos Stavrakakis
    from synnefo.db.aes_encrypt import decrypt_db_charfield as decrypt
10 d0411c0a Christos Stavrakakis
except ImportError:
11 d0411c0a Christos Stavrakakis
    encrypt = None
12 d0411c0a Christos Stavrakakis
    decrypt = None
13 30e0ed74 Christos Stavrakakis
14 30e0ed74 Christos Stavrakakis
class Migration(DataMigration):
15 30e0ed74 Christos Stavrakakis
    
16 30e0ed74 Christos Stavrakakis
    def forwards(self, orm):
17 30e0ed74 Christos Stavrakakis
        "Write your forwards methods here."
18 d0411c0a Christos Stavrakakis
        if encrypt and decrypt:
19 d0411c0a Christos Stavrakakis
            for backend in orm.Backend.objects.all():
20 d0411c0a Christos Stavrakakis
                # Dummy update password in order to be encrypted
21 d0411c0a Christos Stavrakakis
                password = decrypt(backend.password_hash)
22 d0411c0a Christos Stavrakakis
                backend.password_hash = encrypt(password)
23 d0411c0a Christos Stavrakakis
                backend.save()
24 d0411c0a Christos Stavrakakis
        else:
25 d0411c0a Christos Stavrakakis
            pass
26 30e0ed74 Christos Stavrakakis
    
27 30e0ed74 Christos Stavrakakis
    
28 30e0ed74 Christos Stavrakakis
    def backwards(self, orm):
29 30e0ed74 Christos Stavrakakis
        "Write your backwards methods here."
30 30e0ed74 Christos Stavrakakis
        pass
31 30e0ed74 Christos Stavrakakis
    
32 30e0ed74 Christos Stavrakakis
    models = {
33 30e0ed74 Christos Stavrakakis
        'db.backend': {
34 30e0ed74 Christos Stavrakakis
            'Meta': {'object_name': 'Backend'},
35 30e0ed74 Christos Stavrakakis
            'clustername': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '128'}),
36 30e0ed74 Christos Stavrakakis
            'ctotal': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
37 30e0ed74 Christos Stavrakakis
            'dfree': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
38 30e0ed74 Christos Stavrakakis
            'drained': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
39 30e0ed74 Christos Stavrakakis
            'dtotal': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
40 30e0ed74 Christos Stavrakakis
            'hash': ('django.db.models.fields.CharField', [], {'max_length': '40'}),
41 30e0ed74 Christos Stavrakakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
42 30e0ed74 Christos Stavrakakis
            'mfree': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
43 30e0ed74 Christos Stavrakakis
            'mtotal': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
44 30e0ed74 Christos Stavrakakis
            'offline': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
45 30e0ed74 Christos Stavrakakis
            'password_hash': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True', 'blank': 'True'}),
46 30e0ed74 Christos Stavrakakis
            'pinst_cnt': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
47 30e0ed74 Christos Stavrakakis
            'port': ('django.db.models.fields.PositiveIntegerField', [], {'default': '5080'}),
48 30e0ed74 Christos Stavrakakis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
49 30e0ed74 Christos Stavrakakis
            'username': ('django.db.models.fields.CharField', [], {'max_length': '64', 'null': 'True', 'blank': 'True'})
50 30e0ed74 Christos Stavrakakis
        },
51 30e0ed74 Christos Stavrakakis
        'db.backendnetwork': {
52 30e0ed74 Christos Stavrakakis
            'Meta': {'object_name': 'BackendNetwork'},
53 30e0ed74 Christos Stavrakakis
            'backend': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'networks'", 'to': "orm['db.Backend']"}),
54 30e0ed74 Christos Stavrakakis
            'backendjobid': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True'}),
55 30e0ed74 Christos Stavrakakis
            'backendjobstatus': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
56 30e0ed74 Christos Stavrakakis
            'backendlogmsg': ('django.db.models.fields.TextField', [], {'null': 'True'}),
57 30e0ed74 Christos Stavrakakis
            'backendopcode': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
58 30e0ed74 Christos Stavrakakis
            'backendtime': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(1, 1, 1, 0, 0)'}),
59 30e0ed74 Christos Stavrakakis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
60 30e0ed74 Christos Stavrakakis
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
61 30e0ed74 Christos Stavrakakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
62 30e0ed74 Christos Stavrakakis
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'backend_networks'", 'to': "orm['db.Network']"}),
63 30e0ed74 Christos Stavrakakis
            'operstate': ('django.db.models.fields.CharField', [], {'default': "'PENDING'", 'max_length': '30'}),
64 30e0ed74 Christos Stavrakakis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
65 30e0ed74 Christos Stavrakakis
        },
66 30e0ed74 Christos Stavrakakis
        'db.bridgepool': {
67 30e0ed74 Christos Stavrakakis
            'Meta': {'object_name': 'BridgePool'},
68 30e0ed74 Christos Stavrakakis
            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}),
69 30e0ed74 Christos Stavrakakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
70 30e0ed74 Christos Stavrakakis
            'index': ('django.db.models.fields.IntegerField', [], {'unique': 'True'}),
71 30e0ed74 Christos Stavrakakis
            'value': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '128'})
72 30e0ed74 Christos Stavrakakis
        },
73 30e0ed74 Christos Stavrakakis
        'db.flavor': {
74 30e0ed74 Christos Stavrakakis
            'Meta': {'unique_together': "(('cpu', 'ram', 'disk', 'disk_template'),)", 'object_name': 'Flavor'},
75 30e0ed74 Christos Stavrakakis
            'cpu': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
76 30e0ed74 Christos Stavrakakis
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
77 30e0ed74 Christos Stavrakakis
            'disk': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
78 30e0ed74 Christos Stavrakakis
            'disk_template': ('django.db.models.fields.CharField', [], {'default': "'drbd'", 'max_length': '32'}),
79 30e0ed74 Christos Stavrakakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
80 30e0ed74 Christos Stavrakakis
            'ram': ('django.db.models.fields.IntegerField', [], {'default': '0'})
81 30e0ed74 Christos Stavrakakis
        },
82 30e0ed74 Christos Stavrakakis
        'db.macprefixpool': {
83 30e0ed74 Christos Stavrakakis
            'Meta': {'object_name': 'MacPrefixPool'},
84 30e0ed74 Christos Stavrakakis
            'available': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}),
85 30e0ed74 Christos Stavrakakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
86 30e0ed74 Christos Stavrakakis
            'index': ('django.db.models.fields.IntegerField', [], {'unique': 'True'}),
87 30e0ed74 Christos Stavrakakis
            'value': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '128'})
88 30e0ed74 Christos Stavrakakis
        },
89 30e0ed74 Christos Stavrakakis
        'db.network': {
90 30e0ed74 Christos Stavrakakis
            'Meta': {'object_name': 'Network'},
91 30e0ed74 Christos Stavrakakis
            'action': ('django.db.models.fields.CharField', [], {'default': 'None', 'max_length': '32', 'null': 'True'}),
92 30e0ed74 Christos Stavrakakis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
93 30e0ed74 Christos Stavrakakis
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
94 30e0ed74 Christos Stavrakakis
            'dhcp': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'blank': 'True'}),
95 30e0ed74 Christos Stavrakakis
            'gateway': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
96 30e0ed74 Christos Stavrakakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
97 30e0ed74 Christos Stavrakakis
            'link': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True'}),
98 30e0ed74 Christos Stavrakakis
            'mac_prefix': ('django.db.models.fields.CharField', [], {'max_length': '32', 'null': 'True'}),
99 30e0ed74 Christos Stavrakakis
            'machines': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['db.VirtualMachine']", 'through': "orm['db.NetworkInterface']", 'symmetrical': 'False'}),
100 30e0ed74 Christos Stavrakakis
            'name': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
101 30e0ed74 Christos Stavrakakis
            'public': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
102 30e0ed74 Christos Stavrakakis
            'state': ('django.db.models.fields.CharField', [], {'default': "'PENDING'", 'max_length': '32'}),
103 30e0ed74 Christos Stavrakakis
            'subnet': ('django.db.models.fields.CharField', [], {'default': "'10.0.0.0/24'", 'max_length': '32'}),
104 30e0ed74 Christos Stavrakakis
            'type': ('django.db.models.fields.CharField', [], {'default': "'PRIVATE_VLAN'", 'max_length': '50'}),
105 30e0ed74 Christos Stavrakakis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
106 30e0ed74 Christos Stavrakakis
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True'})
107 30e0ed74 Christos Stavrakakis
        },
108 30e0ed74 Christos Stavrakakis
        'db.networkinterface': {
109 30e0ed74 Christos Stavrakakis
            'Meta': {'object_name': 'NetworkInterface'},
110 30e0ed74 Christos Stavrakakis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
111 30e0ed74 Christos Stavrakakis
            'dirty': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
112 30e0ed74 Christos Stavrakakis
            'firewall_profile': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
113 30e0ed74 Christos Stavrakakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
114 30e0ed74 Christos Stavrakakis
            'index': ('django.db.models.fields.IntegerField', [], {}),
115 30e0ed74 Christos Stavrakakis
            'ipv4': ('django.db.models.fields.CharField', [], {'max_length': '15', 'null': 'True'}),
116 30e0ed74 Christos Stavrakakis
            'ipv6': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True'}),
117 30e0ed74 Christos Stavrakakis
            'mac': ('django.db.models.fields.CharField', [], {'max_length': '17', 'null': 'True'}),
118 30e0ed74 Christos Stavrakakis
            'machine': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'to': "orm['db.VirtualMachine']"}),
119 30e0ed74 Christos Stavrakakis
            'network': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'nics'", 'to': "orm['db.Network']"}),
120 30e0ed74 Christos Stavrakakis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
121 30e0ed74 Christos Stavrakakis
        },
122 30e0ed74 Christos Stavrakakis
        'db.virtualmachine': {
123 30e0ed74 Christos Stavrakakis
            'Meta': {'object_name': 'VirtualMachine'},
124 30e0ed74 Christos Stavrakakis
            'action': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
125 30e0ed74 Christos Stavrakakis
            'backend': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'virtual_machines'", 'null': 'True', 'to': "orm['db.Backend']"}),
126 30e0ed74 Christos Stavrakakis
            'backend_hash': ('django.db.models.fields.CharField', [], {'max_length': '128', 'null': 'True'}),
127 30e0ed74 Christos Stavrakakis
            'backendjobid': ('django.db.models.fields.PositiveIntegerField', [], {'null': 'True'}),
128 30e0ed74 Christos Stavrakakis
            'backendjobstatus': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
129 30e0ed74 Christos Stavrakakis
            'backendlogmsg': ('django.db.models.fields.TextField', [], {'null': 'True'}),
130 30e0ed74 Christos Stavrakakis
            'backendopcode': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
131 30e0ed74 Christos Stavrakakis
            'backendtime': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime(1, 1, 1, 0, 0)'}),
132 30e0ed74 Christos Stavrakakis
            'buildpercentage': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
133 30e0ed74 Christos Stavrakakis
            'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
134 30e0ed74 Christos Stavrakakis
            'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
135 30e0ed74 Christos Stavrakakis
            'flavor': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['db.Flavor']"}),
136 30e0ed74 Christos Stavrakakis
            'hostid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
137 30e0ed74 Christos Stavrakakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
138 30e0ed74 Christos Stavrakakis
            'imageid': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
139 30e0ed74 Christos Stavrakakis
            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
140 30e0ed74 Christos Stavrakakis
            'operstate': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True'}),
141 30e0ed74 Christos Stavrakakis
            'suspended': ('django.db.models.fields.BooleanField', [], {'default': 'False', 'blank': 'True'}),
142 30e0ed74 Christos Stavrakakis
            'updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
143 30e0ed74 Christos Stavrakakis
            'userid': ('django.db.models.fields.CharField', [], {'max_length': '100'})
144 30e0ed74 Christos Stavrakakis
        },
145 30e0ed74 Christos Stavrakakis
        'db.virtualmachinemetadata': {
146 30e0ed74 Christos Stavrakakis
            'Meta': {'unique_together': "(('meta_key', 'vm'),)", 'object_name': 'VirtualMachineMetadata'},
147 30e0ed74 Christos Stavrakakis
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
148 30e0ed74 Christos Stavrakakis
            'meta_key': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
149 30e0ed74 Christos Stavrakakis
            'meta_value': ('django.db.models.fields.CharField', [], {'max_length': '500'}),
150 30e0ed74 Christos Stavrakakis
            'vm': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'metadata'", 'to': "orm['db.VirtualMachine']"})
151 30e0ed74 Christos Stavrakakis
        }
152 30e0ed74 Christos Stavrakakis
    }
153 30e0ed74 Christos Stavrakakis
    
154 30e0ed74 Christos Stavrakakis
    complete_apps = ['db']