/**
  * Find object by primary key
  * Use instance pooling to avoid a database query if the object exists
  * <code>
  * $obj  = $c->findPk(12, $con);
  * </code>
  * @param     mixed $key Primary key to use for the query
  * @param     PropelPDO $con an optional connection object
  *
  * @return    CcShowDays|array|mixed the result, formatted by the current formatter
  */
 public function findPk($key, $con = null)
 {
     if (null !== ($obj = CcShowDaysPeer::getInstanceFromPool((string) $key)) && $this->getFormatter()->isObjectFormatter()) {
         // the object is alredy in the instance pool
         return $obj;
     } else {
         // the object has not been requested yet, or the formatter is not an object formatter
         $criteria = $this->isKeepQuery() ? clone $this : $this;
         $stmt = $criteria->filterByPrimaryKey($key)->getSelectStatement($con);
         return $criteria->getFormatter()->init($criteria)->formatOne($stmt);
     }
 }
 /**
  * Retrieve multiple objects by pkey.
  *
  * @param      array $pks List of primary keys
  * @param      PropelPDO $con the connection to use
  * @throws     PropelException Any exceptions caught during processing will be
  *		 rethrown wrapped into a PropelException.
  */
 public static function retrieveByPKs($pks, PropelPDO $con = null)
 {
     if ($con === null) {
         $con = Propel::getConnection(CcShowDaysPeer::DATABASE_NAME, Propel::CONNECTION_READ);
     }
     $objs = null;
     if (empty($pks)) {
         $objs = array();
     } else {
         $criteria = new Criteria(CcShowDaysPeer::DATABASE_NAME);
         $criteria->add(CcShowDaysPeer::ID, $pks, Criteria::IN);
         $objs = CcShowDaysPeer::doSelect($criteria, $con);
     }
     return $objs;
 }
 private function getShowDaysInRange($start, $end)
 {
     $endTimeString = $end->format("Y-m-d H:i:s");
     if (!is_null($start)) {
         $startTimeString = $start->format("Y-m-d H:i:s");
     } else {
         $today_timestamp = new DateTime("now", new DateTimeZone("UTC"));
         $startTimeString = $today_timestamp->format("Y-m-d H:i:s");
     }
     $c = new Criteria();
     $c->add(CcShowDaysPeer::FIRST_SHOW, $endTimeString, Criteria::LESS_THAN);
     $c->addAnd(CcShowDaysPeer::LAST_SHOW, $startTimeString, Criteria::GREATER_THAN);
     $c->addAnd(CcShowDaysPeer::REPEAT_TYPE, -1, Criteria::NOT_EQUAL);
     $c->addOr(CcShowDaysPeer::LAST_SHOW, null, Criteria::ISNULL);
     return CcShowDaysPeer::doSelect($c);
 }
 /**
  * Populates the object using an array.
  *
  * This is particularly useful when populating an object from one of the
  * request arrays (e.g. $_POST).  This method goes through the column
  * names, checking to see whether a matching key exists in populated
  * array. If so the setByName() method is called for that column.
  *
  * You can specify the key type of the array by additionally passing one
  * of the class type constants BasePeer::TYPE_PHPNAME, BasePeer::TYPE_STUDLYPHPNAME,
  * BasePeer::TYPE_COLNAME, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_NUM.
  * The default key type is the column's phpname (e.g. 'AuthorId')
  *
  * @param      array  $arr     An array to populate the object from.
  * @param      string $keyType The type of keys the array uses.
  * @return     void
  */
 public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
 {
     $keys = CcShowDaysPeer::getFieldNames($keyType);
     if (array_key_exists($keys[0], $arr)) {
         $this->setDbId($arr[$keys[0]]);
     }
     if (array_key_exists($keys[1], $arr)) {
         $this->setDbFirstShow($arr[$keys[1]]);
     }
     if (array_key_exists($keys[2], $arr)) {
         $this->setDbLastShow($arr[$keys[2]]);
     }
     if (array_key_exists($keys[3], $arr)) {
         $this->setDbStartTime($arr[$keys[3]]);
     }
     if (array_key_exists($keys[4], $arr)) {
         $this->setDbTimezone($arr[$keys[4]]);
     }
     if (array_key_exists($keys[5], $arr)) {
         $this->setDbDuration($arr[$keys[5]]);
     }
     if (array_key_exists($keys[6], $arr)) {
         $this->setDbDay($arr[$keys[6]]);
     }
     if (array_key_exists($keys[7], $arr)) {
         $this->setDbRepeatType($arr[$keys[7]]);
     }
     if (array_key_exists($keys[8], $arr)) {
         $this->setDbNextPopDate($arr[$keys[8]]);
     }
     if (array_key_exists($keys[9], $arr)) {
         $this->setDbShowId($arr[$keys[9]]);
     }
     if (array_key_exists($keys[10], $arr)) {
         $this->setDbRecord($arr[$keys[10]]);
     }
 }
Example #5
0
 /**
  * Method to invalidate the instance pool of all tables related to cc_show
  * by a foreign key with ON DELETE CASCADE
  */
 public static function clearRelatedInstancePool()
 {
     // Invalidate objects in CcShowInstancesPeer instance pool,
     // since one or more of them may be deleted by ON DELETE CASCADE/SETNULL rule.
     CcShowInstancesPeer::clearInstancePool();
     // Invalidate objects in CcShowDaysPeer instance pool,
     // since one or more of them may be deleted by ON DELETE CASCADE/SETNULL rule.
     CcShowDaysPeer::clearInstancePool();
     // Invalidate objects in CcShowRebroadcastPeer instance pool,
     // since one or more of them may be deleted by ON DELETE CASCADE/SETNULL rule.
     CcShowRebroadcastPeer::clearInstancePool();
     // Invalidate objects in CcShowHostsPeer instance pool,
     // since one or more of them may be deleted by ON DELETE CASCADE/SETNULL rule.
     CcShowHostsPeer::clearInstancePool();
 }