Improve EagerFetching Related Data

[rotexdegba]

Look into allowing nested arrays for specifying related data to be eager loaded via fetch methods. Right now you can only specify a one level array of strings. Need to be able to do something like this:

E.g

fetchOneRecord(
   null,
  [
    'author',
    'summary',
    'replies' => [
        'author'
  ]
);

[rotexdegba]

Added public function eagerLoadRelatedData(array $relationsToInclude): static to the Collection class for helping to eager fetch related data from a fetched collection of related data.

I have an idea of using this method inside the fetch methods that fetch:

• a Record (fetchOneRecord, fetchOneByPkey)
• an array of Records (fetchRecordsIntoArray, fetchRecordsIntoArrayKeyedOnPkVal)
• and a Collection of Records (fetchRecordsIntoCollection, fetchRecordsIntoCollectionKeyedOnPkVal)

This method can be used recursively within the methods above to implement nested eager fetching. Example implementation in the Model class could be like below:

$model->fetchOneRecord(
   null,
  [
    'author',
    'summary',
    'replies' => [
        'author'
  ]
);

// we loop through the relationship array recursively and call **eagerLoadRelatedData(array $relationsToInclude): static** 

// will flesh out this idea later

// traversal algorithm

function traverseArrayRecursively($array) {
    foreach ($array as $key => $value) {
        if (is_array($value)) {
            // If the value is an array, recursively call the function
            echo "Entering sub-array at key: " . $key . "\n";
            traverseArrayRecursively($value);
            echo "Exiting sub-array at key: " . $key . "\n";
        } else {
            // If the value is not an array, process it (e.g., print it)
            echo "Key: " . $key . ", Value: " . $value . "\n";
        }
    }
}