Java Row.getTimestamp方法代碼示例

import com.datastax.driver.core.Row; //導入方法依賴的package包/類
static EntityEvent convertToEntityEvent(Row entityEventData) {
        EventKey eventKey = new EventKey(entityEventData.getString(CassandraEventRecorder.ENTITY_ID), entityEventData.getInt(CassandraEventRecorder.VERSION));
        String opId = entityEventData.getString(CassandraEventRecorder.OP_ID);
        String eventData = entityEventData.getString(CassandraEventRecorder.EVENT_DATA);
//            ObjectNode jsonNode = (ObjectNode) objectMapper.readTree(eventData);
/*            for (String indexedField : indexedFields) {
                if (entityEventData.getColumnDefinitions().contains(indexedField))
                    jsonNode.put(indexedField, entityEventData.getString(indexedField));
            }*/
        return new EntityEvent(eventKey, opId,
                entityEventData.getTimestamp(CassandraEventRecorder.OP_DATE),
                entityEventData.getString(CassandraEventRecorder.EVENT_TYPE),
                EventState.valueOf(entityEventData.getString(CassandraEventRecorder.STATUS)),
                entityEventData.getString(CassandraEventRecorder.AUDIT_INFO),
                eventData);
    }
 

import com.datastax.driver.core.Row; //導入方法依賴的package包/類
private Object getValue(Row musicRow, String colname) {
	ColumnDefinitions cdef = musicRow.getColumnDefinitions();
	String type = cdef.getType(colname).getName().toString().toUpperCase();
	switch (type) {
	case "BIGINT":
		return musicRow.getLong(colname);
	case "BOOLEAN":
		return musicRow.getBool(colname);
	case "BLOB":
		return musicRow.getBytes(colname);
	case "DOUBLE":
		return musicRow.getDouble(colname);
	case "INT":
		return musicRow.getInt(colname);
	case "TIMESTAMP":
		return musicRow.getTimestamp(colname);
	default:
		logger.error("UNEXPECTED COLUMN TYPE: columname="+colname+", columntype="+type);
		// fall thru
	case "VARCHAR":
		return musicRow.getString(colname);
	}
}
 

import com.datastax.driver.core.Row; //導入方法依賴的package包/類
private static RepairSegment createRepairSegmentFromRow(Row segmentRow) {

    RepairSegment.Builder builder = RepairSegment.builder(
          new RingRange(
              new BigInteger(segmentRow.getVarint("start_token") + ""),
              new BigInteger(segmentRow.getVarint("end_token") + "")),
          segmentRow.getUUID("repair_unit_id"))
        .withRunId(segmentRow.getUUID("id"))
        .state(State.values()[segmentRow.getInt("segment_state")])
        .failCount(segmentRow.getInt("fail_count"));

    if (null != segmentRow.getString("coordinator_host")) {
      builder = builder.coordinatorHost(segmentRow.getString("coordinator_host"));
    }
    if (null != segmentRow.getTimestamp("segment_start_time")) {
      builder = builder.startTime(new DateTime(segmentRow.getTimestamp("segment_start_time")));
    }
    if (null != segmentRow.getTimestamp("segment_end_time")) {
      builder = builder.endTime(new DateTime(segmentRow.getTimestamp("segment_end_time")));
    }
    return builder.build(segmentRow.getUUID("segment_id"));
  }
 

import com.datastax.driver.core.Row; //導入方法依賴的package包/類
private static Instant getInstant(Row row, String column) {
    if (row.getColumnDefinitions().contains(column)) {
        Date date = row.getTimestamp(column);
        return date != null ? date.toInstant() : null;
    }
    return null;
}
 

import com.datastax.driver.core.Row; //導入方法依賴的package包/類
/**
 * fix nulls in the repair_run table
 */
public static void migrate(Session session) {
  LOG.warn("Removing NULLs in the repair_run table. This may take some minutes…");

  Statement getRepairSegmentsPrepStmt =
      new SimpleStatement(
              "SELECT id,segment_id,segment_state,segment_start_time,segment_end_time FROM repair_run")
          .setConsistencyLevel(ConsistencyLevel.QUORUM);

  PreparedStatement updateRepairSegmentPrepStmt = session
      .prepare("INSERT INTO repair_run (id,segment_id,segment_start_time,segment_end_time)  VALUES(?, ?, ?, ?)")
      .setConsistencyLevel(ConsistencyLevel.EACH_QUORUM);

  ResultSet resultSet = session.execute(getRepairSegmentsPrepStmt);
  int rowsRead = 0;
  for (Row row : resultSet) {
    resultSet.fetchMoreResults();
    boolean update = false;
    RepairSegment.State state = RepairSegment.State.values()[row.getInt("segment_state")];
    Date startTime = row.getTimestamp("segment_start_time");
    Date endTime = row.getTimestamp("segment_end_time");

    // startTime can only be unset if segment is NOT_STARTED
    if (RepairSegment.State.NOT_STARTED != state && null == startTime) {
      update = true;
      startTime = new Date(0);
    }

    // endTime can only be set if segment is DONE
    if (RepairSegment.State.DONE != state && null != endTime) {
      update = true;
      endTime = null;
    }

    // endTime must be set if segment is DONE
    if (RepairSegment.State.DONE == state && null == endTime) {
      update = true;
      endTime = startTime;
    }

    if (update) {
      session.executeAsync(
          updateRepairSegmentPrepStmt.bind(row.getUUID("id"), row.getUUID("segment_id"), startTime, endTime));
    }
    ++rowsRead;
    if (0 == rowsRead % 1000) {
      LOG.warn("rows read: " + rowsRead);
    }
  }

  LOG.warn("Removal of NULLs in the repair_run table completed.");
}