a918360f7d63_add_unique_contraints_on_.py 1.0 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. """add unique contraints: on GenericAssetType.name & on GenericAssets for name+account_id
  2. Revision ID: a918360f7d63
  3. Revises: 830e72a8b218
  4. Create Date: 2022-01-01 22:08:50.163734
  5. """
  6. from alembic import op
  7. # revision identifiers, used by Alembic.
  8. revision = "a918360f7d63"
  9. down_revision = "830e72a8b218"
  10. branch_labels = None
  11. depends_on = None
  12. def upgrade():
  13. # ### commands auto generated by Alembic - please adjust! ###
  14. op.create_unique_constraint(
  15. "generic_asset_name_account_id_key", "generic_asset", ["name", "account_id"]
  16. )
  17. op.create_unique_constraint(
  18. op.f("generic_asset_type_name_key"), "generic_asset_type", ["name"]
  19. )
  20. # ### end Alembic commands ###
  21. def downgrade():
  22. # ### commands auto generated by Alembic - please adjust! ###
  23. op.drop_constraint(
  24. op.f("generic_asset_type_name_key"), "generic_asset_type", type_="unique"
  25. )
  26. op.drop_constraint(
  27. "generic_asset_name_account_id_key", "generic_asset", type_="unique"
  28. )
  29. # ### end Alembic commands ###