Java Code Examples for org.skife.jdbi.v2.Handle#commit()

The following examples show how to use org.skife.jdbi.v2.Handle#commit() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: PostgresStorage.java    From cassandra-reaper with Apache License 2.0 5 votes vote down vote up
@Override
public Optional<RepairRun> deleteRepairRun(UUID id) {
  RepairRun result = null;
  Handle handle = null;
  try {
    handle = jdbi.open();
    handle.begin();
    IStoragePostgreSql pg = getPostgresStorage(handle);
    RepairRun runToDelete = pg.getRepairRun(UuidUtil.toSequenceId(id));
    if (runToDelete != null) {
      int segmentsRunning
          = pg.getSegmentAmountForRepairRunWithState(UuidUtil.toSequenceId(id), RepairSegment.State.RUNNING);
      if (segmentsRunning == 0) {
        pg.deleteRepairSegmentsForRun(UuidUtil.toSequenceId(runToDelete.getId()));
        pg.deleteRepairRun(UuidUtil.toSequenceId(id));
        result = runToDelete.with()
            .runState(RepairRun.RunState.DELETED)
            .endTime(DateTime.now())
            .build(id);
      } else {
        LOG.warn("not deleting RepairRun \"{}\" as it has segments running: {}", id, segmentsRunning);
      }
    }
    handle.commit();
  } catch (DBIException ex) {
    LOG.warn("DELETE failed", ex);
    if (handle != null) {
      handle.rollback();
    }
  } finally {
    if (handle != null) {
      handle.close();
    }
  }
  return Optional.ofNullable(result);
}
 
Example 2
Source File: AlarmDAOImpl.java    From monasca-thresh with Apache License 2.0 5 votes vote down vote up
@Override
public void addAlarmedMetric(String alarmId, MetricDefinitionAndTenantId metricDefinition) {
  Handle h = db.open();
  try {
    h.begin();
    createAlarmedMetric(h, metricDefinition, alarmId);
    h.commit();
  } catch (RuntimeException e) {
    h.rollback();
    throw e;
  } finally {
    h.close();
  }
}
 
Example 3
Source File: AlarmDAOImpl.java    From monasca-thresh with Apache License 2.0 5 votes vote down vote up
@Override
public void createAlarm(Alarm alarm) {
  Handle h = db.open();
  try {
    String timestamp = formatDateFromMillis(System.currentTimeMillis());
    h.begin();
    h.insert(
        "insert into alarm (id, alarm_definition_id, state, state_updated_at, created_at, updated_at) values (?, ?, ?, ?, ?, ?)",
        alarm.getId(), alarm.getAlarmDefinitionId(), alarm.getState().toString(), timestamp,
            timestamp, timestamp);

    for (final SubAlarm subAlarm : alarm.getSubAlarms()) {
      h.insert(
          "insert into sub_alarm (id, alarm_id, sub_expression_id, expression, state, created_at, updated_at) values (?, ?, ?, ?, ?, ?, ?)",
          subAlarm.getId(), subAlarm.getAlarmId(), subAlarm.getAlarmSubExpressionId(), subAlarm
              .getExpression().getExpression(), subAlarm.getState().toString(), timestamp, timestamp);
    }
    for (final MetricDefinitionAndTenantId md : alarm.getAlarmedMetrics()) {
      createAlarmedMetric(h, md, alarm.getId());
    }
    h.commit();
  } catch (RuntimeException e) {
    h.rollback();
    throw e;
  } finally {
    h.close();
  }
}
 
Example 4
Source File: AlarmDefinitionDAOImplTest.java    From monasca-thresh with Apache License 2.0 4 votes vote down vote up
@Test(enabled=false)
public static void insertAlarmDefinition(Handle handle, AlarmDefinition alarmDefinition) {
  try {
    handle.begin();
    handle
        .insert(
            "insert into alarm_definition (id, tenant_id, name, description, severity, expression, match_by, actions_enabled, created_at, updated_at, deleted_at) values (?, ?, ?, ?, ?, ?, ?, ?, NOW(), NOW(), NULL)",
            alarmDefinition.getId(),
            alarmDefinition.getTenantId(),
            alarmDefinition.getName(),
            alarmDefinition.getDescription(),
            "LOW",
            alarmDefinition.getAlarmExpression().getExpression(),
            alarmDefinition.getMatchBy().isEmpty() ? null : COMMA_JOINER.join(alarmDefinition
                .getMatchBy()), alarmDefinition.isActionsEnabled());

    for (final SubExpression subExpression : alarmDefinition.getSubExpressions()) {
      final AlarmSubExpression alarmSubExpr = subExpression.getAlarmSubExpression();
      handle
          .insert(
              "insert into sub_alarm_definition (id, alarm_definition_id, function, metric_name, operator, "
                  + "threshold, period, periods, is_deterministic, created_at, updated_at) "
                  + "values (?, ?, ?, ?, ?, ?, ?, ?, ?, NOW(), NOW())",
              subExpression.getId(), alarmDefinition.getId(), alarmSubExpr.getFunction().name(),
              alarmSubExpr.getMetricDefinition().name, alarmSubExpr.getOperator().name(),
              alarmSubExpr.getThreshold(), alarmSubExpr.getPeriod(), alarmSubExpr.getPeriods(),
              alarmSubExpr.isDeterministic()
          );
      for (final Map.Entry<String, String> entry : alarmSubExpr.getMetricDefinition().dimensions.entrySet()) {
        handle
            .insert(
                "insert into sub_alarm_definition_dimension (sub_alarm_definition_id, dimension_name, value) values (?, ?, ?)",
                subExpression.getId(), entry.getKey(), entry.getValue());
      }
    }
    handle.commit();
  } catch (RuntimeException e) {
    handle.rollback();
    throw e;
  }
}