"""add school abbreviations and acronyms

Revision ID: 41f361ac6a74
Revises: c<PASSWORD>
Create Date: 2022-06-07 03:48:15.445488+00:00

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

# revision identifiers, used by Alembic.
revision = "41f361ac6a74"
down_revision = "c1b1ed99e50d"
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column(
        "schools",
        sa.Column(
            "abbreviations",
            postgresql.ARRAY(sqlmodel.sql.sqltypes.AutoString()),
            nullable=False,
            server_default=sa.text("array[]::varchar[]"),
        ),
    )
    op.add_column(
        "schools",
        sa.Column(
            "alternatives",
            postgresql.ARRAY(sqlmodel.sql.sqltypes.AutoString()),
            nullable=False,
            server_default=sa.text("array[]::varchar[]"),
        ),
    )
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column("schools", "alternatives")
    op.drop_column("schools", "abbreviations")
    # ### end Alembic commands ###

alembic.op.drop_column sqlalchemy.text sqlmodel.sql.sqltypes.AutoString
[((1100, 1141), 'alembic.op.drop_column', 'op.drop_column', (['"""schools"""', '"""alternatives"""'], {}), "('schools', 'alternatives')\n", (1114, 1141), False, 'from alembic import op\n'), ((1146, 1188), 'alembic.op.drop_column', 'op.drop_column', (['"""schools"""', '"""abbreviations"""'], {}), "('schools', 'abbreviations')\n", (1160, 1188), False, 'from alembic import op\n'), ((582, 616), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (614, 616), False, 'import sqlmodel\n'), ((674, 703), 'sqlalchemy.text', 'sa.text', (['"""array[]::varchar[]"""'], {}), "('array[]::varchar[]')\n", (681, 703), True, 'import sqlalchemy as sa\n'), ((836, 870), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (868, 870), False, 'import sqlmodel\n'), ((928, 957), 'sqlalchemy.text', 'sa.text', (['"""array[]::varchar[]"""'], {}), "('array[]::varchar[]')\n", (935, 957), True, 'import sqlalchemy as sa\n')]