vkk.migrations.0002_departmentcosts_departmentdate_generalcosts_and_more

  1# Generated by Django 4.1.3 on 2022-12-01 19:38
  2
  3from django.db import migrations, models
  4import django.db.models.deletion
  5
  6
  7class Migration(migrations.Migration):
  8
  9    dependencies = [
 10        ('vkk', '0001_initial'),
 11    ]
 12
 13    operations = [
 14        migrations.CreateModel(
 15            name='DepartmentCosts',
 16            fields=[
 17                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 18                ('equivalents_per_hour', models.DecimalField(decimal_places=2, max_digits=8, verbose_name='full time equivalents per hour')),
 19            ],
 20            options={
 21                'verbose_name': 'department costs',
 22                'verbose_name_plural': 'department costs',
 23                'default_permissions': (),
 24            },
 25        ),
 26        migrations.CreateModel(
 27            name='DepartmentDate',
 28            fields=[
 29                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 30                ('date', models.DateField(verbose_name='start date')),
 31            ],
 32            options={
 33                'verbose_name': 'department interval',
 34                'verbose_name_plural': 'department intervals',
 35                'default_permissions': (),
 36            },
 37        ),
 38        migrations.CreateModel(
 39            name='GeneralCosts',
 40            fields=[
 41                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 42                ('start', models.DateField(verbose_name='start date')),
 43                ('costs', models.DecimalField(decimal_places=2, max_digits=8, verbose_name='general costs')),
 44            ],
 45            options={
 46                'verbose_name': 'general costs',
 47                'verbose_name_plural': 'general costs',
 48                'default_permissions': (),
 49            },
 50        ),
 51        migrations.CreateModel(
 52            name='ProjectFundedStaff',
 53            fields=[
 54                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 55                ('hours', models.DecimalField(decimal_places=2, max_digits=8)),
 56            ],
 57            options={
 58                'verbose_name': 'project funded staff',
 59                'verbose_name_plural': 'project funded staff',
 60                'default_permissions': (),
 61            },
 62        ),
 63        migrations.CreateModel(
 64            name='ProjectFundedStaffDate',
 65            fields=[
 66                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 67                ('date', models.DateField(verbose_name='start date')),
 68            ],
 69            options={
 70                'verbose_name': 'project funded staff interval',
 71                'verbose_name_plural': 'project funded staff intervals',
 72                'default_permissions': (),
 73            },
 74        ),
 75        migrations.CreateModel(
 76            name='Receipt',
 77            fields=[
 78                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 79                ('start', models.DateField(verbose_name='start date')),
 80                ('end', models.DateField(verbose_name='end date')),
 81                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='time booked')),
 82                ('data', models.JSONField()),
 83            ],
 84            options={
 85                'verbose_name': 'receipt',
 86                'verbose_name_plural': 'receipts',
 87                'default_permissions': (),
 88            },
 89        ),
 90        migrations.CreateModel(
 91            name='ReceiptTemplate',
 92            fields=[
 93                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 94                ('start', models.DateField(verbose_name='start date')),
 95                ('data', models.JSONField()),
 96            ],
 97            options={
 98                'verbose_name': 'receipt template',
 99                'verbose_name_plural': 'receipt templates',
100                'default_permissions': (),
101            },
102        ),
103        migrations.CreateModel(
104            name='SalaryLevelCosts',
105            fields=[
106                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
107                ('brutto_per_hour', models.DecimalField(decimal_places=2, max_digits=8, verbose_name='brutto staff costs per hour')),
108            ],
109            options={
110                'verbose_name': 'salary level costs',
111                'verbose_name_plural': 'salary level costs',
112                'default_permissions': (),
113            },
114        ),
115        migrations.CreateModel(
116            name='SalaryLevelDate',
117            fields=[
118                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
119                ('date', models.DateField(verbose_name='start date')),
120            ],
121            options={
122                'verbose_name': 'salary interval',
123                'verbose_name_plural': 'salary intervals',
124                'default_permissions': (),
125            },
126        ),
127        migrations.AlterField(
128            model_name='project',
129            name='department',
130            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='vkk.department', verbose_name='department'),
131        ),
132        migrations.AddConstraint(
133            model_name='salaryleveldate',
134            constraint=models.UniqueConstraint(fields=('date',), name='unique_constraint_salary_level_date'),
135        ),
136        migrations.AddField(
137            model_name='salarylevelcosts',
138            name='salary_level',
139            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.salarylevel', verbose_name='salary level'),
140        ),
141        migrations.AddField(
142            model_name='salarylevelcosts',
143            name='start',
144            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.salaryleveldate', verbose_name='start date'),
145        ),
146        migrations.AddConstraint(
147            model_name='receipttemplate',
148            constraint=models.UniqueConstraint(fields=('start',), name='unique_constraint_receipt_template_start'),
149        ),
150        migrations.AddField(
151            model_name='receipt',
152            name='project',
153            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.project', verbose_name='project'),
154        ),
155        migrations.AddField(
156            model_name='projectfundedstaffdate',
157            name='project',
158            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.project', verbose_name='project'),
159        ),
160        migrations.AddField(
161            model_name='projectfundedstaff',
162            name='salary_level',
163            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.salarylevel', verbose_name='salary level'),
164        ),
165        migrations.AddField(
166            model_name='projectfundedstaff',
167            name='start',
168            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.projectfundedstaffdate', verbose_name='start date'),
169        ),
170        migrations.AddConstraint(
171            model_name='generalcosts',
172            constraint=models.UniqueConstraint(fields=('start',), name='unique_constraint_general_costs'),
173        ),
174        migrations.AddConstraint(
175            model_name='departmentdate',
176            constraint=models.UniqueConstraint(fields=('date',), name='unique_constraint_department_date'),
177        ),
178        migrations.AddField(
179            model_name='departmentcosts',
180            name='department',
181            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.department', verbose_name='department'),
182        ),
183        migrations.AddField(
184            model_name='departmentcosts',
185            name='start',
186            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.departmentdate', verbose_name='start date'),
187        ),
188        migrations.AddConstraint(
189            model_name='salarylevelcosts',
190            constraint=models.UniqueConstraint(fields=('salary_level', 'start'), name='unique_constraint_salary_level_costs'),
191        ),
192        migrations.AddConstraint(
193            model_name='receipt',
194            constraint=models.CheckConstraint(check=models.Q(('start__lte', models.F('end'))), name='interval_check_receipt'),
195        ),
196        migrations.AddConstraint(
197            model_name='projectfundedstaffdate',
198            constraint=models.UniqueConstraint(fields=('date', 'project'), name='unique_constraint_project_funded_staff_date'),
199        ),
200        migrations.AddConstraint(
201            model_name='projectfundedstaff',
202            constraint=models.UniqueConstraint(fields=('salary_level', 'start'), name='unique_constraint_project_funded_staff'),
203        ),
204        migrations.AddConstraint(
205            model_name='departmentcosts',
206            constraint=models.UniqueConstraint(fields=('department', 'start'), name='unique_constraint_department_costs'),
207        ),
208    ]
class Migration(django.db.migrations.migration.Migration):
  8class Migration(migrations.Migration):
  9
 10    dependencies = [
 11        ('vkk', '0001_initial'),
 12    ]
 13
 14    operations = [
 15        migrations.CreateModel(
 16            name='DepartmentCosts',
 17            fields=[
 18                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 19                ('equivalents_per_hour', models.DecimalField(decimal_places=2, max_digits=8, verbose_name='full time equivalents per hour')),
 20            ],
 21            options={
 22                'verbose_name': 'department costs',
 23                'verbose_name_plural': 'department costs',
 24                'default_permissions': (),
 25            },
 26        ),
 27        migrations.CreateModel(
 28            name='DepartmentDate',
 29            fields=[
 30                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 31                ('date', models.DateField(verbose_name='start date')),
 32            ],
 33            options={
 34                'verbose_name': 'department interval',
 35                'verbose_name_plural': 'department intervals',
 36                'default_permissions': (),
 37            },
 38        ),
 39        migrations.CreateModel(
 40            name='GeneralCosts',
 41            fields=[
 42                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 43                ('start', models.DateField(verbose_name='start date')),
 44                ('costs', models.DecimalField(decimal_places=2, max_digits=8, verbose_name='general costs')),
 45            ],
 46            options={
 47                'verbose_name': 'general costs',
 48                'verbose_name_plural': 'general costs',
 49                'default_permissions': (),
 50            },
 51        ),
 52        migrations.CreateModel(
 53            name='ProjectFundedStaff',
 54            fields=[
 55                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 56                ('hours', models.DecimalField(decimal_places=2, max_digits=8)),
 57            ],
 58            options={
 59                'verbose_name': 'project funded staff',
 60                'verbose_name_plural': 'project funded staff',
 61                'default_permissions': (),
 62            },
 63        ),
 64        migrations.CreateModel(
 65            name='ProjectFundedStaffDate',
 66            fields=[
 67                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 68                ('date', models.DateField(verbose_name='start date')),
 69            ],
 70            options={
 71                'verbose_name': 'project funded staff interval',
 72                'verbose_name_plural': 'project funded staff intervals',
 73                'default_permissions': (),
 74            },
 75        ),
 76        migrations.CreateModel(
 77            name='Receipt',
 78            fields=[
 79                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 80                ('start', models.DateField(verbose_name='start date')),
 81                ('end', models.DateField(verbose_name='end date')),
 82                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='time booked')),
 83                ('data', models.JSONField()),
 84            ],
 85            options={
 86                'verbose_name': 'receipt',
 87                'verbose_name_plural': 'receipts',
 88                'default_permissions': (),
 89            },
 90        ),
 91        migrations.CreateModel(
 92            name='ReceiptTemplate',
 93            fields=[
 94                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
 95                ('start', models.DateField(verbose_name='start date')),
 96                ('data', models.JSONField()),
 97            ],
 98            options={
 99                'verbose_name': 'receipt template',
100                'verbose_name_plural': 'receipt templates',
101                'default_permissions': (),
102            },
103        ),
104        migrations.CreateModel(
105            name='SalaryLevelCosts',
106            fields=[
107                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
108                ('brutto_per_hour', models.DecimalField(decimal_places=2, max_digits=8, verbose_name='brutto staff costs per hour')),
109            ],
110            options={
111                'verbose_name': 'salary level costs',
112                'verbose_name_plural': 'salary level costs',
113                'default_permissions': (),
114            },
115        ),
116        migrations.CreateModel(
117            name='SalaryLevelDate',
118            fields=[
119                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
120                ('date', models.DateField(verbose_name='start date')),
121            ],
122            options={
123                'verbose_name': 'salary interval',
124                'verbose_name_plural': 'salary intervals',
125                'default_permissions': (),
126            },
127        ),
128        migrations.AlterField(
129            model_name='project',
130            name='department',
131            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='vkk.department', verbose_name='department'),
132        ),
133        migrations.AddConstraint(
134            model_name='salaryleveldate',
135            constraint=models.UniqueConstraint(fields=('date',), name='unique_constraint_salary_level_date'),
136        ),
137        migrations.AddField(
138            model_name='salarylevelcosts',
139            name='salary_level',
140            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.salarylevel', verbose_name='salary level'),
141        ),
142        migrations.AddField(
143            model_name='salarylevelcosts',
144            name='start',
145            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.salaryleveldate', verbose_name='start date'),
146        ),
147        migrations.AddConstraint(
148            model_name='receipttemplate',
149            constraint=models.UniqueConstraint(fields=('start',), name='unique_constraint_receipt_template_start'),
150        ),
151        migrations.AddField(
152            model_name='receipt',
153            name='project',
154            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.project', verbose_name='project'),
155        ),
156        migrations.AddField(
157            model_name='projectfundedstaffdate',
158            name='project',
159            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.project', verbose_name='project'),
160        ),
161        migrations.AddField(
162            model_name='projectfundedstaff',
163            name='salary_level',
164            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.salarylevel', verbose_name='salary level'),
165        ),
166        migrations.AddField(
167            model_name='projectfundedstaff',
168            name='start',
169            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.projectfundedstaffdate', verbose_name='start date'),
170        ),
171        migrations.AddConstraint(
172            model_name='generalcosts',
173            constraint=models.UniqueConstraint(fields=('start',), name='unique_constraint_general_costs'),
174        ),
175        migrations.AddConstraint(
176            model_name='departmentdate',
177            constraint=models.UniqueConstraint(fields=('date',), name='unique_constraint_department_date'),
178        ),
179        migrations.AddField(
180            model_name='departmentcosts',
181            name='department',
182            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.department', verbose_name='department'),
183        ),
184        migrations.AddField(
185            model_name='departmentcosts',
186            name='start',
187            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='vkk.departmentdate', verbose_name='start date'),
188        ),
189        migrations.AddConstraint(
190            model_name='salarylevelcosts',
191            constraint=models.UniqueConstraint(fields=('salary_level', 'start'), name='unique_constraint_salary_level_costs'),
192        ),
193        migrations.AddConstraint(
194            model_name='receipt',
195            constraint=models.CheckConstraint(check=models.Q(('start__lte', models.F('end'))), name='interval_check_receipt'),
196        ),
197        migrations.AddConstraint(
198            model_name='projectfundedstaffdate',
199            constraint=models.UniqueConstraint(fields=('date', 'project'), name='unique_constraint_project_funded_staff_date'),
200        ),
201        migrations.AddConstraint(
202            model_name='projectfundedstaff',
203            constraint=models.UniqueConstraint(fields=('salary_level', 'start'), name='unique_constraint_project_funded_staff'),
204        ),
205        migrations.AddConstraint(
206            model_name='departmentcosts',
207            constraint=models.UniqueConstraint(fields=('department', 'start'), name='unique_constraint_department_costs'),
208        ),
209    ]

