Add integration tests (for shared and dedicated env)

Added integration test. This is a basic test that can be run manually for MR.

This script triggers a pipeline with a "dedicated" or "shared" test and monitors its execution status.
Upon the pipeline's completion, it checks the status of each job. If any of the jobs fail, the entire test run is considered a failure.

Examples:

• Failed: https://gitlab.com/postgres-ai/postgresql-consulting/tests-and-benchmarks/-/jobs/6530207677
• Success: https://gitlab.com/postgres-ai/postgresql-consulting/tests-and-benchmarks/-/jobs/6530505953