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"])
