public function testFormat()
 {
     $con = Propel::getServiceContainer()->getConnection(BookTableMap::DATABASE_NAME);
     BookstoreEmployeeTableMap::clearInstancePool();
     $stmt = $con->query('SELECT id, class_key, name, job_title, supervisor_id, photo FROM bookstore_employee');
     $formatter = new ObjectFormatter();
     $formatter->init(new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\BookstoreEmployee'));
     $emps = $formatter->format($stmt);
     $expectedClass = ['b1' => 'Propel\\Tests\\Bookstore\\BookstoreEmployee', 'b2' => 'Propel\\Tests\\Bookstore\\BookstoreManager', 'b3' => 'Propel\\Tests\\Bookstore\\BookstoreCashier'];
     foreach ($emps as $emp) {
         $this->assertEquals($expectedClass[$emp->getName()], get_class($emp), 'format() creates objects of the correct class when using inheritance');
     }
 }
 public function testFindOneWithRelationName()
 {
     BookstoreDataPopulator::populate();
     BookstoreEmployeeTableMap::clearInstancePool();
     $c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\BookstoreEmployee');
     $c->join('Propel\\Tests\\Bookstore\\BookstoreEmployee.Supervisor s');
     $c->with('s');
     $c->where('s.Name = ?', 'John');
     $c->limit(1);
     $con = Propel::getServiceContainer()->getConnection(BookTableMap::DATABASE_NAME);
     $emps = $c->find($con);
     foreach ($emps as $emp) {
         break;
     }
     $count = $con->getQueryCount();
     $this->assertEquals($emp->getName(), 'Pieter', 'Main object is correctly hydrated');
     $sup = $emp->getSupervisor();
     $this->assertEquals($count, $con->getQueryCount(), 'with() hydrates the related objects to save a query');
     $this->assertEquals($sup->getName(), 'John', 'Related object is correctly hydrated');
 }
Example #3
0
 /**
  * Test foreign key relationships based on references to unique cols but not PK.
  * @link       http://propel.phpdb.org/trac/ticket/691
  */
 public function testUniqueFkRel()
 {
     BookstoreEmployeeAccountTableMap::doDeleteAll();
     $employee = new BookstoreEmployee();
     $employee->setName("Johnny Walker");
     $acct = new BookstoreEmployeeAccount();
     $acct->setBookstoreEmployee($employee);
     $acct->setLogin("test-login");
     $acct->save();
     $acctId = $acct->getEmployeeId();
     $al = new AcctAuditLog();
     $al->setBookstoreEmployeeAccount($acct);
     $al->save();
     $alId = $al->getId();
     BookstoreEmployeeTableMap::clearInstancePool();
     BookstoreEmployeeAccountTableMap::clearInstancePool();
     AcctAuditLogTableMap::clearInstancePool();
     $al2 = AcctAuditLogQuery::create()->findPk($alId);
     /* @var $al2 AcctAuditLog */
     $mapacct = $al2->getBookstoreEmployeeAccount();
     $lookupacct = BookstoreEmployeeAccountQuery::create()->findPk($acctId);
     $logs = $lookupacct->getAcctAuditLogs();
     $this->assertTrue(count($logs) == 1, "Expected 1 audit log result.");
     $this->assertEquals($logs[0]->getId(), $al->getId(), "Expected returned audit log to match created audit log.");
 }
 public function testFindOneWithRelationName()
 {
     BookstoreDataPopulator::populate();
     BookstoreEmployeeTableMap::clearInstancePool();
     $c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\BookstoreEmployee');
     $c->setFormatter(ModelCriteria::FORMAT_ARRAY);
     $c->join('Propel\\Tests\\Bookstore\\BookstoreEmployee.Supervisor s');
     $c->with('s');
     $c->where('s.Name = ?', 'John');
     $emp = $c->findOne();
     $this->assertEquals($emp['Name'], 'Pieter', 'Main object is correctly hydrated');
     $sup = $emp['Supervisor'];
     $this->assertEquals($sup['Name'], 'John', 'Related object is correctly hydrated');
 }
 public function testGetRelation()
 {
     $bookTable = BookTableMap::getTableMap();
     $titleColumn = $bookTable->getColumn('TITLE');
     $this->assertNull($titleColumn->getRelation(), 'getRelation() returns null for non-foreign key columns');
     $publisherColumn = $bookTable->getColumn('PUBLISHER_ID');
     $this->assertEquals($publisherColumn->getRelation(), $bookTable->getRelation('Publisher'), 'getRelation() returns the RelationMap object for this foreign key');
     $bookstoreTable = BookstoreEmployeeTableMap::getTableMap();
     $supervisorColumn = $bookstoreTable->getColumn('SUPERVISOR_ID');
     $this->assertEquals($supervisorColumn->getRelation(), $supervisorColumn->getRelation('Supervisor'), 'getRelation() returns the RelationMap object even whit ha specific refPhpName');
 }
 /**
  * Test hydration of joined rows that contain lazy load columns.
  * @link       http://propel.phpdb.org/trac/ticket/464
  */
 public function testHydrationJoinLazyLoad()
 {
     BookstoreEmployeeAccountTableMap::doDeleteAll();
     BookstoreEmployeeTableMap::doDeleteAll();
     AcctAccessRoleTableMap::doDeleteAll();
     $bemp2 = new BookstoreEmployee();
     $bemp2->setName("Pieter");
     $bemp2->setJobTitle("Clerk");
     $bemp2->save();
     $role = new AcctAccessRole();
     $role->setName("Admin");
     $bempacct = new BookstoreEmployeeAccount();
     $bempacct->setBookstoreEmployee($bemp2);
     $bempacct->setAcctAccessRole($role);
     $bempacct->setLogin("john");
     $bempacct->setPassword("johnp4ss");
     $bempacct->save();
     $results = BookstoreEmployeeAccountQuery::create()->find();
     $o = $results[0];
     $this->assertEquals('Admin', $o->getAcctAccessRole()->getName());
 }