researchequals/api

Fork 0

feat(outputs): add versioning functionality of outputs #156

Merged

chartgerink merged 20 commits from add/versions into main

2026-03-30 09:16:34 +00:00

chartgerink commented

2026-03-24 12:15:07 +00:00

Owner

Builds on the structural changes introduced in 2.0.0.

To do

Ensure version labels for versions prior to February 1st, 2026 are 1.0.0 by default

Builds on the structural changes introduced in 2.0.0. ## To do - [x] Ensure version labels for versions prior to February 1st, 2026 are `1.0.0` by default - [x]

chartgerink added 12 commits

2026-03-24 12:15:08 +00:00

error if new draft version already exists 63eb0f31cb

duplicate new version from old, including authors e7794f2414

add version_label and changelog to versions table 27b9d655cd

add SemVer bump utility 78ccc5b939

update versions handlers c5e14fb446

manage test conformity d598f7e016

add tests for version_label and changelog 36d005126b

init version_history for /[outputs/version]/{id} routes 75ed61710d

refactor into load_version_history() 91f7710a57

add id and version to version_history objects 1bcab9edac

remove version_history from /outputs a302822f70

ensure concordant PIDs per object c0d172c434

/outputs provides output pids, versions provides version pids by
default. versions will provide `output_pids` as well, clearly
named as such

chartgerink added 3 commits

2026-03-24 15:41:31 +00:00

update tests 7403e3801a

add semver comparison utility beec564c99

add updates to versions >1.0.0 2f06ebe749

chartgerink added 2 commits

2026-03-26 09:45:39 +00:00

bump version to 2.2.0 in prep for release 28d7e93c2a

add content_mediatype to /versions/{id} f3908d57ed

chartgerink added 1 commit

2026-03-26 10:46:06 +00:00

add duplication of supporting files 8035795f75

chartgerink added 2 commits

2026-03-30 09:12:36 +00:00

ensure v1 publications are not versionable e2d1fb8dbd

update tests for versionable outputs fad13106a1

chartgerink commented

2026-03-30 09:14:22 +00:00

Author

Owner

After deploying this, the production database needs to be managed properly:

Check for multiple versions prior to Feb 1, 2026 (expecation: none):

-- Find outputs with multiple pre-Feb-2026 versions
SELECT output_id, COUNT(*) as conflict_count
FROM versions
WHERE published_at < '2026-02-01'
GROUP BY output_id
HAVING COUNT(*) > 1;

Then update the version labels for those before 2026-02-01 to be v1.0.0

UPDATE versions
SET version_label = '1.0.0'
WHERE published_at < '2026-02-01';

After deploying this, the production database needs to be managed properly: Check for multiple versions prior to Feb 1, 2026 (expecation: none): ``` -- Find outputs with multiple pre-Feb-2026 versions SELECT output_id, COUNT(*) as conflict_count FROM versions WHERE published_at < '2026-02-01' GROUP BY output_id HAVING COUNT(*) > 1; ``` Then update the version labels for those before 2026-02-01 to be v1.0.0 ``` UPDATE versions SET version_label = '1.0.0' WHERE published_at < '2026-02-01'; ```

chartgerink changed title from ~~WIP: feat(outputs): add versioning functionality of outputs~~ to feat(outputs): add versioning functionality of outputs

2026-03-30 09:14:33 +00:00

chartgerink merged commit 76b06cd5aa into main

2026-03-30 09:16:34 +00:00

chartgerink deleted branch add/versions

2026-03-30 09:16:35 +00:00

chartgerink referenced this pull request from a commit

2026-03-30 09:16:36 +00:00

feat(outputs): add versioning functionality of outputs (#156)