PHP PersonPeer::doSelectStmt方法代码示例

 /**
  * Reloads this object from datastore based on primary key and (optionally) resets all associated objects.
  *
  * This will only work if the object has been saved and has a valid primary key set.
  *
  * @param      boolean $deep (optional) Whether to also de-associated any related objects.
  * @param      PropelPDO $con (optional) The PropelPDO connection to use.
  * @return     void
  * @throws     PropelException - if this object is deleted, unsaved or doesn't have pk match in db
  */
 public function reload($deep = false, PropelPDO $con = null)
 {
     if ($this->isDeleted()) {
         throw new PropelException("Cannot reload a deleted object.");
     }
     if ($this->isNew()) {
         throw new PropelException("Cannot reload an unsaved object.");
     }
     if ($con === null) {
         $con = Propel::getConnection(PersonPeer::DATABASE_NAME, Propel::CONNECTION_READ);
     }
     // We don't need to alter the object instance pool; we're just modifying this instance
     // already in the pool.
     $stmt = PersonPeer::doSelectStmt($this->buildPkeyCriteria(), $con);
     $row = $stmt->fetch(PDO::FETCH_NUM);
     $stmt->closeCursor();
     if (!$row) {
         throw new PropelException('Cannot find matching row in the database to reload object values.');
     }
     $this->hydrate($row, 0, true);
     // rehydrate
     if ($deep) {
         // also de-associate any related objects?
         $this->collBoardMembers = null;
         $this->lastBoardMemberCriteria = null;
         $this->collCompanions = null;
         $this->lastCompanionCriteria = null;
         $this->collContacts = null;
         $this->lastContactCriteria = null;
         $this->collDonors = null;
         $this->lastDonorCriteria = null;
         $this->collEmailListPersons = null;
         $this->lastEmailListPersonCriteria = null;
         $this->collEmailQueues = null;
         $this->lastEmailQueueCriteria = null;
         $this->collEmailTemplates = null;
         $this->lastEmailTemplateCriteria = null;
         $this->collMembers = null;
         $this->lastMemberCriteria = null;
         $this->collPassengers = null;
         $this->lastPassengerCriteria = null;
         $this->collPasswordRequests = null;
         $this->lastPasswordRequestCriteria = null;
         $this->collPersonRoles = null;
         $this->lastPersonRoleCriteria = null;
         $this->singlePersonalNote = null;
         $this->collRequesters = null;
         $this->lastRequesterCriteria = null;
         $this->collWingLeaders = null;
         $this->lastWingLeaderCriteria = null;
     }
     // if (deep)
 }

 public function addIsActiveColumnCriteria(Criteria $criteria, $field, $value)
 {
     if ($value != '') {
         $c = new Criteria();
         $c->addJoin(TeacherPeer::PERSON_ID, PersonPeer::ID);
         $c->add(PersonPeer::IS_ACTIVE, 1);
         $c->clearSelectColumns();
         $c->addSelectColumn(PersonPeer::ID);
         $stmt = PersonPeer::doSelectStmt($c);
         $ids = $stmt->fetchAll(PDO::FETCH_COLUMN);
         if ($value == '1') {
             $criteria->add(TeacherPeer::PERSON_ID, $ids, Criteria::IN);
         } else {
             $criteria->add(TeacherPeer::PERSON_ID, $ids, Criteria::NOT_IN);
         }
     }
 }

 /**
  * Reloads this object from datastore based on primary key and (optionally) resets all associated objects.
  *
  * This will only work if the object has been saved and has a valid primary key set.
  *
  * @param      boolean $deep (optional) Whether to also de-associated any related objects.
  * @param      PropelPDO $con (optional) The PropelPDO connection to use.
  * @return     void
  * @throws     PropelException - if this object is deleted, unsaved or doesn't have pk match in db
  */
 public function reload($deep = false, PropelPDO $con = null)
 {
     if ($this->isDeleted()) {
         throw new PropelException("Cannot reload a deleted object.");
     }
     if ($this->isNew()) {
         throw new PropelException("Cannot reload an unsaved object.");
     }
     if ($con === null) {
         $con = Propel::getConnection(PersonPeer::DATABASE_NAME, Propel::CONNECTION_READ);
     }
     // We don't need to alter the object instance pool; we're just modifying this instance
     // already in the pool.
     $stmt = PersonPeer::doSelectStmt($this->buildPkeyCriteria(), $con);
     $row = $stmt->fetch(PDO::FETCH_NUM);
     $stmt->closeCursor();
     if (!$row) {
         throw new PropelException('Cannot find matching row in the database to reload object values.');
     }
     $this->hydrate($row, 0, true);
     // rehydrate
     if ($deep) {
         // also de-associate any related objects?
         $this->collMoviespersonss = null;
         $this->collMovies = null;
     }
 }

 /**
  * Method to do selects.
  *
  * @param      Criteria $criteria The Criteria object used to build the SELECT statement.
  * @param      PropelPDO $con
  * @return     array Array of selected Objects
  * @throws     PropelException Any exceptions caught during processing will be
  *		 rethrown wrapped into a PropelException.
  */
 public static function doSelect(Criteria $criteria, PropelPDO $con = null)
 {
     return PersonPeer::populateObjects(PersonPeer::doSelectStmt($criteria, $con));
 }