function getPuserKusers($lastPuserKuser, $userLimitEachLoop)
{
PuserKuserPeer::clearInstancePool();
$c = new Criteria();
$c->add(PuserKuserPeer::ID, $lastPuserKuser, Criteria::GREATER_THAN);
$c->addAscendingOrderByColumn(PuserKuserPeer::ID);
$c->setLimit($userLimitEachLoop);
PuserKuserPeer::setUseCriteriaFilter(false);
$puserKusers = PuserKuserPeer::doSelect($c);
PuserKuserPeer::setUseCriteriaFilter(true);
return $puserKusers;
}
/**
* Method perform a DELETE on the database, given a PuserKuser or Criteria object OR a primary key value.
*
* @param mixed $values Criteria or PuserKuser object or primary key or array of primary keys
* which is used to create the DELETE statement
* @param PropelPDO $con the connection to use
* @return int The number of affected rows (if supported by underlying database driver). This includes CASCADE-related rows
* if supported by native driver or if emulated using Propel.
* @throws PropelException Any exceptions caught during processing will be
* rethrown wrapped into a PropelException.
*/
public static function doDelete($values, PropelPDO $con = null)
{
if ($con === null) {
$con = Propel::getConnection(PuserKuserPeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
}
if ($values instanceof Criteria) {
// invalidate the cache for all objects of this type, since we have no
// way of knowing (without running a query) what objects should be invalidated
// from the cache based on this Criteria.
PuserKuserPeer::clearInstancePool();
// rename for clarity
$criteria = clone $values;
} elseif ($values instanceof PuserKuser) {
// it's a model object
// invalidate the cache for this single object
PuserKuserPeer::removeInstanceFromPool($values);
// create criteria based on pk values
$criteria = $values->buildPkeyCriteria();
} else {
// it's a primary key, or an array of pks
$criteria = new Criteria(self::DATABASE_NAME);
$criteria->add(PuserKuserPeer::ID, (array) $values, Criteria::IN);
// invalidate the cache for this object(s)
foreach ((array) $values as $singleval) {
PuserKuserPeer::removeInstanceFromPool($singleval);
}
}
// Set the correct dbName
$criteria->setDbName(self::DATABASE_NAME);
$affectedRows = 0;
// initialize var to track total num of affected rows
try {
// use transaction because $criteria could contain info
// for more than one table or we could emulating ON DELETE CASCADE, etc.
$con->beginTransaction();
$affectedRows += BasePeer::doDelete($criteria, $con);
PuserKuserPeer::clearRelatedInstancePool();
$con->commit();
return $affectedRows;
} catch (PropelException $e) {
$con->rollBack();
throw $e;
}
}
/**
*
* Gets all the pusers from the puser table
* @param int $lastPuserId - the last puser id
* @param int $limit - the limit for the query
*/
private function getAllPusersInPuser($lastPuserId, $limit)
{
$pusers = array();
PuserKuserPeer::clearInstancePool();
$c = new Criteria();
$c->add(PuserKuserPeer::ID, $lastPuserId, Criteria::GREATER_THAN);
// if case we have several entries in the same date (and we stop in the middle)
$c->addAnd(PuserKuserPeer::PUSER_ID, null, Criteria::NOT_EQUAL);
$c->addAnd(PuserKuserPeer::PUSER_ID, "", Criteria::NOT_EQUAL);
if ($this->partnerId) {
$c->addAnd(PuserKuserPeer::PARTNER_ID, $this->partnerId, Criteria::EQUAL);
}
$c->addAnd(PuserKuserPeer::PARTNER_ID, $this->ignorePartners, Criteria::NOT_IN);
$c->addAscendingOrderByColumn(PuserKuserPeer::ID);
$c->setLimit($limit);
PuserKuserPeer::setUseCriteriaFilter(false);
$pusers1 = PuserKuserPeer::doSelect($c);
PuserKuserPeer::setUseCriteriaFilter(true);
foreach ($pusers1 as $puser) {
// $this->printToLog("Found puser with id [{$puser->getId()}], partner [{$puser->getPartnerId()}]");
$pusers[] = new puserDetails($puser->getPuserId(), $puser->getPartnerId());
file_put_contents($this->lastPuserFile, $puser->getId());
}
return $pusers;
}
public static function clearMemory()
{
accessControlPeer::clearInstancePool();
kuserPeer::clearInstancePool();
kshowPeer::clearInstancePool();
entryPeer::clearInstancePool();
// kvotePeer::clearInstancePool();
// commentPeer::clearInstancePool();
// flagPeer::clearInstancePool();
// favoritePeer::clearInstancePool();
// KshowKuserPeer::clearInstancePool();
// MailJobPeer::clearInstancePool();
SchedulerPeer::clearInstancePool();
SchedulerWorkerPeer::clearInstancePool();
SchedulerStatusPeer::clearInstancePool();
SchedulerConfigPeer::clearInstancePool();
ControlPanelCommandPeer::clearInstancePool();
BatchJobPeer::clearInstancePool();
// PriorityGroupPeer::clearInstancePool();
BulkUploadResultPeer::clearInstancePool();
// blockedEmailPeer::clearInstancePool();
// conversionPeer::clearInstancePool();
// flickrTokenPeer::clearInstancePool();
PuserKuserPeer::clearInstancePool();
// PuserRolePeer::clearInstancePool();
PartnerPeer::clearInstancePool();
// WidgetLogPeer::clearInstancePool();
// adminKuserPeer::clearInstancePool();
// notificationPeer::clearInstancePool();
moderationPeer::clearInstancePool();
moderationFlagPeer::clearInstancePool();
roughcutEntryPeer::clearInstancePool();
// widgetPeer::clearInstancePool();
uiConfPeer::clearInstancePool();
// PartnerStatsPeer::clearInstancePool();
// PartnerActivityPeer::clearInstancePool();
ConversionProfilePeer::clearInstancePool();
// ConversionParamsPeer::clearInstancePool();
// KceInstallationErrorPeer::clearInstancePool();
FileSyncPeer::clearInstancePool();
accessControlPeer::clearInstancePool();
mediaInfoPeer::clearInstancePool();
assetParamsPeer::clearInstancePool();
assetParamsOutputPeer::clearInstancePool();
assetPeer::clearInstancePool();
conversionProfile2Peer::clearInstancePool();
flavorParamsConversionProfilePeer::clearInstancePool();
categoryPeer::clearInstancePool();
syndicationFeedPeer::clearInstancePool();
TrackEntryPeer::clearInstancePool();
// SystemUserPeer::clearInstancePool();
StorageProfilePeer::clearInstancePool();
// EmailIngestionProfilePeer::clearInstancePool();
UploadTokenPeer::clearInstancePool();
// invalidSessionPeer::clearInstancePool();
DynamicEnumPeer::clearInstancePool();
UserLoginDataPeer::clearInstancePool();
PermissionPeer::clearInstancePool();
UserRolePeer::clearInstancePool();
PermissionItemPeer::clearInstancePool();
PermissionToPermissionItemPeer::clearInstancePool();
KuserToUserRolePeer::clearInstancePool();
$pluginInstances = KalturaPluginManager::getPluginInstances('IKalturaMemoryCleaner');
foreach ($pluginInstances as $pluginInstance) {
$pluginInstance->cleanMemory();
}
if (function_exists('gc_collect_cycles')) {
// php 5.3 and above
gc_collect_cycles();
}
}
