Chris@18: installSchema('system', ['sequences']); Chris@18: $this->installSchema('user', ['users_data']); Chris@18: $this->installEntitySchema('user'); Chris@18: Chris@18: // Create a few users with permissions, so roles will be created. Chris@18: $user_a = $this->createUser(['access user profiles']); Chris@18: $user_b = $this->createUser(['access user profiles']); Chris@18: $user_c = $this->createUser(['access user profiles']); Chris@18: Chris@18: $uids = [$user_a->id(), $user_b->id(), $user_c->id()]; Chris@18: Chris@18: // These users should have a role Chris@18: $connection = Database::getConnection(); Chris@18: $query = $connection->select('user__roles', 'r'); Chris@18: $roles_created = $query Chris@18: ->fields('r', ['entity_id']) Chris@18: ->condition('entity_id', $uids, 'IN') Chris@18: ->countQuery() Chris@18: ->execute() Chris@18: ->fetchField(); Chris@18: Chris@18: $this->assertGreaterThan(0, $roles_created); Chris@18: // We should be able to load one of the users. Chris@18: $this->assertNotNull(User::load($user_a->id())); Chris@18: // Delete the users. Chris@18: user_delete_multiple($uids); Chris@18: // Test if the roles assignments are deleted. Chris@18: $query = $connection->select('user__roles', 'r'); Chris@18: $roles_after_deletion = $query Chris@18: ->fields('r', ['entity_id']) Chris@18: ->condition('entity_id', $uids, 'IN') Chris@18: ->countQuery() Chris@18: ->execute() Chris@18: ->fetchField(); Chris@18: $this->assertEquals(0, $roles_after_deletion); Chris@18: // Test if the users are deleted, User::load() will return NULL. Chris@18: $this->assertNull(User::load($user_a->id())); Chris@18: $this->assertNull(User::load($user_b->id())); Chris@18: $this->assertNull(User::load($user_c->id())); Chris@18: } Chris@18: Chris@18: }