"""pipeline_status

Revision ID: fede06177f16
Revises: 3e33cc123e7e
Create Date: 2021-01-14 13:46:13.666992

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

# revision identifiers, used by Alembic.
revision = 'fede06177f16'
down_revision = '4f0a134f7711'
branch_labels = None
depends_on = None


def upgrade():
    with APP.test_request_context('/'):
        # Воронка продаж
        models.CmfStatus(
            name="Первичный контакт",
            text="",
            status_type="open",
            color="#99ccff",
            kanban=True,
            cmf_model="CmfDeal",
            cmf_model_activity="sales",
            orderno=10
        ).save()
        models.CmfStatus(
            name="Переговоры",
            text="",
            status_type="in_progress",
            color="#ffff99",
            kanban=True,
            cmf_model="CmfDeal",
            cmf_model_activity="sales",
            orderno=20
        ).save()
        models.CmfStatus(
            name="Принимают решение",
            text="",
            status_type="in_progress",
            color="#ffcc66",
            kanban=True,
            cmf_model="CmfDeal",
            cmf_model_activity="sales",
            orderno=30
        ).save()
        models.CmfStatus(
            name="Согласование договора",
            text="",
            status_type="in_progress",
            color="#ffcccc",
            kanban=True,
            cmf_model="CmfDeal",
            cmf_model_activity="sales",
            orderno=40
        ).save()
        models.CmfStatus(
            name="Отмена",
            text="",
            status_type="closed",
            color="#333f4f",
            kanban=True,
            cmf_model="CmfDeal",
            cmf_model_activity="sales",
            orderno=50
        ).save()
        models.CmfStatus(
            name="Закрыто удачно",
            text="",
            status_type="closed",
            color="rgb(39, 190, 127)",
            kanban=True,
            cmf_model="CmfDeal",
            cmf_model_activity="sales",
            orderno=60
        ).save()


def downgrade():
    pass