"""spot_charts_include

Revision ID: c1b1620d599a
Revises: d9eb79668b29
Create Date: 2018-09-20 09:35:15.401840

"""

# revision identifiers, used by Alembic.
revision = 'c1b1620d599a'
down_revision = 'd9eb79668b29'
branch_labels = None
depends_on = None

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

def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('spy_playlist', sa.Column('include_in_charts', sa.Boolean(), server_default=sa.text('true'), nullable=False))

    op.execute('''update spy_playlist set include_in_charts = false where spyid in (
'62nYoBdWTQYtLJzmWqMUTI', '2iMjNpXB1KzwxEryqITNut', '1g4LsUsgYBvR1AiwN16SoI', '7xom7CO8dOHxx9fnGwwrnO',
'2Off9BCbEBMjGZPIUqt22A', '5YDNMmhBA30S9Fd7NFlcYu', '2sNYAK1W6lu0n93UkiitPN', '37i9dQZEVXbKgCVIE0PTOD',
'37i9dQZEVXbIPOivNiyjjS', '37i9dQZEVXbINTEnbFeb8d', '37i9dQZEVXbLiRSasKsNU9', '37i9dQZEVXbJmRv5TqJW16',
'37i9dQZEVXbO5MSE9RdfN2', '37i9dQZEVXbN7gfhgaomhA', '37i9dQZEVXbKpV6RVDTWcZ', '37i9dQZEVXbKxYYIUIgn7V',
'37i9dQZEVXbMxjQJh4Um8T', '37i9dQZEVXbLuey1EKVv9I', '37i9dQZEVXbJpRQ294oZ9N', '37i9dQZEVXbJVi45MafAu0',
'37i9dQZEVXbKHoaIcElSSA', '37i9dQZEVXbMHnoaLVkVuk', '37i9dQZEVXbM1qaaFAyPLz', '37i9dQZEVXbMGnTCc4Vx7v',
'37i9dQZEVXbMOkSwG072hV', '37i9dQZEVXbMIJZxwqzod6', '37i9dQZEVXbK4KA2JSuft7', '37i9dQZEVXbLRmg3qDbY1H',
'37i9dQZEVXbLuUZrygauiA', '37i9dQZEVXbMIO7B1pcKUy', '37i9dQZEVXbLOov4J0GutU', '37i9dQZEVXbMjKD6qnoc8p',
'37i9dQZEVXbJajpaXyaKll', '37i9dQZEVXbMTKZuy8ORFV', '37i9dQZEVXbKOefHPXPMyf', '37i9dQZEVXbJv2Mvelmc3I',
'37i9dQZEVXbNBxnXSWuAcX', '37i9dQZEVXbMfVLvbaC3bj', '37i9dQZEVXbNjqq6Tw4Fb0', '37i9dQZEVXbNGGDnE9UFTF',
'37i9dQZEVXbKuaTI1Z1Afx', '37i9dQZEVXbKXd6qahcpCg', '37i9dQZEVXbMnf7ONzeQWM', '37i9dQZEVXbJcpVBLdFV7m',
'37i9dQZEVXbMA8BIYDeMkD', '37i9dQZEVXbJ9SRaVj0yDF', '37i9dQZEVXbK3Iy2zvpfp4', '37i9dQZEVXbMBUm3g7j4Kb',
'37i9dQZEVXbKrooeK9WSFF', '37i9dQZEVXbNxY4E5g33Gy', '37i9dQZEVXbKfIuOAZrk7G', '37i9dQZEVXbJs8e2vk15a8',
'37i9dQZEVXbNv6cjoMVCyg', '37i9dQZEVXbNpKdqfZ9Upp', '37i9dQZEVXbLo3yC8XJf1e', '37i9dQZEVXbL3DLHfQeDmV',
'37i9dQZEVXbKbvcwe5owJ1', '37i9dQZEVXbMBNcyQCfU4w', '37i9dQZEVXbJx9hUtTN0Sj', '37i9dQZEVXbOcsE2WCaJa2',
'37i9dQZEVXbMQaPQjt027d', '37i9dQZEVXbIUY6VUoboP4', '37i9dQZEVXbJ7gPAehey5W', '37i9dQZEVXbJWZV7aRNQck',
'37i9dQZEVXbNF1heNYHDnE', '37i9dQZEVXbLzhUVGQUCoe', '37i9dQZEVXbLDLOTfCtAUM'
    )''')
    ### end Alembic commands ###


def downgrade():
    op.drop_column('spy_playlist', 'include_in_charts')
    ### end Alembic commands ###