/** * @depends testChangeOwnerOfModelInReadSubscriptionTableByModelIdAndModelClassNameAndUser */ public function testDeleteUserItemsFromAllReadSubscriptionTables() { $super = User::getByUsername('super'); $david = UserTestHelper::createBasicUser('david'); Yii::app()->user->userModel = $super; // Clean contact table $contacts = Contact::getAll(); foreach ($contacts as $contact) { $contact->delete(); } $sql = "DELETE FROM contact_read_subscription"; ZurmoRedBean::exec($sql); $sql = "SELECT * FROM contact_read_subscription"; $rows = ZurmoRedBean::getAll($sql); $this->assertTrue(empty($rows)); $contact1 = ContactTestHelper::createContactByNameForOwner('Ray', $david); $sql = "SELECT * FROM contact_read_subscription"; $rows = ZurmoRedBean::getAll($sql); $this->assertEquals(0, count($rows)); ReadPermissionsSubscriptionUtil::updateReadSubscriptionTableByModelClassNameAndUser('Contact', $super, time(), true, new MessageLogger()); ReadPermissionsSubscriptionUtil::updateReadSubscriptionTableByModelClassNameAndUser('Contact', $david, time(), true, new MessageLogger()); $sql = "SELECT * FROM contact_read_subscription"; $rows = ZurmoRedBean::getAll($sql); $this->assertEquals(1, count($rows)); $this->assertEquals($david->id, $rows[0]['userid']); $this->assertEquals($contact1->id, $rows[0]['modelid']); $this->assertEquals(ReadPermissionsSubscriptionUtil::TYPE_ADD, $rows[0]['subscriptiontype']); $david->delete(); $sql = "SELECT * FROM contact_read_subscription"; $rows = ZurmoRedBean::getAll($sql); $this->assertEquals(0, count($rows)); }