/**
* Callback to validate module database records.
*
* @param \yii\base\Event $event
*/
public static function onIntegrityCheck($event)
{
$integrityController = $event->sender;
$integrityController->showTestHeadline("User Module - Users (" . User::find()->count() . " entries)");
foreach (User::find()->joinWith(['profile'])->all() as $user) {
if ($user->profile == null) {
$integrityController->showWarning("User with id " . $user->id . " has no profile record!");
}
}
foreach (GroupUser::find()->joinWith(['user'])->all() as $groupUser) {
if ($groupUser->user == null) {
if ($integrityController->showFix("Deleting group admin " . $groupUser->id . " without existing user!")) {
$groupUser->delete();
}
}
}
$integrityController->showTestHeadline("User Module - Password (" . Password::find()->count() . " entries)");
foreach (Password::find()->joinWith(['user'])->all() as $password) {
if ($password->user == null) {
if ($integrityController->showFix("Deleting password " . $password->id . " without existing user!")) {
$password->delete();
}
}
}
$integrityController->showTestHeadline("User Module - Profile (" . Profile::find()->count() . " entries)");
foreach (Profile::find()->joinWith(['user'])->all() as $profile) {
if ($profile->user == null) {
if ($integrityController->showFix("Deleting profile " . $profile->user_id . " without existing user!")) {
$profile->delete();
}
}
}
$integrityController->showTestHeadline("User Module - Mentioning (" . Mentioning::find()->count() . " entries)");
foreach (Mentioning::find()->joinWith(['user'])->all() as $mentioning) {
if ($mentioning->user == null) {
if ($integrityController->showFix("Deleting mentioning " . $mentioning->id . " of non existing user!")) {
$mentioning->delete();
}
}
if ($mentioning->getPolymorphicRelation() == null) {
if ($integrityController->showFix("Deleting mentioning " . $mentioning->id . " of non target!")) {
$mentioning->delete();
}
}
}
$integrityController->showTestHeadline("User Module - Follow (" . Follow::find()->count() . " entries)");
foreach (Follow::find()->joinWith(['user'])->all() as $follow) {
if ($follow->user == null) {
if ($integrityController->showFix("Deleting follow " . $follow->id . " of non existing user!")) {
$follow->delete();
}
}
if ($follow->getTarget() == null) {
if ($integrityController->showFix("Deleting follow " . $follow->id . " of non target!")) {
$follow->delete();
}
}
}
$integrityController->showTestHeadline("User Module - Modules (" . models\Module::find()->count() . " entries)");
foreach (models\Module::find()->joinWith(['user'])->all() as $module) {
if ($module->user == null) {
if ($integrityController->showFix("Deleting user-module " . $module->id . " of non existing user!")) {
$module->delete();
}
}
}
}
