def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('sessions', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('session_id', sa.VARCHAR(length=255), nullable=True), sa.Column('data', sa.BLOB(), nullable=True), sa.Column('expiry', sa.DATETIME(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('session_id') ) with op.batch_alter_table('tasks', schema=None) as batch_op: batch_op.alter_column('id', existing_type=sa.NUMERIC(precision=16), type_=sqlalchemy_utils.types.uuid.UUIDType(), existing_nullable=False) with op.batch_alter_table('templates', schema=None) as batch_op: batch_op.alter_column('id', existing_type=sa.NUMERIC(precision=16), type_=sqlalchemy_utils.types.uuid.UUIDType(), existing_nullable=False) with op.batch_alter_table('user', schema=None) as batch_op: batch_op.add_column(sa.Column('task_ids', sa.JSON(), nullable=True)) batch_op.alter_column('id', existing_type=sa.NUMERIC(precision=16), type_=sqlalchemy_utils.types.uuid.UUIDType(), existing_nullable=False) batch_op.create_unique_constraint('task_ids', ['task_ids']) try: batch_op.drop_column('password_hash') except Exception: pass
def downgrade_live(): ### commands auto generated by Alembic - please adjust! ### op.alter_column('room_bands', 'name', existing_type=sa.VARCHAR(length=255), nullable=True) op.alter_column('room_bands', 'description', existing_type=sa.TEXT(), nullable=True) op.drop_column('room_bands', 'color') op.alter_column('room_band_prices', 'rent', existing_type=sa.NUMERIC(precision=6, scale=2), nullable=True) op.alter_column('room_band_modifiers', 'name', existing_type=sa.VARCHAR(length=255), nullable=True) op.alter_column('room_band_modifiers', 'description', existing_type=sa.TEXT(), nullable=True) op.alter_column('room_band_modifier_prices', 'discount', existing_type=sa.NUMERIC(precision=6, scale=2), nullable=True)
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.drop_column('transaction', 'disbursement_channel') op.drop_column('transaction', 'flow_type') op.drop_column('transaction', 'finance_type') op.drop_column('transaction', 'tied_status') op.drop_column('transaction', 'aid_type') op.drop_column('transaction', 'ref') op.drop_column('transaction', 'provider_org_text') op.drop_column('transaction', 'provider_org_ref') op.drop_column('transaction', 'provider_org_activity_id') op.drop_column('transaction', 'receiver_org_text') op.drop_column('transaction', 'receiver_org_ref') op.drop_column('transaction', 'receiver_org_activity_id') op.alter_column('budget', u'value_amount', existing_type=sa.NUMERIC(), type_=sa.INTEGER(), nullable=True) op.alter_column('transaction', u'value_amount', existing_type=sa.NUMERIC(), type_=sa.INTEGER(), nullable=False) op.drop_column('transaction', 'description') aid_type.drop(bind=op.get_bind()) tied_status.drop(bind=op.get_bind()) flow_type.drop(bind=op.get_bind()) finance_type.drop(bind=op.get_bind()) disbursement.drop(bind=op.get_bind()) finance_type.drop(bind=op.get_bind())
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### with op.batch_alter_table('user') as batch_op: batch_op.alter_column('id', existing_type=sqlalchemy_utils.types.uuid.UUIDType(), type_=sa.NUMERIC(precision=16), existing_nullable=False) with op.batch_alter_table('templates') as batch_op: batch_op.alter_column('id', existing_type=sqlalchemy_utils.types.uuid.UUIDType(), type_=sa.NUMERIC(precision=16), existing_nullable=False) with op.batch_alter_table('tasks') as batch_op: batch_op.alter_column('id', existing_type=sqlalchemy_utils.types.uuid.UUIDType(), type_=sa.NUMERIC(precision=16), existing_nullable=False) op.create_table('sessions', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('session_id', sa.VARCHAR(length=255), nullable=True), sa.Column('data', sa.BLOB(), nullable=True), sa.Column('expiry', sa.DATETIME(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('session_id') )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( "invoices", sa.Column("currency", sa.Text(), nullable=True, server_default="USD"), ) op.add_column( "stores", sa.Column("default_currency", sa.Text(), nullable=True, server_default="USD"), ) op.alter_column("invoices", "currency", server_default=None) op.alter_column("stores", "default_currency", server_default=None) op.alter_column( "invoices", column_name="amount", new_column_name="price", existing_type=sa.NUMERIC(precision=16, scale=8), existing_nullable=False, existing_server_default=None, ) op.alter_column( "products", column_name="amount", new_column_name="price", existing_type=sa.NUMERIC(precision=16, scale=8), existing_nullable=False, existing_server_default=None, )
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('oos_tests', sa.Column('drawdown', sa.NUMERIC(precision=12, scale=4), autoincrement=False, nullable=True)) op.add_column('oos_tests', sa.Column('avg_looser', sa.NUMERIC(precision=12, scale=4), autoincrement=False, nullable=True)) op.drop_column('oos_tests', 'win_streak') op.drop_column('oos_tests', 'total_contracts_held') op.drop_column('oos_tests', 'time_in_str') op.drop_column('oos_tests', 'test_period_str') op.drop_column('oos_tests', 'stdev_monthly_rtn') op.drop_column('oos_tests', 'rtn_retracement_ratio') op.drop_column('oos_tests', 'rtn_on_init_cap') op.drop_column('oos_tests', 'rtn_on_account') op.drop_column('oos_tests', 'rina') op.drop_column('oos_tests', 'required_account') op.drop_column('oos_tests', 'max_run_up') op.drop_column('oos_tests', 'max_contracts_held') op.drop_column('oos_tests', 'lose_streak') op.drop_column('oos_tests', 'largest_winner') op.drop_column('oos_tests', 'largest_loser') op.drop_column('oos_tests', 'drawdown_intra') op.drop_column('oos_tests', 'drawdown_day') op.drop_column('oos_tests', 'buy_hold_ror') op.drop_column('oos_tests', 'avg_monthly_rtn') op.drop_column('oos_tests', 'avg_loser') op.drop_column('oos_tests', 'avg_bars_in_winner') op.drop_column('oos_tests', 'avg_bars_in_loser') op.drop_column('oos_tests', 'avg_bars_in_even') op.drop_column('oos_tests', 'avg_bars_in') op.drop_column('oos_tests', 'annual_ror')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('playlists', 'list_type', existing_type=sa.String(length=32), type_=sa.VARCHAR(length=12), existing_nullable=True) op.alter_column('oos_tests', 'trade_count', existing_type=sa.Integer(), type_=sa.NUMERIC(precision=12, scale=4), existing_nullable=True) op.alter_column('oos_tests', 'rina', existing_type=sa.Numeric(precision=12, scale=4), type_=sa.NUMERIC(precision=8, scale=4), existing_nullable=True) op.alter_column('oos_tests', 'percent_winners', existing_type=sa.Numeric(precision=6, scale=2), type_=sa.NUMERIC(precision=12, scale=4), existing_nullable=True) op.alter_column('oos_tests', 'drawdown_intra', existing_type=sa.Numeric(precision=12, scale=2), type_=sa.NUMERIC(precision=12, scale=4), existing_nullable=True) op.alter_column('oos_tests', 'drawdown_day', existing_type=sa.Numeric(precision=12, scale=2), type_=sa.NUMERIC(precision=12, scale=4), existing_nullable=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'product_pricing', sa.Column('max_discount_amount', sa.NUMERIC(precision=11, scale=2), autoincrement=False, nullable=True)) op.add_column( 'product_pricing', sa.Column('min_order_value', sa.NUMERIC(precision=11, scale=2), autoincrement=False, nullable=False)) op.add_column( 'product_pricing', sa.Column('price', sa.NUMERIC(precision=11, scale=2), autoincrement=False, nullable=False)) op.drop_column('product_pricing', 'discount_value') op.add_column( 'category_discount', sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False)) op.add_column( 'category_discount', sa.Column('max_discount_amount', sa.NUMERIC(precision=11, scale=2), autoincrement=False, nullable=True)) op.add_column( 'category_discount', sa.Column('min_order_value', sa.NUMERIC(precision=11, scale=2), autoincrement=False, nullable=True)) op.drop_constraint(None, 'category_discount', type_='foreignkey') op.create_index('ix_category_discount_valid_until', 'category_discount', ['valid_until'], unique=False) op.drop_column('category_discount', 'genre_name') op.create_table( 'discounts_genres', sa.Column('category_discount_id', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('genre_name', sa.VARCHAR(length=32), autoincrement=False, nullable=False), sa.ForeignKeyConstraint( ['category_discount_id'], ['category_discount.id'], name='discounts_genres_category_discount_id_fkey'), sa.ForeignKeyConstraint(['genre_name'], ['genre.name'], name='discounts_genres_genre_name_fkey'), sa.PrimaryKeyConstraint('category_discount_id', 'genre_name', name='discounts_genres_pkey'))
def upgrade(): op.create_table( 'bills', sa.Column('url', sa.VARCHAR(length=255), autoincrement=False, nullable=False), sa.Column('category', sa.VARCHAR(length=255), autoincrement=False, nullable=False), sa.Column('project', sa.VARCHAR(length=255), autoincrement=False, nullable=True), sa.Column('comments', sa.VARCHAR(length=255), autoincrement=False, nullable=True), sa.Column('contact', sa.VARCHAR(length=255), autoincrement=False, nullable=True), sa.Column('dated_on', sa.DATE(), autoincrement=False, nullable=True), sa.Column('due_on', sa.DATE(), autoincrement=False, nullable=True), sa.Column('due_value', sa.NUMERIC(precision=10, scale=2), autoincrement=False, nullable=True), sa.Column('paid_value', sa.NUMERIC(precision=10, scale=2), autoincrement=False, nullable=True), sa.Column('reference', sa.VARCHAR(length=255), autoincrement=False, nullable=True), sa.Column('sales_tax_rate', sa.NUMERIC(precision=10, scale=2), autoincrement=False, nullable=True), sa.Column('sales_tax_value', sa.NUMERIC(precision=10, scale=2), autoincrement=False, nullable=True), sa.Column('status', sa.VARCHAR(length=255), autoincrement=False, nullable=True), sa.Column('total_value', sa.NUMERIC(precision=10, scale=2), autoincrement=False, nullable=True), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('url', name=u'pk_bills'))
def downgrade(): op.alter_column('ft_billing', 'rate_multiplier', existing_type=sa.Integer(), type_=sa.NUMERIC()) op.alter_column('ft_billing', 'billable_units', existing_type=sa.Integer(), type_=sa.NUMERIC(), existing_nullable=True)
def downgrade(): op.add_column( "bom_station", sa.Column("lat", sa.NUMERIC(), autoincrement=False, nullable=True), ) op.add_column( "bom_station", sa.Column("lng", sa.NUMERIC(), autoincrement=False, nullable=True), ) op.drop_index("idx_bom_station_geom", table_name="bom_station") op.drop_column("bom_station", "geom")
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'cart', sa.Column('total_price', sa.NUMERIC(), autoincrement=False, nullable=True)) op.add_column( 'cart', sa.Column('discount', sa.NUMERIC(), autoincrement=False, nullable=True))
def downgrade(): op.create_table( "time", sa.Column("id", sa.VARCHAR(length=50), autoincrement=False, nullable=False), sa.Column("summary_id", sa.VARCHAR(length=50), autoincrement=False, nullable=False), sa.Column("iteration", sa.INTEGER(), autoincrement=False, nullable=False), sa.Column("result", sa.NUMERIC(), autoincrement=False, nullable=False), sa.ForeignKeyConstraint( ["summary_id"], ["summary.id"], name="time_summary_id_fkey", ondelete="CASCADE", ), sa.PrimaryKeyConstraint("id", name="time_pkey"), ) op.create_index("time_summary_id_index", "time", ["summary_id"], unique=False) op.create_table( "data", sa.Column("id", sa.VARCHAR(length=50), autoincrement=False, nullable=False), sa.Column("summary_id", sa.VARCHAR(length=50), autoincrement=False, nullable=False), sa.Column("iteration", sa.INTEGER(), autoincrement=False, nullable=False), sa.Column("result", sa.NUMERIC(), autoincrement=False, nullable=False), sa.ForeignKeyConstraint( ["summary_id"], ["summary.id"], name="data_summary_id_fkey", ondelete="CASCADE", ), sa.PrimaryKeyConstraint("id", name="data_pkey"), ) op.create_index("data_summary_id_index", "data", ["summary_id"], unique=False)
def downgrade(): op.alter_column("ft_billing", "rate_multiplier", existing_type=sa.Integer(), type_=sa.NUMERIC()) op.alter_column( "ft_billing", "billable_units", existing_type=sa.Integer(), type_=sa.NUMERIC(), existing_nullable=True, )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'spots', sa.Column('id', sa.Integer(), nullable=False), sa.Column('long', sa.NUMERIC(precision=7, scale=4), nullable=True), sa.Column('lat', sa.NUMERIC(precision=7, scale=4), nullable=True), sa.Column('name', sa.String(length=255), nullable=False), sa.Column('image', sa.String(length=255), nullable=True), sa.Column('description', sa.Text(), nullable=False), sa.Column('updated_at', sa.DateTime(), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name')) op.create_table( 'users', sa.Column('id', sa.Integer(), nullable=False), sa.Column('display_name', sa.String(length=40), nullable=False), sa.Column('email', sa.String(length=255), nullable=False), sa.Column('hashed_password', sa.String(length=255), nullable=False), sa.Column('profile_url', sa.String(length=255), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('display_name'), sa.UniqueConstraint('email')) op.create_table('aws', sa.Column('id', sa.Integer(), nullable=False), sa.Column('rss_feed_url', sa.Text(), nullable=False), sa.Column('aws_url', sa.Text(), nullable=False), sa.Column('spot_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['spot_id'], ['spots.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('aws_url')) op.create_table('spot_join_user', sa.Column('user_id', sa.INTEGER(), nullable=False), sa.Column('spot_id', sa.INTEGER(), nullable=False), sa.ForeignKeyConstraint( ['spot_id'], ['spots.id'], ), sa.ForeignKeyConstraint( ['user_id'], ['users.id'], ), sa.PrimaryKeyConstraint('user_id', 'spot_id')) op.create_table('comments', sa.Column('id', sa.Integer(), nullable=False), sa.Column('comment', sa.Text(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=True), sa.Column('spot_id', sa.Integer(), nullable=True), sa.Column('aws_url', sa.Text(), nullable=True), sa.ForeignKeyConstraint( ['aws_url'], ['aws.aws_url'], ), sa.ForeignKeyConstraint( ['spot_id'], ['spots.id'], ), sa.ForeignKeyConstraint( ['user_id'], ['users.id'], ), sa.PrimaryKeyConstraint('id'))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( "bom_station", sa.Column("lat", sa.NUMERIC(), autoincrement=False, nullable=True), ) op.add_column( "bom_station", sa.Column("lng", sa.NUMERIC(), autoincrement=False, nullable=True), ) op.drop_index("idx_bom_station_geom", table_name="bom_station") op.drop_column("bom_station", "geom")
def upgrade(): op.create_table( 'bank_transaction_explanations', sa.Column('url', sa.VARCHAR(length=255), autoincrement=False, nullable=False), sa.Column('bank_transaction', sa.VARCHAR(length=255), autoincrement=False, nullable=False), sa.Column('bank_account', sa.VARCHAR(length=255), autoincrement=False, nullable=False), sa.Column('category', sa.VARCHAR(length=255), autoincrement=False, nullable=True), sa.Column('dated_on', sa.DATE(), autoincrement=False, nullable=True), sa.Column('description', sa.VARCHAR(length=255), autoincrement=False, nullable=True), sa.Column('gross_value', sa.NUMERIC(precision=10, scale=2), autoincrement=False, nullable=True), sa.Column('paid_bill', sa.VARCHAR(length=255), autoincrement=False, nullable=True), sa.Column('paid_invoice', sa.VARCHAR(length=255), autoincrement=False, nullable=True), sa.Column('paid_user', sa.VARCHAR(length=255), autoincrement=False, nullable=True), sa.Column('receipt_reference', sa.VARCHAR(length=255), autoincrement=False, nullable=True), sa.Column('sales_tax_rate', sa.NUMERIC(precision=10, scale=2), autoincrement=False, nullable=True), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('url', name=u'pk_bank_transaction_explanations'))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('users', sa.Column('username', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.create_unique_constraint('users_username_key', 'users', ['username']) op.drop_index(op.f('ix_users_time_created'), table_name='users') op.drop_column('users', 'last_name') op.drop_column('users', 'first_name') op.alter_column('tags', 'name', existing_type=sa.VARCHAR(length=255), nullable=False) op.alter_column('regions', 'name', existing_type=sa.VARCHAR(length=100), nullable=False) op.alter_column('regions', 'cont_id', existing_type=sa.INTEGER(), nullable=False) op.alter_column('favorites', 'user_id', existing_type=sa.INTEGER(), nullable=False) op.alter_column('favorites', 'dest_id', existing_type=sa.INTEGER(), nullable=False) op.alter_column('explored', 'user_id', existing_type=sa.INTEGER(), nullable=False) op.alter_column('explored', 'dest_id', existing_type=sa.INTEGER(), nullable=False) op.alter_column('destinations', 'update_date', existing_type=postgresql.TIMESTAMP(), nullable=False) op.alter_column('destinations', 'name', existing_type=sa.VARCHAR(length=100), nullable=False) op.alter_column('dest_tags', 'tag_id', existing_type=sa.INTEGER(), nullable=False) op.alter_column('dest_tags', 'dest_id', existing_type=sa.INTEGER(), nullable=False) op.alter_column('dest_locations', 'lng', existing_type=sa.NUMERIC(precision=11, scale=8), nullable=False) op.alter_column('dest_locations', 'lat', existing_type=sa.NUMERIC(precision=10, scale=8), nullable=False) op.alter_column('countries', 'name', existing_type=sa.VARCHAR(length=100), nullable=False) op.alter_column('continents', 'name', existing_type=sa.VARCHAR(length=100), nullable=False)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'strategies', type_='foreignkey') op.create_table('candidate_tmps', sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False), sa.Column('test_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('proto_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('sec_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('symbol', sa.VARCHAR(length=12), autoincrement=False, nullable=True), sa.Column('template_file', sa.VARCHAR(length=250), autoincrement=False, nullable=False), sa.Column('strategy_name', sa.VARCHAR(length=250), autoincrement=False, nullable=False), sa.Column('session_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('timeframe_1', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('timeframe_1_unit', sa.VARCHAR(length=10), autoincrement=False, nullable=True), sa.Column('timeframe_2', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('timeframe_2_unit', sa.VARCHAR(length=10), autoincrement=False, nullable=True), sa.Column('fitness_function', sa.VARCHAR(length=12), autoincrement=False, nullable=True), sa.Column('max_days_back', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('start_dt', sa.DATE(), autoincrement=False, nullable=True), sa.Column('end_dt', sa.DATE(), autoincrement=False, nullable=True), sa.Column('use_second_data', sa.BOOLEAN(), autoincrement=False, nullable=True), sa.Column('lsb', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('trades_per_day', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('day_swing', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('poi_switch', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('poi_n1', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('natr', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('fract', sa.NUMERIC(precision=5, scale=2), autoincrement=False, nullable=True), sa.Column('t_segment', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('filter_1_switch', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('filter_1_n1', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('filter_1_n2', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('filter_2_switch', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('filter_2_n1', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('filter_2_n2', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('sl_switch', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('stop_loss', sa.NUMERIC(precision=12, scale=5), autoincrement=False, nullable=True), sa.Column('pt_switch', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('profit_target', sa.NUMERIC(precision=12, scale=5), autoincrement=False, nullable=True), sa.Column('bt_start_dt', sa.DATE(), autoincrement=False, nullable=True), sa.Column('bt_end_dt', sa.DATE(), autoincrement=False, nullable=True), sa.Column('input_vars', sa.VARCHAR(length=256), autoincrement=False, nullable=True), sa.Column('optimization_string', sa.VARCHAR(length=120), autoincrement=False, nullable=True), sa.Column('status', sa.VARCHAR(length=12), autoincrement=False, nullable=True), sa.Column('status_state', sa.VARCHAR(length=12), autoincrement=False, nullable=True), sa.Column('start_run', postgresql.TIMESTAMP(), autoincrement=False, nullable=True), sa.Column('end_run', postgresql.TIMESTAMP(), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id', name='candidate_tmps_pkey') ) op.drop_table('market_internal_optimizations')
def create_dep_data_table(name=None): return db.t.create( name or "dep_data", sa.Column("acct", sa.VARCHAR(32)), sa.Column("balance", sa.NUMERIC(32, 2, asdecimal=False)), sa.Column("month_acc", sa.NUMERIC(32, 2, asdecimal=False)), sa.Column("season_acc", sa.NUMERIC(32, 2, asdecimal=False)), sa.Column("year_acc", sa.NUMERIC(32, 2, asdecimal=False)), sa.Column("date", sa.DATE), sa.ForeignKeyConstraint(("acct", ), [ "dep_acct.acct", ]), )
def downgrade(): """Reverse actions performed during upgrade.""" op.drop_column('apartment', 'heating_costs') op.drop_column('apartment', 'additional_costs') op.alter_column('apartment', 'size', existing_type=sa.Numeric(precision=5, scale=2), type_=sa.NUMERIC(precision=4, scale=1), existing_nullable=True) op.alter_column('apartment', 'rooms', existing_type=sa.Numeric(precision=3, scale=1), type_=sa.NUMERIC(precision=2, scale=1), existing_nullable=True)
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.alter_column('product', 'retail_price', existing_type=sa.NUMERIC(precision=8, scale=2), nullable=True) op.alter_column('product', 'purchase_price', existing_type=sa.NUMERIC(precision=8, scale=2), nullable=True) op.alter_column('enum_values', 'code', existing_type=sa.VARCHAR(length=32), nullable=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_column('meter_snapshots', 'consumption') op.drop_column('meter_snapshots', 'automatic') op.add_column( 'electricity_meter_snapshots', sa.Column('current_voltage', sa.NUMERIC(), autoincrement=False, nullable=False)) op.drop_column('electricity_meter_snapshots', 'voltage') op.drop_column('electricity_meter_snapshots', 'current') op.create_table( 'water_meter_snapshots', sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False), sa.Column('snapshot_id', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('consumption', sa.NUMERIC(), autoincrement=False, nullable=False), sa.ForeignKeyConstraint(['snapshot_id'], ['meter_snapshots.id'], name='water_meter_snapshots_snapshot_id_fkey', ondelete='CASCADE'), sa.PrimaryKeyConstraint('id', name='water_meter_snapshots_pkey'), sa.UniqueConstraint('snapshot_id', name='water_meter_snapshots_snapshot_id_key')) op.create_table( 'readings', sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False), sa.Column('date', postgresql.TIMESTAMP(), autoincrement=False, nullable=True), sa.Column('type', sa.VARCHAR(length=255), autoincrement=False, nullable=True), sa.Column('value', sa.VARCHAR(length=255), autoincrement=False, nullable=True), sa.Column('meter_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['meter_id'], ['meters.id'], name='readings_meter_id_fkey', ondelete='CASCADE'), sa.PrimaryKeyConstraint('id', name='readings_pkey'))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'shares', sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False), sa.Column('shares_name', sa.VARCHAR(length=100), autoincrement=False, nullable=True), sa.Column('shares_no', sa.NUMERIC(), autoincrement=False, nullable=True), sa.Column('total_price', sa.NUMERIC(), autoincrement=False, nullable=True), sa.Column('created_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=True), sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['user_id'], ['users.id'], name='shares_user_id_fkey'), sa.PrimaryKeyConstraint('id', name='shares_pkey')) op.create_table( 'history', sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False), sa.Column('shares_name', sa.VARCHAR(length=100), autoincrement=False, nullable=True), sa.Column('shares_no', sa.NUMERIC(), autoincrement=False, nullable=True), sa.Column('price', sa.NUMERIC(), autoincrement=False, nullable=True), sa.Column('status', sa.VARCHAR(length=100), autoincrement=False, nullable=True), sa.Column('timestamp', postgresql.TIMESTAMP(), autoincrement=False, nullable=True), sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['user_id'], ['users.id'], name='history_user_id_fkey'), sa.PrimaryKeyConstraint('id', name='history_pkey'))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('sales', 'value', existing_type=sa.Numeric(precision=6, scale=2), type_=sa.NUMERIC(precision=4, scale=2), existing_nullable=False)
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_table( u'crash_adu_by_build_signature', sa.Column(u'crash_adu_by_build_signature_id', sa.INTEGER(), nullable=False), sa.Column(u'signature_id', sa.INTEGER(), nullable=False), sa.Column(u'signature', citexttype.CitextType(), nullable=False), sa.Column(u'adu_date', sa.DATE(), nullable=False), sa.Column(u'build_date', sa.DATE(), nullable=False), sa.Column(u'buildid', sa.NUMERIC(), server_default='0', nullable=False), sa.Column(u'crash_count', sa.INTEGER(), server_default='0', nullable=False), sa.Column(u'adu_count', sa.INTEGER(), server_default='0', nullable=False), sa.Column(u'os_name', citexttype.CitextType(), nullable=False), sa.Column(u'channel', citexttype.CitextType(), nullable=False), sa.PrimaryKeyConstraint(u'crash_adu_by_build_signature_id')) ### end Alembic commands ### load_stored_proc(op, [ 'backfill_crash_adu_by_build_signature.sql', 'backfill_matviews.sql', 'update_crash_adu_by_build_signature.sql' ]) fix_permissions(op, 'crash_adu_by_build_signature')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'quotes', type_='unique') op.create_table( 'tests', sa.Column('id', sa.NUMERIC(), autoincrement=False, nullable=False), sa.PrimaryKeyConstraint('id', name='tests_pkey'))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column("address", "type", existing_type=sa.VARCHAR(length=20), nullable=False) op.alter_column( "address", "postal_code", existing_type=sa.VARCHAR(length=20), nullable=False, ) op.alter_column( "address", "geo_api_id", existing_type=sa.VARCHAR(length=255), nullable=False, ) op.alter_column( "address", "coords", existing_type=postgresql.ARRAY(sa.NUMERIC()), nullable=False, ) op.alter_column("address", "city", existing_type=sa.VARCHAR(length=255), nullable=False) op.drop_column("address", "manual") op.alter_column("address", "geo_api_raw_data", nullable=False)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'menuitem', sa.Column('item_id', sa.INTEGER(), nullable=False), sa.Column('name', sa.VARCHAR(length=30), autoincrement=False, nullable=False), sa.Column('category', sa.VARCHAR(length=15), autoincrement=False, nullable=False), sa.Column('description', sa.TEXT(), autoincrement=False, nullable=False), sa.Column('price', sa.NUMERIC(precision=5, scale=2), autoincrement=False, nullable=False), sa.Column('restaurantid', sa.INTEGER(), autoincrement=False, nullable=False), sa.ForeignKeyConstraint(['restaurantid'], ['restaurant.restaurantid'], name='menuitem_restaurantid_fkey'), sa.PrimaryKeyConstraint('item_id', name='menuitem_pkey')) op.drop_table('rater')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### try: op.drop_table('sessions') except Exception: pass with op.batch_alter_table('templates', schema=None) as batch_op: batch_op.alter_column('id', existing_type=sa.NUMERIC(precision=16), type_=sqlalchemy_utils.types.uuid.UUIDType(), existing_nullable=False) with op.batch_alter_table('user', schema=None) as batch_op: batch_op.alter_column('id', existing_type=sa.NUMERIC(precision=16), type_=sqlalchemy_utils.types.uuid.UUIDType(), existing_nullable=False)