Esempio n. 1
0
  public int clear(String topology, long currentTimeMillis) {
    Connection c = getConnection(topology);

    int deletes = 0;
    try {
      deleteBooleanEvent.setLong(1, currentTimeMillis);
      deleteCountEvent.setLong(1, currentTimeMillis);
      deleteDistributionEvent.setLong(1, currentTimeMillis);
      deleteEmitEvent.setLong(1, currentTimeMillis);
      deleteNumberEvent.setLong(1, currentTimeMillis);
      deleteReceiveEvent.setLong(1, currentTimeMillis);
      deleteTimeEvent.setLong(1, currentTimeMillis);

      deletes = deleteBooleanEvent.executeUpdate();

      deletes += deleteCountEvent.executeUpdate();

      deletes += deleteDistributionEvent.executeUpdate();

      deletes += deleteEmitEvent.executeUpdate();

      deletes += deleteNumberEvent.executeUpdate();

      deletes += deleteReceiveEvent.executeUpdate();

      deletes += deleteTimeEvent.executeUpdate();

      c.commit();

      Logger.info(this.getClass(), "clear", "Deleted " + deletes + " events");

    } catch (Exception e) {
      Logger.error(this.getClass(), "clear", e.getLocalizedMessage());
    }

    return deletes;
  }
Esempio n. 2
0
  private Connection getConnection(String topology) {
    Logger.debug(this.getClass(), "getConnection", "enter");

    if (conn == null) {
      try {

        File folder = new File(this.location + "/" + topology);
        boolean exists = folder.exists();
        Class.forName("org.h2.Driver");
        String url = "jdbc:h2:" + this.location + "/" + topology + "/db";
        conn = DriverManager.getConnection(url, "sa", "");

        if (!exists) {

          Statement statement = conn.createStatement();
          statement.execute(H2DataModel.CREATE_BOOLEAN);

          statement = conn.createStatement();
          statement.execute(H2DataModel.CREATE_COUNT);

          statement = conn.createStatement();
          statement.execute(H2DataModel.CREATE_DIST);

          statement = conn.createStatement();
          statement.execute(H2DataModel.CREATE_EMIT);

          statement = conn.createStatement();
          statement.execute(H2DataModel.CREATE_NUMBER);

          statement = conn.createStatement();
          statement.execute(H2DataModel.CREATE_RECEIVE);

          statement = conn.createStatement();
          statement.execute(H2DataModel.CREATE_TIME);

          Logger.info(this.getClass(), "init", "Created Data Bases");
        }

        /** Prepared statements */
        this.insertBooleanEvent = conn.prepareStatement(H2DataModel.INSERT_BOOLEAN);

        this.insertCountEvent = conn.prepareStatement(H2DataModel.INSERT_COUNT);

        this.insertEmitEvent = conn.prepareStatement(H2DataModel.INSERT_EMIT);

        this.insertReceiveEvent = conn.prepareStatement(H2DataModel.INSERT_RECEIVE);

        this.insertNumberEvent = conn.prepareStatement(H2DataModel.INSERT_NUMBER);

        this.insertTimeEvent = conn.prepareStatement(H2DataModel.INSERT_TIME);

        this.insertDistributionEvent = conn.prepareStatement(H2DataModel.INSERT_DIST);

        this.deleteBooleanEvent = conn.prepareStatement(H2DataModel.DELETE_BOOLEAN);

        this.deleteCountEvent = conn.prepareStatement(H2DataModel.DELETE_COUNT);

        this.deleteReceiveEvent = conn.prepareStatement(H2DataModel.DELETE_RECEIVE);

        this.deleteEmitEvent = conn.prepareStatement(H2DataModel.DELETE_EMIT);

        this.deleteNumberEvent = conn.prepareStatement(H2DataModel.DELETE_NUMBER);

        this.deleteTimeEvent = conn.prepareStatement(H2DataModel.DELETE_TIME);

        this.deleteDistributionEvent = conn.prepareStatement(H2DataModel.DELETE_DIST);

        Logger.debug(this.getClass(), "getConnection", "Connected to " + url);
      } catch (Exception e) {
        Logger.error(this.getClass(), "getConnection", e.getLocalizedMessage());
      }
    }

    return conn;
  }
