🔨 New pytest-simcore `environment_config` fixtures and `utils_postgres` helpers

pcrespov commented 1 month ago

What do these changes do?

Here are some changes in pytest-simcore and servicelib that can be useful in many services. I have used them in some of the services as example and will do systematically with many more in different PRs

🔨 new fixture docker_compose_service_environment_dict: replicates the env vars that the real services will encounter
- resolves .env-devel and the environment section of a service_name. Detects e.g. missing env vars in .env-devel
- used in payments as example (NOTE: recommended to build app_environment fixture in all services services)
🔨 new helper pytest_simcore.helpers.utils_postgres.insert_and_get_row_lifespan context for a control lifespan of a new row.
♻️ moved middleware to packages/service-library/src/servicelib/fastapi/timing_middleware.py from dat-core service

Related issue/s

Preparation for https://github.com/ITISFoundation/osparc-simcore/pull/5904 (the latter was too big for a single PR)

How to test

in place

Dev-ops checklist

None

codecov[bot] commented 1 month ago

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 78.8%. Comparing base (cafbf96) to head (f015145). Report is 250 commits behind head on master.

Additional details and impacted files

[![Impacted file tree graph](https://app.codecov.io/gh/ITISFoundation/osparc-simcore/pull/5909/graphs/tree.svg?width=650&height=150&src=pr&token=h1rOE8q7ic&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=ITISFoundation)](https://app.codecov.io/gh/ITISFoundation/osparc-simcore/pull/5909?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=ITISFoundation) ```diff @@ Coverage Diff @@ ## master #5909 +/- ## ========================================= - Coverage 84.5% 78.8% -5.8% ========================================= Files 10 1165 +1155 Lines 214 48699 +48485 Branches 25 821 +796 ========================================= + Hits 181 38403 +38222 - Misses 23 10132 +10109 - Partials 10 164 +154 ``` | [Flag](https://app.codecov.io/gh/ITISFoundation/osparc-simcore/pull/5909/flags?src=pr&el=flags&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=ITISFoundation) | Coverage Δ | | |---|---|---| | [integrationtests](https://app.codecov.io/gh/ITISFoundation/osparc-simcore/pull/5909/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=ITISFoundation) | `58.9% <ø> (?)` | | | [unittests](https://app.codecov.io/gh/ITISFoundation/osparc-simcore/pull/5909/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=ITISFoundation) | `78.7% <100.0%> (-5.8%)` | :arrow_down: | Flags with carried forward coverage won't be shown. [Click here](https://docs.codecov.io/docs/carryforward-flags?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=ITISFoundation#carryforward-flags-in-the-pull-request-comment) to find out more. | [Files](https://app.codecov.io/gh/ITISFoundation/osparc-simcore/pull/5909?dropdown=coverage&src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=ITISFoundation) | Coverage Δ | | |---|---|---| | [...imcore\_service\_datcore\_adapter/api/module\_setup.py](https://app.codecov.io/gh/ITISFoundation/osparc-simcore/pull/5909?src=pr&el=tree&filepath=services%2Fdatcore-adapter%2Fsrc%2Fsimcore_service_datcore_adapter%2Fapi%2Fmodule_setup.py&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=ITISFoundation#diff-c2VydmljZXMvZGF0Y29yZS1hZGFwdGVyL3NyYy9zaW1jb3JlX3NlcnZpY2VfZGF0Y29yZV9hZGFwdGVyL2FwaS9tb2R1bGVfc2V0dXAucHk=) | `100.0% <100.0%> (ø)` | | ... and [1147 files with indirect coverage changes](https://app.codecov.io/gh/ITISFoundation/osparc-simcore/pull/5909/indirect-changes?src=pr&el=tree-more&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=ITISFoundation)