Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Cleanup and Prevent Orphaned read_access Entries for Permanently Deleted Resources #170

Closed
hhund opened this issue Jan 16, 2024 · 0 comments · Fixed by #171 or #185
Closed

Cleanup and Prevent Orphaned read_access Entries for Permanently Deleted Resources #170

hhund opened this issue Jan 16, 2024 · 0 comments · Fixed by #171 or #185
Assignees
@hhund
Labels
enhancement New feature or request ready for release Issue is fixed and merged into develop, ready for next release
Milestone
1.5.0

Comments

@hhund
Copy link
Member

hhund commented Jan 16, 2024

If resources are permanently deleted, corresponding entries in the read_access table are left orphaned.

We should add a database migration script to cleanup old orphaned entries and add BEFORE DELETE database triggers to resource tables to remove corresponding entries from the read_access table if resources are permanently deleted.
@hhund hhund added the enhancement New feature or request label Jan 16, 2024
@hhund hhund added this to the 1.5.0 milestone Jan 16, 2024
@hhund hhund self-assigned this Jan 16, 2024
@hhund hhund mentioned this issue Jan 16, 2024
Merged
@hhund hhund linked a pull request Jan 16, 2024 that will close this issue
Issue/170 orphaned read access entries #171
Merged
@hhund hhund added the ready for release Issue is fixed and merged into develop, ready for next release label Feb 19, 2024
@hhund hhund mentioned this issue Feb 21, 2024
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@hhund hhund

Labels
enhancement New feature or request ready for release Issue is fixed and merged into develop, ready for next release
Projects
None yet
Milestone
1.5.0
1 participant
@hhund