"""crm_system_data

Revision ID: 6b41a7eba769
Revises: 7ed56fdf83b4
Create Date: 2021-01-22 11:50:50.266659

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
from sqlalchemy.ext.automap import automap_base
import sys
from pathlib import Path
sys.path.append(str(Path(".").resolve()))
from cmf.manage import *

revision = '6b41a7eba769'
down_revision = '7ed56fdf83b4'
branch_labels = None
depends_on = None


def upgrade():

    with APP.test_request_context('/'):
        s = models.CmfTask.dp.data_driver.Session()
        Base = automap_base()
        Base.prepare(models.CmfTask.dp.data_driver.engine, reflect=True)
        CmfCurrency = Base.classes.cmf_currency
        CmfUnit = Base.classes.cmf_unit

        s.add(CmfCurrency(name="рубли", code="руб", main=True, cmf_deleted=False,
                          id="CmfCurrency:00000000-0000-0000-0000-000000000030"))
        s.add(CmfUnit(name="штуки", code="шт", cmf_deleted=False,
                      id="CmfUnit:00000000-0000-0000-0000-000000000029"))


def downgrade():
    pass