def upgrade(): op.create_table('documents_tags', sa.Column('user_id', sa.Integer(), nullable=False), sa.Column('document_id', sa.Integer(), nullable=False), sa.Column('document_type', sa.String(1), nullable=False), sa.ForeignKeyConstraint( ['user_id'], ['users.user.id'], ), sa.ForeignKeyConstraint( ['document_id'], ['guidebook.documents.document_id']), sa.PrimaryKeyConstraint('user_id', 'document_id'), schema='guidebook') op.create_index(op.f('ix_guidebook_documents_tags_user_id'), 'documents_tags', ['user_id'], unique=False, schema='guidebook') op.create_index(op.f('ix_guidebook_documents_tags_document_id'), 'documents_tags', ['document_id'], unique=False, schema='guidebook') op.create_index(op.f('ix_guidebook_documents_tags_document_type'), 'documents_tags', ['document_type'], unique=False, schema='guidebook') op.create_table('documents_tags_log', sa.Column('id', sa.Integer(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=False), sa.Column('document_id', sa.Integer(), nullable=False), sa.Column('document_type', sa.String(1), nullable=False), sa.Column('is_creation', sa.Boolean(), nullable=False), sa.Column('written_at', sa.DateTime(timezone=True), nullable=False), sa.ForeignKeyConstraint( ['user_id'], ['users.user.id'], ), sa.ForeignKeyConstraint( ['document_id'], ['guidebook.documents.document_id']), sa.PrimaryKeyConstraint('id'), schema='guidebook') op.create_index(op.f('ix_guidebook_documents_tags_log_written_at'), 'documents_tags_log', ['written_at'], unique=False, schema='guidebook') # TODO add index on user_id/document_id? op.create_view(view_users_for_routes)
def upgrade_rdr(): # ### commands auto generated by Alembic - please adjust! ### op.execute('drop view ppi_participant_view') op.create_view(PPI_PARTICIPANT_VIEW) op.execute('drop view raw_ppi_participant_view') op.create_view(RAW_PARTICIPANT_VIEW) op.execute('drop view participant_view') op.create_view(PARTICIPANT_VIEW)
def upgrade(): op.create_view(bsc) op.create_view(channel_group) op.create_view(external_cell) op.create_view(inner_cell) op.create_view(internal_cell) op.create_view(msc) op.create_view(nrel) op.create_view(outer_cell) op.create_view(overlaid_cell) op.create_view(priority_profile) op.create_view(site) op.create_view(tg) op.create_view(utran_external_cell) op.create_view(utran_nrel)
def upgrade(): op.create_view(vw_umts_external_cells)
def upgrade(): op.create_view(vw_baseline_parameter_config)
def upgrade(): op.create_view(ScreenResults)
def upgrade(): op.create_view(vw_lte_cells_data)
def upgrade(): op.create_view(vw_gsm_external_cells)
def upgrade(): # commands auto generated by Alembic - please adjust! ### op.create_table('config', sa.Column('config_id', sa.Integer(), nullable=False), sa.Column('modified_at', ArrowMicrosecondType(), nullable=True), sa.Column('read_only', sa.Boolean(), nullable=True), sa.Column('server', sa.String(length=255), nullable=True), sa.Column('port', sa.Integer(), nullable=True), sa.Column('devicegroup', sa.String(length=255), nullable=True), sa.Column('subject', sa.String(length=255), nullable=True), sa.Column('reinf_n_pellets', sa.Integer(), nullable=True), sa.Column('reinf_pellet_pulse_ms', sa.Integer(), nullable=True), sa.Column('reinf_interpellet_gap_ms', sa.Integer(), nullable=True), sa.Column('iti_duration_ms', sa.Integer(), nullable=True), sa.Column('repeat_incomplete_trials', sa.Boolean(), nullable=True), sa.PrimaryKeyConstraint('config_id', name=op.f('pk_config')) ) op.create_table('config_stage', sa.Column('config_stage_id', sa.Integer(), nullable=False), sa.Column('modified_at', ArrowMicrosecondType(), nullable=True), sa.Column('config_id', sa.Integer(), nullable=False), sa.Column('stagenum', sa.Integer(), nullable=False), sa.Column('sequence_length', sa.Integer(), nullable=True), sa.Column('limited_hold_s', sa.Float(), nullable=True), sa.Column('progression_criterion_x', sa.Integer(), nullable=True), sa.Column('progression_criterion_y', sa.Integer(), nullable=True), sa.Column('stop_after_n_trials', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['config_id'], ['config.config_id'], name=op.f( 'fk_config_stage_config_id_config')), # noqa sa.PrimaryKeyConstraint('config_stage_id', name=op.f('pk_config_stage')) ) op.create_table('session', sa.Column('session_id', sa.Integer(), nullable=False), sa.Column('config_id', sa.Integer(), nullable=False), sa.Column('started_at', ArrowMicrosecondType(), nullable=False), sa.Column('trials_responded', sa.Integer(), nullable=False), sa.Column('trials_correct', sa.Integer(), nullable=False), sa.ForeignKeyConstraint(['config_id'], ['config.config_id'], name=op.f( 'fk_session_config_id_config')), sa.PrimaryKeyConstraint('session_id', name=op.f('pk_session')) ) op.create_table('trial', sa.Column('trial_id', sa.Integer(), nullable=False), sa.Column('session_id', sa.Integer(), nullable=False), sa.Column('trialnum', sa.Integer(), nullable=False), sa.Column('config_stage_id', sa.Integer(), nullable=False), sa.Column('stagenum', sa.Integer(), nullable=False), sa.Column('started_at', ArrowMicrosecondType(), nullable=True), sa.Column('initiated_at', ArrowMicrosecondType(), nullable=True), sa.Column('initiation_latency_s', sa.Float(), nullable=True), sa.Column('sequence_holes', sqlalchemy_utils.types.scalar_list.ScalarListType(), # noqa nullable=True), sa.Column('sequence_length', sa.Integer(), nullable=True), sa.Column('choice_holes', sqlalchemy_utils.types.scalar_list.ScalarListType(), # noqa nullable=True), sa.Column('choice_seq_positions', sqlalchemy_utils.types.scalar_list.ScalarListType(), # noqa nullable=True), sa.Column('choice_hole_left', sa.Integer(), nullable=True), sa.Column('choice_hole_right', sa.Integer(), nullable=True), sa.Column('choice_hole_earliest', sa.Integer(), nullable=True), sa.Column('choice_hole_latest', sa.Integer(), nullable=True), sa.Column('choice_seqpos_earliest', sa.Integer(), nullable=True), sa.Column('choice_seqpos_latest', sa.Integer(), nullable=True), sa.Column('sequence_n_offered', sa.Integer(), nullable=False), sa.Column('choice_offered', sa.Boolean(), nullable=False), sa.Column('choice_offered_at', ArrowMicrosecondType(), nullable=True), sa.Column('responded', sa.Boolean(), nullable=False), sa.Column('responded_at', ArrowMicrosecondType(), nullable=True), sa.Column('responded_hole', sa.Integer(), nullable=True), sa.Column('response_correct', sa.Boolean(), nullable=True), sa.Column('response_latency_s', sa.Float(), nullable=True), sa.Column('reinforced_at', ArrowMicrosecondType(), nullable=True), sa.Column('reinf_collected_at', ArrowMicrosecondType(), nullable=True), sa.Column('reinf_collect_latency_s', sa.Float(), nullable=True), sa.Column('n_premature', sa.Integer(), nullable=False), sa.Column('iti_started_at', ArrowMicrosecondType(), nullable=True), sa.ForeignKeyConstraint(['config_stage_id'], ['config_stage.config_stage_id'], name=op.f( 'fk_trial_config_stage_id_config_stage')), # noqa sa.ForeignKeyConstraint(['session_id'], ['session.session_id'], name=op.f( 'fk_trial_session_id_session')), sa.PrimaryKeyConstraint('trial_id', name=op.f('pk_trial')) ) op.create_table('event', sa.Column('event_id', sa.Integer(), nullable=False), sa.Column('session_id', sa.Integer(), nullable=False), sa.Column('eventnum_in_session', sa.Integer(), nullable=False), sa.Column('trial_id', sa.Integer(), nullable=True), sa.Column('trialnum', sa.Integer(), nullable=True), sa.Column('eventnum_in_trial', sa.Integer(), nullable=True), sa.Column('event', sa.String(length=40), nullable=False), sa.Column('timestamp', ArrowMicrosecondType(), nullable=False), sa.Column('whisker_timestamp_ms', sa.BigInteger(), nullable=True), sa.Column('from_server', sa.Boolean(), nullable=True), sa.ForeignKeyConstraint(['session_id'], ['session.session_id'], name=op.f( 'fk_event_session_id_session')), sa.ForeignKeyConstraint(['trial_id'], ['trial.trial_id'], name=op.f( 'fk_event_trial_id_trial')), sa.PrimaryKeyConstraint('event_id', name=op.f('pk_event')) ) with op.batch_alter_table('event', schema=None) as batch_op: batch_op.create_index(batch_op.f('ix_event_eventnum_in_session'), ['eventnum_in_session'], unique=False) op.create_table('sequence_timing', sa.Column('sequence_timing_id', sa.Integer(), nullable=False), sa.Column('trial_id', sa.Integer(), nullable=False), sa.Column('seq_pos', sa.Integer(), nullable=False), sa.Column('hole_num', sa.Integer(), nullable=False), sa.Column('hole_lit_at', ArrowMicrosecondType(), nullable=True), sa.Column('hole_response_at', ArrowMicrosecondType(), nullable=True), sa.Column('hole_response_latency_s', sa.Float(), nullable=True), sa.Column('mag_lit_at', ArrowMicrosecondType(), nullable=True), sa.Column('mag_response_at', ArrowMicrosecondType(), nullable=True), sa.Column('mag_response_latency_s', sa.Float(), nullable=True), sa.ForeignKeyConstraint(['trial_id'], ['trial.trial_id'], name=op.f( 'fk_sequence_timing_trial_id_trial')), # noqa sa.PrimaryKeyConstraint('sequence_timing_id', name=op.f('pk_sequence_timing')) ) # end Alembic commands ### op.create_view(subject_session_view) op.create_view(subject_session_trial_view)
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 upgrade(): op.create_view(vw_umts_cells_data)
def upgrade(): op.create_view(MagicFormulaScore)
def upgrade(): op.create_view(premium_users_view)
def upgrade(): op.create_view(PiotroskiScore)