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)
