Handle InvalidRequestErrors by re-initializing the database session.

[snekiam]

What's New?

Re-init database when there's an invalid transaction. Everything except for lines 6, 117, and 118 of flask_api.py should be formatting changes only.

Fixes #195

Type of change (pick-one)

• [x] Bug fix (non-breaking change which fixes an issue)
• [ ] New feature (non-breaking change which adds functionality)
• [ ] Breaking change (fix or feature that would cause existing functionality to not work as expected)
• [ ] This change requires a documentation update

How Has This Been Tested?

Killed internet, asked questions, then re-enabled internet. This allows Nimbus to try reconnecting to the MySQL database after an interruption like that.

Checklist (check-all-before-merge)

formatting help: - [x] means "checked' and - [ ] means "unchecked"

• [ ] I documented my code according to the Google Python Style Guide

• [ ] I ran ./build_docs.sh and the docs look fine

• [ ] I ran ./type_check.sh and got no errors

• [x] I ran ./format.sh because it automatically cleans my code for me 😄

• [ ] I ran ./lint.sh to check for what "format" missed

• [ ] I added my tests to the /tests directory

• [x] I ran ./run_tests.sh and all the tests pass

[sonarcloud[bot]]

Kudos, SonarCloud Quality Gate passed!

0 Bugs
0 Vulnerabilities (and 0 Security Hotspots to review)
1 Code Smell

No Coverage information
0.0% Duplication