1. <?php
  3. /**
  4. * Diff metadata datasets without external libraries.
  5. *
  6. * @param array $dataset1 The first dataset (array of associative arrays).
  7. * @param array $dataset2 The second dataset (array of associative arrays).
  8. * @param string $key The key to compare within each dataset entry.
  9. * @return array An array of differences, where each element is an array
  10. * containing the key and the differing values from dataset1 and dataset2.
  11. */
  12. function diffMetadataDatasets(array $dataset1, array $dataset2, string $key): array
  13. {
  14. $differences = [];
  16. // Create associative arrays for easier lookup
  17. $dataset1_map = [];
  18. foreach ($dataset1 as $item) {
  19. if (isset($item[$key])) {
  20. $dataset1_map[$item[$key]] = $item;
  21. }
  22. }
  24. $dataset2_map = [];
  25. foreach ($dataset2 as $item) {
  26. if (isset($item[$key])) {
  27. $dataset2_map[$item[$key]] = $item;
  28. }
  29. }
  31. // Find items present in dataset1 but not in dataset2
  32. foreach ($dataset1_map as $key => $item1) {
  33. if (!isset($dataset2_map[$key])) {
  34. $differences[] = [$key => ['dataset1' => $item1, 'dataset2' => null]];
  35. }
  36. }
  38. // Find items present in dataset2 but not in dataset1
  39. foreach ($dataset2_map as $key => $item2) {
  40. if (!isset($dataset1_map[$key])) {
  41. $differences[] = [$key => ['dataset1' => null, 'dataset2' => $item2]];
  42. }
  43. }
  46. // Find differences for common keys
  47. foreach ($dataset1_map as $key => $item1) {
  48. if (isset($dataset2_map[$key])) {
  49. $item2 = $dataset2_map[$key];
  51. // Compare values for each key in the items
  52. $diff = [];
  53. foreach ($item1 as $k => $v) {
  54. if ($v !== $item2[$k]) {
  55. $diff[$k] = ['dataset1' => $v, 'dataset2' => $item2[$k]];
  56. }
  57. }
  58. if (!empty($diff)) {
  59. $differences[] = [$key => ['dataset1' => $item1, 'dataset2' => $item2, 'diff' => $diff]];
  60. }
  61. }
  62. }
  64. return $differences;
  65. }
  67. //Example Usage (for testing)
  68. /*
  69. $dataset1 = [
  70. ['id' => 1, 'name' => 'Alice', 'age' => 30],
  71. ['id' => 2, 'name' => 'Bob', 'age' => 25],
  72. ['id' => 3, 'name' => 'Charlie', 'age' => 35],
  73. ];
  75. $dataset2 = [
  76. ['id' => 1, 'name' => 'Alice', 'age' => 30],
  77. ['id' => 2, 'name' => 'Robert', 'age' => 25],
  78. ['id' => 4, 'name' => 'David', 'age' => 40],
  79. ];
  81. $differences = diffMetadataDatasets($dataset1, $dataset2, 'id');
  83. print_r($differences);
  84. */
  86. ?>

Add your comment