private function getUsedEveCharacters($apiIds)
 {
     $chars = ECP\EveCharacterQuery::create()->filterByEveApiId($apiIds)->find();
     $charDict = array();
     foreach ($chars as $char) {
         $key = $char->getEveApiId();
         if (!array_key_exists($key, $charDict)) {
             $charDict[$key] = array($char);
         } else {
             $charDict[$key][] = $char;
         }
     }
     return $charDict;
 }
 /**
  * Returns the number of related EveCharacter objects.
  *
  * @param      Criteria $criteria
  * @param      boolean $distinct
  * @param      ConnectionInterface $con
  * @return int             Count of related EveCharacter objects.
  * @throws PropelException
  */
 public function countEveCharacters(Criteria $criteria = null, $distinct = false, ConnectionInterface $con = null)
 {
     $partial = $this->collEveCharactersPartial && !$this->isNew();
     if (null === $this->collEveCharacters || null !== $criteria || $partial) {
         if ($this->isNew() && null === $this->collEveCharacters) {
             return 0;
         }
         if ($partial && !$criteria) {
             return count($this->getEveCharacters());
         }
         $query = ChildEveCharacterQuery::create(null, $criteria);
         if ($distinct) {
             $query->distinct();
         }
         return $query->filterByEveApi($this)->count($con);
     }
     return count($this->collEveCharacters);
 }
 /**
  * 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 = ChildEveCharacterQuery::create();
     $criteria->add(EveCharacterTableMap::COL_ID, $this->id);
     return $criteria;
 }
 /**
  * Performs an INSERT on the database, given a EveCharacter or Criteria object.
  *
  * @param mixed               $criteria Criteria or EveCharacter 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(EveCharacterTableMap::DATABASE_NAME);
     }
     if ($criteria instanceof Criteria) {
         $criteria = clone $criteria;
         // rename for clarity
     } else {
         $criteria = $criteria->buildCriteria();
         // build Criteria from EveCharacter object
     }
     if ($criteria->containsKey(EveCharacterTableMap::COL_ID) && $criteria->keyContainsValue(EveCharacterTableMap::COL_ID)) {
         throw new PropelException('Cannot insert a value for auto-increment primary key (' . EveCharacterTableMap::COL_ID . ')');
     }
     // Set the correct dbName
     $query = EveCharacterQuery::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);
     });
 }
 public function processGroups()
 {
     while (true) {
         $groups = ECP\GroupQuery::create()->where('Group.lastComputed < ?', time() - 24 * 60 * 60)->find();
         $groups->populateRelation('GroupEvePerson');
         $groups->populateRelation('GroupPerson');
         $evePersonNames = array();
         foreach ($groups as $group) {
             foreach ($group->getGroupEvepeople() as $groupEvePerson) {
                 $evePersonNames[] = $groupEvePerson->getName();
             }
         }
         if (count($evePersonNames) != 0) {
             $eveCharacters = ECP\EveCharacterQuery::create()->filterByCharName($evePersonNames)->_or()->filterByCorpName($evePersonNames)->_or()->filterByAllyName($evePersonNames)->find();
             $eveCharacters->populateRelation('EveApi');
             $eveNameDict = array();
             foreach ($eveCharacters as $eveCharacter) {
                 $eveApi = $eveCharacter->getEveApi();
                 $userId = $eveApi->getUserId();
                 $eveNameDict[$eveCharacter->getCharName()] = array($userId);
                 if ($eveCharacter->getCorpId() != 0) {
                     $this->pushEveName($eveNameDict, $eveCharacter->getCorpName(), $userId);
                 }
                 if ($eveCharacter->getAllyId() != 0) {
                     $this->pushEveName($eveNameDict, $eveCharacter->getAllyName(), $userId);
                 }
             }
             foreach ($eveNameDict as $key => $userIds) {
                 $eveNameDict[$key] = array_unique($userIds);
             }
             foreach ($groups as $group) {
                 $personDict = array();
                 foreach ($group->getGrouppeople() as $groupPerson) {
                     $personKey = $groupPerson->getGroupPersonTypeId() . '-' . $groupPerson->getGroupEvePersonId();
                     if (!array_key_exists($personKey, $personDict)) {
                         $personDict[$personKey] = array($groupPerson);
                     } else {
                         $personDict[$personKey][] = $groupPerson;
                     }
                 }
                 $group->setLastComputed(time());
                 $connection = $this->getPropelConnection();
                 try {
                     $connection->beginTransaction();
                     foreach ($group->getGroupEvepeople() as $groupEvePerson) {
                         $name = $groupEvePerson->getName();
                         $userIds = array_key_exists($name, $eveNameDict) ? $eveNameDict[$name] : array();
                         $personKey = $groupEvePerson->getGroupPersonTypeId() . '-' . $groupEvePerson->getId();
                         $persons = array_key_exists($personKey, $personDict) ? $personDict[$personKey] : array();
                         $personByUserId = array();
                         foreach ($persons as $person) {
                             $personById[$person->getUserId()];
                         }
                         foreach ($userIds as $userId) {
                             if (!array_key_exists($userId, $personByUserId)) {
                                 $groupPersonEntity = new ECP\GroupPerson();
                                 $groupPersonEntity->setGroup($group);
                                 $groupPersonEntity->setGroupPersonTypeId($groupEvePerson->getGroupPersonTypeId());
                                 $groupPersonEntity->setGroupEvePersonId($groupEvePerson->getId());
                                 $groupPersonEntity->setUserId($userId);
                                 $this->prepareSubentitySave2($connection, $group, 'GroupPerson', $groupPersonEntity, true);
                             }
                         }
                         foreach ($persons as $groupPersonEntity) {
                             if (!in_array($groupPersonEntity->getUserId(), $userIds)) {
                                 $group->removeGroupPerson($groupPersonEntity);
                             }
                         }
                     }
                     $group->save($connection);
                     $connection->commit();
                 } catch (Exception $e) {
                     $connection->rollBack();
                     throw $e;
                 }
             }
         }
         sleep(30);
     }
 }