lacuna-tech / mds-core

Repo for LADOT MDS implementation for contribution to the Open Mobility Foundation
Apache License 2.0
13 stars 9 forks source link

Truncate many-to-many join tables #981

Closed mdurling closed 2 years ago

mdurling commented 2 years ago

📚 Purpose

FK relationships are mostly unnecessary, but they are used on occasion. When a join table for a many-to-many relationship exists, it must be truncated before the tables it references.

changeset-bot[bot] commented 2 years ago

🦋 Changeset detected

Latest commit: 84421e67f31c811e71465ea49e4e5e70e0b5a85d

The changes in this PR will be included in the next version bump.

This PR includes changesets to release 45 packages | Name | Type | | ------------------------------------------ | ----- | | @mds-core/mds-repository | Patch | | @mds-core/mds-attachment-service | Patch | | @mds-core/mds-audit-service | Patch | | @mds-core/mds-collector-service | Patch | | @mds-core/mds-compliance-service | Patch | | @mds-core/mds-geography-service | Patch | | @mds-core/mds-ingest-service | Patch | | @mds-core/mds-jurisdiction-service | Patch | | @mds-core/mds-policy-service | Patch | | @mds-core/mds-transaction-service | Patch | | @mds-core/mds-audit-api | Patch | | @mds-core/mds-db | Patch | | @container-images/mds-attachment-service | Patch | | @container-images/mds-audit-service | Patch | | @mds-core/mds-collector-api | Patch | | @container-images/mds-collector-service | Patch | | @mds-core/mds-compliance-api | Patch | | @mds-core/mds-compliance-batch-processor | Patch | | @mds-core/mds-compliance-engine | Patch | | @container-images/mds-compliance-service | Patch | | @mds-core/mds-geography-api | Patch | | @mds-core/mds-geography-author-api | Patch | | @mds-core/mds-policy-author-api | Patch | | @mds-core/mds-policy | Patch | | @container-images/mds-geography-service | Patch | | @mds-core/mds-agency | Patch | | @mds-core/mds-test-data | Patch | | @container-images/mds-ingest-service | Patch | | @mds-core/mds-jurisdiction-api | Patch | | @container-images/mds-jurisdiction-service | Patch | | @container-images/mds-policy-service | Patch | | @mds-core/mds-transaction-api | Patch | | @container-images/mds-transaction-service | Patch | | @container-images/mds-audit-api | Patch | | @mds-core/mds-api-helpers | Patch | | @container-images/mds-collector-api | Patch | | @container-images/mds-compliance-api | Patch | | @container-images/mds-geography-api | Patch | | @container-images/mds-geography-author-api | Patch | | @container-images/mds-policy-author-api | Patch | | @container-images/mds-policy | Patch | | @container-images/mds-agency | Patch | | @container-images/mds-jurisdiction-api | Patch | | @container-images/mds-transaction-api | Patch | | @container-images/mds-config-api | Patch |

Not sure what this means? Click here to learn what changesets are.

Click here if you're a maintainer who wants to add another changeset to this PR

nessur commented 2 years ago

You're forgetting TRUNCATE ... CASCADE