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;
}
