datastore/tests/integration/test_s3_with_https/test.py

import logging
import time
import pytest

from helpers.cluster import ClickHouseCluster


def check_proxy_logs(cluster, proxy_instance) -> bool:
    logs = cluster.get_container_logs(proxy_instance)
    # Check that all possible interactions with Minio are present
    for http_method in ["PUT", "GET", "POST"]:
        if logs.find(http_method + " https://minio1") < 0:
            return False

    return True


@pytest.fixture(scope="module")
def cluster():
    try:
        cluster = ClickHouseCluster(__file__)
        cluster.add_instance(
            "node",
            main_configs=[
                "configs/config.d/storage_conf.xml",
                "configs/config.d/ssl.xml",
            ],
            with_minio=True,
            minio_certs_dir="minio_certs",
            # Disable `with_remote_database_disk` as the test uses S3 with http, which might cause the S3 unreachable with default settings
            with_remote_database_disk=False,
        )
        logging.info("Starting cluster...")
        cluster.start()
        logging.info("Cluster started")

        yield cluster
    finally:
        cluster.shutdown()


@pytest.mark.parametrize("policy", ["s3_secure", "s3_secure_with_proxy"])
def test_s3_with_https(cluster, policy):
    node = cluster.instances["node"]

    node.query(
        """
        CREATE TABLE s3_test (
            id Int64,
            data String
        ) ENGINE=MergeTree()
        ORDER BY id
        SETTINGS storage_policy='{}'
        """.format(
            policy
        )
    )

    node.query("INSERT INTO s3_test VALUES (0,'data'),(1,'data')")
    assert (
        node.query("SELECT * FROM s3_test order by id FORMAT Values")
        == "(0,'data'),(1,'data')"
    )

    node.query("DROP TABLE IF EXISTS s3_test SYNC")

    if policy.find("proxy") != -1:
        for i in range(100):
            proxy_logs_exist = check_proxy_logs(cluster, "proxy1")
            if proxy_logs_exist:
                break

            time.sleep(1)

        assert proxy_logs_exist