/** * 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) { $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(CaptionAssetItemPeer::DATABASE_NAME); $criteria->add(CaptionAssetItemPeer::ID, $pks, Criteria::IN); $objs = CaptionAssetItemPeer::doSelect($criteria, $con); } return $objs; }
/** * Search caption asset items by filter, pager and free text * * @action search * @param KalturaBaseEntryFilter $entryFilter * @param KalturaCaptionAssetItemFilter $captionAssetItemFilter * @param KalturaFilterPager $captionAssetItemPager * @return KalturaCaptionAssetItemListResponse */ function searchAction(KalturaBaseEntryFilter $entryFilter = null, KalturaCaptionAssetItemFilter $captionAssetItemFilter = null, KalturaFilterPager $captionAssetItemPager = null) { if (!$captionAssetItemPager) { $captionAssetItemPager = new KalturaFilterPager(); } if (!$captionAssetItemFilter) { $captionAssetItemFilter = new KalturaCaptionAssetItemFilter(); } $captionAssetItemCoreFilter = new CaptionAssetItemFilter(); $captionAssetItemFilter->toObject($captionAssetItemCoreFilter); if ($entryFilter) { $entryCoreFilter = new entryFilter(); $entryFilter->toObject($entryCoreFilter); $this->addEntryAdvancedSearchFilter($captionAssetItemFilter, $entryCoreFilter); $entryCriteria = KalturaCriteria::create(entryPeer::OM_CLASS); $entryCoreFilter->attachToCriteria($entryCriteria); $entryCriteria->applyFilters(); $entryIds = $entryCriteria->getFetchedIds(); if (!$entryIds || !count($entryIds)) { $entryIds = array('NOT_EXIST'); } $captionAssetItemCoreFilter->setEntryIdIn($entryIds); } $captionAssetItemCriteria = KalturaCriteria::create(CaptionAssetItemPeer::OM_CLASS); $captionAssetItemCoreFilter->attachToCriteria($captionAssetItemCriteria); $captionAssetItemPager->attachToCriteria($captionAssetItemCriteria); $dbList = CaptionAssetItemPeer::doSelect($captionAssetItemCriteria); $list = KalturaCaptionAssetItemArray::fromDbArray($dbList); $response = new KalturaCaptionAssetItemListResponse(); $response->objects = $list; $response->totalCount = $captionAssetItemCriteria->getRecordsCount(); return $response; }
public static function retrieveByAssetId($assetId, PropelPDO $con = null) { $criteria = new Criteria(); $criteria->add(CaptionAssetItemPeer::CAPTION_ASSET_ID, $assetId); return CaptionAssetItemPeer::doSelect($criteria, $con); }
/** * Search caption asset items by filter, pager and free text * * @action search * @param KalturaBaseEntryFilter $entryFilter * @param KalturaCaptionAssetItemFilter $captionAssetItemFilter * @param KalturaFilterPager $captionAssetItemPager * @return KalturaCaptionAssetItemListResponse */ function searchAction(KalturaBaseEntryFilter $entryFilter = null, KalturaCaptionAssetItemFilter $captionAssetItemFilter = null, KalturaFilterPager $captionAssetItemPager = null) { if (!$captionAssetItemPager) { $captionAssetItemPager = new KalturaFilterPager(); } if (!$captionAssetItemFilter) { $captionAssetItemFilter = new KalturaCaptionAssetItemFilter(); } $captionAssetItemFilter->validatePropertyNotNull(array("contentLike", "contentMultiLikeOr", "contentMultiLikeAnd")); $captionAssetItemCoreFilter = new CaptionAssetItemFilter(); $captionAssetItemFilter->toObject($captionAssetItemCoreFilter); if ($entryFilter || kEntitlementUtils::getEntitlementEnforcement()) { $entryCoreFilter = new entryFilter(); if ($entryFilter) { $entryFilter->toObject($entryCoreFilter); } $entryCoreFilter->setPartnerSearchScope($this->getPartnerId()); $this->addEntryAdvancedSearchFilter($captionAssetItemFilter, $entryCoreFilter); $entryCriteria = KalturaCriteria::create(entryPeer::OM_CLASS); $entryCoreFilter->attachToCriteria($entryCriteria); $entryCriteria->applyFilters(); $entryIds = $entryCriteria->getFetchedIds(); if (!$entryIds || !count($entryIds)) { $entryIds = array('NOT_EXIST'); } $captionAssetItemCoreFilter->setEntryIdIn($entryIds); } $captionAssetItemCriteria = KalturaCriteria::create(CaptionAssetItemPeer::OM_CLASS); $captionAssetItemCoreFilter->attachToCriteria($captionAssetItemCriteria); $captionAssetItemPager->attachToCriteria($captionAssetItemCriteria); $dbList = CaptionAssetItemPeer::doSelect($captionAssetItemCriteria); $list = KalturaCaptionAssetItemArray::fromDbArray($dbList, $this->getResponseProfile()); $response = new KalturaCaptionAssetItemListResponse(); $response->objects = $list; $response->totalCount = $captionAssetItemCriteria->getRecordsCount(); return $response; }
$c->add(CaptionAssetItemPeer::PARTNER_ID, $argv[2], Criteria::EQUAL); } if ($argc > 3 && is_numeric($argv[3])) { $c->add(CaptionAssetItemPeer::ID, $argv[3], Criteria::GREATER_EQUAL); } if ($argc > 4) { CaptionAssetItemPeer::setUseCriteriaFilter((bool) $argv[4]); } $c->addAscendingOrderByColumn(CaptionAssetItemPeer::CREATED_AT); $c->addAscendingOrderByColumn(CaptionAssetItemPeer::ID); $c->setLimit(10000); $con = myDbHelper::getConnection(myDbHelper::DB_HELPER_CONN_PROPEL2); //$sphinxCon = DbManager::getSphinxConnection(); $captions = CaptionAssetItemPeer::doSelect($c, $con); $sphinx = new kSphinxSearchManager(); while (count($captions)) { foreach ($captions as $caption) { KalturaLog::log('caption_asset_id ' . $caption->getId() . ' int id[' . $caption->getIntId() . '] crc id[' . $sphinx->getSphinxId($caption) . '] last updated at [' . $caption->getUpdatedAt(null) . ']'); try { $ret = $sphinx->saveToSphinx($caption, true); } catch (Exception $e) { KalturaLog::err($e->getMessage()); exit - 1; } } $c->setOffset($c->getOffset() + count($captions)); kMemoryManager::clearMemory(); $captions = CaptionAssetItemPeer::doSelect($c, $con); } KalturaLog::log('Done. Cureent time: ' . time()); exit(0);