/**
* @param string $baseClass
* @param string $enumValue
* @param array $constructorArgs
* @return object
*/
public static function loadObject($baseClass, $enumValue, array $constructorArgs = null)
{
if ($baseClass == 'ISyncableFile' && isset($constructorArgs['objectId'])) {
$objectId = $constructorArgs['objectId'];
switch ($enumValue) {
case FileSyncObjectType::METADATA:
MetadataPeer::setUseCriteriaFilter(false);
$object = MetadataPeer::retrieveByPK($objectId);
MetadataPeer::setUseCriteriaFilter(true);
return $object;
case FileSyncObjectType::METADATA_PROFILE:
MetadataProfilePeer::setUseCriteriaFilter(false);
$object = MetadataProfilePeer::retrieveByPK($objectId);
MetadataProfilePeer::setUseCriteriaFilter(true);
return $object;
}
}
if ($baseClass == 'kJobData') {
switch ($enumValue) {
case KalturaBatchJobType::METADATA_IMPORT:
return new kImportJobData();
case KalturaBatchJobType::METADATA_TRANSFORM:
return new kTransformMetadataJobData();
}
}
if ($baseClass == 'KalturaJobData') {
switch ($enumValue) {
case KalturaBatchJobType::METADATA_IMPORT:
return new KalturaImportJobData();
case KalturaBatchJobType::METADATA_TRANSFORM:
return new KalturaTransformMetadataJobData();
}
}
return null;
}
/**
* @param int $objectType
* @param string $objectId
*/
protected function deleteMetadataObjects($objectType, $objectId)
{
$c = new Criteria();
$c->add(MetadataPeer::OBJECT_TYPE, $objectType);
$c->add(MetadataPeer::OBJECT_ID, $objectId);
$c->add(MetadataPeer::STATUS, Metadata::STATUS_DELETED, Criteria::NOT_EQUAL);
$peer = null;
MetadataPeer::setUseCriteriaFilter(false);
$metadatas = MetadataPeer::doSelect($c);
foreach ($metadatas as $metadata) {
kEventsManager::raiseEvent(new kObjectDeletedEvent($metadata));
}
$update = new Criteria();
$update->add(MetadataPeer::STATUS, Metadata::STATUS_DELETED);
$con = Propel::getConnection(MetadataPeer::DATABASE_NAME, Propel::CONNECTION_READ);
BasePeer::doUpdate($c, $update, $con);
}
/**
* @param Metadata $metadata
* @return int affected records
*/
protected function deleteOldVersions(Metadata $metadata)
{
$c = new Criteria();
$c->add(MetadataPeer::OBJECT_ID, $metadata->getObjectId());
$c->add(MetadataPeer::OBJECT_TYPE, $metadata->getObjectType());
$c->add(MetadataPeer::METADATA_PROFILE_ID, $metadata->getMetadataProfileId());
$c->add(MetadataPeer::METADATA_PROFILE_VERSION, $metadata->getMetadataProfileVersion(), Criteria::LESS_THAN);
$c->add(MetadataPeer::STATUS, KalturaMetadataStatus::DELETED, Criteria::NOT_EQUAL);
MetadataPeer::setUseCriteriaFilter(false);
$metadatas = MetadataPeer::doSelect($c);
MetadataPeer::setUseCriteriaFilter(true);
foreach ($metadatas as $metadata) {
kEventsManager::raiseEvent(new kObjectDeletedEvent($metadata));
}
$update = new Criteria();
$update->add(MetadataPeer::STATUS, KalturaMetadataStatus::DELETED);
$con = Propel::getConnection(MetadataPeer::DATABASE_NAME);
$count = BasePeer::doUpdate($c, $update, $con);
return $count;
}
/**
* Reloads this object from datastore based on primary key and (optionally) resets all associated objects.
*
* This will only work if the object has been saved and has a valid primary key set.
*
* @param boolean $deep (optional) Whether to also de-associated any related objects.
* @param PropelPDO $con (optional) The PropelPDO connection to use.
* @return void
* @throws PropelException - if this object is deleted, unsaved or doesn't have pk match in db
*/
public function reload($deep = false, PropelPDO $con = null)
{
if ($this->isDeleted()) {
throw new PropelException("Cannot reload a deleted object.");
}
if ($this->isNew()) {
throw new PropelException("Cannot reload an unsaved object.");
}
if ($con === null) {
$con = Propel::getConnection(MetadataPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
// We don't need to alter the object instance pool; we're just modifying this instance
// already in the pool.
MetadataPeer::setUseCriteriaFilter(false);
$stmt = MetadataPeer::doSelectStmt($this->buildPkeyCriteria(), $con);
MetadataPeer::setUseCriteriaFilter(true);
$row = $stmt->fetch(PDO::FETCH_NUM);
$stmt->closeCursor();
if (!$row) {
throw new PropelException('Cannot find matching row in the database to reload object values.');
}
$this->hydrate($row, 0, true);
// rehydrate
if ($deep) {
// also de-associate any related objects?
}
// if (deep)
}
protected static function init()
{
kEventsManager::enableDeferredEvents(false);
MetadataProfilePeer::setUseCriteriaFilter(false);
MetadataPeer::setUseCriteriaFilter(false);
entryPeer::setUseCriteriaFilter(false);
uiConfPeer::setUseCriteriaFilter(false);
assetPeer::setUseCriteriaFilter(false);
PartnerPeer::setUseCriteriaFilter(false);
FileSyncPeer::setUseCriteriaFilter(false);
$options = getopt('hrl:p:o:b:e:', array('real-run', 'error-objects', 'old-versions', 'blocked-partners', 'files'));
if (isset($options['h'])) {
self::failWrongInputs();
}
if (isset($options['blocked-partners'])) {
self::$deleteDeletedPartnersFileSyncs = true;
}
if (isset($options['error-objects'])) {
self::$deleteErrorObjects = true;
}
if (isset($options['old-versions'])) {
self::$deleteOldVersions = true;
}
if (isset($options['files'])) {
self::$purgeDeletedFileSyncs = true;
}
if (isset($options['r']) || isset($options['real-run'])) {
self::$dryRun = false;
}
KalturaStatement::setDryRun(self::$dryRun);
$cacheFilePath = kConf::get('cache_root_path') . '/scripts/deleteOldContent.cache';
if (file_exists($cacheFilePath)) {
$cache = unserialize(file_get_contents($cacheFilePath));
if (isset($cache['oldVersionsStartUpdatedAt'])) {
self::$oldVersionsStartUpdatedAt = $cache['oldVersionsStartUpdatedAt'];
}
if (isset($cache['purgeStartUpdatedAt'])) {
self::$purgeStartUpdatedAt = $cache['purgeStartUpdatedAt'];
}
}
if (!self::$purgeStartUpdatedAt) {
$criteria = new Criteria();
$criteria->add(FileSyncPeer::UPDATED_AT, 0, Criteria::GREATER_THAN);
$criteria->add(FileSyncPeer::DC, kDataCenterMgr::getCurrentDcId());
$criteria->add(FileSyncPeer::STATUS, FileSync::FILE_SYNC_STATUS_DELETED);
$criteria->addSelectColumn('UNIX_TIMESTAMP(MIN(' . FileSyncPeer::UPDATED_AT . '))');
$stmt = FileSyncPeer::doSelectStmt($criteria);
$mins = $stmt->fetchAll(PDO::FETCH_COLUMN);
if (count($mins)) {
self::$purgeStartUpdatedAt = reset($mins);
}
}
if (is_null(self::$purgeStartUpdatedAt)) {
self::$purgeStartUpdatedAt = 0;
}
self::$purgeNextStartUpdatedAt = self::$purgeStartUpdatedAt;
$oldVersionsUpdatedAtPeriod = 30;
// days
if (isset($options['o'])) {
if (!is_numeric($options['o']) || $options['o'] < 0) {
self::failWrongInputs("Period of old versions to delete must be positive numeric of days");
}
$oldVersionsUpdatedAtPeriod = $options['o'];
}
foreach (self::$oldVersionsStartUpdatedAt as $objectType => $oldVersionsStartUpdatedAt) {
self::$oldVersionsEndUpdatedAt[$objectType] = $oldVersionsStartUpdatedAt + $oldVersionsUpdatedAtPeriod * 60 * 60 * 24;
}
// days
$purgeUpdatedAtPeriod = 30;
// days
if (isset($options['p'])) {
if (!is_numeric($options['p']) || $options['p'] < 0) {
self::failWrongInputs("Period of purge must be positive numeric of days");
}
$purgeUpdatedAtPeriod = $options['p'];
}
self::$purgeEndUpdatedAt = self::$purgeStartUpdatedAt + $purgeUpdatedAtPeriod * 60 * 60 * 24;
// days
$oldPartnersUpdatedAtPeriod = 24;
// months
if (isset($options['b'])) {
if (!is_numeric($options['b']) || $options['b'] < 0) {
self::failWrongInputs("Period of blocked partners to delete must be positive numeric of months");
}
$oldPartnersUpdatedAtPeriod = $options['b'];
}
self::$oldPartnersUpdatedAt = time() - $oldPartnersUpdatedAtPeriod * 60 * 60 * 24 * 30;
// months
$errObjectsUpdatedAtPeriod = 24;
// months
if (isset($options['e'])) {
if (!is_numeric($options['e']) || $options['e'] < 0) {
self::failWrongInputs("Period of error objects to delete must be positive numeric of months");
}
$errObjectsUpdatedAtPeriod = $options['e'];
}
self::$errObjectsUpdatedAt = time() - $errObjectsUpdatedAtPeriod * 60 * 60 * 24 * 30;
// months
if (isset($options['l'])) {
if (!is_numeric($options['l']) || $options['l'] < 0) {
self::failWrongInputs("Limit querymust be positive numeric value");
}
self::$queryLimit = $options['l'];
}
}
public static function loadObject($baseClass, $enumValue, array $constructorArgs = null)
{
if ($baseClass == 'ISyncableFile' && isset($constructorArgs['objectId'])) {
$objectId = $constructorArgs['objectId'];
switch ($enumValue) {
case FileSyncObjectType::METADATA:
MetadataPeer::setUseCriteriaFilter(false);
$object = MetadataPeer::retrieveByPK($objectId);
MetadataPeer::setUseCriteriaFilter(true);
return $object;
case FileSyncObjectType::METADATA_PROFILE:
MetadataProfilePeer::setUseCriteriaFilter(false);
$object = MetadataProfilePeer::retrieveByPK($objectId);
MetadataProfilePeer::setUseCriteriaFilter(true);
return $object;
}
}
if ($baseClass == 'kJobData') {
switch ($enumValue) {
case KalturaBatchJobType::METADATA_IMPORT:
return new kImportJobData();
case KalturaBatchJobType::METADATA_TRANSFORM:
return new kTransformMetadataJobData();
}
}
if ($baseClass == 'KalturaJobData') {
switch ($enumValue) {
case KalturaBatchJobType::METADATA_IMPORT:
return new KalturaImportJobData();
case KalturaBatchJobType::METADATA_TRANSFORM:
return new KalturaTransformMetadataJobData();
}
}
if ($baseClass == 'KalturaCondition') {
if ($enumValue == MetadataPlugin::getConditionTypeCoreValue(MetadataConditionType::METADATA_FIELD_COMPARE)) {
return new KalturaCompareMetadataCondition();
}
if ($enumValue == MetadataPlugin::getConditionTypeCoreValue(MetadataConditionType::METADATA_FIELD_MATCH)) {
return new KalturaMatchMetadataCondition();
}
if ($enumValue == MetadataPlugin::getConditionTypeCoreValue(MetadataConditionType::METADATA_FIELD_CHANGED)) {
return new KalturaMetadataFieldChangedCondition();
}
}
if ($baseClass == 'KalturaFilter') {
if ($enumValue == 'MetadataFilter') {
return new KalturaMetadataFilter();
}
}
if ($baseClass == 'KIndexingEngine') {
if ($enumValue == KalturaIndexObjectType::METADATA) {
return new KIndexingMetadataEngine();
}
}
if ($baseClass == 'KalturaResponseProfileMapping') {
if ($enumValue == 'kMetadataResponseProfileMapping') {
return new KalturaMetadataResponseProfileMapping();
}
}
return null;
}
/**
* Update an existing metadata object definition file
*
* @action revert
* @param int $id
* @param int $toVersion
* @return KalturaMetadataProfile
* @throws MetadataErrors::METADATA_PROFILE_NOT_FOUND
* @throws MetadataErrors::METADATA_FILE_NOT_FOUND
* @throws MetadataErrors::METADATA_UNABLE_TO_TRANSFORM
*/
function revertAction($id, $toVersion)
{
$dbMetadataProfile = MetadataProfilePeer::retrieveByPK($id);
if (!$dbMetadataProfile) {
throw new KalturaAPIException(MetadataErrors::METADATA_PROFILE_NOT_FOUND, $id);
}
$oldKey = $dbMetadataProfile->getSyncKey(MetadataProfile::FILE_SYNC_METADATA_DEFINITION, $toVersion);
if (!kFileSyncUtils::fileSync_exists($oldKey)) {
throw new KalturaAPIException(MetadataErrors::METADATA_FILE_NOT_FOUND, $oldKey);
}
$dbMetadataProfile->incrementFileSyncVersion();
$dbMetadataProfile->incrementVersion();
$dbMetadataProfile->save();
$key = $dbMetadataProfile->getSyncKey(MetadataProfile::FILE_SYNC_METADATA_DEFINITION);
kFileSyncUtils::createSyncFileLinkForKey($key, $oldKey);
kMetadataManager::parseProfileSearchFields($this->getPartnerId(), $dbMetadataProfile);
MetadataPeer::setUseCriteriaFilter(false);
$metadatas = MetadataPeer::retrieveByProfile($id, $toVersion);
foreach ($metadatas as $metadata) {
// validate object exists
$object = kMetadataManager::getObjectFromPeer($metadata);
if (!$object) {
continue;
}
$metadata->incrementVersion();
$oldKey = $metadata->getSyncKey(Metadata::FILE_SYNC_METADATA_DATA, $toVersion);
if (!kFileSyncUtils::fileSync_exists($oldKey)) {
continue;
}
$xml = kFileSyncUtils::file_get_contents($oldKey, true, false);
if (!$xml) {
continue;
}
$errorMessage = '';
if (!kMetadataManager::validateMetadata($dbMetadataProfile->getId(), $xml, $errorMessage)) {
continue;
}
$metadata->setMetadataProfileVersion($dbMetadataProfile->getVersion());
$metadata->setStatus(Metadata::STATUS_VALID);
$metadata->save();
$key = $metadata->getSyncKey(MetadataProfile::FILE_SYNC_METADATA_DEFINITION);
kFileSyncUtils::createSyncFileLinkForKey($key, $oldKey);
}
$metadataProfile = new KalturaMetadataProfile();
$metadataProfile->fromObject($dbMetadataProfile, $this->getResponseProfile());
return $metadataProfile;
}
/**
* Code to be run after inserting to database
* @param PropelPDO $con
*/
public function postInsert(PropelPDO $con = null)
{
MetadataPeer::setUseCriteriaFilter(false);
$this->reload();
MetadataPeer::setUseCriteriaFilter(true);
kEventsManager::raiseEvent(new kObjectCreatedEvent($this));
if ($this->copiedFrom) {
kEventsManager::raiseEvent(new kObjectCopiedEvent($this->copiedFrom, $this));
}
}
<?php
chdir(dirname(__FILE__));
require_once __DIR__ . '/../../bootstrap.php';
$c = new Criteria();
if ($argc > 1 && is_numeric($argv[1])) {
$c->add(MetadataPeer::UPDATED_AT, $argv[1], Criteria::GREATER_EQUAL);
}
if ($argc > 2 && is_numeric($argv[2])) {
$c->add(MetadataPeer::PARTNER_ID, $argv[2], Criteria::EQUAL);
}
if ($argc > 3 && is_numeric($argv[3])) {
$c->add(MetadataPeer::ID, $argv[3], Criteria::GREATER_EQUAL);
}
if ($argc > 4) {
MetadataPeer::setUseCriteriaFilter((bool) $argv[4]);
}
// only dynamic objects are saved to sphinx for now
$c->addAnd(MetadataPeer::OBJECT_TYPE, MetadataObjectType::DYNAMIC_OBJECT);
$c->addAscendingOrderByColumn(MetadataPeer::UPDATED_AT);
$c->addAscendingOrderByColumn(MetadataPeer::ID);
$c->setLimit(10000);
$con = myDbHelper::getConnection(myDbHelper::DB_HELPER_CONN_PROPEL2);
$metadatas = MetadataPeer::doSelect($c, $con);
$sphinx = new kSphinxSearchManager();
while (count($metadatas)) {
foreach ($metadatas as $metadata) {
/* @var $metadata Metadata */
KalturaLog::log('metadata id ' . $metadata->getId() . ' updated at ' . $metadata->getUpdatedAt(null));
try {
$ret = $sphinx->saveToSphinx($metadata, true);
