diff options
| author |   danielhanrahan <daniel.hanrahan@est.tech> | 2023-05-04 22:34:41 +0100 |
|---|---|---|
| committer | danielhanrahan <daniel.hanrahan@est.tech> | 2023-05-12 13:17:38 +0100 |
| commit | b740156bb50784fc461e2fbda13cd91e3f208b38 (patch) | |
| tree | b305c9c827ae7c323e40ac10975a34093e86fecc /cps-ri/src/test/resources/data/anchor.sql | |
| parent | 26a51754dd8aa9b467bcb442e6042f22af2ba001 (diff) | |
Remove dataspace_id column from Fragment table
- Remove dataspace_id column from fragment table and drop associated
index, foreign key constraint and uniqueness constaint.
- Add uniqueness constraint using only fragment xpath and anchor_id.
- Add not-null constraint to anchor_id.
- Update code and test data to remove references to dataspace_id.
- Repopulate the dataspace_id in Liquibase rollback
(verified with manual testing of update/rollback).
Issue-ID: CPS-1677
Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech>
Change-Id: I467cccba25ac5d884ec790064ca58150281b7e1d
Diffstat (limited to 'cps-ri/src/test/resources/data/anchor.sql')
| -rw-r--r-- | cps-ri/src/test/resources/data/anchor.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/cps-ri/src/test/resources/data/anchor.sql b/cps-ri/src/test/resources/data/anchor.sql index 2ab7966e18..a15d5aed21 100644 --- a/cps-ri/src/test/resources/data/anchor.sql +++ b/cps-ri/src/test/resources/data/anchor.sql @@ -35,5 +35,5 @@ INSERT INTO ANCHOR (ID, NAME, DATASPACE_ID, SCHEMA_SET_ID) VALUES (3002, 'ANCHOR-002', 1001, 2002), (3003, 'ANCHOR-003', 1001, 2002); -INSERT INTO FRAGMENT (ID, DATASPACE_ID, ANCHOR_ID, PARENT_ID, XPATH, ATTRIBUTES) VALUES - (4001, 1001, 3001, null, '/xpath', '{}'); +INSERT INTO FRAGMENT (ID, ANCHOR_ID, PARENT_ID, XPATH, ATTRIBUTES) VALUES + (4001, 3001, null, '/xpath', '{}'); |