"""cust_field

Revision ID: d5e9bba25ca6
Revises: de35641345bb
Create Date: 2024-05-06 10:10:32.908490

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'd5e9bba25ca6'
down_revision = 'de35641345bb'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    # Сбрасываем старые значения, у клиентов еще нет этого функционала
    op.execute("update cmf_cust_field set \"default\" = '{\"value\": null}'")
    op.execute("update cmf_cust_field_conf_field set \"default\" = '{\"value\": null}' where \"default\" is null")
    op.execute("update cmf_cust_field_conf_field set \"default\" = '{\"value\": \"_NONE_\"}' where \"default\" <> '{\"value\": null}'")
    
    op.alter_column('cmf_cust_field', 'default',
               existing_type=sa.TEXT(),
               nullable=False)
    op.alter_column('cmf_cust_field_conf_field', 'default',
               existing_type=sa.VARCHAR(),
               type_=sa.TEXT(),
               nullable=False)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.alter_column('cmf_cust_field_conf_field', 'default',
               existing_type=sa.TEXT(),
               type_=sa.VARCHAR(),
               nullable=True)
    op.alter_column('cmf_cust_field', 'default',
               existing_type=sa.TEXT(),
               nullable=True)
    # ### end Alembic commands ###