The base class for all migrations.

Migration files will import this from django.db.migrations.Migration and subclass it as a class called Migration. It will have one or more of the following attributes:

  • operations: A list of Operation instances, probably from django.db.migrations.operations
  • dependencies: A list of tuples of (app_path, migration_name)
  • run_before: A list of tuples of (app_path, migration_name)
  • replaces: A list of migration_names

Note that all migrations come out of migrations and into the Loader or Graph as instances, having been initialized with their app label and name.

dependencies = [('vkk', '0001_initial')]
operations = [<CreateModel name='DepartmentCosts', fields=[('id', <django.db.models.fields.BigAutoField>), ('equivalents_per_hour', <django.db.models.fields.DecimalField>)], options={'verbose_name': 'department costs', 'verbose_name_plural': 'department costs', 'default_permissions': ()}>, <CreateModel name='DepartmentDate', fields=[('id', <django.db.models.fields.BigAutoField>), ('date', <django.db.models.fields.DateField>)], options={'verbose_name': 'department interval', 'verbose_name_plural': 'department intervals', 'default_permissions': ()}>, <CreateModel name='GeneralCosts', fields=[('id', <django.db.models.fields.BigAutoField>), ('start', <django.db.models.fields.DateField>), ('costs', <django.db.models.fields.DecimalField>)], options={'verbose_name': 'general costs', 'verbose_name_plural': 'general costs', 'default_permissions': ()}>, <CreateModel name='ProjectFundedStaff', fields=[('id', <django.db.models.fields.BigAutoField>), ('hours', <django.db.models.fields.DecimalField>)], options={'verbose_name': 'project funded staff', 'verbose_name_plural': 'project funded staff', 'default_permissions': ()}>, <CreateModel name='ProjectFundedStaffDate', fields=[('id', <django.db.models.fields.BigAutoField>), ('date', <django.db.models.fields.DateField>)], options={'verbose_name': 'project funded staff interval', 'verbose_name_plural': 'project funded staff intervals', 'default_permissions': ()}>, <CreateModel name='Receipt', fields=[('id', <django.db.models.fields.BigAutoField>), ('start', <django.db.models.fields.DateField>), ('end', <django.db.models.fields.DateField>), ('create_time', <django.db.models.fields.DateTimeField>), ('data', <django.db.models.fields.json.JSONField>)], options={'verbose_name': 'receipt', 'verbose_name_plural': 'receipts', 'default_permissions': ()}>, <CreateModel name='ReceiptTemplate', fields=[('id', <django.db.models.fields.BigAutoField>), ('start', <django.db.models.fields.DateField>), ('data', <django.db.models.fields.json.JSONField>)], options={'verbose_name': 'receipt template', 'verbose_name_plural': 'receipt templates', 'default_permissions': ()}>, <CreateModel name='SalaryLevelCosts', fields=[('id', <django.db.models.fields.BigAutoField>), ('brutto_per_hour', <django.db.models.fields.DecimalField>)], options={'verbose_name': 'salary level costs', 'verbose_name_plural': 'salary level costs', 'default_permissions': ()}>, <CreateModel name='SalaryLevelDate', fields=[('id', <django.db.models.fields.BigAutoField>), ('date', <django.db.models.fields.DateField>)], options={'verbose_name': 'salary interval', 'verbose_name_plural': 'salary intervals', 'default_permissions': ()}>, <AlterField model_name='project', name='department', field=<django.db.models.fields.related.ForeignKey>>, <AddConstraint model_name='salaryleveldate', constraint=<UniqueConstraint: fields=('date',) name='unique_constraint_salary_level_date'>>, <AddField model_name='salarylevelcosts', name='salary_level', field=<django.db.models.fields.related.ForeignKey>>, <AddField model_name='salarylevelcosts', name='start', field=<django.db.models.fields.related.ForeignKey>>, <AddConstraint model_name='receipttemplate', constraint=<UniqueConstraint: fields=('start',) name='unique_constraint_receipt_template_start'>>, <AddField model_name='receipt', name='project', field=<django.db.models.fields.related.ForeignKey>>, <AddField model_name='projectfundedstaffdate', name='project', field=<django.db.models.fields.related.ForeignKey>>, <AddField model_name='projectfundedstaff', name='salary_level', field=<django.db.models.fields.related.ForeignKey>>, <AddField model_name='projectfundedstaff', name='start', field=<django.db.models.fields.related.ForeignKey>>, <AddConstraint model_name='generalcosts', constraint=<UniqueConstraint: fields=('start',) name='unique_constraint_general_costs'>>, <AddConstraint model_name='departmentdate', constraint=<UniqueConstraint: fields=('date',) name='unique_constraint_department_date'>>, <AddField model_name='departmentcosts', name='department', field=<django.db.models.fields.related.ForeignKey>>, <AddField model_name='departmentcosts', name='start', field=<django.db.models.fields.related.ForeignKey>>, <AddConstraint model_name='salarylevelcosts', constraint=<UniqueConstraint: fields=('salary_level', 'start') name='unique_constraint_salary_level_costs'>>, <AddConstraint model_name='receipt', constraint=<CheckConstraint: check=(AND: ('start__lte', F(end))) name='interval_check_receipt'>>, <AddConstraint model_name='projectfundedstaffdate', constraint=<UniqueConstraint: fields=('date', 'project') name='unique_constraint_project_funded_staff_date'>>, <AddConstraint model_name='projectfundedstaff', constraint=<UniqueConstraint: fields=('salary_level', 'start') name='unique_constraint_project_funded_staff'>>, <AddConstraint model_name='departmentcosts', constraint=<UniqueConstraint: fields=('department', 'start') name='unique_constraint_department_costs'>>]
Inherited Members
django.db.migrations.migration.Migration
Migration
run_before
replaces
initial
atomic
name
app_label
mutate_state
apply
unapply
suggest_name