83 lines
2.1 KiB
YAML
Executable File
83 lines
2.1 KiB
YAML
Executable File
# 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 |