Merge lp:~rvb/maas/maas-new-event-index into lp:~maas-committers/maas/trunk

Proposed by Raphaël Badin
Status: Merged
Approved by: Raphaël Badin
Approved revision: no longer in the source branch.
Merged at revision: 4000
Proposed branch: lp:~rvb/maas/maas-new-event-index
Merge into: lp:~maas-committers/maas/trunk
Diff against target: 464 lines (+448/-0)
2 files modified
src/maasserver/migrations/0138_perf_index_on_node_events.py (+445/-0)
src/maasserver/models/event.py (+3/-0)
To merge this branch: bzr merge lp:~rvb/maas/maas-new-event-index
Reviewer Review Type Date Requested Status
Andres Rodriguez (community) Approve
Gavin Panella (community) Approve
Review via email: mp+261473@code.launchpad.net

Commit message

Add index (node_id, id) on node events: it speeds up the query that gets the last events that's issued for the UI display.

Description of the change

Note that this is a manually created migration since index_together indexes are only supported (as in "detected automatically") by South 0.8 and Trusty uses 0.7.5.

I've tested the index in OIL (manually) and tested this fix in my lab.

To post a comment you must log in.
Revision history for this message
Gavin Panella (allenap) :
review: Approve
Revision history for this message
Andres Rodriguez (andreserl) wrote :

lgtm!

