/** * @param string $instanceName * @param string|null $userName * @param int|null $limit * @param TimeFrame $timeFrame * * @return array the popular channels */ private function getPopularChannels($instanceName, $userName, $limit, $timeFrame) { // Find the instance and the user $instance = InstanceQuery::create()->findOneByName($instanceName); $user = UserQuery::create()->findOneByName($userName); $query = SubscriptionQuery::create()->getPopularChannelsQuery($instance, $user); $ignoredUsers = $this->configuration->getInstanceByName($instanceName)->getIgnoredUsers(); $query = $query->filterByLimit($limit); $query = $query->filterByTimeFrame($timeFrame); $query = $query->useUserQuery()->filterIgnoredUsers($ignoredUsers)->endUse(); return $query->find()->getData(); }
/** * Builds a Criteria object containing the primary key for this object. * * Unlike buildCriteria() this method includes the primary key values regardless * of whether or not they have been modified. * * @throws LogicException if no primary key is defined * * @return Criteria The Criteria object containing value(s) for primary key(s). */ public function buildPkeyCriteria() { $criteria = ChildSubscriptionQuery::create(); $criteria->add(SubscriptionTableMap::COL_ID, $this->id); return $criteria; }
/** * If this collection has already been initialized with * an identical criteria, it returns the collection. * Otherwise if this Channel is new, it will return * an empty collection; or if this Channel has previously * been saved, it will retrieve related Subscriptions from storage. * * This method is protected by default in order to keep the public * api reasonable. You can provide public methods for those you * actually need in Channel. * * @param Criteria $criteria optional Criteria object to narrow the query * @param ConnectionInterface $con optional connection object * @param string $joinBehavior optional join type to use (defaults to Criteria::LEFT_JOIN) * @return ObjectCollection|ChildSubscription[] List of ChildSubscription objects */ public function getSubscriptionsJoinUser(Criteria $criteria = null, ConnectionInterface $con = null, $joinBehavior = Criteria::LEFT_JOIN) { $query = ChildSubscriptionQuery::create(null, $criteria); $query->joinWith('User', $joinBehavior); return $this->getSubscriptions($query, $con); }
/** * Returns a new ChildSubscriptionQuery object. * * @param string $modelAlias The alias of a model in the query * @param Criteria $criteria Optional Criteria to build the query from * * @return ChildSubscriptionQuery */ public static function create($modelAlias = null, Criteria $criteria = null) { if ($criteria instanceof ChildSubscriptionQuery) { return $criteria; } $query = new ChildSubscriptionQuery(); if (null !== $modelAlias) { $query->setModelAlias($modelAlias); } if ($criteria instanceof Criteria) { $query->mergeWith($criteria); } return $query; }
/** * @param SubscriptionStateChangeEvent $event */ public function onSubscriptionStateChange(SubscriptionStateChangeEvent $event) { $instanceName = $event->getInstance(); $stateChange = $event->getStateChange(); // We only need to persist subscription stops if ($stateChange->getState() === StateChange::STATE_SUBSCRIPTION_STARTED) { return; } // Find the latest matching subscription $subscription = SubscriptionQuery::create()->getNewestMatching($instanceName, $stateChange->getSubscriptionId()); // EPG grab subscriptions are not stored so we don't want to log these with a high level if ($subscription === null) { $this->logger->error('Got subscription stop without a matching start (instance: {instanceName}, subscription: {subscriptionId})', ['instanceName' => $instanceName, 'subscriptionId' => $stateChange->getSubscriptionId()]); return; } $subscription->setStopped(new \DateTime()); $subscription->save(); $user = $subscription->getUser(); $channel = $subscription->getChannel(); $this->logger->info('Stored subscription stop (instance: {instanceName}, user: {userName}, channel: {channelName})', ['instanceName' => $instanceName, 'userName' => $user !== null ? $user->getName() : 'N/A', 'channelName' => $channel->getName()]); }
/** * Performs an INSERT on the database, given a Subscription or Criteria object. * * @param mixed $criteria Criteria or Subscription object containing data that is used to create the INSERT statement. * @param ConnectionInterface $con the ConnectionInterface connection to use * @return mixed The new primary key. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doInsert($criteria, ConnectionInterface $con = null) { if (null === $con) { $con = Propel::getServiceContainer()->getWriteConnection(SubscriptionTableMap::DATABASE_NAME); } if ($criteria instanceof Criteria) { $criteria = clone $criteria; // rename for clarity } else { $criteria = $criteria->buildCriteria(); // build Criteria from Subscription object } if ($criteria->containsKey(SubscriptionTableMap::COL_ID) && $criteria->keyContainsValue(SubscriptionTableMap::COL_ID)) { throw new PropelException('Cannot insert a value for auto-increment primary key (' . SubscriptionTableMap::COL_ID . ')'); } // Set the correct dbName $query = SubscriptionQuery::create()->mergeWith($criteria); // use transaction because $criteria could contain info // for more than one table (I guess, conceivably) return $con->transaction(function () use($con, $query) { return $query->doInsert($con); }); }