#1977 Bug: Update to Delivered After Other Status is Assigned

[EvanParish]

Description

This changes how we handling updating our notification statuses, so that delivered takes precedence over others.

Note: Setting execution_options on the query was necessary because of an error when attempting run the query stating the query could not be evaluate in python. Setting this option to 'fetch' causes a select query or db returning statement to execute with the update effectively doubling the number of queries executed here. We could set this option to False instead if we want the update to just go through when it's executed instead of having the session state be updated. sqlalchemy docs

issue #1977

How Has This Been Tested?

This will be somewhat tricky to test because part of the reason this change is necessary is because a notification seems to be able to reach another status we consider "final" before reaching a "delivered" status.

• [x] unit tests pass

• [x] deployed to Dev

• We can't really force this to happen, so we'll have to rely on the regression tests

Checklist

• [x] I have assigned myself to this PR
• [x] PR has an appropriate title: #9999 - What the thing does
• [x] PR has a detailed description, including links to specific documentation
• [x] I have added the appropriate labels to the PR.
• [x] I did not remove any parts of the template, such as checkboxes even if they are not used
• [x] My code follows the style guidelines of this project
• [x] I have performed a self-review of my own code
• [x] I have commented my code, particularly in hard-to-understand areas
• [ ] I have made corresponding changes to any documentation
• [x] My changes generate no new warnings
• [x] I have added tests that prove my fix is effective or that my feature works. Testing guidelines
• [x] I have ensured the latest main is merged into my branch and all checks are green prior to review
• [x] New and existing unit tests pass locally with my changes
• [ ] Any dependent changes have been merged and published in downstream modules
• [x] The ticket was moved into the DEV test column when I began testing this change