"""total spend default value

Revision ID: bbdb0b646783
Revises: 0867f18fc4a3
Create Date: 2019-07-12 11:04:36.470801

"""
from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql

# revision identifiers, used by Alembic.
from models.projects import Project

revision = 'bbdb0b646783'
down_revision = '0867f18fc4a3'
branch_labels = None
depends_on = None

class Campaign(Project):
    __tablename__ = "Campaign"

def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    connection = op.get_bind()

    stmt = Campaign.__table__.update().values(
        total_spend=0
    ).where(
        Campaign.total_spend.is_(None)
    )

    connection.execute(stmt)