review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
=== added file 'src/maasserver/migrations/0138_perf_index_on_node_events.py'
--- src/maasserver/migrations/0138_perf_index_on_node_events.py 1970-01-01 00:00:00 +0000
+++ src/maasserver/migrations/0138_perf_index_on_node_events.py 2015-06-09 08:14:30 +0000
@@ -0,0 +1,445 @@
1# -*- coding: utf-8 -*-
2import datetime
3
4from django.db import models
5from south.db import db
6from south.v2 import SchemaMigration
7
8
9class Migration(SchemaMigration):
10
11 def forwards(self, orm):
12 # Adding index on 'Event', fields ['node', u'id']
13 db.create_index(u'maasserver_event', ['node_id', u'id'])
14
15
16 def backwards(self, orm):
17 # Removing index on 'Event', fields ['node', u'id']
18 db.delete_index(u'maasserver_event', ['node_id', u'id'])
19
20
21 models = {
22 u'auth.group': {
23 'Meta': {'object_name': 'Group'},
24 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
25 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '80'}),
26 'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': u"orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'})
27 },
28 u'auth.permission': {
29 'Meta': {'ordering': "(u'content_type__app_label', u'content_type__model', u'codename')", 'unique_together': "((u'content_type', u'codename'),)", 'object_name': 'Permission'},
30 'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
31 'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['contenttypes.ContentType']"}),
32 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
33 'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
34 },
35 u'auth.user': {
36 'Meta': {'object_name': 'User'},
37 'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
38 'email': ('django.db.models.fields.EmailField', [], {'unique': 'True', 'max_length': '75', 'blank': 'True'}),
39 'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
40 'groups': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "u'user_set'", 'blank': 'True', 'to': u"orm['auth.Group']"}),
41 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
42 'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
43 'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
44 'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
45 'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
46 'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
47 'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
48 'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "u'user_set'", 'blank': 'True', 'to': u"orm['auth.Permission']"}),
49 'username': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'})
50 },
51 u'contenttypes.contenttype': {
52 'Meta': {'ordering': "('name',)", 'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"},
53 'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
54 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
55 'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
56 'name': ('django.db.models.fields.CharField', [], {'max_length': '100'})
57 },
58 u'maasserver.blockdevice': {
59 'Meta': {'ordering': "[u'id']", 'unique_together': "((u'node', u'path'),)", 'object_name': 'BlockDevice'},
60 'block_size': ('django.db.models.fields.IntegerField', [], {}),
61 'created': ('django.db.models.fields.DateTimeField', [], {}),
62 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
63 'id_path': ('django.db.models.fields.FilePathField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}),
64 'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
65 'node': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['maasserver.Node']"}),
66 'path': ('django.db.models.fields.FilePathField', [], {'max_length': '100'}),
67 'size': ('django.db.models.fields.BigIntegerField', [], {}),
68 'tags': ('djorm_pgarray.fields.ArrayField', [], {'default': '[]', 'dbtype': "u'text'", 'blank': 'True'}),
69 'updated': ('django.db.models.fields.DateTimeField', [], {})
70 },
71 u'maasserver.bootresource': {
72 'Meta': {'unique_together': "((u'name', u'architecture'),)", 'object_name': 'BootResource'},
73 'architecture': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
74 'created': ('django.db.models.fields.DateTimeField', [], {}),
75 'extra': ('maasserver.fields.JSONObjectField', [], {'default': "u''", 'blank': 'True'}),
76 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
77 'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
78 'rtype': ('django.db.models.fields.IntegerField', [], {'max_length': '10'}),
79 'updated': ('django.db.models.fields.DateTimeField', [], {})
80 },
81 u'maasserver.bootresourcefile': {
82 'Meta': {'unique_together': "((u'resource_set', u'filetype'),)", 'object_name': 'BootResourceFile'},
83 'created': ('django.db.models.fields.DateTimeField', [], {}),
84 'extra': ('maasserver.fields.JSONObjectField', [], {'default': "u''", 'blank': 'True'}),
85 'filename': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
86 'filetype': ('django.db.models.fields.CharField', [], {'default': "u'root-tgz'", 'max_length': '20'}),
87 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
88 'largefile': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['maasserver.LargeFile']"}),
89 'resource_set': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "u'files'", 'to': u"orm['maasserver.BootResourceSet']"}),
90 'updated': ('django.db.models.fields.DateTimeField', [], {})
91 },
92 u'maasserver.bootresourceset': {
93 'Meta': {'unique_together': "((u'resource', u'version'),)", 'object_name': 'BootResourceSet'},
94 'created': ('django.db.models.fields.DateTimeField', [], {}),
95 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
96 'label': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
97 'resource': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "u'sets'", 'to': u"orm['maasserver.BootResource']"}),
98 'updated': ('django.db.models.fields.DateTimeField', [], {}),
99 'version': ('django.db.models.fields.CharField', [], {'max_length': '255'})
100 },
101 u'maasserver.bootsource': {
102 'Meta': {'object_name': 'BootSource'},
103 'created': ('django.db.models.fields.DateTimeField', [], {}),
104 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
105 'keyring_data': ('maasserver.fields.EditableBinaryField', [], {'blank': 'True'}),
106 'keyring_filename': ('django.db.models.fields.FilePathField', [], {'max_length': '100', 'blank': 'True'}),
107 'updated': ('django.db.models.fields.DateTimeField', [], {}),
108 'url': ('django.db.models.fields.URLField', [], {'unique': 'True', 'max_length': '200'})
109 },
110 u'maasserver.bootsourcecache': {
111 'Meta': {'object_name': 'BootSourceCache'},
112 'arch': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
113 'boot_source': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['maasserver.BootSource']"}),
114 'created': ('django.db.models.fields.DateTimeField', [], {}),
115 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
116 'label': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
117 'os': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
118 'release': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
119 'subarch': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
120 'updated': ('django.db.models.fields.DateTimeField', [], {})
121 },
122 u'maasserver.bootsourceselection': {
123 'Meta': {'unique_together': "((u'boot_source', u'os', u'release'),)", 'object_name': 'BootSourceSelection'},
124 'arches': ('djorm_pgarray.fields.ArrayField', [], {'default': 'None', 'dbtype': "u'text'", 'null': 'True', 'blank': 'True'}),
125 'boot_source': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['maasserver.BootSource']"}),
126 'created': ('django.db.models.fields.DateTimeField', [], {}),
127 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
128 'labels': ('djorm_pgarray.fields.ArrayField', [], {'default': 'None', 'dbtype': "u'text'", 'null': 'True', 'blank': 'True'}),
129 'os': ('django.db.models.fields.CharField', [], {'default': "u''", 'max_length': '20', 'blank': 'True'}),
130 'release': ('django.db.models.fields.CharField', [], {'default': "u''", 'max_length': '20', 'blank': 'True'}),
131 'subarches': ('djorm_pgarray.fields.ArrayField', [], {'default': 'None', 'dbtype': "u'text'", 'null': 'True', 'blank': 'True'}),
132 'updated': ('django.db.models.fields.DateTimeField', [], {})
133 },
134 u'maasserver.candidatename': {
135 'Meta': {'unique_together': "((u'name', u'position'),)", 'object_name': 'CandidateName'},
136 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
137 'name': ('django.db.models.fields.SlugField', [], {'max_length': '50'}),
138 'position': ('django.db.models.fields.IntegerField', [], {})
139 },
140 u'maasserver.componenterror': {
141 'Meta': {'object_name': 'ComponentError'},
142 'component': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '40'}),
143 'created': ('django.db.models.fields.DateTimeField', [], {}),
144 'error': ('django.db.models.fields.CharField', [], {'max_length': '1000'}),
145 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
146 'updated': ('django.db.models.fields.DateTimeField', [], {})
147 },
148 u'maasserver.config': {
149 'Meta': {'object_name': 'Config'},
150 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
151 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
152 'value': ('maasserver.fields.JSONObjectField', [], {'null': 'True'})
153 },
154 u'maasserver.dhcplease': {
155 'Meta': {'object_name': 'DHCPLease'},
156 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
157 'ip': ('maasserver.fields.MAASIPAddressField', [], {'unique': 'True', 'max_length': '39'}),
158 'mac': ('maasserver.fields.MACAddressField', [], {}),
159 'nodegroup': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['maasserver.NodeGroup']"})
160 },
161 u'maasserver.downloadprogress': {
162 'Meta': {'object_name': 'DownloadProgress'},
163 'bytes_downloaded': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
164 'created': ('django.db.models.fields.DateTimeField', [], {}),
165 'error': ('django.db.models.fields.CharField', [], {'max_length': '1000', 'blank': 'True'}),
166 'filename': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
167 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
168 'nodegroup': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['maasserver.NodeGroup']"}),
169 'size': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
170 'updated': ('django.db.models.fields.DateTimeField', [], {})
171 },
172 u'maasserver.event': {
173 'Meta': {'object_name': 'Event', 'index_together': "((u'node', u'id'),)"},
174 'created': ('django.db.models.fields.DateTimeField', [], {}),
175 'description': ('django.db.models.fields.TextField', [], {'default': "u''", 'blank': 'True'}),
176 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
177 'node': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['maasserver.Node']"}),
178 'type': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['maasserver.EventType']"}),
179 'updated': ('django.db.models.fields.DateTimeField', [], {})
180 },
181 u'maasserver.eventtype': {
182 'Meta': {'object_name': 'EventType'},
183 'created': ('django.db.models.fields.DateTimeField', [], {}),
184 'description': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
185 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
186 'level': ('django.db.models.fields.IntegerField', [], {'db_index': 'True'}),
187 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
188 'updated': ('django.db.models.fields.DateTimeField', [], {})
189 },
190 u'maasserver.filestorage': {
191 'Meta': {'unique_together': "((u'filename', u'owner'),)", 'object_name': 'FileStorage'},
192 'content': ('metadataserver.fields.BinaryField', [], {'blank': 'True'}),
193 'filename': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
194 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
195 'key': ('django.db.models.fields.CharField', [], {'default': "u'ca7f9ec6-0e7e-11e5-8f3a-3c970e0e56dc'", 'unique': 'True', 'max_length': '36'}),
196 'owner': ('django.db.models.fields.related.ForeignKey', [], {'default': 'None', 'to': u"orm['auth.User']", 'null': 'True', 'blank': 'True'})
197 },
198 u'maasserver.filesystem': {
199 'Meta': {'object_name': 'Filesystem'},
200 'block_device': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['maasserver.BlockDevice']", 'null': 'True', 'blank': 'True'}),
201 'create_params': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
202 'created': ('django.db.models.fields.DateTimeField', [], {}),
203 'filesystem_group': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "u'filesystems'", 'null': 'True', 'to': u"orm['maasserver.FilesystemGroup']"}),
204 'fstype': ('django.db.models.fields.CharField', [], {'default': "u'ext4'", 'max_length': '20'}),
205 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
206 'mount_params': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
207 'mount_point': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
208 'partition': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['maasserver.Partition']", 'null': 'True', 'blank': 'True'}),
209 'updated': ('django.db.models.fields.DateTimeField', [], {}),
210 'uuid': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '36'})
211 },
212 u'maasserver.filesystemgroup': {
213 'Meta': {'object_name': 'FilesystemGroup'},
214 'create_params': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
215 'created': ('django.db.models.fields.DateTimeField', [], {}),
216 'group_type': ('django.db.models.fields.CharField', [], {'max_length': '20'}),
217 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
218 'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
219 'updated': ('django.db.models.fields.DateTimeField', [], {}),
220 'uuid': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '36'})
221 },
222 u'maasserver.largefile': {
223 'Meta': {'object_name': 'LargeFile'},
224 'content': ('maasserver.fields.LargeObjectField', [], {}),
225 'created': ('django.db.models.fields.DateTimeField', [], {}),
226 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
227 'sha256': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '64'}),
228 'total_size': ('django.db.models.fields.BigIntegerField', [], {}),
229 'updated': ('django.db.models.fields.DateTimeField', [], {})
230 },
231 u'maasserver.licensekey': {
232 'Meta': {'unique_together': "((u'osystem', u'distro_series'),)", 'object_name': 'LicenseKey'},
233 'created': ('django.db.models.fields.DateTimeField', [], {}),
234 'distro_series': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
235 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
236 'license_key': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
237 'osystem': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
238 'updated': ('django.db.models.fields.DateTimeField', [], {})
239 },
240 u'maasserver.macaddress': {
241 'Meta': {'ordering': "(u'created',)", 'object_name': 'MACAddress'},
242 'cluster_interface': ('django.db.models.fields.related.ForeignKey', [], {'default': 'None', 'to': u"orm['maasserver.NodeGroupInterface']", 'null': 'True', 'on_delete': 'models.SET_NULL', 'blank': 'True'}),
243 'created': ('django.db.models.fields.DateTimeField', [], {}),
244 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
245 'ip_addresses': ('django.db.models.fields.related.ManyToManyField', [], {'to': u"orm['maasserver.StaticIPAddress']", 'symmetrical': 'False', 'through': u"orm['maasserver.MACStaticIPAddressLink']", 'blank': 'True'}),
246 'mac_address': ('maasserver.fields.MACAddressField', [], {'unique': 'True'}),
247 'networks': ('django.db.models.fields.related.ManyToManyField', [], {'to': u"orm['maasserver.Network']", 'symmetrical': 'False', 'blank': 'True'}),
248 'node': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['maasserver.Node']", 'null': 'True', 'blank': 'True'}),
249 'updated': ('django.db.models.fields.DateTimeField', [], {})
250 },
251 u'maasserver.macstaticipaddresslink': {
252 'Meta': {'unique_together': "((u'ip_address', u'mac_address'),)", 'object_name': 'MACStaticIPAddressLink'},
253 'created': ('django.db.models.fields.DateTimeField', [], {}),
254 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
255 'ip_address': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['maasserver.StaticIPAddress']", 'unique': 'True'}),
256 'mac_address': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['maasserver.MACAddress']"}),
257 'nic_alias': ('django.db.models.fields.IntegerField', [], {'default': 'None', 'null': 'True', 'blank': 'True'}),
258 'updated': ('django.db.models.fields.DateTimeField', [], {})
259 },
260 u'maasserver.network': {
261 'Meta': {'object_name': 'Network'},
262 'default_gateway': ('maasserver.fields.MAASIPAddressField', [], {'max_length': '39', 'null': 'True', 'blank': 'True'}),
263 'description': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
264 'dns_servers': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
265 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
266 'ip': ('maasserver.fields.MAASIPAddressField', [], {'unique': 'True', 'max_length': '39'}),
267 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
268 'netmask': ('maasserver.fields.MAASIPAddressField', [], {'max_length': '39'}),
269 'vlan_tag': ('django.db.models.fields.PositiveSmallIntegerField', [], {'unique': 'True', 'null': 'True', 'blank': 'True'})
270 },
271 u'maasserver.node': {
272 'Meta': {'object_name': 'Node'},
273 'agent_name': ('django.db.models.fields.CharField', [], {'default': "u''", 'max_length': '255', 'null': 'True', 'blank': 'True'}),
274 'architecture': ('django.db.models.fields.CharField', [], {'max_length': '31', 'null': 'True', 'blank': 'True'}),
275 'boot_type': ('django.db.models.fields.CharField', [], {'default': "u'fastpath'", 'max_length': '20'}),
276 'cpu_count': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
277 'created': ('django.db.models.fields.DateTimeField', [], {}),
278 'disable_ipv4': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
279 'distro_series': ('django.db.models.fields.CharField', [], {'default': "u''", 'max_length': '20', 'blank': 'True'}),
280 'error': ('django.db.models.fields.CharField', [], {'default': "u''", 'max_length': '255', 'blank': 'True'}),
281 'error_description': ('django.db.models.fields.TextField', [], {'default': "u''", 'blank': 'True'}),
282 'hostname': ('django.db.models.fields.CharField', [], {'default': "u''", 'unique': 'True', 'max_length': '255', 'blank': 'True'}),
283 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
284 'installable': ('django.db.models.fields.BooleanField', [], {'default': 'True', 'db_index': 'True'}),
285 'license_key': ('django.db.models.fields.CharField', [], {'max_length': '30', 'null': 'True', 'blank': 'True'}),
286 'memory': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
287 'netboot': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
288 'nodegroup': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['maasserver.NodeGroup']", 'null': 'True'}),
289 'osystem': ('django.db.models.fields.CharField', [], {'default': "u''", 'max_length': '20', 'blank': 'True'}),
290 'owner': ('django.db.models.fields.related.ForeignKey', [], {'default': 'None', 'to': u"orm['auth.User']", 'null': 'True', 'blank': 'True'}),
291 'parent': ('django.db.models.fields.related.ForeignKey', [], {'default': 'None', 'related_name': "u'children'", 'null': 'True', 'blank': 'True', 'to': u"orm['maasserver.Node']"}),
292 'power_parameters': ('maasserver.fields.JSONObjectField', [], {'default': "u''", 'blank': 'True'}),
293 'power_state': ('django.db.models.fields.CharField', [], {'default': "u'unknown'", 'max_length': '10'}),
294 'power_type': ('django.db.models.fields.CharField', [], {'default': "u''", 'max_length': '10', 'blank': 'True'}),
295 'pxe_mac': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "u'+'", 'on_delete': 'models.SET_NULL', 'default': 'None', 'to': u"orm['maasserver.MACAddress']", 'blank': 'True', 'null': 'True'}),
296 'routers': ('djorm_pgarray.fields.ArrayField', [], {'default': 'None', 'dbtype': "u'macaddr'", 'null': 'True', 'blank': 'True'}),
297 'status': ('django.db.models.fields.IntegerField', [], {'default': '0', 'max_length': '10'}),
298 'swap_size': ('django.db.models.fields.BigIntegerField', [], {'default': 'None', 'null': 'True', 'blank': 'True'}),
299 'system_id': ('django.db.models.fields.CharField', [], {'default': "u'node-ca8290ae-0e7e-11e5-8f3a-3c970e0e56dc'", 'unique': 'True', 'max_length': '41'}),
300 'tags': ('django.db.models.fields.related.ManyToManyField', [], {'to': u"orm['maasserver.Tag']", 'symmetrical': 'False'}),
301 'token': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['piston.Token']", 'null': 'True'}),
302 'updated': ('django.db.models.fields.DateTimeField', [], {}),
303 'zone': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['maasserver.Zone']", 'on_delete': 'models.SET_DEFAULT'})
304 },
305 u'maasserver.nodegroup': {
306 'Meta': {'object_name': 'NodeGroup'},
307 'api_key': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '18'}),
308 'api_token': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['piston.Token']", 'unique': 'True'}),
309 'cluster_name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '100', 'blank': 'True'}),
310 'created': ('django.db.models.fields.DateTimeField', [], {}),
311 'default_disable_ipv4': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
312 'dhcp_key': ('django.db.models.fields.CharField', [], {'default': "u''", 'max_length': '255', 'blank': 'True'}),
313 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
314 'maas_url': ('django.db.models.fields.CharField', [], {'default': "u''", 'max_length': '255', 'blank': 'True'}),
315 'name': ('maasserver.models.nodegroup.DomainNameField', [], {'max_length': '80', 'blank': 'True'}),
316 'status': ('django.db.models.fields.IntegerField', [], {'default': '1'}),
317 'updated': ('django.db.models.fields.DateTimeField', [], {}),
318 'uuid': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '36'})
319 },
320 u'maasserver.nodegroupinterface': {
321 'Meta': {'unique_together': "((u'nodegroup', u'name'),)", 'object_name': 'NodeGroupInterface'},
322 'broadcast_ip': ('maasserver.fields.MAASIPAddressField', [], {'default': 'None', 'max_length': '39', 'null': 'True', 'blank': 'True'}),
323 'created': ('django.db.models.fields.DateTimeField', [], {}),
324 'foreign_dhcp_ip': ('maasserver.fields.MAASIPAddressField', [], {'default': 'None', 'max_length': '39', 'null': 'True', 'blank': 'True'}),
325 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
326 'interface': ('django.db.models.fields.CharField', [], {'default': "u''", 'max_length': '255', 'blank': 'True'}),
327 'ip': ('maasserver.fields.MAASIPAddressField', [], {'max_length': '39'}),
328 'ip_range_high': ('maasserver.fields.MAASIPAddressField', [], {'default': 'None', 'max_length': '39', 'null': 'True', 'blank': 'True'}),
329 'ip_range_low': ('maasserver.fields.MAASIPAddressField', [], {'default': 'None', 'max_length': '39', 'null': 'True', 'blank': 'True'}),
330 'management': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
331 'name': ('django.db.models.fields.CharField', [], {'default': "u''", 'max_length': '255', 'blank': 'True'}),
332 'nodegroup': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['maasserver.NodeGroup']"}),
333 'router_ip': ('maasserver.fields.MAASIPAddressField', [], {'default': 'None', 'max_length': '39', 'null': 'True', 'blank': 'True'}),
334 'static_ip_range_high': ('maasserver.fields.MAASIPAddressField', [], {'default': 'None', 'max_length': '39', 'null': 'True', 'blank': 'True'}),
335 'static_ip_range_low': ('maasserver.fields.MAASIPAddressField', [], {'default': 'None', 'max_length': '39', 'null': 'True', 'blank': 'True'}),
336 'subnet_mask': ('maasserver.fields.MAASIPAddressField', [], {'default': 'None', 'max_length': '39', 'null': 'True', 'blank': 'True'}),
337 'updated': ('django.db.models.fields.DateTimeField', [], {})
338 },
339 u'maasserver.partition': {
340 'Meta': {'object_name': 'Partition'},
341 'bootable': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
342 'created': ('django.db.models.fields.DateTimeField', [], {}),
343 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
344 'partition_table': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "u'partitions'", 'to': u"orm['maasserver.PartitionTable']"}),
345 'size': ('django.db.models.fields.BigIntegerField', [], {}),
346 'start_offset': ('django.db.models.fields.BigIntegerField', [], {}),
347 'updated': ('django.db.models.fields.DateTimeField', [], {}),
348 'uuid': ('django.db.models.fields.CharField', [], {'max_length': '36', 'unique': 'True', 'null': 'True', 'blank': 'True'})
349 },
350 u'maasserver.partitiontable': {
351 'Meta': {'object_name': 'PartitionTable'},
352 'block_device': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['maasserver.BlockDevice']"}),
353 'created': ('django.db.models.fields.DateTimeField', [], {}),
354 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
355 'table_type': ('django.db.models.fields.CharField', [], {'default': "u'GPT'", 'max_length': '20'}),
356 'updated': ('django.db.models.fields.DateTimeField', [], {})
357 },
358 u'maasserver.physicalblockdevice': {
359 'Meta': {'ordering': "[u'id']", 'object_name': 'PhysicalBlockDevice', '_ormbases': [u'maasserver.BlockDevice']},
360 u'blockdevice_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': u"orm['maasserver.BlockDevice']", 'unique': 'True', 'primary_key': 'True'}),
361 'model': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
362 'serial': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'})
363 },
364 u'maasserver.sshkey': {
365 'Meta': {'unique_together': "((u'user', u'key'),)", 'object_name': 'SSHKey'},
366 'created': ('django.db.models.fields.DateTimeField', [], {}),
367 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
368 'key': ('django.db.models.fields.TextField', [], {}),
369 'updated': ('django.db.models.fields.DateTimeField', [], {}),
370 'user': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['auth.User']"})
371 },
372 u'maasserver.sslkey': {
373 'Meta': {'unique_together': "((u'user', u'key'),)", 'object_name': 'SSLKey'},
374 'created': ('django.db.models.fields.DateTimeField', [], {}),
375 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
376 'key': ('django.db.models.fields.TextField', [], {}),
377 'updated': ('django.db.models.fields.DateTimeField', [], {}),
378 'user': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['auth.User']"})
379 },
380 u'maasserver.staticipaddress': {
381 'Meta': {'object_name': 'StaticIPAddress'},
382 'alloc_type': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
383 'created': ('django.db.models.fields.DateTimeField', [], {}),
384 'hostname': ('django.db.models.fields.CharField', [], {'default': "u''", 'max_length': '255', 'null': 'True', 'blank': 'True'}),
385 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
386 'ip': ('maasserver.fields.MAASIPAddressField', [], {'unique': 'True', 'max_length': '39'}),
387 'updated': ('django.db.models.fields.DateTimeField', [], {}),
388 'user': ('django.db.models.fields.related.ForeignKey', [], {'default': 'None', 'to': u"orm['auth.User']", 'null': 'True', 'blank': 'True'})
389 },
390 u'maasserver.tag': {
391 'Meta': {'object_name': 'Tag'},
392 'comment': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
393 'created': ('django.db.models.fields.DateTimeField', [], {}),
394 'definition': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
395 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
396 'kernel_opts': ('django.db.models.fields.TextField', [], {'null': 'True', 'blank': 'True'}),
397 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '256'}),
398 'updated': ('django.db.models.fields.DateTimeField', [], {})
399 },
400 u'maasserver.userprofile': {
401 'Meta': {'object_name': 'UserProfile'},
402 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
403 'user': ('django.db.models.fields.related.OneToOneField', [], {'to': u"orm['auth.User']", 'unique': 'True'})
404 },
405 u'maasserver.virtualblockdevice': {
406 'Meta': {'ordering': "[u'id']", 'object_name': 'VirtualBlockDevice', '_ormbases': [u'maasserver.BlockDevice']},
407 u'blockdevice_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': u"orm['maasserver.BlockDevice']", 'unique': 'True', 'primary_key': 'True'}),
408 'filesystem_group': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "u'virtual_devices'", 'to': u"orm['maasserver.FilesystemGroup']"}),
409 'uuid': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '36'})
410 },
411 u'maasserver.zone': {
412 'Meta': {'ordering': "[u'name']", 'object_name': 'Zone'},
413 'created': ('django.db.models.fields.DateTimeField', [], {}),
414 'description': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
415 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
416 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '256'}),
417 'updated': ('django.db.models.fields.DateTimeField', [], {})
418 },
419 u'piston.consumer': {
420 'Meta': {'object_name': 'Consumer'},
421 'description': ('django.db.models.fields.TextField', [], {}),
422 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
423 'key': ('django.db.models.fields.CharField', [], {'max_length': '18'}),
424 'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
425 'secret': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
426 'status': ('django.db.models.fields.CharField', [], {'default': "'pending'", 'max_length': '16'}),
427 'user': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'consumers'", 'null': 'True', 'to': u"orm['auth.User']"})
428 },
429 u'piston.token': {
430 'Meta': {'object_name': 'Token'},
431 'callback': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
432 'callback_confirmed': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
433 'consumer': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['piston.Consumer']"}),
434 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
435 'is_approved': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
436 'key': ('django.db.models.fields.CharField', [], {'max_length': '18'}),
437 'secret': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
438 'timestamp': ('django.db.models.fields.IntegerField', [], {'default': '1433837342L'}),
439 'token_type': ('django.db.models.fields.IntegerField', [], {}),
440 'user': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'tokens'", 'null': 'True', 'to': u"orm['auth.User']"}),
441 'verifier': ('django.db.models.fields.CharField', [], {'max_length': '10'})
442 }
443 }
444
445 complete_apps = ['maasserver']
0\ No newline at end of file446\ No newline at end of file
1447
=== modified file 'src/maasserver/models/event.py'
--- src/maasserver/models/event.py 2015-05-07 18:14:38 +0000
+++ src/maasserver/models/event.py 2015-06-09 08:14:30 +0000
@@ -80,6 +80,9 @@
8080
81 class Meta(DefaultMeta):81 class Meta(DefaultMeta):
82 verbose_name = "Event record"82 verbose_name = "Event record"
83 index_together = (
84 ("node", "id"),
85 )
8386
84 def __unicode__(self):87 def __unicode__(self):
85 return "%s (node=%s, type=%s, created=%s)" % (88 return "%s (node=%s, type=%s, created=%s)" % (