Multiple tests are skipped for Async operations

[henrikstranneheim]

As a system developer
I want all test functions to not be skipped,
So that I can change the code and trust in the test suite.

Acceptance Criteria

• Criteria 1
• Criteria 2
• Criteria 3
  ...

Notes

• Additional information.
• Dependencies.
• Related user stories.

Implementation plan

• Work item 1
• Work item 2

[henrikstranneheim]

@ahdamin This seem to be related to the async changes.

[ahdamin]

Thank you, @henrikstranneheim, for highlighting this issue. It seems we need to add a fixture for AsyncSession and incorporate pytest-asyncio to properly handle tests involving asynchronous operations