ONAP-REST/src/main/java/org/onap/policy/rest/daoimpl/PolicyValidationDaoImpl.java

   1 /*-
   2  * ============LICENSE_START=======================================================
   3  * ONAP Policy Engine
   4  * ================================================================================
   5  * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
   6  * ================================================================================
   7  * Licensed under the Apache License, Version 2.0 (the "License");
   8  * you may not use this file except in compliance with the License.
   9  * You may obtain a copy of the License at
  10  *
  11  *      http://www.apache.org/licenses/LICENSE-2.0
  12  *
  13  * Unless required by applicable law or agreed to in writing, software
  14  * distributed under the License is distributed on an "AS IS" BASIS,
  15  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  16  * See the License for the specific language governing permissions and
  17  * limitations under the License.
  18  * ============LICENSE_END=========================================================
  19  */
  20 package org.onap.policy.rest.daoimpl;
  21
  22 import java.util.ArrayList;
  23 import java.util.List;
  24 import java.util.Map;
  25
  26 import javax.script.SimpleBindings;
  27
  28 import org.hibernate.Criteria;
  29 import org.hibernate.HibernateException;
  30 import org.hibernate.Query;
  31 import org.hibernate.Session;
  32 import org.hibernate.SessionFactory;
  33 import org.hibernate.Transaction;
  34 import org.hibernate.criterion.Conjunction;
  35 import org.hibernate.criterion.Disjunction;
  36 import org.hibernate.criterion.Projections;
  37 import org.hibernate.criterion.Restrictions;
  38 import org.onap.policy.common.logging.flexlogger.FlexLogger;
  39 import org.onap.policy.common.logging.flexlogger.Logger;
  40 import org.onap.policy.rest.dao.CommonClassDao;
  41 import org.onap.policy.rest.jpa.PolicyRoles;
  42 import org.onap.policy.xacml.api.XACMLErrorConstants;
  43 import org.springframework.beans.factory.annotation.Autowired;
  44 import org.springframework.stereotype.Component;
  45 import org.springframework.stereotype.Service;
  46
  47 @Component
  48 public class PolicyValidationDaoImpl implements CommonClassDao{
  49
  50         private static final Logger LOGGER = FlexLogger.getLogger(PolicyValidationDaoImpl.class);
  51         private static SessionFactory sessionfactory;
  52
  53     public static SessionFactory getSessionfactory() {
  54           return sessionfactory;
  55     }
  56
  57     public static void setSessionfactory(SessionFactory sessionfactory) {
  58           PolicyValidationDaoImpl.sessionfactory = sessionfactory;
  59     }
  60
  61     @Autowired
  62     private PolicyValidationDaoImpl(SessionFactory sessionfactory){
  63           PolicyValidationDaoImpl.sessionfactory = sessionfactory;
  64     }
  65
  66     public PolicyValidationDaoImpl(){
  67           //Default Constructor
  68     }
  69
  70         @SuppressWarnings({ "unchecked", "rawtypes" })
  71         @Override
  72         public List<Object> getData(Class className) {
  73                 Session session = sessionfactory.openSession();
  74                 List<Object> data = null;
  75                 try{
  76                         Criteria cr = session.createCriteria(className);
  77                         data = cr.list();
  78                 }catch(Exception e){
  79                         LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
  80                 }finally{
  81                         try{
  82                                 session.close();
  83                         }catch(Exception e){
  84                                 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e);
  85                         }
  86                 }
  87                 return data;
  88         }
  89
  90
  91         @SuppressWarnings({ "rawtypes", "unchecked" })
  92         @Override
  93         public List<Object> getDataById(Class className, String columnName, String key) {
  94                 Session session = sessionfactory.openSession();
  95                 List<Object> data = null;
  96                 try {
  97                         Criteria cr = session.createCriteria(className);
  98                         if(columnName.contains(":") && key.contains(":")){
  99                                 String[] columns = columnName.split(":");
 100                                 String[] keys = key.split(":");
 101                                 for(int i=0; i < columns.length; i++){
 102                                         cr.add(Restrictions.eq(columns[i], keys[i]));
 103                                 }
 104                         }else{
 105                                 cr.add(Restrictions.eq(columnName, key));
 106                         }
 107                         data = cr.list();
 108                 } catch (Exception e) {
 109                         LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
 110                 }finally{
 111                         try{
 112                                 session.close();
 113                         }catch(Exception e1){
 114                                 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
 115                         }
 116                 }
 117                 return data;
 118         }
 119
 120         @Override
 121         public void save(Object entity) {
 122                 Session session = sessionfactory.openSession();
 123                 Transaction tx = session.beginTransaction();
 124                 try {
 125                         session.persist(entity);
 126                         tx.commit();
 127                 }catch(Exception e){
 128                         LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Saving  data to Table"+e);
 129                 }finally{
 130                         try{
 131                                 session.close();
 132                         }catch(Exception e1){
 133                                 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
 134                         }
 135                 }
 136
 137         }
 138
 139         @Override
 140         public void delete(Object entity) {
 141                 Session session = sessionfactory.openSession();
 142                 Transaction tx = session.beginTransaction();
 143                 try {
 144                         session.delete(entity);
 145                         tx.commit();
 146                 }catch(Exception e){
 147                         LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Deleting data from Table"+e);
 148                 }finally{
 149                         try{
 150                                 session.close();
 151                         }catch(Exception e1){
 152                                 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
 153                         }
 154                 }
 155
 156         }
 157
 158
 159         @Override
 160         public void update(Object entity) {
 161                 Session session = sessionfactory.openSession();
 162                 Transaction tx = session.beginTransaction();
 163                 try {
 164                         session.update(entity);
 165                         tx.commit();
 166                 }catch(Exception e){
 167                         LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating data to Table"+e);
 168                 }finally{
 169                         try{
 170                                 session.close();
 171                         }catch(Exception e1){
 172                                 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
 173                         }
 174                 }
 175
 176         }
 177
 178
 179         @SuppressWarnings({ "unchecked", "rawtypes" })
 180         @Override
 181         public List<Object> checkDuplicateEntry(String value, String columnName, Class className) {
 182                 Session session = sessionfactory.openSession();
 183                 Transaction tx = session.beginTransaction();
 184                 List<Object> data = null;
 185                 String[] columnNames = null;
 186                 if(columnName != null && columnName.contains(":")){
 187                         columnNames = columnName.split(":");
 188                 }
 189                 String[] values = null;
 190                 if(value != null && value.contains(":")){
 191                         values = value.split(":");
 192                 }
 193                 try {
 194                         Criteria cr = session.createCriteria(className);
 195                         if(columnNames != null && values != null && columnNames.length == values.length){
 196                                 for (int i = 0; i < columnNames.length; i++){
 197                                         cr.add(Restrictions.eq(columnNames[i],values[i]));
 198                                 }
 199                         }else{
 200                                 cr.add(Restrictions.eq(columnName,value));
 201                         }
 202                         data = cr.list();
 203                         tx.commit();
 204                 } catch (Exception e) {
 205                         LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying for Duplicate Entries for Table"+e + className);
 206                 }finally{
 207                         try{
 208                                 session.close();
 209                         }catch(Exception e1){
 210                                 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
 211                         }
 212                 }
 213                 return data;
 214         }
 215
 216
 217         @SuppressWarnings("unchecked")
 218         @Override
 219         public List<PolicyRoles> getUserRoles() {
 220                 Session session = sessionfactory.openSession();
 221                 Transaction tx = session.beginTransaction();
 222                 List<PolicyRoles> rolesData = null;
 223                 try {
 224                         Criteria cr = session.createCriteria(PolicyRoles.class);
 225                         Disjunction disjunction = Restrictions.disjunction();
 226                         Conjunction conjunction1  = Restrictions.conjunction();
 227                         conjunction1.add(Restrictions.eq("role", "admin"));
 228                         Conjunction conjunction2  = Restrictions.conjunction();
 229                         conjunction2.add(Restrictions.eq("role", "editor"));
 230                         Conjunction conjunction3  = Restrictions.conjunction();
 231                         conjunction3.add(Restrictions.eq("role", "guest"));
 232                         disjunction.add(conjunction1);
 233                         disjunction.add(conjunction2);
 234                         disjunction.add(conjunction3);
 235                         rolesData = cr.add(disjunction).list();
 236                         tx.commit();
 237                 } catch (Exception e) {
 238                         LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying PolicyRoles Table"+e);
 239                 }finally{
 240                         try{
 241                                 session.close();
 242                         }catch(Exception e1){
 243                                 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
 244                         }
 245                 }
 246                 return rolesData;
 247         }
 248
 249
 250         @Override
 251         public List<Object> checkExistingGroupListforUpdate(String arg0, String arg1) {
 252                 return null;
 253         }
 254
 255
 256         @Override
 257         public void deleteAll() {}
 258
 259
 260         @SuppressWarnings("unchecked")
 261         @Override
 262         public List<Object> getDataByQuery(String query, SimpleBindings params) {
 263                 Session session = sessionfactory.openSession();
 264                 Transaction tx = session.beginTransaction();
 265                 List<Object> data = null;
 266                 try {
 267                         Query hbquery = session.createQuery(query);
 268                         for (Map.Entry<String, Object> paramPair : params.entrySet()) {
 269                                 if(paramPair.getValue() instanceof java.lang.Long){
 270                                         hbquery.setLong(paramPair.getKey(), (long) paramPair.getValue());
 271                                 }
 272                                 else{
 273                                         hbquery.setParameter(paramPair.getKey(), paramPair.getValue());
 274                                 }
 275                         }
 276                         data = hbquery.list();
 277                         tx.commit();
 278                 } catch (Exception e) {
 279                         LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Database Table"+e);
 280                         throw e;
 281                 }finally{
 282                         try{
 283                                 session.close();
 284                         }catch(HibernateException e1){
 285                                 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
 286                         }
 287                 }
 288                 return data;
 289         }
 290
 291
 292         @SuppressWarnings("rawtypes")
 293         @Override
 294         public Object getEntityItem(Class className, String columnName, String key) {
 295                 Session session = sessionfactory.openSession();
 296                 Transaction tx = session.beginTransaction();
 297                 Object data = null;
 298                 try {
 299                         Criteria cr = session.createCriteria(className);
 300                         if(columnName.contains(":") && key.contains(":")){
 301                                 String[] columns = columnName.split(":");
 302                                 String[] keys = key.split(":");
 303                                 for(int i=0; i < columns.length; i++){
 304                                         cr.add(Restrictions.eq(columns[i], keys[i]));
 305                                 }
 306                         }else{
 307                                 cr.add(Restrictions.eq(columnName, key));
 308                         }
 309                         data = cr.list().get(0);
 310                         tx.commit();
 311                 } catch (Exception e) {
 312                         LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Database Table"+e);
 313                 }finally{
 314                         try{
 315                                 session.close();
 316                         }catch(Exception e1){
 317                                 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
 318                         }
 319                 }
 320                 return data;
 321         }
 322
 323
 324         @Override
 325         public void updateClAlarms(String arg0, String arg1) {}
 326
 327
 328         @Override
 329         public void updateClYaml(String arg0, String arg1) {}
 330
 331
 332         @Override
 333         public void updateQuery(String query) {
 334                 Session session = sessionfactory.openSession();
 335                 Transaction tx = session.beginTransaction();
 336                 try {
 337                         Query hbquery = session.createQuery(query);
 338                         hbquery.executeUpdate();
 339                         tx.commit();
 340                 } catch (Exception e) {
 341                         LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating Database Table"+e);
 342                 }finally{
 343                         try{
 344                                 session.close();
 345                         }catch(Exception e1){
 346                                 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
 347                         }
 348                 }
 349
 350         }
 351
 352
 353         @SuppressWarnings({ "rawtypes", "unchecked" })
 354         @Override
 355         public List<String> getDataByColumn(Class className, String columnName) {
 356                 Session session = sessionfactory.openSession();
 357                 List<String> data = null;
 358                 try{
 359                         Criteria cr = session.createCriteria(className);
 360                         cr.setProjection(Projections.property(columnName));
 361                         data = cr.list();
 362                 }catch(Exception e){
 363                         LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
 364                 }finally{
 365                         try{
 366                                 session.close();
 367                         }catch(Exception e){
 368                                 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e);
 369                         }
 370                 }
 371                 return data;
 372         }
 373
 374
 375         @SuppressWarnings({ "rawtypes", "unchecked" })
 376         @Override
 377         public List<Object> getMultipleDataOnAddingConjunction(Class className, String columnName, List<String> data) {
 378                 Session session = sessionfactory.openSession();
 379                 Transaction tx = session.beginTransaction();
 380                 List<Object> entityData = null;
 381                 try {
 382                         Criteria cr = session.createCriteria(className);
 383                         Disjunction disjunction = Restrictions.disjunction();
 384                         List<Conjunction> conjunctionList = new ArrayList<>();
 385                         String[] columNames = columnName.split(":");
 386                         for(int i =0; i < data.size(); i++){
 387                                 String[] entiySplit = data.get(i).split(":");
 388                                 Conjunction conjunction = Restrictions.conjunction();
 389                                 conjunction.add(Restrictions.eq(columNames[0], entiySplit[0]));
 390                                 conjunction.add(Restrictions.eq(columNames[1], entiySplit[1]));
 391                                 conjunctionList.add(conjunction);
 392                         }
 393                         for(int j =0 ; j < conjunctionList.size(); j++){
 394                                 disjunction.add(conjunctionList.get(j));
 395                         }
 396                         entityData = cr.add(disjunction).list();
 397                         tx.commit();
 398                 } catch (Exception e) {
 399                         LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table" +className +e);
 400                 }finally{
 401                         try{
 402                                 session.close();
 403                         }catch(Exception e1){
 404                                 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
 405                         }
 406                 }
 407                 return entityData;
 408         }
 409
 410 }