1. <?php
  3. /**
  4. * Validates dataset configurations.
  5. *
  6. * @param array $dataset_configs An array of dataset configurations.
  7. * @return array An array of validation errors. Empty array if no errors.
  8. */
  9. function validateDatasetConfigs(array $dataset_configs): array
  10. {
  11. $errors = [];
  13. foreach ($dataset_configs as $dataset_id => $config) {
  15. // Validate required fields
  16. if (empty($config['dataset_name'])) {
  17. $errors[$dataset_id] = "Dataset name is required.";
  18. }
  20. if (empty($config['data_source'])) {
  21. $errors[$dataset_id] = "Data source is required.";
  22. }
  24. if (empty($config['schema_path'])) {
  25. $errors[$dataset_id] = "Schema path is required.";
  26. }
  28. // Validate data source format
  29. if (!is_string($config['data_source'])) {
  30. $errors[$dataset_id] = "Data source must be a string.";
  31. }
  33. // Validate schema path format
  34. if (!is_string($config['schema_path'])) {
  35. $errors[$dataset_id] = "Schema path must be a string.";
  36. }
  38. // Validate data type (example: 'csv', 'json', etc.)
  39. if (empty($config['data_type'])) {
  40. $errors[$dataset_id] = "Data type is required.";
  41. }
  43. $valid_data_types = ['csv', 'json', 'sql']; //Example valid types
  44. if (!in_array(strtolower($config['data_type']), $valid_data_types)) {
  45. $errors[$dataset_id] = "Invalid data type. Allowed types are: " . implode(', ', $valid_data_types);
  46. }
  48. // Validate connection parameters (example for SQL)
  49. if (strtolower($config['data_type']) === 'sql') {
  50. if (empty($config['db_host'])) {
  51. $errors[$dataset_id] = "Database host is required for SQL data sources.";
  52. }
  53. if (empty($config['db_name'])) {
  54. $errors[$dataset_id] = "Database name is required for SQL data sources.";
  55. }
  56. if (empty($config['db_user'])) {
  57. $errors[$dataset_id] = "Database user is required for SQL data sources.";
  58. }
  59. if (empty($config['db_password'])) {
  60. $errors[$dataset_id] = "Database password is required for SQL data sources.";
  61. }
  62. }
  63. }
  65. return $errors;
  66. }
  68. //Example Usage
  69. /*
  70. $dataset_configs = [
  71. 1 => [
  72. 'dataset_name' => 'Customer Data',
  73. 'data_source' => 'data.csv',
  74. 'schema_path' => '/path/to/schema.json',
  75. 'data_type' => 'csv'
  76. ],
  77. 2 => [
  78. 'dataset_name' => 'Product Catalog',
  79. 'data_source' => 'products.json',
  80. 'schema_path' => '/path/to/product_schema.json',
  81. 'data_type' => 'json'
  82. ],
  83. 3 => [
  84. 'dataset_name' => 'Sales Data',
  85. 'data_source' => 'mydb',
  86. 'schema_path' => '/path/to/sql_schema.json',
  87. 'data_type' => 'sql'
  88. ]
  89. ];
  91. $validation_errors = validateDatasetConfigs($dataset_configs);
  93. if (!empty($validation_errors)) {
  94. echo "Validation Errors:\n";
  95. foreach ($validation_errors as $dataset_id => $error) {
  96. echo "Dataset " . $dataset_id . ": " . $error . "\n";
  97. }
  98. } else {
  99. echo "All datasets are valid.\n";
  100. }
  101. */
  105. ?>

Add your comment