"""delete_empty_company_contacts

Revision ID: 3343f4239ce8
Revises: 454901229e5b
Create Date: 2021-06-04 09:43:06.453903

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '3343f4239ce8'
down_revision = '454901229e5b'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.execute(
        '''UPDATE cmf_person
             SET cmf_deleted = TRUE
              WHERE company_id IS NULL
              AND id NOT IN 
            (
                SELECT cmf_person_group_rg_members.right_id FROM cmf_person 
                LEFT JOIN cmf_person_group_rg_members ON cmf_person_group_rg_members.right_id = cmf_person.id
                INNER JOIN cmf_person_group ON cmf_person_group.id = cmf_person_group_rg_members.left_id
                WHERE cmf_person_group.code = 'user'
            )''')
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    pass
    # ### end Alembic commands ###