🧰 Issue

Fixes #1112.

🚀 Overview:

SQLAlchemy v1.4.28 emits more warnings in various situations (see here. These warnings are triggered by various geoalchemy functions we use. In our CI, we have it set to turn warnings into errors - which is a good idea in general, but means that we can get unexpected errors from dependencies being upgraded by minor point releases which change warnings rules.

The requirement for SQLAlchemy just required v1.4.x, which is normally ok as breaking changes shouldn't occur in a point release - but this doesn't apply to warnings. So, this PR fixes the version to v1.4.27.

There is already a PR in geoalchemy2 to fix these warnings, so once that PR is merged and a new version is released, then we can stop fixing the point version.

🤔 Reason:

Fix CI.

🔨Work carried out:

[x] Fix version of SQLAlchemy
[x] Tests pass

Confirmations

[x] I have chosen reviewers for my PR.
[x] I have chosen an appropriate label for the PR, adding interactive_review if reviewers will need to see UI
[x] I have extended/updated the documentation in \docs folder
[x] Any database content changes (Create, Edit, Delete) are recorded in the Log/Changes tables
[x] Any database schema changes are implemented via alembic revision transitions
[x] I have completed the mandatory sections of this document.
[x] I have deleted any unused sections.

📝 Developer Notes:

Codecov Report

Merging #1114 (5e16209) into develop (f006e5e) will increase coverage by 0.01%. The diff coverage is n/a.

@@             Coverage Diff             @@
##           develop    #1114      +/-   ##
===========================================
+ Coverage    80.06%   80.07%   +0.01%     
===========================================
  Files          110      110              
  Lines        11896    11896              
===========================================
+ Hits          9524     9526       +2     
+ Misses        2372     2370       -2

Impacted Files	Coverage Δ
pepys_import/resolvers/command_line_resolver.py	`94.85% <0.00%> (+0.25%)`	:arrow_up:
pepys_import/file/file_processor.py	`98.73% <0.00%> (+0.31%)`	:arrow_up:

Continue to review full report at Codecov.

Legend - Click here to learn more Δ = absolute <relative> (impact), ø = not affected, ? = missing data Powered by Codecov. Last update 6b58dcf...5e16209. Read the comment docs.

debrief / pepys-import

Fix SQLAlchemy version to v1.4.27, as v1.4.28 #1114