Esempio n. 3
0
  public int save(Events e) {
    Connection c = getConnection(e.getTopology());
    int inserts = 0;

    try {

      ArrayList<BooleanEvent> booleanEvents = e.getBools();
      for (BooleanEvent event : booleanEvents) {

        insertBooleanEvent.setLong(1, e.getTimestamp());
        insertBooleanEvent.setString(2, event.getServer());
        insertBooleanEvent.setString(3, event.getComponent());
        insertBooleanEvent.setString(4, event.getInstance());
        insertBooleanEvent.setString(5, event.getAspect());

        insertBooleanEvent.setLong(6, event.getTrues());
        insertBooleanEvent.setLong(7, event.getFalses());
        int done = insertBooleanEvent.executeUpdate();

        if (done == 0) {
          Logger.error(this.getClass(), "clear", "Did not insert BooleanEvent");
        }
        inserts += done;
      }

      ArrayList<CountEvent> countEvents = e.getCounts();
      for (CountEvent event : countEvents) {

        insertCountEvent.setLong(1, e.getTimestamp());
        insertCountEvent.setString(2, event.getServer());
        insertCountEvent.setString(3, event.getComponent());
        insertCountEvent.setString(4, event.getInstance());
        insertCountEvent.setString(5, event.getAspect());

        insertCountEvent.setLong(6, event.getCount());
        int done = insertCountEvent.executeUpdate();

        if (done == 0) {
          Logger.error(this.getClass(), "clear", "Did not insert CountEvent");
        }
        inserts += done;
      }

      ArrayList<EmitEvent> emitEvents = e.getEmits();
      for (EmitEvent event : emitEvents) {

        insertEmitEvent.setLong(1, e.getTimestamp());
        insertEmitEvent.setString(2, event.getServer());
        insertEmitEvent.setString(3, event.getComponent());
        insertEmitEvent.setString(4, event.getInstance());
        insertEmitEvent.setString(5, event.getAspect());

        insertEmitEvent.setLong(6, event.getCount());
        int done = insertEmitEvent.executeUpdate();

        if (done == 0) {
          Logger.error(this.getClass(), "clear", "Did not insert EmitEvent");
        }
        inserts += done;
      }

      ArrayList<ReceiveEvent> receiveEvents = e.getReceives();
      for (ReceiveEvent event : receiveEvents) {

        insertReceiveEvent.setLong(1, e.getTimestamp());
        insertReceiveEvent.setString(2, event.getServer());
        insertReceiveEvent.setString(3, event.getComponent());
        insertReceiveEvent.setString(4, event.getInstance());
        insertReceiveEvent.setString(5, event.getAspect());

        insertReceiveEvent.setLong(6, event.getCount());
        int done = insertReceiveEvent.executeUpdate();

        if (done == 0) {
          Logger.error(this.getClass(), "clear", "Did not insert ReceiveEvent");
        }
        inserts += done;
      }

      ArrayList<NumberEvent> numberEvents = e.getNumbers();
      for (NumberEvent event : numberEvents) {

        insertNumberEvent.setLong(1, e.getTimestamp());
        insertNumberEvent.setString(2, event.getServer());
        insertNumberEvent.setString(3, event.getComponent());
        insertNumberEvent.setString(4, event.getInstance());
        insertNumberEvent.setString(5, event.getAspect());

        insertNumberEvent.setLong(6, event.getCount());
        insertNumberEvent.setDouble(7, event.getValue());
        int done = insertNumberEvent.executeUpdate();

        if (done == 0) {
          Logger.error(this.getClass(), "clear", "Did not insert NumberEvent");
        }
        inserts += done;
      }

      ArrayList<TimeEvent> timEvents = e.getTime();
      for (TimeEvent event : timEvents) {

        insertTimeEvent.setLong(1, e.getTimestamp());
        insertTimeEvent.setString(2, event.getServer());
        insertTimeEvent.setString(3, event.getComponent());
        insertTimeEvent.setString(4, event.getInstance());
        insertTimeEvent.setString(5, event.getAspect());

        insertTimeEvent.setLong(6, event.getCount());
        insertTimeEvent.setLong(7, event.getNanos());
        int done = insertTimeEvent.executeUpdate();

        if (done == 0) {
          Logger.error(this.getClass(), "clear", "Did not insert NumberEvent");
        }
        inserts += done;
      }

      ArrayList<DistributionEvent> distEvents = e.getDistributions();
      for (DistributionEvent event : distEvents) {

        HashMap<Double, Long> dist = event.getDistribution();
        for (Double value : dist.keySet()) {

          insertDistributionEvent.setLong(1, e.getTimestamp());
          insertDistributionEvent.setString(2, event.getServer());
          insertDistributionEvent.setString(3, event.getComponent());
          insertDistributionEvent.setString(4, event.getInstance());
          insertDistributionEvent.setString(5, event.getAspect());

          insertDistributionEvent.setDouble(6, value);
          insertDistributionEvent.setLong(7, dist.get(value));

          int done = insertDistributionEvent.executeUpdate();

          if (done == 0) {
            Logger.error(this.getClass(), "clear", "Did not insert NumberEvent");
          }
          inserts += done;
        }
      }

      c.commit();

      Logger.info(this.getClass(), "save", "Added " + inserts + " events");
    } catch (Exception ex) {
      Logger.error(this.getClass(), "save", ex.getLocalizedMessage());
    }

    return inserts;
  }