// the event didn't happen, so it couldn't result in usage
if (!EventVO.LEVEL_INFO.equals(event.getLevel())) {
return;
}
String eventType = event.getType();
UsageEventVO usageEvent = null;
if (isVMEvent(eventType)) {
usageEvent = convertVMEvent(event);
} else if (isIPEvent(eventType)) {
usageEvent = convertIPEvent(event, conn);
} else if (isVolumeEvent(eventType)) {
usageEvent = convertVolumeEvent(event, conn);
} else if (isTemplateEvent(eventType)) {
usageEvent = convertTemplateEvent(event);
} else if (isISOEvent(eventType)) {
usageEvent = convertISOEvent(event);
} else if (isSnapshotEvent(eventType)) {
usageEvent = convertSnapshotEvent(event, conn);
} /*
* else if (isSecurityGrpEvent(eventType)) { usageEvent = convertSecurityGrpEvent(event); } else if
* (isLoadBalancerEvent(eventType)) { usageEvent = convertLoadBalancerEvent(event); }
*/
if (usageEvent != null) {
usageEvent.setCreatedDate(event.getCreateDate());
if (usageEvent.getZoneId() == -1) {
usageEvent.setZoneId(0);
}
// update firewall_rules table
PreparedStatement pstmt = null;
pstmt = conn
.prepareStatement("INSERT INTO usage_event (usage_event.type, usage_event.created, usage_event.account_id, usage_event.zone_id, usage_event.resource_id, usage_event.resource_name,"
+ " usage_event.offering_id, usage_event.template_id, usage_event.size) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");
pstmt.setString(1, usageEvent.getType());
pstmt.setString(2, DateUtil.getDateDisplayString(TimeZone.getTimeZone("GMT"), usageEvent.getCreateDate()));
pstmt.setLong(3, usageEvent.getAccountId());
pstmt.setLong(4, usageEvent.getZoneId());
pstmt.setLong(5, usageEvent.getResourceId());
pstmt.setString(6, usageEvent.getResourceName());
if (usageEvent.getOfferingId() != null) {
pstmt.setLong(7, usageEvent.getOfferingId());
} else {
pstmt.setNull(7, Types.BIGINT);
}
if (usageEvent.getTemplateId() != null) {
pstmt.setLong(8, usageEvent.getTemplateId());
} else {
pstmt.setNull(8, Types.BIGINT);
}
if (usageEvent.getSize() != null) {
pstmt.setLong(9, usageEvent.getSize());
} else {
pstmt.setNull(9, Types.BIGINT);
}
// pstmt.setString(10, usageEvent.getResourceType());
pstmt.executeUpdate();