# Generated by Django 3.1.3 on 2020-11-16 11:48
import apps.core.models.reservation
import apps.core.models.sensor
from django.db import migrations, models
import django.db.models.deletion
import django_enum_choices.choice_builders
import django_enum_choices.fields
import uuid
[docs]class Migration(migrations.Migration):
dependencies = [
('core', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Area',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False, unique=True)),
('delete_at', models.DateTimeField(null=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('created_at', models.DateTimeField(auto_now_add=True)),
('office_name', models.CharField(max_length=50)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Device',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False, unique=True)),
('delete_at', models.DateTimeField(null=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('created_at', models.DateTimeField(auto_now_add=True)),
('battery_state', models.PositiveSmallIntegerField()),
('version', models.CharField(max_length=50)),
('human_readable_name', models.CharField(max_length=50)),
('ipv6_address', models.GenericIPAddressField(protocol='IPv6')),
('last_data', models.DateTimeField(auto_now=True)),
('type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.devicetype')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='PhysicalUnit',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False, unique=True)),
('unit_name', models.CharField(max_length=50)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Sensor',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False, unique=True)),
('delete_at', models.DateTimeField(null=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('created_at', models.DateTimeField(auto_now_add=True)),
('sensor_type', django_enum_choices.fields.EnumChoiceField(choice_builder=django_enum_choices.choice_builders.value_value, choices=[('air', 'air'), ('temperature', 'temperature')], enum_class=apps.core.models.sensor.SensorEnum, max_length=11)),
('configuration', models.CharField(max_length=50)),
('unit_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.physicalunit')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Reservation',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False, unique=True)),
('delete_at', models.DateTimeField(null=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('created_at', models.DateTimeField(auto_now_add=True)),
# ('reservation_state', django_enum_choices.fields.EnumChoiceField(choice_builder=django_enum_choices.choice_builders.value_value, choices=[('free', 'free'), ('reserved', 'reserved')], enum_class=apps.core.models.reservation.ReservationEnum, max_length=8)),
('owner', models.CharField(max_length=30)),
('time_from', models.DateTimeField(auto_now=True)),
('time_to', models.DateTimeField(auto_now=True)),
('area_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.area')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Measurement',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False, unique=True)),
('delete_at', models.DateTimeField(null=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('created_at', models.DateTimeField(auto_now_add=True)),
('datetime', models.DateTimeField(auto_now=True)),
('value', models.DecimalField(decimal_places=5, max_digits=10)),
('measurement_type', models.CharField(max_length=30)),
('device_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.device')),
('physical_units_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.physicalunit')),
('sensor_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.sensor')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='DeviceTypeSensor',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False, unique=True)),
('sensor', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.sensor')),
('type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.devicetype')),
],
options={
'abstract': False,
},
),
migrations.AddField(
model_name='area',
name='device',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.device'),
),
migrations.AddField(
model_name='area',
name='subarea',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.area'),
),
]