Produits Entr'ouvert » Passerelle

# -*- coding: utf-8 -*-

# Generated by Django 1.11.18 on 2020-05-04 12:06

from __future__ import unicode_literals

from django.db import migrations

from passerelle.utils.db import EnsureJsonbType

class Migration(migrations.Migration):

    dependencies = [

        ('atos_genesys', '0003_auto_20200504_1402'),

    ]

    operations = [

        EnsureJsonbType(model_name='Link', field_name='extra'),

    ]

# -*- coding: utf-8 -*-

# Generated by Django 1.11.18 on 2020-05-04 12:06

from __future__ import unicode_literals

from django.db import migrations

from passerelle.utils.db import EnsureJsonbType

class Migration(migrations.Migration):

    dependencies = [

        ('base_adresse', '0017_auto_20200504_1402'),

    ]

    operations = [

        EnsureJsonbType(model_name='AddressCacheModel', field_name='data'),

    ]

# -*- coding: utf-8 -*-

# Generated by Django 1.11.18 on 2020-05-04 12:06

from __future__ import unicode_literals

from django.db import migrations

from passerelle.utils.db import EnsureJsonbType

class Migration(migrations.Migration):

    dependencies = [

        ('cartads_cs', '0011_cartadsdossier_cartads_cache_infos'),

    ]

    operations = [

        EnsureJsonbType(model_name='CartaDSDataCache', field_name='data_parameters'),

        EnsureJsonbType(model_name='CartaDSDataCache', field_name='data_values'),

        EnsureJsonbType(model_name='cartadsdossier', field_name='cartads_steps_cache'),

        EnsureJsonbType(model_name='cartadsdossier', field_name='cartads_cache_infos'),

    ]

# -*- coding: utf-8 -*-

# Generated by Django 1.11.18 on 2020-05-04 12:06

from __future__ import unicode_literals

from django.db import migrations

from passerelle.utils.db import EnsureJsonbType

class Migration(migrations.Migration):

    dependencies = [

        ('csvdatasource', '0017_auto_20200504_1402'),

    ]

    operations = [

        EnsureJsonbType(model_name='csvdatasource', field_name='_dialect_options'),

        EnsureJsonbType(model_name='TableRow', field_name='data'),

    ]

# -*- coding: utf-8 -*-

# Generated by Django 1.11.18 on 2020-05-04 12:06

from __future__ import unicode_literals

from django.db import migrations

from passerelle.utils.db import EnsureJsonbType

class Migration(migrations.Migration):

    dependencies = [

        ('gesbac', '0003_auto_20200504_1402'),

    ]

    operations = [

        EnsureJsonbType(model_name='Form', field_name='demand_data'),

        EnsureJsonbType(model_name='Form', field_name='card_data'),

    ]

# -*- coding: utf-8 -*-

# Generated by Django 1.11.18 on 2020-05-04 12:06

from __future__ import unicode_literals

from django.db import migrations

from passerelle.utils.db import EnsureJsonbType

class Migration(migrations.Migration):

    dependencies = [

        ('jsondatastore', '0007_auto_20200504_1402'),

    ]

    operations = [

        EnsureJsonbType(model_name='JsonData', field_name='content'),

    ]

# -*- coding: utf-8 -*-

# Generated by Django 1.11.18 on 2020-05-04 12:06

from __future__ import unicode_literals

from django.db import migrations

from passerelle.utils.db import EnsureJsonbType

class Migration(migrations.Migration):

    dependencies = [

        ('mdel_ddpacs', '0002_auto_20200504_1402'),

    ]

    operations = [

        EnsureJsonbType(model_name='Demand', field_name='data'),

    ]

# -*- coding: utf-8 -*-

# Generated by Django 1.11.18 on 2020-05-04 12:06

from __future__ import unicode_literals

from django.db import migrations

from passerelle.utils.db import EnsureJsonbType

class Migration(migrations.Migration):

    dependencies = [

        ('opengis', '0010_auto_20200504_1402'),

    ]

    operations = [

        EnsureJsonbType(model_name='FeatureCache', field_name='data'),

    ]

# -*- coding: utf-8 -*-

# Generated by Django 1.11.18 on 2020-05-04 12:06

from __future__ import unicode_literals

from django.db import migrations

from passerelle.utils.db import EnsureJsonbType

class Migration(migrations.Migration):

    dependencies = [

        ('pastell', '0007_auto_20200504_1402'),

    ]

    operations = [

        EnsureJsonbType(model_name='Pastell', field_name='document_fields'),

    ]

