Files
ms 2c1c48df0c
PostgreSQL integration / tests (push) Has been cancelled
init
2026-11-09 13:15:48 +01:00

190 lines
9.3 KiB
Python

# Generated by Django 5.2.19 on 2026-11-04 17:06
import django.db.models.deletion
import uuid
from django.conf import settings
from django.db import migrations, models
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Audit',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('at', models.DateTimeField(auto_now_add=True)),
('actor', models.CharField(max_length=150)),
('action', models.CharField(max_length=200)),
('details', models.JSONField(default=dict)),
],
),
migrations.CreateModel(
name='Configuration',
fields=[
('id', models.PositiveSmallIntegerField(default=1, editable=False, primary_key=True, serialize=False)),
('retention_days', models.PositiveIntegerField(default=90)),
('heartbeat_timeout', models.PositiveIntegerField(default=60)),
('cpu_warning', models.PositiveIntegerField(default=85)),
('ram_warning', models.PositiveIntegerField(default=90)),
('disk_warning', models.PositiveIntegerField(default=90)),
('updated_at', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Segment',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=100, unique=True)),
('cidr', models.CharField(blank=True, max_length=100)),
],
),
migrations.CreateModel(
name='AccessToken',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('digest', models.CharField(max_length=64, unique=True)),
('expires_at', models.DateTimeField(db_index=True)),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Alarm',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('code', models.CharField(max_length=80)),
('severity', models.CharField(default='warning', max_length=20)),
('message', models.CharField(max_length=400)),
('opened_at', models.DateTimeField(auto_now_add=True)),
('resolved_at', models.DateTimeField(blank=True, null=True)),
('acknowledged_at', models.DateTimeField(blank=True, null=True)),
('acknowledged_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Notification',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('sent_at', models.DateTimeField(blank=True, null=True)),
('attempts', models.IntegerField(default=0)),
('next_attempt', models.DateTimeField()),
('last_error', models.CharField(blank=True, max_length=100)),
('alarm', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to='monitoring.alarm')),
],
),
migrations.CreateModel(
name='Server',
fields=[
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
('name', models.CharField(max_length=150, unique=True)),
('address', models.CharField(blank=True, max_length=255)),
('enabled', models.BooleanField(default=True)),
('maintenance', models.BooleanField(default=False)),
('last_seen', models.DateTimeField(blank=True, null=True)),
('latest_sample_at', models.DateTimeField(blank=True, null=True)),
('latest', models.JSONField(blank=True, default=dict)),
('created_at', models.DateTimeField(auto_now_add=True)),
('segment', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='monitoring.segment')),
],
),
migrations.CreateModel(
name='Event',
fields=[
('id', models.UUIDField(primary_key=True, serialize=False)),
('kind', models.CharField(db_index=True, max_length=50)),
('occurred_at', models.DateTimeField(db_index=True)),
('received_at', models.DateTimeField(auto_now_add=True, db_index=True)),
('payload', models.JSONField(default=dict)),
('server', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='monitoring.server')),
],
),
migrations.AddField(
model_name='alarm',
name='server',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='monitoring.server'),
),
migrations.CreateModel(
name='AgentCredential',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('digest', models.CharField(max_length=64, unique=True)),
('label', models.CharField(default='agent', max_length=100)),
('active', models.BooleanField(default=True)),
('created_at', models.DateTimeField(auto_now_add=True)),
('server', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='monitoring.server')),
],
),
migrations.CreateModel(
name='Task',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('task_id', models.CharField(max_length=200)),
('name', models.CharField(blank=True, max_length=255)),
('worker', models.CharField(blank=True, max_length=255)),
('state', models.CharField(max_length=30)),
('first_at', models.DateTimeField()),
('last_at', models.DateTimeField(db_index=True)),
('runtime', models.FloatField(blank=True, null=True)),
('retries', models.IntegerField(default=0)),
('server', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='monitoring.server')),
],
),
migrations.CreateModel(
name='Worker',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('hostname', models.CharField(max_length=255)),
('last_seen', models.DateTimeField()),
('online', models.BooleanField(default=True)),
('active', models.IntegerField(default=0)),
('processed', models.BigIntegerField(default=0)),
('server', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='monitoring.server')),
],
),
migrations.CreateModel(
name='Metric',
fields=[
('event', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='monitoring.event')),
('at', models.DateTimeField(db_index=True)),
('cpu', models.FloatField()),
('ram', models.FloatField()),
('disk', models.FloatField()),
('server', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='monitoring.server')),
],
),
migrations.AddIndex(
model_name='event',
index=models.Index(fields=['server', 'occurred_at'], name='monitoring__server__5462e1_idx'),
),
migrations.AddIndex(
model_name='event',
index=models.Index(fields=['server', 'kind', 'occurred_at'], name='monitoring__server__c2dfbb_idx'),
),
migrations.AddConstraint(
model_name='alarm',
constraint=models.UniqueConstraint(condition=models.Q(('resolved_at__isnull', True)), fields=('server', 'code'), name='one_open_alarm'),
),
migrations.AddIndex(
model_name='task',
index=models.Index(fields=['server', 'last_at'], name='monitoring__server__712f75_idx'),
),
migrations.AddConstraint(
model_name='task',
constraint=models.UniqueConstraint(fields=('server', 'task_id'), name='unique_task_per_collector'),
),
migrations.AddConstraint(
model_name='worker',
constraint=models.UniqueConstraint(fields=('server', 'hostname'), name='unique_worker_per_collector'),
),
migrations.AddIndex(
model_name='metric',
index=models.Index(fields=['server', 'at'], name='monitoring__server__0da9e8_idx'),
),
]