protected function getScalarValueFromQuery($query) { $result = $this->upgradeUtility->executeSql($query); $row = mysqli_fetch_row($result); $logMessage = print_r($row, true); UpgradeLogger::writeLogMessage($logMessage); $value = $row[0]; UpgradeLogger::writeLogMessage('value = ' . $value . ' value + 1 = ' . ($value + 1)); return $value + 1; }
public function executeSql($query) { $result = mysqli_query($this->dbConnection, $query); UpgradeLogger::writeLogMessage('Executing SQL:' . $query); if (!$result) { $logMessage = 'MySQL Error: ' . mysqli_error($this->dbConnection) . ". \nQuery: {$query}\n"; UpgradeLogger::writeErrorMessage($logMessage, true); } return $result; }
public function execute($request) { $dbInfo = $this->getUser()->getAttribute('dbInfo'); $taskNo = $request->getParameter('task'); UpgradeLogger::writeLogMessage('Task:' . $taskNo); $currentTask = "SchemaIncrementTask{$taskNo}"; UpgradeLogger::writeLogMessage("Running task class: {$currentTask}"); $task = new $currentTask($dbInfo); try { $task->execute(); } catch (Exception $e) { UpgradeLogger::writeErrorMessage("Error when running task: " . $e->getMessage() . ', stacktrace = ' . $e->getTraceAsString()); } $progeress = $task->getProgress(); $arr = array('progress' => $progeress); echo json_encode($arr); }
protected function getLeavePeriodList() { if (is_null($this->leavePeriodList)) { $leavePeriods = array(); $result = $this->upgradeUtility->executeSql('select * from ohrm_leave_period_history order by created_at, id'); if (!$result) { throw new Exception("query failed"); } while ($row = mysqli_fetch_array($result)) { $leavePeriods[] = $row; } $this->leavePeriodList = $this->getGeneratedLeavePeriodList($leavePeriods); UpgradeLogger::writeLogMessage("Leave Period List: " . print_r($this->leavePeriodList, true)); } return $this->leavePeriodList; }