/**
  * Saves itself in data base. If already exists in database performs update otherwise inserts new
  * record. Returns current id if update was executed or new id in case of insert.
  *
  * @return unique id
  */
 public int save() throws DBException {
   SQLUpdate update = new SQLUpdate(TABLE_NAME);
   if (_name != null) {
     update.addValue("solution_name", _name);
   }
   if (_info != null) {
     update.addValue("solution_info", _info);
   }
   if (_host != null) {
     update.addValue("hostname", _host);
   }
   if (_path != null) {
     update.addValue("db_path", _path);
   }
   if (_user != null) {
     update.addValue("username", _user);
   }
   if (_passwd != null) {
     update.addValue("passwd", _passwd);
   }
   update.addValue("lm_date", new Date(System.currentTimeMillis()));
   try {
     _solutionID = _dbManager.insertOrUpdate(update, "solution_id", _solutionID, GEN_NAME);
   } catch (SQLException e) {
     LOGGER.fatal("Exception was thrown!", e);
     throw new DBException("Cannot save solution info!", e);
   }
   return _solutionID;
 }
예제 #2
0
 public void run() {
   LOGGER.info("Running tasks");
   /*
    * while (true) { Task task = getTask(); IDataPlugin plugin =
    * task.getPlugin(); Settings settings = task.getSettings();
    * plugin.doJob(_dataEngine, _environment, settings);
    */
   TaskInfo taskInfo = null;
   for (ITask task : _tasks) {
     try {
       taskInfo = ((Task) task).getInfo();
       LOGGER.info("task: " + taskInfo.getName());
       ISettings settings = task.getSettings();
       taskInfo.setStatus(TaskInfo.REALIZATION);
       // changing status
       taskInfo.save();
       _dbManager.commit();
       //
       // processing task
       //
       ILocalPlugin plugin = task.getPlugin();
       LOGGER.debug("plugin: " + plugin + " id: " + plugin.getInfo().getId());
       IResult result = plugin.doJob(getDataEngine(), _environment, settings);
       //
       // saving result of its execution
       //
       task.setResult(result);
       taskInfo.save();
       _dbManager.commit();
       //
       // if task was not processed correctly
       // exception is caught and shoul be handled here
       //
     } catch (Exception e) {
       LOGGER.fatal("TASK PROCESSING ERROR", e);
       try {
         taskInfo.setStatus(TaskInfo.EXCEPTION);
         taskInfo.save();
       } catch (Exception ex) {
         LOGGER.fatal("", ex);
       }
       _dbManager.commit();
     }
   }
 }
 public boolean delete() throws DBException {
   SQLDelete delete = new SQLDelete(TABLE_NAME);
   delete.addCondition("solution_id =", _solutionID);
   try {
     return (_dbManager.delete(delete) > 0);
   } catch (SQLException e) {
     LOGGER.fatal("Exception was thrown!", e);
     throw new DBException("Cannot delete solution info!", e);
   }
 }
예제 #4
0
 /** @see salomon.engine.task.ITaskManager#addTask(salomon.platform.task.ITask) */
 public void addTask(ITask task) throws PlatformException {
   try {
     task.getInfo().save();
     _dbManager.commit();
   } catch (Exception e) {
     _dbManager.rollback();
     LOGGER.fatal("", e);
     throw new PlatformException(e.getLocalizedMessage());
   }
   _tasks.add(task);
 }
