Level 104
I want to use DB::Transaction to store option with values or rollback all
Why do you need a transaction here; what is the context, where is this createOptionWithValues method used?
Dec 4, 2025
3
Level 2
Refactor function and DB Transaction
Hello, i have this function in a service :
public function createOptionWithValues(array $data): Option
{
$data = $this->prepareOptionData($data);
$validationErrors = $this->validateOption($data);
if (!empty($validationErrors)) {
throw ValidationException::withMessages($validationErrors);
}
$option = new Option();
$option->title = $data['title'];
$option->normalized_title = $data['normalized_title'];
$option->type = OptionTypesEnum::from($data['type']);
$option->status_id = $data['status_id'];
$option->sort = $data['sort'] ?? 0;
$option->image = $data['image'] ?? null;
$option->meta_data = $data['meta_data'] ?? null;
$option->save();
// Create option values if provided
if (!empty($data['values'])) {
foreach ($data['values'] as $value) {
$this->createValue($option, $value);
}
}
return $option;
}
I want to use DB::Transaction to store option with values or rollback all
first: can we refactor this function second: can i use DB::Transaction in a service or in the controller
Level 2
it creats values with this option (master details table) in the same service
public function createValue(Option $option, array $value): OptionValue
{
$optionValue = new OptionValue();
$optionValue->option_id = $option->id;
$optionValue->fill($this->mapOptionValue($value));
$optionValue->save();
return $optionValue;
}
Level 104
What Exception(s) are you expecting in this scenario; is there something else happening other than new records being written to the database?
In response to your original question, you can put the transaction anywhere, in the Service class method or the Controller action depending on what else you need to wrap within the transaction. Just be mindful nesting transactions is not possible for many RDBMS.
Please or to participate in this conversation.