Level 8
Here's an article @fideloper wrote a year ago regarding and exampling the topic
1 like
Dec 29, 2014
7
Level 8
how to know if DB::transaction failed
I have some code that runs every night as a transaction:
DB::transaction(function() {
$vitelity = new Vitelity;
$calls = $vitelity->getAllCalls();
DB::table('calls')->insert($calls);
});
I know that DB::transaction will automatically rollback if it encounters any errors, but how do I catch that it has rolled back and find out what the error is. Ill probably use mailgun to send the info to me when I can figure out how to get the info when it happens.
Level 8
wow I appreciate the link a lot but its a lot of info and I think what I want is much simpler I just want to know if the transaction automatically got rolled back in the above code example. i.e. what to test for
Level 8
maybe something like:
DB::transaction(function() {
$vitelity = new Vitelity;
$calls = $vitelity->getAllCalls();
try
{
DB::table('calls')->insert($calls);
}
catch (\PDOException $e)
{
//send mail with subject "db import failed" and body of $e->getMessage()
}
});
that seems like it could work right?
Level 41
Yes, Putting your code inside a try and catching any exception will works just fine.
Level 8
thanks @rachidlaasri so instead of:
catch (\PDOException $e)
do
catch (\Exception $e)
and that will catch any exception at all?
Thanks for the help I'm going to go straight here: https://laracasts.com/lessons/lets-talk-exceptions
Level 41
Yeah, There's couple examples in this link.
Level 11
Sounds like you want to know if Laravel fires an event if a rollback happens.
Looks like, yes, it just might. Try listening for event connection.rollingBack:
1 like
Please or to participate in this conversation.