PHP flavorAssetPeer::doSelectStmt Examples

Example #1

File: fixZeroDurationEntries.php Project: richhl/kalturaCE

$entryCriteria->clearSelectColumns();
$entryCriteria->addSelectColumn(entryPeer::ID);
$con = myDbHelper::getConnection(myDbHelper::DB_HELPER_CONN_PROPEL2);
$rs = entryPeer::doSelectStmt($entryCriteria, $con);
$entries = $rs->fetchAll(PDO::FETCH_COLUMN);
$saved = 0;
foreach ($entries as $entryId) {
    entryPeer::clearInstancePool();
    flavorAssetPeer::clearInstancePool();
    mediaInfoPeer::clearInstancePool();
    $flavorAssetCriteria = new Criteria();
    $flavorAssetCriteria->add(flavorAssetPeer::STATUS, flavorAsset::FLAVOR_ASSET_STATUS_READY);
    $flavorAssetCriteria->clearSelectColumns();
    $flavorAssetCriteria->addSelectColumn(flavorAssetPeer::ID);
    $flavorAssetCriteria->add(flavorAssetPeer::ENTRY_ID, $entryId);
    $rs = flavorAssetPeer::doSelectStmt($flavorAssetCriteria, $con);
    $flavorAssets = $rs->fetchAll(PDO::FETCH_COLUMN);
    if (!count($flavorAssets)) {
        continue;
    }
    $criteria = new Criteria();
    $criteria->add(mediaInfoPeer::FLAVOR_ASSET_ID, $flavorAssets, Criteria::IN);
    $criteria->addDescendingOrderByColumn(mediaInfoPeer::ID);
    $mediaInfos = mediaInfoPeer::doSelect($criteria, $con);
    if (!count($mediaInfos)) {
        continue;
    }
    $entry = entryPeer::retrieveByPK($entryId, $con);
    if (!$entry) {
        continue;
    }