예제 #1
0
  /**
   * Method for adding application creation events to database
   *
   * @param versionHashId version hash id
   * @param event application creation event
   * @return
   * @throws AppCloudException
   */
  public boolean addAppCreationEvent(String versionHashId, Event event, int tenantId)
      throws AppCloudException {

    Connection dbConnection = DBUtil.getDBConnection();
    PreparedStatement preparedStatement = null;

    try {
      preparedStatement = dbConnection.prepareStatement(SQLQueryConstants.ADD_APP_CREATION_EVENT);
      preparedStatement.setString(1, event.getEventName());
      preparedStatement.setString(2, event.getEventStatus());
      preparedStatement.setString(3, versionHashId);
      preparedStatement.setTimestamp(4, event.getTimestamp());
      preparedStatement.setString(5, event.getEventDescription());
      preparedStatement.setInt(6, tenantId);

      boolean result = preparedStatement.execute();
      dbConnection.commit();
    } catch (SQLException e) {
      String msg =
          "Error occurred while adding app creation event: "
              + event.getEventName()
              + " status: "
              + event.getEventStatus()
              + " timestamp: "
              + event.getTimestamp();
      log.error(msg, e);
      throw new AppCloudException(msg, e);

    } finally {
      DBUtil.closePreparedStatement(preparedStatement);
      DBUtil.closeConnection(dbConnection);
    }
    return true;
  }
예제 #2
0
  /**
   * Method to get event stream of an application
   *
   * @param versionHashId application id
   * @return
   * @throws AppCloudException
   */
  public List<Event> getEventsOfApplication(String versionHashId) throws AppCloudException {

    Connection dbConnection = DBUtil.getDBConnection();
    PreparedStatement preparedStatement = null;

    List<Event> eventList = new ArrayList<>();

    try {
      preparedStatement =
          dbConnection.prepareStatement(SQLQueryConstants.GET_ALL_EVENTS_OF_APPLICATION);
      preparedStatement.setString(1, versionHashId);

      ResultSet resultSet = preparedStatement.executeQuery();
      Event event;
      while (resultSet.next()) {
        event = new Event();
        event.setEventName(resultSet.getString(SQLQueryConstants.NAME));
        event.setEventStatus(resultSet.getString(SQLQueryConstants.STATUS));
        event.setTimestamp(resultSet.getTimestamp(SQLQueryConstants.EVENT_TIMESTAMP));
        event.setEventDescription(resultSet.getString(SQLQueryConstants.DESCRIPTION));

        eventList.add(event);
      }

    } catch (SQLException e) {
      String msg =
          "Error while retrieving Application creation event stream for application with hash id : "
              + versionHashId;
      log.error(msg, e);
      throw new AppCloudException(msg, e);
    } finally {
      DBUtil.closePreparedStatement(preparedStatement);
      DBUtil.closeConnection(dbConnection);
    }
    return eventList;
  }