if(!$workflow_entity = $em->getRepository('AlbatrossAceBundle:Workflow')->findByIdAndStatus($line[$titleArr['WorkflowStepID']],$line[$titleArr['WorkflowStatus']])){
$workflow_entity = new Workflow();
$workflow_entity->setWorkflowStatus($line[$titleArr['WorkflowStatus']]);
$workflow_entity->setWorkflowStepID($line[$titleArr['WorkflowStepID']]);
$em->persist($workflow_entity);
}
I only check if the same data already exists in the current database,
But there are already several pieces of the same data in the data being inserted.
So during the insertion operation, this information is given
An exception occurred while executing 'INSERT INTO workflow (workflow_step_id, workflow_status) VALUES (?, ?)' with params ["10", "Assigned"]:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10-Assigned' for key 'stepid_status_uniq'
uniqueConstraints:
stepid_status_uniq:
columns: [ workflow_step_id, workflow_status ]
I have created a unique constraint in the database (I don’t know if this is correct)
But the data that is being inserted now has the same data before flash
How do I know that the current data violates the unique rule before saving it to the database?
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
You can query once before inserting according to your constraint rules. For example, according to your example, query first
If the result is not 0, it means that continuing to insert will violate the unique rule.
Of course, this is actually not recommended. It is very resource intensive to check every time you insert it
You can consider using
Then check affected_rows after inserting. If it returns 0, it means the data insertion failed. At this time, check whether the constraint rules are violated.
You should use Validation,
http://symfony.com/doc/master/reference/constraints/UniqueEntity.html