Extract the Common Tool

Change-Id: I010c398172a8a7e75d12326b0c4c7c487c6b9abe
Issue-ID: HOLMES-75
Signed-off-by: Guangrong Fu <fu.guangrong@zte.com.cn>

1 files changed, 50 insertions, 0 deletions

diff --git a/holmes-actions/src/main/java/org/onap/holmes/common/utils/CorrelationRuleMapper.java b/holmes-actions/src/main/java/org/onap/holmes/common/utils/CorrelationRuleMapper.java
new file mode 100644
index 0000000..aba5060
--- /dev/null
+++ b/holmes-actions/src/main/java/org/onap/holmes/common/utils/CorrelationRuleMapper.java
@@ -0,0 +1,50 @@
+/*
+ * Copyright 2017 ZTE Corporation.
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.onap.holmes.common.utils;
+
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.Properties;
+import org.onap.holmes.common.api.entity.CorrelationRule;
+import org.skife.jdbi.v2.StatementContext;
+import org.skife.jdbi.v2.tweak.ResultSetMapper;
+
+public class CorrelationRuleMapper implements ResultSetMapper<CorrelationRule> {
+
+    @Override
+    public CorrelationRule map(int i, ResultSet resultSet, StatementContext statementContext) throws SQLException {
+        CorrelationRule correlationRule = new CorrelationRule();
+        correlationRule.setName(resultSet.getString("name"));
+        correlationRule.setRid(resultSet.getString("rid"));
+        correlationRule.setDescription(resultSet.getString("description"));
+        correlationRule.setEnabled(resultSet.getInt("enable"));
+        correlationRule.setTemplateID(resultSet.getInt("templateID"));
+        correlationRule.setEngineID(resultSet.getString("engineID"));
+        correlationRule.setEngineType(resultSet.getString("engineType"));
+        correlationRule.setCreator(resultSet.getString("creator"));
+        correlationRule.setCreateTime(resultSet.getDate("createTime"));
+        correlationRule.setModifier(resultSet.getString("updator"));
+        correlationRule.setUpdateTime(resultSet.getDate("updateTime"));
+        correlationRule.setParams((Properties) resultSet.getObject("params"));
+        correlationRule.setContent(resultSet.getString("content"));
+        correlationRule.setVendor(resultSet.getString("vendor"));
+        correlationRule.setPackageName(resultSet.getString("package"));
+        correlationRule.setClosedControlLoopName(resultSet.getString("ctrlloop"));
+        return correlationRule;
+    }
+
+}