def upgrade(): op.rename_table('payment_transactions', 'payment_transactions_old', schema='events') op.execute( _rename_constraint('events', 'payment_transactions_old', 'pk_payment_transactions', 'pk_payment_transactions_old')) op.execute( "ALTER SEQUENCE events.payment_transactions_id_seq RENAME TO payment_transactions_old_id_seq" ) op.create_table( 'payment_transactions', sa.Column('id', sa.Integer(), nullable=False), sa.Column('registration_id', sa.Integer(), nullable=False, index=True), sa.Column('status', PyIntEnum(TransactionStatus), nullable=False), sa.Column('amount', sa.Numeric(precision=8, scale=2), nullable=False), sa.Column('currency', sa.String(), nullable=False), sa.Column('provider', sa.String(), nullable=False), sa.Column('timestamp', UTCDateTime, nullable=False), sa.Column('data', postgresql.JSON(), nullable=False), sa.CheckConstraint('amount > 0', name='positive_amount'), sa.ForeignKeyConstraint(['registration_id'], ['event_registration.registrations.id']), sa.PrimaryKeyConstraint('id'), schema='events') op.create_foreign_key(None, 'registrations', 'payment_transactions', ['transaction_id'], ['id'], source_schema='event_registration', referent_schema='events')
def upgrade(): op.execute(CreateSchema('plugin_livesync')) op.create_table('agents', sa.Column('id', sa.Integer(), nullable=False), sa.Column('backend_name', sa.String(), nullable=False), sa.Column('name', sa.String(), nullable=False), sa.Column('initial_data_exported', sa.Boolean(), nullable=False), sa.Column('last_run', UTCDateTime(), nullable=False), sa.Column('settings', postgresql.JSON(), nullable=False), sa.PrimaryKeyConstraint('id', name='agents_pkey'), schema='plugin_livesync') op.create_table('queues', sa.Column('id', sa.Integer(), nullable=False), sa.Column('agent_id', sa.Integer(), nullable=False), sa.Column('timestamp', UTCDateTime(), nullable=False), sa.Column('processed', sa.Boolean(), nullable=False), sa.Column('change', PyIntEnum(ChangeType), nullable=False), sa.Column('type', sa.String(), nullable=False), sa.Column('category_id', sa.String()), sa.Column('event_id', sa.String()), sa.Column('contrib_id', sa.String()), sa.Column('subcontrib_id', sa.String()), sa.ForeignKeyConstraint(['agent_id'], ['plugin_livesync.agents.id'], name='queues_agent_id_fkey'), sa.PrimaryKeyConstraint('id', name='queues_pkey'), sa.Index('ix_plugin_livesync_queues_agent_id', 'agent_id'), schema='plugin_livesync') # later migrations expect the old name... op.execute(_rename_constraint('plugin_livesync', 'queues', 'ck_queues_valid_enum_change', 'queues_change_check'))
def downgrade(): op.drop_constraint(op.f('fk_registrations_transaction_id_payment_transactions'), 'registrations', schema='event_registration') op.drop_table('payment_transactions', schema='events') op.execute("ALTER SEQUENCE events.payment_transactions_old_id_seq RENAME TO payment_transactions_id_seq") op.execute(_rename_constraint('events', 'payment_transactions_old', 'pk_payment_transactions_old', 'pk_payment_transactions')) op.rename_table('payment_transactions_old', 'payment_transactions', schema='events')
def downgrade(): op.drop_constraint( op.f('fk_registrations_transaction_id_payment_transactions'), 'registrations', schema='event_registration') op.drop_table('payment_transactions', schema='events') op.execute( "ALTER SEQUENCE events.payment_transactions_old_id_seq RENAME TO payment_transactions_id_seq" ) op.execute( _rename_constraint('events', 'payment_transactions_old', 'pk_payment_transactions_old', 'pk_payment_transactions')) op.rename_table('payment_transactions_old', 'payment_transactions', schema='events')
def upgrade(): op.rename_table('payment_transactions', 'payment_transactions_old', schema='events') op.execute(_rename_constraint('events', 'payment_transactions_old', 'pk_payment_transactions', 'pk_payment_transactions_old')) op.execute("ALTER SEQUENCE events.payment_transactions_id_seq RENAME TO payment_transactions_old_id_seq") op.create_table( 'payment_transactions', sa.Column('id', sa.Integer(), nullable=False), sa.Column('registration_id', sa.Integer(), nullable=False, index=True), sa.Column('status', PyIntEnum(TransactionStatus), nullable=False), sa.Column('amount', sa.Numeric(precision=8, scale=2), nullable=False), sa.Column('currency', sa.String(), nullable=False), sa.Column('provider', sa.String(), nullable=False), sa.Column('timestamp', UTCDateTime, nullable=False), sa.Column('data', postgresql.JSON(), nullable=False), sa.CheckConstraint('amount > 0', name='positive_amount'), sa.ForeignKeyConstraint(['registration_id'], ['event_registration.registrations.id']), sa.PrimaryKeyConstraint('id'), schema='events' ) op.create_foreign_key(None, 'registrations', 'payment_transactions', ['transaction_id'], ['id'], source_schema='event_registration', referent_schema='events')