2 * ============LICENSE_START=======================================================
\r
4 * ================================================================================
\r
5 * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
\r
6 * ================================================================================
\r
7 * Licensed under the Apache License, Version 2.0 (the "License");
\r
8 * you may not use this file except in compliance with the License.
\r
9 * You may obtain a copy of the License at
\r
11 * http://www.apache.org/licenses/LICENSE-2.0
\r
13 * Unless required by applicable law or agreed to in writing, software
\r
14 * distributed under the License is distributed on an "AS IS" BASIS,
\r
15 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
\r
16 * See the License for the specific language governing permissions and
\r
17 * limitations under the License.
\r
18 * ============LICENSE_END=========================================================
\r
21 package org.openecomp.camunda.bpmn.plugin.urnmap.resources;
\r
23 import java.beans.Statement;
\r
24 import java.sql.DriverManager;
\r
25 import java.sql.ResultSet;
\r
26 import java.sql.SQLException;
\r
28 import java.sql.Connection;
\r
29 import java.sql.PreparedStatement;
\r
30 import java.sql.ResultSet;
\r
31 import java.util.ArrayList;
\r
32 import java.util.List;
\r
33 import java.util.StringTokenizer;
\r
35 import javax.naming.Context;
\r
36 import javax.naming.InitialContext;
\r
37 import javax.sql.DataSource;
\r
38 import javax.ws.rs.GET;
\r
39 import javax.ws.rs.POST;
\r
40 import javax.ws.rs.PUT;
\r
42 import org.camunda.bpm.cockpit.db.QueryParameters;
\r
43 import org.camunda.bpm.cockpit.plugin.resource.AbstractCockpitPluginResource;
\r
46 //import org.camunda.bpm.cockpit.plugin.resource.AbstractPluginResource;
\r
47 import org.openecomp.camunda.bpmn.plugin.urnmap.db.URNData;
\r
48 import org.openecomp.mso.logger.MsoLogger;
\r
51 //public class ProcessInstanceResource extends AbstractPluginResource {
\r
52 public class URNResource extends AbstractCockpitPluginResource{
\r
53 public URNResource(String engineName) {
\r
57 private Connection conn;
\r
58 private static MsoLogger msoLogger = MsoLogger.getMsoLogger(MsoLogger.Catalog.BPEL);
\r
60 public List<URNData> getUrnDataMap()
\r
62 List<URNData> list = new ArrayList();
\r
66 conn = getDBConnection();
\r
67 PreparedStatement psData = conn
\r
68 .prepareStatement("select * from MSO_URN_MAPPING order by NAME_");
\r
70 ResultSet r = psData.executeQuery();
\r
74 URNData d = new URNData();
\r
75 d.setURNName(r.getString("NAME_"));
\r
76 d.setURNValue(r.getString("VALUE_"));
\r
77 d.setVer_( r.getString("REV_"));
\r
85 } catch (Exception e)
\r
88 e.printStackTrace();
\r
91 for(URNData d: list)
\r
93 msoLogger.debug( d.getURNName() + " " + d.getURNValue());
\r
94 //msoLogger.debug("Started Executing " + getTaskName());
\r
95 msoLogger.debug("Started Executing " + d.getURNName() + " " + d.getURNValue());
\r
101 public List<URNData> getUrnDataMapOLD()
\r
104 List<URNData> list = getQueryService()
\r
105 .executeQuery("cockpit.urnMap.retrieveUrnKeyValuePair", new QueryParameters<URNData>());
\r
107 msoLogger.debug("urnmap-plugin project - Results Retrieved: ");
\r
108 msoLogger.debug("URNName: " + " " + "URNValue: " );
\r
110 for(URNData d: list)
\r
112 //msoLogger.debug( d.getURNName() + " " + d.getURNValue());
\r
113 msoLogger.debug( d.getURNName() + " " + d.getURNValue());
\r
119 public Connection getDBConnection()
\r
125 Context ctx = new InitialContext();
\r
126 DataSource ds = (DataSource)ctx.lookup("java:jboss/datasources/ProcessEngine");//jboss
\r
127 conn = ds.getConnection();
\r
131 } catch (Exception e)
\r
134 e.printStackTrace();
\r
141 public void insertNewRow(String temp)
\r
143 msoLogger.debug("AddNewRow: XXXXXXXXXXXXXXXXX ---> " + temp);
\r
144 msoLogger.debug("AddNewRow: EngineName ---> " + engineName);
\r
146 StringTokenizer st = new StringTokenizer(temp, "|");
\r
148 String value_ = "";
\r
150 while(st.hasMoreTokens()) {
\r
151 key_ = st.nextToken();
\r
152 value_ = st.nextToken();
\r
153 msoLogger.debug(key_ + "\t" + value_);
\r
156 msoLogger.debug("AddNewRow: XXXXXXXXXXXXXXXXX ---> key: " + key_ + " , Value: " + value_);
\r
157 final URNData nRow = new URNData();
\r
158 nRow.setVer_("1");
\r
159 final String myKey = key_;
\r
160 final String myValue = value_;
\r
162 msoLogger.debug("----------- START ----------------------");
\r
165 conn = getDBConnection();
\r
166 PreparedStatement psData = conn
\r
167 .prepareStatement("Insert into MSO_URN_MAPPING values ('" + key_ + "', '" + value_ + "', '1')");
\r
169 psData.executeUpdate();
\r
175 } catch (Exception e)
\r
178 e.printStackTrace();
\r
180 // getQueryService().executeQuery("cockpit.urnMap.insertNewRow", nRow, URNData.class);
\r
184 public void getPersistData(URNData d) {
\r
186 //getQueryService().executeQuery("cockpit.urnMap.persistURNData", d, URNData.class);
\r
190 conn = getDBConnection();
\r
191 PreparedStatement psData = conn
\r
192 .prepareStatement("UPDATE MSO_URN_MAPPING set VALUE_ ='"+ d.getURNValue() + "' WHERE NAME_='" + d.getURNName() + "'");
\r
194 psData.executeUpdate();
\r
198 } catch (Exception e)
\r
201 e.printStackTrace();
\r