Is it possible to make a query inside a transaction?
Let's say I am adding 100 records inside one transaction. Before adding each record I need to check if a simmiliar one have already been added within the ongoing transaction.
I would like to use it this way:
$transaction = $manager->get(); //adding records ... $car = new Car(); $car->setTransaction($transaction); $car->setPlate('XYZ'); $car->create(); // adding more records ... //I want to check here if a car with plates XYZ have been added during transaction already Car::findByPlate('XYZ'); //PROBLEM! this returns "false" and I want it to return "true" $manager->commit(); //from here the car will be visible in DB Car::findByPlate('XYZ'); //returns "true"
I am using MySQL.