from decimal import Decimal

from django.db import migrations, models


# Common corridor VAT percents (GCC + frequent origins). Missing countries default to 0% at runtime.
_SEED_RATES = {
    'AE': Decimal('5.00'),
    'SA': Decimal('15.00'),
    'BH': Decimal('10.00'),
    'OM': Decimal('5.00'),
    'QA': Decimal('0.00'),
    'KW': Decimal('0.00'),
    'EG': Decimal('14.00'),
    'PK': Decimal('0.00'),
}


def seed_country_vat_rates(apps, schema_editor):
    CountryVatRate = apps.get_model('core', 'CountryVatRate')
    for code, rate in _SEED_RATES.items():
        CountryVatRate.objects.update_or_create(
            country_code=code,
            defaults={'vat_rate_percent': rate, 'is_active': True},
        )


class Migration(migrations.Migration):

    dependencies = [
        ('core', '0040_trip_cancel_and_cancelled_status'),
    ]

    operations = [
        migrations.CreateModel(
            name='CountryVatRate',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('country_code', models.CharField(max_length=2, unique=True)),
                ('vat_rate_percent', models.DecimalField(
                    decimal_places=2,
                    help_text='VAT percentage, e.g. 5.00 for 5%.',
                    max_digits=6,
                )),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
            ],
            options={
                'verbose_name': 'Country VAT rate',
                'verbose_name_plural': 'Country VAT rates',
                'ordering': ['country_code'],
            },
        ),
        migrations.RunPython(seed_country_vat_rates, migrations.RunPython.noop),
    ]
