/**
* 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)
{
$criteriaForSelect = kshowPeer::prepareCriteriaForSelect($criteria);
$queryDB = kQueryCache::QUERY_DB_UNDEFINED;
$cacheKey = null;
$cachedResult = kQueryCache::getCachedQueryResults($criteriaForSelect, kQueryCache::QUERY_TYPE_SELECT, 'kshowPeer', $cacheKey, $queryDB);
if ($cachedResult !== null) {
$cacheKey = null;
kshowPeer::filterSelectResults($cachedResult, $criteriaForSelect);
kshowPeer::updateInstancePool($cachedResult);
return $cachedResult;
}
$con = kshowPeer::alternativeCon($con, $queryDB);
$queryResult = kshowPeer::populateObjects(BasePeer::doSelect($criteriaForSelect, $con));
if ($criteriaForSelect instanceof KalturaCriteria) {
$criteriaForSelect->applyResultsSort($queryResult);
}
if ($cacheKey !== null) {
kQueryCache::cacheQueryResults($cacheKey, $queryResult);
$cacheKey = null;
}
kshowPeer::filterSelectResults($queryResult, $criteria);
kshowPeer::addInstancesToPool($queryResult);
return $queryResult;
}
public static function getKshowsByEntryIds($entry_ids)
{
$c = new Criteria();
//$c->addSelectColumn(kshowPeer::ID);
//$c->addSelectColumn(kshowPeer::NAME);
kshowPeer::addSelectColumns($c);
$c->addJoin(kshowPeer::ID, roughcutEntryPeer::ROUGHCUT_KSHOW_ID);
$c->add(roughcutEntryPeer::ENTRY_ID, $entry_ids, Criteria::IN);
$results = kshowPeer::populateObjects(self::doSelectStmt($c));
kshowPeer::addInstancesToPool($results);
return $results;
}