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