[ehb54/us3_sql] a4da98: Refuse to delete a project that has experiments li...
Branch: refs/heads/ehb54-issue-1143 Home: https://github.com/ehb54/us3_sql Commit: a4da98d5561c970221ddb00d79b933aa3c8f1aa6 https://github.com/ehb54/us3_sql/commit/a4da98d5561c970221ddb00d79b933aa3c8f... Author: ehb54 <brookes@uthscsa.edu> Date: 2026-10-13 (Tue, 13 Oct 2026) Changed paths: M us3_procedures.sql M us3_proj_procs.sql Log Message: ----------- Refuse to delete a project that has experiments linked to it delete_project only checked ownership before deleting the project. Since fk_experiment_projectID is ON DELETE SET NULL, every experiment in the project silently lost its project link. delete_project now counts the linked experiments first. If there are any, it deletes nothing and returns the new PROJECT_IN_USE (556) status, as the analyte, buffer and solution deletes already do. The new get_project_experiments procedure lists the linked experiments, so that clients can show them to the user. Part of ehb54/ultrascan-tickets#1143 Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com> To unsubscribe from these emails, change your notification settings at https://github.com/ehb54/us3_sql/settings/notifications
participants (1)
-
emre brookes