summaryrefslogtreecommitdiffstats
path: root/src/lib/Bcfg2/Reporting/migrations/0001_initial.py
blob: 6a52a8b2d4fc2079e520809999a5bc836c226454 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
# -*- coding: utf-8 -*-
from __future__ import unicode_literals

from django.db import models, migrations


class Migration(migrations.Migration):

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='ActionEntry',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('name', models.CharField(max_length=128, db_index=True)),
                ('hash_key', models.IntegerField(editable=False, db_index=True)),
                ('state', models.IntegerField(choices=[(0, b'Good'), (1, b'Bad'), (2, b'Modified'), (3, b'Extra')])),
                ('exists', models.BooleanField(default=True)),
                ('status', models.CharField(default=b'check', max_length=128)),
                ('output', models.IntegerField(default=0)),
            ],
            options={
                'ordering': ('state', 'name'),
                'abstract': False,
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='Bundle',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('name', models.CharField(unique=True, max_length=255)),
            ],
            options={
                'ordering': ('name',),
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='Client',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('creation', models.DateTimeField(auto_now_add=True)),
                ('name', models.CharField(max_length=128)),
                ('expiration', models.DateTimeField(null=True, blank=True)),
            ],
            options={
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='FailureEntry',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('name', models.CharField(max_length=128, db_index=True)),
                ('hash_key', models.IntegerField(editable=False, db_index=True)),
                ('entry_type', models.CharField(max_length=128)),
                ('message', models.TextField()),
            ],
            options={
                'abstract': False,
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='FileAcl',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('name', models.CharField(max_length=128, db_index=True)),
            ],
            options={
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='FilePerms',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('owner', models.CharField(max_length=128)),
                ('group', models.CharField(max_length=128)),
                ('perms', models.CharField(max_length=128)),
            ],
            options={
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='Group',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('name', models.CharField(unique=True, max_length=255)),
                ('profile', models.BooleanField(default=False)),
                ('public', models.BooleanField(default=False)),
                ('category', models.CharField(max_length=1024, blank=True)),
                ('comment', models.TextField(blank=True)),
                ('bundles', models.ManyToManyField(to='Reporting.Bundle')),
                ('groups', models.ManyToManyField(to='Reporting.Group')),
            ],
            options={
                'ordering': ('name',),
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='Interaction',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('timestamp', models.DateTimeField(db_index=True)),
                ('state', models.CharField(max_length=32)),
                ('repo_rev_code', models.CharField(max_length=64)),
                ('server', models.CharField(max_length=256)),
                ('good_count', models.IntegerField()),
                ('total_count', models.IntegerField()),
                ('bad_count', models.IntegerField(default=0)),
                ('modified_count', models.IntegerField(default=0)),
                ('extra_count', models.IntegerField(default=0)),
                ('actions', models.ManyToManyField(to='Reporting.ActionEntry')),
                ('bundles', models.ManyToManyField(to='Reporting.Bundle')),
                ('client', models.ForeignKey(related_name='interactions', to='Reporting.Client')),
                ('failures', models.ManyToManyField(to='Reporting.FailureEntry')),
                ('groups', models.ManyToManyField(to='Reporting.Group')),
            ],
            options={
                'ordering': ['-timestamp'],
                'get_latest_by': 'timestamp',
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='PackageEntry',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('name', models.CharField(max_length=128, db_index=True)),
                ('hash_key', models.IntegerField(editable=False, db_index=True)),
                ('state', models.IntegerField(choices=[(0, b'Good'), (1, b'Bad'), (2, b'Modified'), (3, b'Extra')])),
                ('exists', models.BooleanField(default=True)),
                ('target_version', models.CharField(default=b'', max_length=1024)),
                ('current_version', models.CharField(max_length=1024)),
                ('verification_details', models.TextField(default=b'')),
            ],
            options={
                'ordering': ('state', 'name'),
                'abstract': False,
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='PathEntry',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('name', models.CharField(max_length=128, db_index=True)),
                ('hash_key', models.IntegerField(editable=False, db_index=True)),
                ('state', models.IntegerField(choices=[(0, b'Good'), (1, b'Bad'), (2, b'Modified'), (3, b'Extra')])),
                ('exists', models.BooleanField(default=True)),
                ('path_type', models.CharField(max_length=128, choices=[(b'device', b'Device'), (b'directory', b'Directory'), (b'hardlink', b'Hard Link'), (b'nonexistent', b'Non Existent'), (b'permissions', b'Permissions'), (b'symlink', b'Symlink')])),
                ('detail_type', models.IntegerField(default=0, choices=[(0, b'Unused'), (1, b'Diff'), (2, b'Binary'), (3, b'Sensitive'), (4, b'Size limit exceeded'), (5, b'VCS output'), (6, b'Pruned paths')])),
                ('details', models.TextField(default=b'')),
            ],
            options={
                'ordering': ('state', 'name'),
                'abstract': False,
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='LinkEntry',
            fields=[
                ('pathentry_ptr', models.OneToOneField(parent_link=True, auto_created=True, primary_key=True, serialize=False, to='Reporting.PathEntry')),
                ('target_path', models.CharField(max_length=1024, blank=True)),
                ('current_path', models.CharField(max_length=1024, blank=True)),
            ],
            options={
                'ordering': ('state', 'name'),
                'abstract': False,
            },
            bases=('Reporting.pathentry',),
        ),
        migrations.CreateModel(
            name='DeviceEntry',
            fields=[
                ('pathentry_ptr', models.OneToOneField(parent_link=True, auto_created=True, primary_key=True, serialize=False, to='Reporting.PathEntry')),
                ('device_type', models.CharField(max_length=16, choices=[(b'block', b'Block'), (b'char', b'Char'), (b'fifo', b'Fifo')])),
                ('target_major', models.IntegerField()),
                ('target_minor', models.IntegerField()),
                ('current_major', models.IntegerField()),
                ('current_minor', models.IntegerField()),
            ],
            options={
                'ordering': ('state', 'name'),
                'abstract': False,
            },
            bases=('Reporting.pathentry',),
        ),
        migrations.CreateModel(
            name='Performance',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('metric', models.CharField(max_length=128)),
                ('value', models.DecimalField(max_digits=32, decimal_places=16)),
                ('interaction', models.ForeignKey(related_name='performance_items', to='Reporting.Interaction')),
            ],
            options={
            },
            bases=(models.Model,),
        ),
        migrations.CreateModel(
            name='ServiceEntry',
            fields=[
                ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
                ('name', models.CharField(max_length=128, db_index=True)),
                ('hash_key', models.IntegerField(editable=False, db_index=True)),
                ('state', models.IntegerField(choices=[(0, b'Good'), (1, b'Bad'), (2, b'Modified'), (3, b'Extra')])),
                ('exists', models.BooleanField(default=True)),
                ('target_status', models.CharField(default=b'', max_length=128)),
                ('current_status', models.CharField(default=b'', max_length=128)),
            ],
            options={
                'ordering': ('state', 'name'),
                'abstract': False,
            },
            bases=(models.Model,),
        ),
        migrations.AddField(
            model_name='pathentry',
            name='acls',
            field=models.ManyToManyField(to='Reporting.FileAcl'),
            preserve_default=True,
        ),
        migrations.AddField(
            model_name='pathentry',
            name='current_perms',
            field=models.ForeignKey(related_name='+', to='Reporting.FilePerms'),
            preserve_default=True,
        ),
        migrations.AddField(
            model_name='pathentry',
            name='target_perms',
            field=models.ForeignKey(related_name='+', to='Reporting.FilePerms'),
            preserve_default=True,
        ),
        migrations.AddField(
            model_name='interaction',
            name='packages',
            field=models.ManyToManyField(to='Reporting.PackageEntry'),
            preserve_default=True,
        ),
        migrations.AddField(
            model_name='interaction',
            name='paths',
            field=models.ManyToManyField(to='Reporting.PathEntry'),
            preserve_default=True,
        ),
        migrations.AddField(
            model_name='interaction',
            name='profile',
            field=models.ForeignKey(related_name='+', to='Reporting.Group'),
            preserve_default=True,
        ),
        migrations.AddField(
            model_name='interaction',
            name='services',
            field=models.ManyToManyField(to='Reporting.ServiceEntry'),
            preserve_default=True,
        ),
        migrations.AlterUniqueTogether(
            name='interaction',
            unique_together=set([('client', 'timestamp')]),
        ),
        migrations.AlterUniqueTogether(
            name='fileperms',
            unique_together=set([('owner', 'group', 'perms')]),
        ),
        migrations.AddField(
            model_name='client',
            name='current_interaction',
            field=models.ForeignKey(related_name='parent_client', blank=True, to='Reporting.Interaction', null=True),
            preserve_default=True,
        ),
    ]