function testBeginAndCommitTransaction()
 {
     $this->driver->shouldReceive("begin")->withNoArgs()->once();
     $this->dbManager->begin();
     $this->driver->shouldReceive("commit")->withNoArgs()->once();
     $this->dbManager->commit();
 }
 /**
  * @param ItemTreeBounds $itemBounds
  * @param int $userId
  * @param int $groupId
  * @param int $type
  * @param boolean $global
  * @param int[] $additionalEventIds additional event ids to include, indexed by licenseId
  */
 public function makeDecisionFromLastEvents(ItemTreeBounds $itemBounds, $userId, $groupId, $type, $global, $additionalEventIds = array())
 {
     if ($type < self::NO_LICENSE_KNOWN_DECISION_TYPE) {
         return;
     }
     $this->dbManager->begin();
     $itemId = $itemBounds->getItemId();
     $previousEvents = $this->clearingDao->getRelevantClearingEvents($itemBounds, $groupId);
     if ($type === self::NO_LICENSE_KNOWN_DECISION_TYPE) {
         $type = DecisionTypes::IDENTIFIED;
         $clearingEventIds = $this->insertClearingEventsForAgentFindings($itemBounds, $userId, $groupId, true, ClearingEventTypes::USER);
         foreach ($previousEvents as $eventId => $clearingEvent) {
             if (!in_array($eventId, $clearingEventIds) && !$clearingEvent->isRemoved()) {
                 $licenseId = $clearingEvent->getLicenseId();
                 $newEventId = $this->clearingDao->insertClearingEvent($itemBounds->getItemId(), $userId, $groupId, $licenseId, true);
                 $clearingEventIds[$licenseId] = $newEventId;
             }
         }
     } else {
         $clearingEventIds = $this->insertClearingEventsForAgentFindings($itemBounds, $userId, $groupId, false, ClearingEventTypes::AGENT, $previousEvents);
         foreach ($previousEvents as $clearingEvent) {
             $clearingEventIds[$clearingEvent->getLicenseId()] = $clearingEvent->getEventId();
         }
     }
     $currentDecision = $this->clearingDao->getRelevantClearingDecision($itemBounds, $groupId);
     $clearingEventIds = array_unique(array_merge($clearingEventIds, $additionalEventIds));
     $scope = $global ? DecisionScopes::REPO : DecisionScopes::ITEM;
     if (null === $currentDecision || $this->clearingDecisionIsDifferentFrom($currentDecision, $type, $scope, $clearingEventIds)) {
         $this->clearingDao->createDecisionFromEvents($itemBounds->getItemId(), $userId, $groupId, $type, $scope, $clearingEventIds);
     } else {
         $this->clearingDao->removeWipClearingDecision($itemId, $groupId);
     }
     $this->dbManager->commit();
 }
Exemple #3
0
 /**
  * @param string $agentName
  * @return bool
  */
 public function renewCurrentAgent($agentName)
 {
     $this->dbManager->begin();
     $row = $this->dbManager->getSingleRow("SELECT agent_pk, agent_name, agent_rev, agent_desc FROM agent " . "WHERE agent_enabled AND agent_name=\$1 ORDER BY agent_pk DESC LIMIT 1", array($agentName), __METHOD__ . '.get');
     $this->dbManager->getSingleRow("UPDATE agent SET agent_rev=agent_rev||'.'||substr(md5(agent_ts::text),0,6) " . "WHERE agent_pk=\$1", array($row['agent_pk']), __METHOD__ . '.upd');
     unset($row['agent_pk']);
     $this->dbManager->insertTableRow('agent', $row);
     $this->dbManager->commit();
     return true;
 }
 public function moveUploadBeyond($moveUpload, $beyondUpload)
 {
     $this->dbManager->begin();
     $this->dbManager->prepare($stmt = __METHOD__ . '.get.single.Upload', $sql = 'SELECT upload_fk,' . self::PRIO_COLUMN . ' FROM upload_clearing WHERE group_fk=$1 AND upload_fk=$2');
     $movePoint = $this->dbManager->getSingleRow($sql, array($this->groupId, $moveUpload), $stmt);
     $beyondPoint = $this->dbManager->getSingleRow($sql, array($this->groupId, $beyondUpload), $stmt);
     if ($movePoint[self::PRIO_COLUMN] > $beyondPoint[self::PRIO_COLUMN]) {
         $farPoint = $this->dbManager->getSingleRow("SELECT MAX(" . self::PRIO_COLUMN . ") m FROM upload_clearing WHERE group_fk=\$1 AND " . self::PRIO_COLUMN . "<\$2", array($this->groupId, $beyondPoint[self::PRIO_COLUMN]), 'get.upload.with.lower.priority');
         $farPrio = $farPoint['m'] !== null ? $farPoint['m'] : $beyondPoint[self::PRIO_COLUMN] - 1;
     } else {
         $farPoint = $this->dbManager->getSingleRow("SELECT MIN(" . self::PRIO_COLUMN . ") m FROM upload_clearing WHERE group_fk=\$1 AND " . self::PRIO_COLUMN . ">\$2", array($this->groupId, $beyondPoint[self::PRIO_COLUMN]), 'get.upload.with.higher.priority');
         $farPrio = $farPoint['m'] !== null ? $farPoint['m'] : $beyondPoint[self::PRIO_COLUMN] + 1;
     }
     $newPriority = ($farPrio + $beyondPoint[self::PRIO_COLUMN]) / 2;
     $this->dbManager->getSingleRow('UPDATE upload_clearing SET ' . self::PRIO_COLUMN . '=$1 WHERE group_fk=$2 AND upload_fk=$3', array($newPriority, $this->groupId, $moveUpload), __METHOD__ . '.update.priority');
     $this->dbManager->commit();
 }
Exemple #5
0
 /**
  * @param int $uploadTreeId
  * @param int $userId
  * @param int $groupId
  * @param int $licenseId
  * @param string $what
  * @param string $changeTo
  */
 public function updateClearingEvent($uploadTreeId, $userId, $groupId, $licenseId, $what, $changeTo)
 {
     $this->dbManager->begin();
     $statementGetOldata = "SELECT * FROM clearing_event WHERE uploadtree_fk=\$1 AND rf_fk=\$2 AND group_fk=\$3  ORDER BY clearing_event_pk DESC LIMIT 1";
     $statementName = __METHOD__ . 'getOld';
     $params = array($uploadTreeId, $licenseId, $groupId);
     $row = $this->dbManager->getSingleRow($statementGetOldata, $params, $statementName);
     if (!$row) {
         //The license was not added as user decision yet -> we promote it here
         $type = ClearingEventTypes::USER;
         $row['type_fk'] = $type;
         $row['comment'] = "";
         $row['reportinfo'] = "";
     }
     if ($what == 'reportinfo') {
         $reportInfo = $changeTo;
         $comment = $row['comment'];
     } else {
         $reportInfo = $row['reportinfo'];
         $comment = $changeTo;
     }
     $this->insertClearingEvent($uploadTreeId, $userId, $groupId, $licenseId, false, $row['type_fk'], $reportInfo, $comment);
     $this->dbManager->commit();
 }