#!/bin/bash
DB="YourDatabase"  # e.g., "Clickhouse", "Postgres"

REQUIRED_CLASSES=(
  "${DB}SpecTest"
  "${DB}TestConfigFactory"
  "${DB}TestTableOperationsClient"
  "${DB}TableOperationsTest"
  "${DB}CheckTest"
  "${DB}WriteInitTest"
  "${DB}WiringTest"
  "${DB}TableSchemaEvolutionTest"
  "${DB}BasicFunctionalityTest"
)

echo "Checking for required test classes..."
MISSING=0

for class in "${REQUIRED_CLASSES[@]}"; do
  if grep -rq "class $class" src/test-integration/; then
    echo "✅ $class"
  else
    echo "❌ $class - MISSING"
    MISSING=$((MISSING + 1))
  fi
done

echo ""
if [ $MISSING -eq 0 ]; then
  echo "All test classes present!"
else
  echo "Missing $MISSING test class(es)"
  exit 1
fi

@Test override fun `connect to database`()
@Test override fun `create and drop namespaces`()
@Test override fun `create and drop tables`()
@Test override fun `insert records`()
@Test override fun `count table rows`()

@Test override fun `all beans are injectable`()
@Test override fun `writer setup completes`()
@Test override fun `can create append stream loader`()
@Test override fun `can write one record`()

@Test override fun `discover recognizes all data types`()
@Test override fun `computeSchema handles all data types`()
@Test override fun `noop diff`()
@Test override fun `changeset is correct when adding a column`()
@Test override fun `changeset is correct when dropping a column`()
@Test override fun `changeset is correct when changing a column's type`()
@Test override fun `apply changeset - handle sync mode append`()
@Test override fun `apply changeset - handle changing sync mode from append to dedup`()
@Test override fun `apply changeset - handle changing sync mode from dedup to append`()
@Test override fun `apply changeset - handle sync mode dedup`()
@Test override fun `change from string type to unknown type`()
@Test override fun `change from unknown type to string type`()

# Component tests (fast, uses Testcontainers)
./gradlew :destination-{db}:componentTest

# Integration tests (requires secrets/config.json)
./gradlew :destination-{db}:integrationTest

# Full validation
./gradlew :destination-{db}:check

destination-clickhouse/src/test-integration/kotlin/io/airbyte/integrations/destination/clickhouse/
├── spec/
│   └── ClickhouseSpecTest.kt
├── check/
│   └── ClickhouseCheckTest.kt
├── write/
│   └── ClickhouseWriteInitTest.kt
└── component/
    ├── ClickhouseTestConfigFactory.kt
    ├── ClickhouseTestTableOperationsClient.kt
    ├── ClickhouseTableOperationsTest.kt
    ├── ClickhouseWiringTest.kt
    └── ClickhouseTableSchemaEvolutionTest.kt