JSON fields to update only subkeys if present in the body

To achieve the desired functionality of updating only specific subkeys of the config field in the database, you can use Laravel's ->json() method to update JSON columns. Here's how you can adapt your code to handle this:

1. Check if the config key exists in the request body.
2. Merge the existing config data with the new data from the request body.
3. Update the config field in the database with the merged data.

Here's the updated code:

$fieldsToUpdate = [];

foreach ($body->payload as $key => $value) {
    if (in_array($key, ['input_bandwidth', 'output_bandwidth', 'config'])) {
        if ($key === 'config' && is_array($value)) {
            // Fetch the existing config from the database
            $existingConfig = $port->config ?? [];

            // Merge the existing config with the new values
            $mergedConfig = array_merge($existingConfig, $value);

            // Add the merged config to the fields to update
            $fieldsToUpdate[$key] = $mergedConfig;
        } else {
            if ($value) {
                $fieldsToUpdate[$key] = $value;
            }
        }
    }
}

$infrastructure = Infrastructure::firstOrCreate([
    'name' => $body->payload->infrastructure_name,
]);

$port = Port::updateOrCreate([
    'name' => $body->payload->name,
    'infrastructure_id' => $infrastructure->id,
], $fieldsToUpdate);

Explanation:

1. Check for config key: The code checks if the config key is present in the request body and if it is an array.
2. Fetch existing config: It fetches the existing config data from the database. If the config field is null, it initializes it as an empty array.
3. Merge configs: It merges the existing config data with the new data from the request body.
4. Update fields: It adds the merged config data to the $fieldsToUpdate array.
5. Update or create: Finally, it updates or creates the Port record with the updated fields.

This approach ensures that only the specified subkeys in the config field are updated, while the other subkeys remain unchanged.