| 12345678910111213141516171819202122232425262728293031323334353637383940 |
- """time-series-indexes
- Revision ID: a5b970eadb3b
- Revises: bddc5e9f72a3
- Create Date: 2020-11-05 17:15:31.767627
- """
- from alembic import op
- # revision identifiers, used by Alembic.
- revision = "a5b970eadb3b"
- down_revision = "bddc5e9f72a3"
- branch_labels = None
- depends_on = None
- def upgrade():
- # ### commands auto generated by Alembic - please adjust! ###
- op.create_index(op.f("power_asset_id_idx"), "power", ["asset_id"], unique=False)
- op.create_index(op.f("power_datetime_idx"), "power", ["datetime"], unique=False)
- op.create_index(op.f("price_datetime_idx"), "price", ["datetime"], unique=False)
- op.create_index(op.f("price_market_id_idx"), "price", ["market_id"], unique=False)
- op.create_index(op.f("weather_datetime_idx"), "weather", ["datetime"], unique=False)
- op.create_index(
- op.f("weather_sensor_id_idx"), "weather", ["sensor_id"], unique=False
- )
- # ### end Alembic commands ###
- def downgrade():
- # ### commands auto generated by Alembic - please adjust! ###
- op.drop_index(op.f("weather_sensor_id_idx"), table_name="weather")
- op.drop_index(op.f("weather_datetime_idx"), table_name="weather")
- op.drop_index(op.f("price_market_id_idx"), table_name="price")
- op.drop_index(op.f("price_datetime_idx"), table_name="price")
- op.drop_index(op.f("power_datetime_idx"), table_name="power")
- op.drop_index(op.f("power_asset_id_idx"), table_name="power")
- # ### end Alembic commands ###
|
