clickhouse-ci-integration

# ClickHouse CI Integration ## Overview Run integration tests against a real ClickHouse server in GitHub Actions using Docker service containers. No mocks needed for schema and query validation. ## Prerequisites - GitHub repository with Actions enabled - `@clickhouse/client` in project dependencies - Test suite (vitest or jest) ## Instructions ### Step 1: GitHub Actions Workflow with ClickHouse Service ```yaml # .github/workflows/clickhouse-tests.yml name: ClickHouse Integration Tests on: push: branches: [main] pull_request: branches: [main] jobs: test: runs-on: ubuntu-latest services: clickhouse: image: clickhouse/clickhouse-server:latest ports: - 8123:8123 - 9000:9000 options: >- --health-cmd "wget --no-verbose --tries=1 --spider http://localhost:8123/ping || exit 1" --health-interval 10s --health-timeout 5s --health-retries 5 env: CLICKHOUSE_HOST: http://localhost:8123 CLICKHOUSE_USER: default CLICKHOUSE_PASSWORD: "" steps: - uses: actions/checkout@v4 - uses: actions/setup-node@v4 with: node-version: "20" cache: "npm" - run: npm ci # Apply schema before tests - name: Apply schema run: | curl -s 'http://localhost:8123/' -d 'CREATE DATABASE IF NOT EXISTS test_db' for f in init-db/*.sql; do echo "Applying $f..." curl -...