/** * Gets an array of PersonRole objects which contain a foreign key that references this object. * * If this collection has already been initialized with an identical Criteria, it returns the collection. * Otherwise if this Role has previously been saved, it will retrieve * related PersonRoles from storage. If this Role is new, it will return * an empty collection or the current collection, the criteria is ignored on a new object. * * @param PropelPDO $con * @param Criteria $criteria * @return array PersonRole[] * @throws PropelException */ public function getPersonRoles($criteria = null, PropelPDO $con = null) { if ($criteria === null) { $criteria = new Criteria(RolePeer::DATABASE_NAME); } elseif ($criteria instanceof Criteria) { $criteria = clone $criteria; } if ($this->collPersonRoles === null) { if ($this->isNew()) { $this->collPersonRoles = array(); } else { $criteria->add(PersonRolePeer::ROLE_ID, $this->id); PersonRolePeer::addSelectColumns($criteria); $this->collPersonRoles = PersonRolePeer::doSelect($criteria, $con); } } else { // criteria has no effect for a new object if (!$this->isNew()) { // the following code is to determine if a new query is // called for. If the criteria is the same as the last // one, just return the collection. $criteria->add(PersonRolePeer::ROLE_ID, $this->id); PersonRolePeer::addSelectColumns($criteria); if (!isset($this->lastPersonRoleCriteria) || !$this->lastPersonRoleCriteria->equals($criteria)) { $this->collPersonRoles = PersonRolePeer::doSelect($criteria, $con); } } } $this->lastPersonRoleCriteria = $criteria; return $this->collPersonRoles; }
/** * Retrieve object using using composite pkey values. * @param int $person_id @param int $role_id * @param PropelPDO $con * @return PersonRole */ public static function retrieveByPK($person_id, $role_id, PropelPDO $con = null) { $key = serialize(array((string) $person_id, (string) $role_id)); if (null !== ($obj = PersonRolePeer::getInstanceFromPool($key))) { return $obj; } if ($con === null) { $con = Propel::getConnection(PersonRolePeer::DATABASE_NAME, Propel::CONNECTION_READ); } $criteria = new Criteria(PersonRolePeer::DATABASE_NAME); $criteria->add(PersonRolePeer::PERSON_ID, $person_id); $criteria->add(PersonRolePeer::ROLE_ID, $role_id); $v = PersonRolePeer::doSelect($criteria, $con); return !empty($v) ? $v[0] : null; }