예제 #5
0
 public void saveTasks() throws PlatformException {
   try {
     for (ITask task : _tasks) {
       ((Task) task).getInfo().save();
     }
     _dbManager.commit();
   } catch (Exception e) {
     _dbManager.rollback();
     LOGGER.fatal("", e);
     throw new PlatformException(e.getLocalizedMessage());
   }
 }
 /**
  * Initializes itself basing on given row from resultSet.
  *
  * @param resultSet
  * @throws DBException
  */
 public void load(ResultSet resultSet) throws DBException {
   try {
     _solutionID = resultSet.getInt("solution_id");
     _name = resultSet.getString("solution_name");
     _info = resultSet.getString("solution_info");
     _host = resultSet.getString("hostname");
     _path = resultSet.getString("db_path");
     _user = resultSet.getString("username");
     _passwd = resultSet.getString("passwd");
   } catch (SQLException e) {
     LOGGER.fatal("Exception was thrown!", e);
     throw new DBException("Cannot load solution info!", e);
   }
 }
 public void testLoad() {
   LOGGER.debug("DescriptionTest.testLoad()");
   boolean success = false;
   SQLSelect select = new SQLSelect();
   select.addTable(PluginInfo.TABLE_NAME);
   select.addCondition("plugin_id =", 20);
   ResultSet resultSet = null;
   try {
     resultSet = _manager.select(select);
     assertNotNull(resultSet);
     success = true;
   } catch (SQLException e) {
     LOGGER.fatal("", e);
   }
   assertTrue(success);
   success = false;
   // PluginInfo desc = new PluginInfo();
   try {
     if (resultSet.next()) {
       // desc.load(resultSet);
       success = true;
     } else {
       LOGGER.debug("No data found");
       success = true;
     }
   } catch (Exception e) {
     LOGGER.fatal("", e);
   } finally {
     try {
       resultSet.close();
     } catch (SQLException ex) {
       LOGGER.fatal("", ex);
     }
   }
   assertTrue(success);
   // LOGGER.debug(desc);
 }
 public void testDelete() {
   LOGGER.debug("DescriptionTest.testDelete()");
   boolean success = false;
   // PluginInfo desc = new PluginInfo();
   // desc.setPluginID(40);
   try {
     // desc.delete();
     success = true;
     _manager.commit();
   } catch (Exception e) {
     LOGGER.fatal("", e);
     _manager.rollback();
   }
   assertTrue(success);
 }
예제 #9
0
 public TaskManager(IManagerEngine managerEngine, DBManager manager) {
   _managerEngine = managerEngine;
   _dbManager = manager;
   _tasks = new LinkedList<ITask>();
   _taskEngine = new TaskEngine();
   // TODO: where it should be created?
   _environment = new Environment();
   // TODO: temporary
   // TODO: temporary
   IVariable variable;
   try {
     variable = _environment.createEmpty("CURRENT_DATA_SET");
     variable.setValue(new SimpleString("all_data"));
     _environment.add(variable);
   } catch (PlatformException e) {
     LOGGER.fatal("Exception was thrown!", e);
   }
 }
예제 #10
0
 /**
  * Removes given tasks.
  *
  * @see salomon.engine.task.ITaskManager#removeTask(salomon.engine.task.ITask)
  */
 public boolean removeTask(ITask task) throws PlatformException {
   SQLDelete delete = new SQLDelete(TaskInfo.TABLE_NAME);
   IProject currProject = _managerEngine.getProjectManager().getCurrentProject();
   delete.addCondition("project_id =", currProject.getInfo().getId());
   delete.addCondition("task_id = ", task.getInfo().getId());
   boolean retVal = false;
   int deletedRows = 0;
   try {
     deletedRows = _dbManager.delete(delete);
     _dbManager.commit();
     // removing from list
     _tasks.remove(task);
     retVal = (deletedRows > 0);
   } catch (SQLException e) {
     _dbManager.rollback();
     LOGGER.fatal("", e);
     throw new PlatformException(e.getLocalizedMessage());
   }
   return retVal;
 }
