# Generated by Django 5.2.17 on 2026-09-27 18:04

import django.core.validators
import django.db.models.deletion
import django.db.models.functions.text
import uuid
from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('catalog', '0002_deviceidentificationpolicy'),
    ]

    operations = [
        migrations.CreateModel(
            name='PartCategory',
            fields=[
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ('code', models.CharField(max_length=64, unique=True, validators=[django.core.validators.RegexValidator('^[A-Z0-9][A-Z0-9_-]*$', 'Use uppercase letters, digits, hyphens and underscores.')])),
                ('name', models.CharField(max_length=200)),
                ('description', models.TextField(blank=True, validators=[django.core.validators.MaxLengthValidator(4000)])),
                ('is_active', models.BooleanField(default=True)),
            ],
            options={
                'verbose_name_plural': 'part categories',
                'ordering': ['code'],
                'constraints': [models.CheckConstraint(condition=models.Q(('code__regex', '^[A-Z0-9][A-Z0-9_-]*$')), name='parts_category_code_format'), models.CheckConstraint(condition=models.Q(models.Q(('name', ''), _negated=True), ('name', django.db.models.functions.text.Trim('name'))), name='parts_category_name_trimmed')],
            },
        ),
        migrations.CreateModel(
            name='SparePart',
            fields=[
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ('part_code', models.CharField(max_length=64, unique=True, validators=[django.core.validators.RegexValidator('^[A-Z0-9][A-Z0-9_-]*$', 'Use uppercase letters, digits, hyphens and underscores.')])),
                ('name', models.CharField(max_length=200)),
                ('description', models.TextField(blank=True, validators=[django.core.validators.MaxLengthValidator(4000)])),
                ('manufacturer_part_number', models.CharField(blank=True, max_length=128)),
                ('serialization_policy', models.CharField(choices=[('NOT_SERIALIZED', 'Not serialized'), ('OPTIONAL_SERIAL', 'Optional serial'), ('REQUIRED_SERIAL', 'Required serial')], max_length=20)),
                ('is_active', models.BooleanField(default=True)),
                ('category', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='spare_parts', to='parts.partcategory')),
            ],
            options={
                'ordering': ['part_code'],
            },
        ),
        migrations.CreateModel(
            name='SparePartCompatibility',
            fields=[
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
                ('is_active', models.BooleanField(default=True)),
                ('product_model', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='spare_part_compatibilities', to='catalog.productmodel')),
                ('product_variant', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='spare_part_compatibilities', to='catalog.productvariant')),
                ('spare_part', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='compatibilities', to='parts.sparepart')),
            ],
            options={
                'verbose_name_plural': 'spare part compatibilities',
                'ordering': ['created_at', 'id'],
            },
        ),
        migrations.AddConstraint(
            model_name='sparepart',
            constraint=models.CheckConstraint(condition=models.Q(('part_code__regex', '^[A-Z0-9][A-Z0-9_-]*$')), name='parts_part_code_format'),
        ),
        migrations.AddConstraint(
            model_name='sparepart',
            constraint=models.CheckConstraint(condition=models.Q(models.Q(('name', ''), _negated=True), ('name', django.db.models.functions.text.Trim('name'))), name='parts_part_name_trimmed'),
        ),
        migrations.AddConstraint(
            model_name='sparepart',
            constraint=models.CheckConstraint(condition=models.Q(('serialization_policy__in', ['NOT_SERIALIZED', 'OPTIONAL_SERIAL', 'REQUIRED_SERIAL'])), name='parts_serialization_policy_valid'),
        ),
        migrations.AddConstraint(
            model_name='sparepartcompatibility',
            constraint=models.CheckConstraint(condition=models.Q(models.Q(('product_model__isnull', False), ('product_variant__isnull', True)), models.Q(('product_model__isnull', True), ('product_variant__isnull', False)), _connector='OR'), name='parts_compat_exactly_one_target'),
        ),
        migrations.AddConstraint(
            model_name='sparepartcompatibility',
            constraint=models.UniqueConstraint(fields=('spare_part', 'product_model'), name='parts_compat_model_unique'),
        ),
        migrations.AddConstraint(
            model_name='sparepartcompatibility',
            constraint=models.UniqueConstraint(fields=('spare_part', 'product_variant'), name='parts_compat_variant_unique'),
        ),
    ]