PHP StorageProfilePeer::doSelect方法代碼示例

 public static function retrieveExternalByPartnerId($partnerId, $con = null)
 {
     $criteria = new Criteria(StorageProfilePeer::DATABASE_NAME);
     $criteria->add(StorageProfilePeer::PARTNER_ID, $partnerId);
     $criteria->add(StorageProfilePeer::STATUS, array(StorageProfile::STORAGE_STATUS_AUTOMATIC, StorageProfile::STORAGE_STATUS_MANUAL), Criteria::IN);
     return StorageProfilePeer::doSelect($criteria, $con);
 }

 /**
  * @action listByPartner
  * @param KalturaPartnerFilter $filter
  * @param KalturaFilterPager $pager
  * @return KalturaStorageProfileListResponse
  */
 public function listByPartnerAction(KalturaPartnerFilter $filter = null, KalturaFilterPager $pager = null)
 {
     $c = new Criteria();
     if (!is_null($filter)) {
         $partnerFilter = new partnerFilter();
         $filter->toObject($partnerFilter);
         $partnerFilter->set('_gt_id', 0);
         $partnerCriteria = new Criteria();
         $partnerFilter->attachToCriteria($partnerCriteria);
         $partnerCriteria->setLimit(1000);
         $partnerCriteria->clearSelectColumns();
         $partnerCriteria->addSelectColumn(PartnerPeer::ID);
         $stmt = PartnerPeer::doSelectStmt($partnerCriteria);
         if ($stmt->rowCount() < 1000) {
             $partnerIds = $stmt->fetchAll(PDO::FETCH_COLUMN);
             $c->add(StorageProfilePeer::PARTNER_ID, $partnerIds, Criteria::IN);
         }
     }
     if (is_null($pager)) {
         $pager = new KalturaFilterPager();
     }
     $totalCount = StorageProfilePeer::doCount($c);
     $pager->attachToCriteria($c);
     $list = StorageProfilePeer::doSelect($c);
     $newList = KalturaStorageProfileArray::fromStorageProfileArray($list);
     $response = new KalturaStorageProfileListResponse();
     $response->totalCount = $totalCount;
     $response->objects = $newList;
     return $response;
 }

 /**
  * Prepare storage profiles array for sorting
  *
  * @param int $partnerId
  */
 protected static function prepareStorageProfilesForSort($partnerId)
 {
     if (!is_null(self::$storageProfilesOrder)) {
         return;
     }
     $criteria = new Criteria();
     $criteria->add(StorageProfilePeer::PARTNER_ID, $partnerId);
     $criteria->add(StorageProfilePeer::DELIVERY_STATUS, StorageProfileDeliveryStatus::BLOCKED, Criteria::NOT_EQUAL);
     $criteria->addAscendingOrderByColumn(StorageProfilePeer::DELIVERY_PRIORITY);
     // Using doSelect instead of doSelectStmt for the ID column so that we can take adavntage of the query cache
     self::$storageProfilesOrder = array();
     $results = StorageProfilePeer::doSelect($criteria);
     foreach ($results as $result) {
         self::$storageProfilesOrder[] = $result->getId();
     }
 }

 /**
  * 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(StorageProfilePeer::DATABASE_NAME);
         $criteria->add(StorageProfilePeer::ID, $pks, Criteria::IN);
         $objs = StorageProfilePeer::doSelect($criteria, $con);
     }
     return $objs;
 }

            $passed = false;
        }
        if (!$passed) {
            break;
        }
    }
    if ($passed) {
        KalturaLog::notice("Drop folder [{$dropFolderId}] passed");
    } else {
        KalturaLog::err("Drop folder [{$dropFolderId}] failed");
    }
}
$storageProfileCriteria = new Criteria();
$storageProfileCriteria->add(StorageProfilePeer::STATUS, StorageProfile::STORAGE_STATUS_AUTOMATIC);
$storageProfileCriteria->add(StorageProfilePeer::PROTOCOL, StorageProfile::STORAGE_PROTOCOL_SFTP);
$storageProfiles = StorageProfilePeer::doSelect($storageProfileCriteria);
KalturaLog::debug("Storage profiles count [" . count($storageProfiles) . "]");
foreach ($storageProfiles as $storageProfile) {
    /* @var $storageProfile StorageProfile */
    $storageProfileId = $storageProfile->getId();
    $passed = true;
    $sftp = kFileTransferMgr::getInstance(kFileTransferMgrType::SFTP_SEC_LIB);
    /* @var $sftp sftpSecLibMgr */
    try {
        $sftp->login($storageProfile->getStorageUrl(), $storageProfile->getStorageUsername(), $storageProfile->getStoragePassword());
    } catch (Exception $e) {
        KalturaLog::err("Storage profile [{$storageProfileId}] login failed: " . $e->getMessage());
        continue;
    }
    $path = $storageProfile->getStorageBaseDir();
    $elements = $sftp->listDir($path);

 /**	
  * @action list
  * @param KalturaStorageProfileFilter $filter
  * @param KalturaFilterPager $pager
  * @return KalturaStorageProfileListResponse
  */
 public function listAction(KalturaStorageProfileFilter $filter = null, KalturaFilterPager $pager = null)
 {
     $c = new Criteria();
     if (!$filter) {
         $filter = new KalturaStorageProfileFilter();
     }
     $storageProfileFilter = new StorageProfileFilter();
     $filter->toObject($storageProfileFilter);
     $storageProfileFilter->attachToCriteria($c);
     $list = StorageProfilePeer::doSelect($c);
     if (!$pager) {
         $pager = new KalturaFilterPager();
     }
     $pager->attachToCriteria($c);
     $response = new KalturaStorageProfileListResponse();
     $response->totalCount = StorageProfilePeer::doCount($c);
     $response->objects = KalturaStorageProfileArray::fromDbArray($list, $this->getResponseProfile());
     return $response;
 }