# Test Configuration for Docker SQL Server Environment
# Use this configuration with the Docker test environment

database_pairs:
  - name: "Docker_Test_Comparison"
    enabled: true
    description: "Compare Docker test databases"
    baseline:
      server: "localhost,1433"
      database: "TestDB_Baseline"
      # Use environment variables for credentials: DRT_DB_USERNAME, DRT_DB_PASSWORD
      # username: "${DRT_DB_USERNAME}"
      # password: "${DRT_DB_PASSWORD}"
      timeout:
        connection: 30
        query: 300
    target:
      server: "localhost,1434"
      database: "TestDB_Target"
      # Use environment variables for credentials: DRT_DB_USERNAME, DRT_DB_PASSWORD
      # username: "${DRT_DB_USERNAME}"
      # password: "${DRT_DB_PASSWORD}"
      timeout:
        connection: 30
        query: 300

comparison:
  mode: "health_check"
  row_count:
    enabled: true
    tolerance_percent: 0.0
  schema:
    enabled: true
    checks:
      column_names: true
      data_types: true
  aggregates:
    enabled: true
    tolerance_percent: 0.01

tables:
  - schema: "dbo"
    name: "DimTable1"
    enabled: true
    expected_in_target: true
    aggregate_columns: []
    notes: "Example dimension table"

  - schema: "dbo"
    name: "DimTable2"
    enabled: true
    expected_in_target: true
    aggregate_columns: []
    notes: "Example dimension table with schema differences"

  - schema: "dbo"
    name: "FactTable1"
    enabled: true
    expected_in_target: true
    aggregate_columns:
      - "Quantity"
      - "Amount"
      - "Tax"
    notes: "Example fact table with numeric aggregates"

  - schema: "dbo"
    name: "TempTable1"
    enabled: true
    expected_in_target: false
    aggregate_columns: []
    notes: "Example temporary table - only exists in target"

reporting:
  output_directory: "/home/user/reports"
  investigation_directory: "/home/user/investigation_reports"
  formats: ["html", "csv"]
  filename_template: "test_regression_{timestamp}"

logging:
  level: "INFO"
  directory: "/home/user/logs"
  filename_template: "drt_test_{timestamp}.log"
  console: true