def downgrade_rdr(): # ### commands auto generated by Alembic - please adjust! ### op.drop_column('questionnaire_response', 'language') # ### end Alembic commands ### op.replace_sp(sp_get_questionnaire_answers, replace_with="1338221caf81.sp_get_questionnaire_answers")
def upgrade_rdr(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('questionnaire_response', sa.Column('language', sa.String(length=2), nullable=True)) op.execute('ALTER TABLE questionnaire_response CHANGE COLUMN `language` `language` CHAR(2) NULL AFTER authored') # ### end Alembic commands ### op.replace_sp(sp_get_questionnaire_answers, replaces="1338221caf81.sp_get_questionnaire_answers")
def upgrade_rdr(): op.replace_sp(sp_get_code_module_items, replaces="ed28b84f061e.sp_get_code_module_items") op.replace_sp(sp_get_questionnaire_answers, replaces="1338221caf81.sp_get_questionnaire_answers") op.create_view(participant_answers_view)
def downgrade_rdr(): op.replace_sp(sp_get_code_module_items, replace_with="ed28b84f061e.sp_get_code_module_items") op.replace_sp(sp_get_questionnaire_answers, replace_with="1338221caf81.sp_get_questionnaire_answers") op.drop_view(participant_answers_view)
def downgrade_rdr(): # ### commands auto generated by Alembic - please adjust! ### op.replace_sp(sp_get_questionnaire_answers, replace_with="ed28b84f061e.sp_get_questionnaire_answers")