"""user table

Revision ID: aa65d380908a
Revises: 23ea93cd533f
Create Date: 2020-10-16 10:34:05.598596

"""


from alembic import op
import sqlalchemy as sa
import sys
from pathlib import Path
sys.path.append(str(Path(".").resolve()))
from cmf.manage import *

# revision identifiers, used by Alembic.
revision = 'aa65d380908a'
down_revision = '23ea93cd533f'
branch_labels = None
depends_on = None


def upgrade():
    with APP.test_request_context('/'):
        # миграция бажит при мигрировании со старой версии
        return
        grp = models.CmfPersonGroup(id="CmfPersonGroup:00000000-0000-0000-0000-000000000028",
                                    name="User", text="Пользователи", code='user').save()
        for user in models.CmfPerson.list(is_internal=True, fields=['rg_member_of']):
            user.rg_member_of.append(grp)
            user.save(only_data=True)


def downgrade():
    with APP.test_request_context('/'):
        # миграция бажит при мигрировании со старой версии
        return
        group = models.CmfPersonGroup.get("CmfPersonGroup:00000000-0000-0000-0000-000000000028")
        for user in models.CmfPerson.list(rg_member_of="CmfPersonGroup:00000000-0000-0000-0000-000000000028",
                                          fields=['rg_member_of']):
            user.rg_member_of.remove(group)
            user.save(only_data=True)
        type(group).dp.delete(group)