Resolve "Models for advanced features from SchoolApps (imported from Untis)"

Closes #58 (closed)

aleksis/apps/chronos/migrations/0007_advanced_models_from_untis.py

+# Generated by Django 3.0.3 on 2020-03-08 20:16
+
+import colorfield.fields
+import django.contrib.postgres.fields.jsonb
+from django.db import migrations, models
+import django.db.models.deletion
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('chronos', '0006_extended_data'),
+    ]
+
+    operations = [
+        migrations.CreateModel(
+            name='Absence',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('extended_data', django.contrib.postgres.fields.jsonb.JSONField(default=dict, editable=False)),
+                ('date_start', models.DateField(null=True, verbose_name='Effective start date of absence')),
+                ('date_end', models.DateField(null=True, verbose_name='Effective end date of absence')),
+                ('comment', models.TextField(verbose_name='Comment', null=True, blank=True)),
+            ],
+            options={
+                'verbose_name': 'Absence',
+                'verbose_name_plural': 'Absences',
+                'ordering': ['date_start'],
+            },
+        ),
+        migrations.CreateModel(
+            name='AbsenceReason',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('extended_data', django.contrib.postgres.fields.jsonb.JSONField(default=dict, editable=False)),
+                ('title', models.CharField(max_length=50, verbose_name='Title')),
+                ('description', models.TextField(verbose_name='Description', null=True, blank=True)),
+            ],
+            options={
+                'verbose_name': 'Absence reason',
+                'verbose_name_plural': 'Absence reasons',
+            },
+        ),
+        migrations.CreateModel(
+            name='Event',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('extended_data', django.contrib.postgres.fields.jsonb.JSONField(default=dict, editable=False)),
+                ('title', models.CharField(max_length=50, verbose_name='Title')),
+                ('date_start', models.DateField(null=True, verbose_name='Effective start date of event')),
+                ('date_end', models.DateField(null=True, verbose_name='Effective end date of event')),
+            ],
+            options={
+                'verbose_name': 'Events',
+                'verbose_name_plural': 'Events',
+                'ordering': ['date_start'],
+            },
+        ),
+        migrations.CreateModel(
+            name='Exam',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('extended_data', django.contrib.postgres.fields.jsonb.JSONField(default=dict, editable=False)),
+                ('date', models.DateField(null=True, verbose_name='Date of exam')),
+                ('title', models.CharField(max_length=50, verbose_name='Title')),
+                ('comment', models.TextField(verbose_name='Comment', null=True, blank=True)),
+            ],
+            options={
+                'verbose_name': 'Exam',
+                'verbose_name_plural': 'Exams',
+                'ordering': ['date'],
+            },
+        ),
+        migrations.CreateModel(
+            name='Holiday',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('extended_data', django.contrib.postgres.fields.jsonb.JSONField(default=dict, editable=False)),
+                ('title', models.CharField(max_length=50, verbose_name='Title of the holidays')),
+                ('date_start', models.DateField(null=True, verbose_name='Effective start date of holidays')),
+                ('date_end', models.DateField(null=True, verbose_name='Effective end date of holidays')),
+                ('comments', models.TextField(verbose_name='Comments', null=True, blank=True)),
+            ],
+            options={
+                'verbose_name': 'Holiday',
+                'verbose_name_plural': 'Holidays',
+                'ordering': ['date_start'],
+            },
+        ),
+        migrations.CreateModel(
+            name='SupervisionArea',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('extended_data', django.contrib.postgres.fields.jsonb.JSONField(default=dict, editable=False)),
+                ('short_name', models.CharField(max_length=10, verbose_name='Short name')),
+                ('name', models.CharField(max_length=50, verbose_name='Long name')),
+                ('colour_fg', colorfield.fields.ColorField(default='#000000', max_length=18)),
+                ('colour_bg', colorfield.fields.ColorField(default='#FFFFFF', max_length=18)),
+            ],
+            options={
+                'verbose_name': 'Supervision areas',
+                'verbose_name_plural': 'Supervision areas',
+                'ordering': ['name'],
+            },
+        ),
+        migrations.CreateModel(
+            name='Break',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('extended_data', django.contrib.postgres.fields.jsonb.JSONField(default=dict, editable=False)),
+                ('short_name', models.CharField(max_length=10, verbose_name='Short name')),
+                ('name', models.CharField(max_length=50, verbose_name='Long name')),
+                ('weekday', models.PositiveSmallIntegerField(
+                    choices=[(0, 'Montag'), (1, 'Dienstag'), (2, 'Mittwoch'), (3, 'Donnerstag'), (4, 'Freitag'),
+                             (5, 'Samstag'), (6, 'Sonntag')], verbose_name='Week day')),
+                ('time_start', models.TimeField(verbose_name='Start time')),
+                ('time_end', models.TimeField(verbose_name='End time')),
+            ],
+            options={
+                'verbose_name': 'Break',
+                'verbose_name_plural': 'Breaks',
+                'ordering': ['weekday', 'time_start'],
+            },
+        ),
+        migrations.CreateModel(
+            name='Supervision',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('extended_data', django.contrib.postgres.fields.jsonb.JSONField(default=dict, editable=False)),
+            ],
+            options={
+                'verbose_name': 'Supervision',
+                'verbose_name_plural': 'Supervisions',
+                'ordering': ['area', 'break_item'],
+            },
+        ),
+        migrations.CreateModel(
+            name='SupervisionSubstitution',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('extended_data', django.contrib.postgres.fields.jsonb.JSONField(default=dict, editable=False)),
+                ('date', models.DateField(verbose_name='Date')),
+            ],
+            options={
+                'verbose_name': 'Supervision substitution',
+                'verbose_name_plural': 'Supervision substitutions',
+                'ordering': ['date', 'supervision'],
+            },
+        ),
+        migrations.AddIndex(
+            model_name='holiday',
+            index=models.Index(fields=['date_start', 'date_end'], name='chronos_hol_date_st_a47004_idx'),
+        ),
+        migrations.AddField(
+            model_name='exam',
+            name='lesson',
+            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='exams', to='chronos.Lesson'),
+        ),
+        migrations.AddField(
+            model_name='exam',
+            name='period_from',
+            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='+', to='chronos.TimePeriod', verbose_name='Effective start period of exam'),
+        ),
+        migrations.AddField(
+            model_name='exam',
+            name='period_to',
+            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='+', to='chronos.TimePeriod', verbose_name='Effective end period of exam'),
+        ),
+        migrations.AddField(
+            model_name='event',
+            name='absence_reason',
+            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='absence_reason', to='chronos.AbsenceReason', verbose_name='Absence reason'),
+        ),
+        migrations.AddField(
+            model_name='event',
+            name='teachers',
+            field=models.ManyToManyField(related_name='events', to='core.Person', verbose_name='Teachers'),
+        ),
+        migrations.AddField(
+            model_name='event',
+            name='period_from',
+            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='+', to='chronos.TimePeriod', verbose_name='Effective start period of event'),
+        ),
+        migrations.AddField(
+            model_name='event',
+            name='period_to',
+            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='+', to='chronos.TimePeriod', verbose_name='Effective end period of event'),
+        ),
+        migrations.AddField(
+            model_name='event',
+            name='rooms',
+            field=models.ManyToManyField(related_name='events', to='chronos.Room', verbose_name='Rooms'),
+        ),
+        migrations.AddField(
+            model_name='absence',
+            name='period_from',
+            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='+', to='chronos.TimePeriod', verbose_name='Effective start period of absence'),
+        ),
+        migrations.AddField(
+            model_name='absence',
+            name='period_to',
+            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='+', to='chronos.TimePeriod', verbose_name='Effective end period of absence'),
+        ),
+        migrations.AddField(
+            model_name='absence',
+            name='person',
+            field=models.ManyToManyField(related_name='absences', to='core.Person'),
+        ),
+        migrations.AddField(
+            model_name='absence',
+            name='reason',
+            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='absences', to='chronos.AbsenceReason'),
+        ),
+        migrations.AddIndex(
+            model_name='exam',
+            index=models.Index(fields=['date'], name='chronos_exa_date_5ba442_idx'),
+        ),
+        migrations.AddIndex(
+            model_name='event',
+            index=models.Index(fields=['period_from', 'period_to', 'date_start', 'date_end'], name='chronos_eve_periodf_56eb18_idx'),
+        ),
+        migrations.AddIndex(
+            model_name='absence',
+            index=models.Index(fields=['date_start', 'date_end'], name='chronos_abs_date_st_337ff5_idx'),
+        ),
+        migrations.AddField(
+            model_name='lessonsubstitution',
+            name='cancelled_for_teachers',
+            field=models.BooleanField(default=False, verbose_name='Cancelled for teachers?'),
+        ),
+        migrations.AddField(
+            model_name='lessonsubstitution',
+            name='comment',
+            field=models.TextField(blank=True, null=True, verbose_name='Comment'),
+        ),
+        migrations.AlterField(
+            model_name='lessonsubstitution',
+            name='cancelled',
+            field=models.BooleanField(default=False, verbose_name='Cancelled?'),
+        ),
+        migrations.AddField(
+            model_name='event',
+            name='groups',
+            field=models.ManyToManyField(related_name='events', to='core.Group', verbose_name='Groups'),
+        ),
+        migrations.AddField(
+            model_name='supervisionsubstitution',
+            name='supervision',
+            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='substitutions',
+                                    to='chronos.Supervision', verbose_name='Supervision'),
+        ),
+        migrations.AddField(
+            model_name='supervisionsubstitution',
+            name='teacher',
+            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
+                                    related_name='substituted_supervisions', to='core.Person', verbose_name='Teacher'),
+        ),
+        migrations.AddField(
+            model_name='supervision',
+            name='area',
+            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='supervisions',
+                                    to='chronos.SupervisionArea', verbose_name='Supervision area'),
+        ),
+        migrations.AddField(
+            model_name='supervision',
+            name='break_item',
+            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='supervisions',
+                                    to='chronos.Break', verbose_name='Break'),
+        ),
+        migrations.AddField(
+            model_name='supervision',
+            name='teacher',
+            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='supervisions',
+                                    to='core.Person', verbose_name='Teacher'),
+        ),
+        migrations.AddIndex(
+            model_name='break',
+            index=models.Index(fields=['weekday', 'time_start', 'time_end'], name='chronos_bre_weekday_165338_idx'),
+        ),
+    ]