Separate long duration tests

[ckunki]

In the scope of issue #45 a test case was implemented and added to SAPIPY.
In consequence the duration of integration tests increased significantly.

To enable faster turn around cycles the current issue requests to

• Separate such long-running tests should be from faster tests
• Enable to control execution of these slow tests by a keyword in the commit message

See documentation and discussions on GitHub

• https://github.com./orgs/community/discussions/28474
• stackoverflow.com/59471099
• Event pull-request
• reusing-workflows

[ckunki]

See annotation @pytest.mark.skipif in integration tests of pytest-idte for example:

default_version_only=pytest.mark.skipif(
    "EXASOL_VERSION" in os.environ and os.environ["EXASOL_VERSION"] != default_version,
    reason="""...""",
)

And see example for detecting keywords in commit messages in ai-lab's workflow check_ci.yaml.

    if: "contains(github.event.head_commit.message, '[run-notebook-tests]')"

See also pytest documentation:

[tool.pytest.ini_options]
markers = [
    "slow: marks tests as slow (deselect with '-m \"not slow\"')",
    "serial",
]