"""Update system column

Revision ID: f8bf40be74a1
Revises: 1b2409e7f83a
Create Date: 2021-06-23 14:11:24.166145

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'f8bf40be74a1'
down_revision = '1b2409e7f83a'
branch_labels = None
depends_on = None


def upgrade():
    op.execute(r"update cmf_person set system = 't' where id like '%\:00000000-0000-0000-%'")
    op.execute(r"update cmf_person_group set system = 't' where id like '%\:00000000-0000-0000-%'")
    op.execute(r"update cmf_unit set system = 't' where id like '%\:00000000-0000-0000-%'")
    op.execute(r"update cmf_currency set system = 't' where id like '%\:00000000-0000-0000-%'")
    op.execute(r"update cmf_chat_group set system = 't' where code = 'user'")
    op.execute(r"update cmf_status set system = 't' where id like '%\:00000000-0000-0000-%'")


def downgrade():
    pass