def upgrade(): # ### commands auto generated by Alembic - please adjust! ### context = op.get_context() bind = op.get_bind() if context.bind.dialect.name == 'postgresql': has_size_type = bind.execute( text( """ select exists (select 1 from pg_type where typname = :enum_name)""" ), enum_name=enum_name ).scalar() if not has_size_type: bind.execute(text(f"CREATE TYPE {enum_name} AS ENUM ()")) op.sync_enum_values('public', enum_name, [], ['normal', 'exam']) op.add_column( 'Assignment', sa.Column( 'kind', sa.Enum('normal', 'exam', name='assignmentkind'), server_default='normal', nullable=False ) )
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.sync_enum_values( 'public', 'runnerstate', ['cleaned', 'cleaning', 'creating', 'not_running', 'running'], ['cleaned', 'cleaning', 'not_running', 'running'] )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('certificates', sa.Column('external_id', sa.String(128), nullable=True)) op.sync_enum_values( 'public', 'log_type', ['create_cert', 'key_view', 'update_cert'], ['create_cert', 'key_view', 'revoke_cert', 'update_cert'])
def upgrade(): op.sync_enum_values( 'public', 'log_type', ['create_cert', 'key_view', 'revoke_cert', 'update_cert'], [ 'create_cert', 'delete_cert', 'key_view', 'revoke_cert', 'update_cert' ])
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.sync_enum_values( 'public', 'log_type', ['create_cert', 'key_view', 'revoke_cert', 'update_cert'], ['create_cert', 'key_view', 'update_cert']) op.drop_column('certificates', 'external_id')
def downgrade(): op.sync_enum_values( "public", "platformtype", ["AVOD", "GLOBAL", "INFO", "SVOD", "TVOD"], ["GLOBAL", "INFO", "SVOD", "TVOD"], )
def downgrade(): op.sync_enum_values( "public", "log_type", ["create_cert", "delete_cert", "key_view", "revoke_cert", "update_cert"], ["create_cert", "key_view", "revoke_cert", "update_cert"], )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### context = op.get_context() if context.bind.dialect.name == 'postgresql': bind = op.get_bind() has_size_type = bind.execute( "select exists (select 1 from pg_type " "where typname='proxystate')" ).scalar() if not has_size_type: op.execute("CREATE TYPE proxystate AS ENUM ()") op.sync_enum_values( 'public', 'proxystate', [], ENUM_OPTS, ) op.add_column( 'proxy', sa.Column( 'state', sa.Enum(*ENUM_OPTS, name='proxystate'), nullable=False, server_default='before_post' ) ) op.add_column('proxy', sa.Column('password', sa.Unicode(), nullable=False))
def downgrade(): # FIXME: downgrade probably does not work op.sync_enum_values( "public", "exportfilestatus", ["ABSENT", "DONE", "FAILED", "PROCESSING", "QUERYING", "SCHEDULED"], ["DONE", "FAILED", "PROCESSING", "QUERYING", "SCHEDULED"], ) op.alter_column( "export_template", "fields", existing_type=postgresql.JSONB(astext_type=sa.Text()), nullable=True, ) op.alter_column( "export_file", "status", existing_type=postgresql.ENUM( "SCHEDULED", "QUERYING", "PROCESSING", "DONE", "FAILED", name="exportfilestatus", ), nullable=True, existing_server_default=sa.text("'SCHEDULED'::exportfilestatus"), )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.sync_enum_values( 'public', 'autotestrunstate', ['crashed', 'done', 'not_started', 'running', 'timed_out'], [ 'changing_runner', 'crashed', 'done', 'running', 'starting', 'timed_out', 'waiting_for_runner' ])
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.sync_enum_values( 'public', 'autoteststeptesttype', ['check_points', 'custom_output', 'io_test', 'run_program'], [ 'check_points', 'custom_output', 'io_test', 'junit_test', 'run_program' ])
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.sync_enum_values( "public", "log_type", ["create_cert", "key_view", "revoke_cert", "update_cert"], ["create_cert", "key_view", "update_cert"], ) op.drop_column("certificates", "external_id")
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column("certificates", sa.Column("external_id", sa.String(128), nullable=True)) op.sync_enum_values( "public", "log_type", ["create_cert", "key_view", "update_cert"], ["create_cert", "key_view", "revoke_cert", "update_cert"], )
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_column('proxy', 'state') op.drop_column('proxy', 'password') op.sync_enum_values( 'public', 'proxystate', ENUM_OPTS, [], )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_column('AutoTestResult', 'points_achieved') op.add_column( 'AutoTestRunner', sa.Column('after_run_called', sa.Boolean(), server_default='true', nullable=False)) op.sync_enum_values( 'public', 'autoteststepresultstate', ['failed', 'not_started', 'passed', 'running'], ['failed', 'not_started', 'passed', 'running', 'timed_out']) op.sync_enum_values( 'public', 'autotestrunstate', ['not_started', 'running', 'done', 'timed_out'], ['not_started', 'running', 'done', 'timed_out', 'crashed'])
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.sync_enum_values( 'public', 'autoteststepresultstate', ['failed', 'not_started', 'passed', 'running', 'timed_out'], ['failed', 'not_started', 'passed', 'running']) op.sync_enum_values( 'public', 'autotestrunstate', ['not_started', 'running', 'done', 'timed_out', 'crashed'], ['not_started', 'running', 'done', 'timed_out']) op.drop_column('AutoTestRunner', 'after_run_called') op.add_column( 'AutoTestResult', sa.Column('points_achieved', postgresql.DOUBLE_PRECISION(precision=53), autoincrement=False, nullable=True))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### context = op.get_context() bind = op.get_bind() if context.bind.dialect.name == 'postgresql': has_size_type = bind.execute(text(""" select exists (select 1 from pg_type where typname = :enum_name)""" ), enum_name=enum_name).scalar() if not has_size_type: bind.execute(text(f"CREATE TYPE {enum_name} AS ENUM ()")) op.sync_enum_values('public', enum_name, [], ['deep_linked', 'visible', 'deleted']) op.add_column( 'Assignment', sa.Column( 'visibility_state', sa.Enum( 'deep_linked', 'visible', 'deleted', name=enum_name, ), )) bind.execute( text("""UPDATE "Assignment" set visibility_state = (CASE WHEN deleted then 'deleted' else 'visible' END)::{}""".format(enum_name))) op.alter_column('Assignment', 'visibility_state', nullable=False) op.drop_column('Assignment', 'deleted') op.add_column( 'course_lti_provider', sa.Column('last_names_roles_poll', sa.TIMESTAMP(timezone=True), nullable=True)) op.add_column('course_lti_provider', sa.Column('names_roles_claim', sa.JSON(), nullable=True))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_column('course_lti_provider', 'names_roles_claim') op.drop_column('course_lti_provider', 'last_names_roles_poll') op.add_column( 'Assignment', sa.Column('deleted', sa.BOOLEAN(), server_default=sa.text('false'), autoincrement=False, nullable=False)) bind = op.get_bind() bind.execute( text( """UPDATE "Assignment" set deleted = (visibility_state = 'deleted')""" )) op.drop_column('Assignment', 'visibility_state') op.sync_enum_values('public', enum_name, ['deep_linked', 'visible', 'deleted'], []) bind.execute(f'DROP TYPE {enum_name}')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('certificates', sa.Column('external_id', sa.String(128), nullable=True)) op.sync_enum_values('public', 'log_type', ['create_cert', 'key_view', 'update_cert'], ['create_cert', 'key_view', 'revoke_cert', 'update_cert'])
def downgrade(): op.sync_enum_values('public', 'log_type', ['create_cert', 'key_view', 'update_cert'], ['key_view'])
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.sync_enum_values( 'public', 'ui_preference_name', ['no_msg_for_mosaic_1', 'no_msg_for_mosaic_2', 'rubric_editor_v2'], ['rubric_editor_v2'])
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.sync_enum_values( 'public', 'autoteststepresultstate', ['failed', 'not_started', 'passed', 'running', 'skipped', 'timed_out'], ['failed', 'not_started', 'passed', 'running', 'timed_out'])
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.sync_enum_values('public', 'autotestrunnertype', ['simple_runner', 'transip_runner'], ['simple_runner'])
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.sync_enum_values( 'public', 'taskresultstate', ['crashed', 'failed', 'finished', 'not_started', 'skipped', 'started'], ['crashed', 'failed', 'finished', 'not_started', 'started'])
def upgrade(): op.sync_enum_values('public', 'log_type', ['create_cert', 'key_view', 'revoke_cert', 'update_cert'], ['create_cert', 'delete_cert', 'key_view', 'revoke_cert', 'update_cert'])
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.sync_enum_values('public', 'log_type', ['create_cert', 'key_view', 'revoke_cert', 'update_cert'], ['create_cert', 'key_view', 'update_cert']) op.drop_column('certificates', 'external_id')
def upgrade(): op.sync_enum_values("public", "log_type", ["key_view"], ["create_cert", "key_view", "update_cert"])