"""renameusersadmins

Revision ID: 0b9abe377a7d
Revises: b2ae40ca8fe8
Create Date: 2021-09-27 04:40:25.364725

"""
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 = '0b9abe377a7d'
down_revision = 'b2ae40ca8fe8'
branch_labels = None
depends_on = None


def upgrade():
    pass
    # ### commands auto generated by Alembic - please adjust! ###
    #
    # with APP.test_request_context('/'):
    #     APP.preprocess_request()
    #     ugrp = models.CmfPersonGroup.get(id="CmfPersonGroup:00000000-0000-0000-0000-000000000028")
    #     ugrp.name="Все"
    #     ugrp.code="Users"
    #     ugrp.save(only_data=True)
    #
    #     ugrp = models.CmfPersonGroup.get(id="CmfPersonGroup:00000000-0000-0000-0000-000000000013")
    #     ugrp.name="Admins"
    #     ugrp.code="Admins"
    #     ugrp.save(only_data=True)
    #
    #     myfolders=models.CmfProject.list(filter=['project_type', '=', 'home'])
    #     # myfolders=models.CmfProject.list(filter=['code', 'LIKE', '%@%'])
    #     for f in myfolders:
    #         print(f.code)
    #         f.project_type = 'section'
    #         f.name = f.code
    #         f.cmf_owner = "CmfPerson:00000000-0000-0000-0000-000000000001"
    #         f.save(only_data=True)
    #
    #     chat = models.CmfChatGroup.get(code='user')
    #     if chat:
    #         chat.code='Users'
    #         chat.save(only_data=True)
    #     APP.process_response(make_response(''))

    #op.execute(
    #    """UPDATE cmf_sales_order_items
    #        SET cmf_deleted = true
    #        FROM cmf_sales_order
    #        WHERE cmf_sales_order_items.sales_order_id = cmf_sales_order.id
    #        AND cmf_sales_order.cmf_deleted = true"""
    #)

    # ### end Alembic commands ###


def downgrade():
    pass