# -*- coding: utf-8 -*-

# Generated by Django 1.11.18 on 2020-05-04 12:06

from __future__ import unicode_literals

from django.db import migrations

from passerelle.utils.db import EnsureJsonbType

class Migration(migrations.Migration):

    dependencies = [

        ('phonecalls', '0001_initial'),

    ]

    operations = [

        EnsureJsonbType(model_name='Call', field_name='details'),

    ]

# -*- coding: utf-8 -*-

# Generated by Django 1.11.18 on 2020-05-04 12:06

from __future__ import unicode_literals

from django.db import migrations

from passerelle.utils.db import EnsureJsonbType

class Migration(migrations.Migration):

    dependencies = [

        ('sp_fr', '0002_auto_20200504_1402'),

    ]

    operations = [

        EnsureJsonbType(model_name='Mapping', field_name='rules'),

    ]

# -*- coding: utf-8 -*-

# Generated by Django 1.11.18 on 2020-05-04 12:06

from __future__ import unicode_literals

from django.db import migrations

from passerelle.utils.db import EnsureJsonbType

class Migration(migrations.Migration):

    dependencies = [

        ('base', '0018_smslog'),

    ]

    operations = [

        EnsureJsonbType(model_name='ResourceLog', field_name='extra'),

        EnsureJsonbType(model_name='Job', field_name='parameters'),

        EnsureJsonbType(model_name='Job', field_name='status_details'),

    ]

# -*- coding: utf-8 -*-

# Generated by Django 1.11.18 on 2020-05-04 12:06

from __future__ import unicode_literals

from django.db import migrations

from passerelle.utils.db import EnsureJsonbType

class Migration(migrations.Migration):

    dependencies = [

        ('fake_family', '0005_auto_20200504_1402'),

    ]

    operations = [

        EnsureJsonbType(model_name='FakeFamily', field_name='jsondatabase'),

    ]

# -*- coding: utf-8 -*-

# Generated by Django 1.11.18 on 2020-05-04 12:06

from __future__ import unicode_literals

from django.db import migrations

from passerelle.utils.db import EnsureJsonbType

class Migration(migrations.Migration):

    dependencies = [

        ('meyzieu_newsletters', '0004_remove_meyzieunewsletters_log_level'),

    ]

    operations = [

        EnsureJsonbType(model_name='MeyzieuNewsletters', field_name='transport_titles_mapping'),

    ]

# -*- coding: utf-8 -*-

# Generated by Django 1.11.18 on 2020-05-04 12:06

from __future__ import unicode_literals

from django.db import migrations

from passerelle.utils.db import EnsureJsonbType

class Migration(migrations.Migration):

    dependencies = [

        ('planitech', '0005_auto_20200504_1402'),

    ]

    operations = [

        EnsureJsonbType(model_name='planitechconnector', field_name='custom_fields'),

    ]

# -*- coding: utf-8 -*-

# Generated by Django 1.11.18 on 2020-05-04 12:06

from __future__ import unicode_literals

from django.db import migrations

from passerelle.utils.db import EnsureJsonbType

class Migration(migrations.Migration):

    dependencies = [

        ('teamnet_axel', '0008_auto_20200504_1402'),

    ]

    operations = [

        EnsureJsonbType(model_name='TeamnetAxel', field_name='billing_regies'),

    ]

from django.db.migrations.operations.base import Operation

class EnsureJsonbType(Operation):

    reversible = False

    def __init__(self, model_name, field_name):

        self.model_name = model_name

        self.field_name = field_name

    def state_forwards(self, app_label, state):

        pass

    def database_forwards(self, app_label, schema_editor, from_state, to_state):

        model = from_state.apps.get_model(app_label, self.model_name)

        table_name = model._meta.db_table

        field = model._meta.get_field(self.field_name)

        _, column_name = field.get_attname_column()

        with schema_editor.connection.cursor() as cursor:

            cursor.execute(

                'SELECT data_type FROM information_schema.columns WHERE table_name = %s AND '

                'column_name = %s;', (table_name, column_name)

            )

            current_type = cursor.fetchone()[0].lower()

            if current_type != 'jsonb':

                assert current_type in ('json', 'text')

                cursor.execute(

                    'ALTER TABLE {table} ALTER COLUMN {col} TYPE jsonb USING {col}::jsonb;'

                    .format(table=table_name, col=column_name)

                )

    def describe(self):

        return "Migrate to postgres jsonb type"