public function testBatchDeleteForNoIncrementIdModel()
{
/** @var User[] $inputModels */
$inputModels = [];
for ($i = 0; $i < 10; $i++) {
$m = $inputModels[] = new User();
$m->username = "******" . rand(10000, 99999);
$m->password = $m->username;
}
/** @var User[] $savedReturn */
$savedReturn = [];
DbHelper::batchSave($inputModels, [], DbHelper::SAVE_MODE_AUTO, $savedReturn);
/** @var User[] $savedUsers */
$savedUsers = $savedReturn['inserted'];
$department = new Department();
$department->name = "Department testBatchSaveForNoIncrementIdField";
$department->save(false);
/** @var UserDepartmentAssignment[] $inputModels */
$inputModels = [];
$ids = [];
$sql = '';
foreach ($savedUsers as $savedUser) {
$m = $inputModels[] = new UserDepartmentAssignment();
$m->userId = $savedUser->id;
$m->departmentId = $department->id;
$ids[] = ['userId' => $savedUser->id, 'departmentId' => $department->id];
if ($sql != '') {
$sql = $sql . ' OR ';
}
$sql = $sql . "(`userId`={$savedUser->id} AND `departmentId`={$department->id})";
}
DbHelper::batchSave($inputModels, [], DbHelper::SAVE_MODE_AUTO);
$return = DbHelper::batchDelete(UserDepartmentAssignment::tableName(), $ids);
Debug::debug('Batch insert 10 UserDepartmentAssignment records. return=' . Json::encode($return));
$this->assertEquals(10, $return);
$sql = 'SELECT * FROM ' . UserDepartmentAssignment::tableName() . ' WHERE ' . $sql;
$return = UserDepartmentAssignment::findBySql($sql)->count();
$this->assertEquals(0, $return);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getDepartment()
{
return $this->hasOne(Department::className(), ['id' => 'departmentId']);
}
