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);
   }
 }
  public boolean delete() throws PlatformException, DBException {
    SQLDelete delete = new SQLDelete();
    // deleting data set
    delete.setTable(TABLE_NAME);
    delete.addCondition("attributeset_id =", _attributeSetID);
    int rows;
    try {
      rows = _dbManager.delete(delete);
    } catch (SQLException e) {
      LOGGER.fatal("", e);
      throw new DBException("Cannot delete!", e);
    }

    LOGGER.debug("rows deleted: " + rows);
    return (rows > 0);
  }
Exemplo n.º 3
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;
 }
  public int save() throws PlatformException, DBException {
    // removing old attribute set with the same name
    SQLDelete delete = new SQLDelete();
    delete.setTable(TABLE_NAME);
    delete.addCondition("attributeset_name = ", _name);
    int rows;
    try {
      rows = _dbManager.delete(delete);
    } catch (SQLException e) {
      LOGGER.fatal("!", e);
      throw new DBException("Cannot delete!", e);
    }
    LOGGER.debug("rows deleted: " + rows);

    // saving header
    SQLUpdate update = new SQLUpdate(TABLE_NAME);
    if (_name != null) {
      update.addValue("attributeset_name", _name);
    }
    if (_info != null) {
      update.addValue("attributeset_info", _info);
    }

    if (_attributeSetID == 0) {
      update.addValue("c_date", new Date(System.currentTimeMillis()));
    }

    update.addValue("solution_id", _solutionID);
    update.addValue("lm_date", new Date(System.currentTimeMillis()));

    try {
      _attributeSetID =
          _dbManager.insertOrUpdate(update, "attributeset_id", _attributeSetID, GEN_NAME);
    } catch (SQLException e) {
      LOGGER.fatal("Exception was thrown!", e);
      throw new DBException("Cannot save!", e);
    }

    try {
      // saving items
      for (IAttributeDescription description : _descriptions) {
        // FIXME: why it can be null???
        if (description != null) {
          SQLInsert insert = new SQLInsert(ITEMS_TABLE_NAME);
          insert.addValue("attributeset_id", _attributeSetID);
          insert.addValue("attribute_name", description.getName());
          insert.addValue("attribute_type", description.getType().getDBString());
          insert.addValue("table_name", description.getColumn().getTable().getName());
          insert.addValue("column_name", description.getColumn().getName());
          insert.addValue("is_output", description.isOutput() ? "Y" : "N");
          // FIXME: workaround!
          if (description instanceof EnumAttributeDescription) {
            insert.addValue(
                "attribute_value", ((EnumAttributeDescription) description).valuesToString());
          }

          LOGGER.debug("insert: " + insert.getQuery());
          _dbManager.insert(insert, "attributeset_item_id");
        }
      }
    } catch (SQLException e) {
      LOGGER.fatal("Exception was thrown!", e);
      throw new DBException("Cannot save!", e);
    }

    return _attributeSetID;
  }