예제 #11
0
    private ITask getTask() {
      ITask currentTask = null;
      while (true) {
        synchronized (_tasks) {
          if (_tasks.size() > 0) {
            currentTask = _tasks.getFirst();
          }
        }
        _tasks.notifyAll();
        if (currentTask != null) {
          break;
        }
        try {
          _tasks.wait();
        } catch (InterruptedException e) {
          LOGGER.fatal("", e);
        }
      } // while (currentTask != null);

      return currentTask;
    }
 public void testSave() {
   LOGGER.debug("DescriptionTest.testSave()");
   boolean success = false;
   // PluginInfo desc = new PluginInfo();
   // desc.setName("test_plugin");
   // try {
   // desc.setLocation(new URL("http://www.test_description.pl"));
   //	success = true;
   // } catch (MalformedURLException e) {
   //	LOGGER.fatal("", e);
   // }
   assertTrue(success);
   success = false;
   try {
     // desc.save();
     _manager.commit();
     success = true;
   } catch (Exception e) {
     LOGGER.fatal("", e);
     _manager.rollback();
   }
   assertTrue(success);
 }
  public IResult doJob(IDataEngine dataEngine, IEnvironment env, ISettings settings) {
    CreatorSettings cSettings = (CreatorSettings) settings;
    String dataSetName = cSettings.getDataSetName();
    IDataSetManager dataSetManager = dataEngine.getDataSetManager();

    boolean isSuccessfull = false;

    try {
      String[] strConds = cSettings.getConditions();
      ICondition[] conditions = new ICondition[strConds.length];
      int i = 0;
      for (String cond : strConds) {
        if (cond != null) {
          conditions[i] = dataSetManager.createCondition(cond);
          ++i;
        }
      }

      IDataSet mainDataSet = dataSetManager.getMainDataSet();
      IDataSet subSet = mainDataSet.createSubset(conditions);
      subSet.setName(dataSetName);
      dataSetManager.add(subSet);

      isSuccessfull = true;
    } catch (PlatformException e) {
      LOGGER.fatal("", e);
    }

    CreatorResult result = new CreatorResult();
    result.setSuccessful(isSuccessfull);
    if (!isSuccessfull) {
      dataSetName = "ERROR";
    }
    result.setDataSetName(dataSetName);
    return result;
  }
예제 #14
0
  /**
   * Returns tasks associated with current project. They are returned sorted by task_nr.
   *
   * @see salomon.engine.task.ITaskManager#getTasks()
   */
  public ITask[] getTasks() throws PlatformException {
    LinkedList<ITask> tasks = null;
    // TODO: use _project in stead of it
    IProject currProject = _managerEngine.getProjectManager().getCurrentProject();
    if (_tasks.isEmpty() && currProject != null) {
      tasks = new LinkedList<ITask>();
      SQLSelect select = new SQLSelect();
      select.addTable(TaskInfo.TABLE_NAME + " t");
      select.addTable(PluginInfo.TABLE_NAME + " p");
      select.addColumn("t.task_id");
      select.addColumn("t.task_nr");
      select.addColumn("t.project_id");
      select.addColumn("t.task_name");
      select.addColumn("t.task_info");
      select.addColumn("t.status");
      select.addColumn("t.plugin_settings");
      select.addColumn("t.plugin_result");
      select.addColumn("p.plugin_id");
      select.addColumn("p.plugin_name");
      select.addColumn("p.plugin_info");
      select.addColumn("p.location");
      int projectID = currProject.getInfo().getId();
      select.addCondition("t.project_id =", projectID);
      select.addCondition("t.plugin_id = p.plugin_id");
      // tasks are sorted by task_nr
      select.addOrderBy("t.task_nr");

      // executing query
      ResultSet resultSet = null;
      try {
        resultSet = _dbManager.select(select);
        while (resultSet.next()) {
          // TODO: Plugin info shoul not be instantied from outside of pluginManger :-/
          PluginInfo pluginInfo = new PluginInfo(_dbManager);
          pluginInfo.load(resultSet);
          LocalPlugin localPlugin =
              (LocalPlugin) _managerEngine.getPluginManager().getPlugin(pluginInfo);
          localPlugin.load();
          // FIXME: real settings should be loaded
          ISettings pluginSettings = localPlugin.getSettingComponent().getDefaultSettings();

          Task task = (Task) this.createTask();
          task.setSettings(pluginSettings);
          task.setPlugin(localPlugin);
          // loading task
          task.getInfo().load(resultSet);
          tasks.add(task);
        }
        resultSet.close();
        // if everything is OK, then loaded tasks list is assigned
        // to manager's tasks list
        _tasks = tasks;
      } catch (Exception e) {
        LOGGER.fatal("", e);
        try {
          resultSet.close();
        } catch (SQLException ex) {
          LOGGER.fatal("", ex);
        }
        throw new PlatformException(e.getLocalizedMessage());
      }
    }
    ITask[] tasksArr = new ITask[_tasks.size()];
    return _tasks.toArray(tasksArr);
  }