private function loadFixtures() { $u1 = new CmsUser(); $u2 = new CmsUser(); $u3 = new CmsUser(); $u1->setEmail(new CmsEmail()); $u1->setAddress(new CmsAddress()); $u1->addPhonenumber(new CmsPhonenumber()); $u2->setEmail(new CmsEmail()); $u2->setAddress(new CmsAddress()); $u2->addPhonenumber(new CmsPhonenumber()); $u2->addPhonenumber(new CmsPhonenumber()); $u3->setEmail(new CmsEmail()); $u3->setAddress(new CmsAddress()); $u3->addPhonenumber(new CmsPhonenumber()); $u3->addPhonenumber(new CmsPhonenumber()); $u3->addPhonenumber(new CmsPhonenumber()); $u1->name = 'Test 1'; $u1->username = '******'; $u1->status = 'developer'; $u1->email->email = '*****@*****.**'; $u1->address->zip = '111111111'; $u1->address->city = 'Some City 1'; $u1->address->country = 'Some Country 2'; $u1->phonenumbers[0]->phonenumber = "(11) 1111-1111"; $u2->name = 'Test 2'; $u2->username = '******'; $u2->status = 'developer'; $u2->email->email = '*****@*****.**'; $u2->address->zip = '222222222'; $u2->address->city = 'Some City 2'; $u2->address->country = 'Some Country 2'; $u2->phonenumbers[0]->phonenumber = "(22) 1111-1111"; $u2->phonenumbers[1]->phonenumber = "(22) 2222-2222"; $u3->name = 'Test 3'; $u3->username = '******'; $u3->status = 'developer'; $u3->email->email = '*****@*****.**'; $u3->address->zip = '33333333'; $u3->address->city = 'Some City 3'; $u3->address->country = 'Some Country 3'; $u3->phonenumbers[0]->phonenumber = "(33) 1111-1111"; $u3->phonenumbers[1]->phonenumber = "(33) 2222-2222"; $u3->phonenumbers[2]->phonenumber = "(33) 3333-3333"; $this->_em->persist($u1); $this->_em->persist($u2); $this->_em->persist($u3); $this->_em->flush(); $this->_em->clear(); $this->fixtures = array($u1, $u2, $u3); }
public function testGivenOrphanRemovalOneToOne_WhenReplacing_ThenNoUniqueConstraintError() { $user = new CmsUser(); $user->name = "Benjamin"; $user->username = "******"; $user->status = "something"; $user->setEmail($email = new CmsEmail()); $email->setEmail("*****@*****.**"); $this->_em->persist($user); $this->_em->flush(); $this->assertTrue($this->_em->contains($email)); $user->setEmail($newEmail = new CmsEmail()); $newEmail->setEmail("*****@*****.**"); $this->_em->flush(); $this->assertFalse($this->_em->contains($email)); }
public function testOrphanRemovalWhenUnlink() { $user = new CmsUser(); $user->status = 'dev'; $user->username = '******'; $user->name = 'Bejamin Eberlei'; $email = new CmsEmail(); $email->email = '*****@*****.**'; $user->setEmail($email); $this->_em->persist($user); $this->_em->flush(); $userId = $user->getId(); $this->_em->clear(); $user = $this->_em->find('Doctrine\\Tests\\Models\\CMS\\CmsUser', $userId); $user->setEmail(null); $this->_em->persist($user); $this->_em->flush(); $this->_em->clear(); $query = $this->_em->createQuery('SELECT e FROM Doctrine\\Tests\\Models\\CMS\\CmsEmail e'); $result = $query->getResult(); $this->assertEquals(0, count($result), 'CmsEmail should be removed by orphanRemoval'); }
/** * @group DDC-1663 */ public function testBasicNativeNamedQueryWithResultClass() { $user = new CmsUser(); $user->name = 'Fabio B. Silva'; $user->username = '******'; $user->status = 'dev'; $email = new CmsEmail(); $email->email = '*****@*****.**'; $user->setEmail($email); $this->_em->clear(); $this->_em->persist($user); $this->_em->flush(); $this->_em->clear(); $repository = $this->_em->getRepository('Doctrine\\Tests\\Models\\CMS\\CmsUser'); $result = $repository->createNativeNamedQuery('fetchIdAndUsernameWithResultClass')->setParameter(1, 'FabioBatSilva')->getResult(); $this->assertEquals(1, count($result)); $this->assertInstanceOf('Doctrine\\Tests\\Models\\CMS\\CmsUser', $result[0]); $this->assertNull($result[0]->name); $this->assertNull($result[0]->email); $this->assertEquals($user->id, $result[0]->id); $this->assertEquals('FabioBatSilva', $result[0]->username); $this->_em->clear(); $result = $repository->createNativeNamedQuery('fetchAllColumns')->setParameter(1, 'FabioBatSilva')->getResult(); $this->assertEquals(1, count($result)); $this->assertInstanceOf('Doctrine\\Tests\\Models\\CMS\\CmsUser', $result[0]); $this->assertEquals($user->id, $result[0]->id); $this->assertEquals('Fabio B. Silva', $result[0]->name); $this->assertEquals('FabioBatSilva', $result[0]->username); $this->assertEquals('dev', $result[0]->status); $this->assertInstanceOf('Doctrine\\Tests\\Models\\CMS\\CmsEmail', $result[0]->email); }
public function loadFixtureUserEmail() { $user1 = new CmsUser(); $user2 = new CmsUser(); $user3 = new CmsUser(); $email1 = new CmsEmail(); $email2 = new CmsEmail(); $email3 = new CmsEmail(); $user1->name = 'Test 1'; $user1->username = '******'; $user1->status = 'active'; $user2->name = 'Test 2'; $user2->username = '******'; $user2->status = 'active'; $user3->name = 'Test 3'; $user3->username = '******'; $user3->status = 'active'; $email1->email = '*****@*****.**'; $email2->email = '*****@*****.**'; $email3->email = '*****@*****.**'; $user1->setEmail($email1); $user2->setEmail($email2); $user3->setEmail($email3); $this->_em->persist($user1); $this->_em->persist($user2); $this->_em->persist($user3); $this->_em->persist($email1); $this->_em->persist($email2); $this->_em->persist($email3); $this->_em->flush(); $this->_em->clear(); return array($user1, $user2, $user3); }
private function loadFixture() { $user = new CmsUser(); $user->name = 'Roman'; $user->username = '******'; $user->status = 'developer'; $address = new CmsAddress(); $address->country = 'Germany'; $address->city = 'Berlin'; $address->zip = '12345'; $user->setAddress($address); $email = new CmsEmail(); $email->setEmail('*****@*****.**'); $user->setEmail($email); $ph1 = new CmsPhonenumber(); $ph1->phonenumber = "0301234"; $ph2 = new CmsPhonenumber(); $ph2->phonenumber = "987654321"; $user->addPhonenumber($ph1); $user->addPhonenumber($ph2); $this->_em->persist($user); $this->_em->flush(); $this->userId = $user->getId(); $this->_em->clear(); }