✨ Import group: archive

1 files changed, 144 insertions, 0 deletions

diff --git a/ishtar_common/migrations/0230_auto_20230920_1417.py b/ishtar_common/migrations/0230_auto_20230920_1417.py
new file mode 100644
index 000000000..e7a22d119
--- /dev/null
+++ b/ishtar_common/migrations/0230_auto_20230920_1417.py
@@ -0,0 +1,144 @@
+# Generated by Django 2.2.24 on 2023-09-20 14:17
+
+import django.core.validators
+from django.db import migrations, models
+import django.db.models.deletion
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('ishtar_common', '0229_auto_20230608_1303'),
+    ]
+
+    operations = [
+        migrations.CreateModel(
+            name='ImporterGroup',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('name', models.CharField(max_length=200, verbose_name='Name')),
+                ('slug', models.SlugField(max_length=100, unique=True, verbose_name='Slug')),
+                ('description', models.TextField(blank=True, default='', verbose_name='Description')),
+                ('available', models.BooleanField(default=True, verbose_name='Available')),
+            ],
+            options={
+                'verbose_name': 'Importer - Group',
+                'verbose_name_plural': 'Importer - Groups',
+                'ordering': ('name',),
+            },
+        ),
+        migrations.AlterModelOptions(
+            name='import',
+            options={'verbose_name': 'Import - Import', 'verbose_name_plural': 'Import - Imports'},
+        ),
+        migrations.AlterModelOptions(
+            name='itemkey',
+            options={'verbose_name': 'Import - Item key', 'verbose_name_plural': 'Import - Item keys'},
+        ),
+        migrations.AddField(
+            model_name='import',
+            name='next_import',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='imports', to='ishtar_common.Import', verbose_name='Next import'),
+        ),
+        migrations.AddField(
+            model_name='importerdefault',
+            name='required_fields',
+            field=models.CharField(blank=True, default='', help_text='Theses defaults values only apply if the designated fields are not empty. Use the "__" notation to pass between models.Leave empty to always apply.', max_length=500, verbose_name='Required fields'),
+        ),
+        migrations.AddField(
+            model_name='importertype',
+            name='archive_required',
+            field=models.BooleanField(default=False, verbose_name='Archive required'),
+        ),
+        migrations.AddField(
+            model_name='importertype',
+            name='is_import',
+            field=models.BooleanField(default=True, verbose_name='Can be import'),
+        ),
+        migrations.AddField(
+            model_name='importertype',
+            name='pre_import_message',
+            field=models.TextField(blank=True, default='', max_length=500, verbose_name='Pre-import form message'),
+        ),
+        migrations.AddField(
+            model_name='importertype',
+            name='tab_number',
+            field=models.PositiveIntegerField(default=1, help_text='When using an Excel or Calc file choose the tab number. Keep it to 1 by default.', validators=[django.core.validators.MinValueValidator(1)], verbose_name='Tab number'),
+        ),
+        migrations.AlterField(
+            model_name='import',
+            name='imported_images',
+            field=models.FileField(blank=True, help_text='La taille maximale supportée pour le fichier est de 100 Mo.', max_length=220, null=True, upload_to='upload/imports/%Y/%m/', verbose_name='Associated documents (zip file)'),
+        ),
+        migrations.AlterField(
+            model_name='importercolumn',
+            name='col_number',
+            field=models.SmallIntegerField(default=1, help_text='Column number in the table. Put 0 or negative number for pre-importer field.', verbose_name='Column number'),
+        ),
+        migrations.AlterField(
+            model_name='importerdefault',
+            name='target',
+            field=models.CharField(help_text='The target of the default values. Can be set to empty with "-". Use the "__" notation to pass between models.', max_length=500, verbose_name='Target'),
+        ),
+        migrations.AlterField(
+            model_name='ishtarsiteprofile',
+            name='account_naming_style',
+            field=models.CharField(choices=[('NF', 'name.firstname'), ('FN', 'firstname.name')], default='FN', max_length=2, verbose_name='Naming style for accounts'),
+        ),
+        migrations.CreateModel(
+            name='ImportGroup',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('name', models.CharField(max_length=500, null=True, verbose_name='Name')),
+                ('imported_file', models.FileField(blank=True, help_text='La taille maximale supportée pour le fichier est de 100 Mo.', max_length=220, null=True, upload_to='upload/imports/%Y/%m/', verbose_name='Imported file')),
+                ('imported_images', models.FileField(blank=True, help_text='La taille maximale supportée pour le fichier est de 100 Mo.', max_length=220, null=True, upload_to='upload/imports/%Y/%m/', verbose_name='Associated documents (zip file)')),
+                ('archive_file', models.FileField(blank=True, help_text='La taille maximale supportée pour le fichier est de 100 Mo.', max_length=255, null=True, upload_to='upload/imports/%Y/%m/', verbose_name='Archive file')),
+                ('encoding', models.CharField(choices=[('windows-1252', 'windows-1252'), ('ISO-8859-15', 'ISO-8859-15'), ('utf-8', 'utf-8')], default='utf-8', help_text='Only required for CSV file', max_length=15, verbose_name='Encoding')),
+                ('csv_sep', models.CharField(choices=[(',', ','), (';', ';'), ('|', '|')], default=',', help_text='Separator for CSV file. Standard is comma but Microsoft Excel do not follow this standard and use semi-colon.', max_length=1, verbose_name='CSV separator')),
+                ('skip_lines', models.IntegerField(default=1, help_text='Number of header lines in your file (can be 0 and should be 0 for geopackage or Shapefile).', verbose_name='Skip lines')),
+                ('creation_date', models.DateTimeField(auto_now_add=True, null=True, verbose_name='Creation date')),
+                ('end_date', models.DateTimeField(auto_now_add=True, null=True, verbose_name='End date')),
+                ('current_import', models.PositiveIntegerField(blank=True, null=True, verbose_name='Current import')),
+                ('state', models.CharField(choices=[('C', 'Created'), ('AP', 'Analyse in progress'), ('A', 'Analysed'), ('IQ', 'Import in queue'), ('IP', 'Import in progress'), ('PP', 'Post-processing in progress'), ('FE', 'Finished with errors'), ('F', 'Finished'), ('AC', 'Archived')], default='C', max_length=2, verbose_name='State')),
+                ('importer_type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='ishtar_common.ImporterGroup', verbose_name='Importer group type')),
+                ('user', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='ishtar_common.IshtarUser')),
+            ],
+            options={
+                'verbose_name': 'Import - Group',
+                'verbose_name_plural': 'Import - Groups',
+            },
+        ),
+        migrations.AddField(
+            model_name='import',
+            name='group',
+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='imports', to='ishtar_common.ImportGroup', verbose_name='Group'),
+        ),
+        migrations.CreateModel(
+            name='ImporterGroupImporter',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('order', models.PositiveIntegerField(default=10, validators=[django.core.validators.MinValueValidator(1)], verbose_name='Order')),
+                ('group', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='importer_types', to='ishtar_common.ImporterGroup')),
+                ('importer_type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='groups', to='ishtar_common.ImporterType')),
+            ],
+            options={
+                'verbose_name': 'Importer - Group <-> Importer',
+                'ordering': ('group', 'order'),
+                'unique_together': {('group', 'order')},
+            },
+        ),
+        migrations.CreateModel(
+            name='ImportColumnValue',
+            fields=[
+                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+                ('value', models.TextField(blank=True, default='')),
+                ('column', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='ishtar_common.ImporterColumn')),
+                ('import_item', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='ishtar_common.Import')),
+            ],
+            options={
+                'verbose_name': 'Import - Pre-import value',
+                'verbose_name_plural': 'Import - Pre-import values',
+                'unique_together': {('column', 'import_item')},
+            },
+        ),
+    ]