PortaDelegataFetch.java

  1. /*
  2.  * GovWay - A customizable API Gateway
  3.  * https://govway.org
  4.  *
  5.  * Copyright (c) 2005-2025 Link.it srl (https://link.it).
  6.  *
  7.  * This program is free software: you can redistribute it and/or modify
  8.  * it under the terms of the GNU General Public License version 3, as published by
  9.  * the Free Software Foundation.
  10.  *
  11.  * This program is distributed in the hope that it will be useful,
  12.  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  13.  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  14.  * GNU General Public License for more details.
  15.  *
  16.  * You should have received a copy of the GNU General Public License
  17.  * along with this program.  If not, see <http://www.gnu.org/licenses/>.
  18.  *
  19.  */
  20. package org.openspcoop2.core.commons.search.dao.jdbc.fetch;

  21. import org.openspcoop2.generic_project.beans.IModel;
  22. import org.openspcoop2.generic_project.dao.jdbc.utils.AbstractJDBCFetch;
  23. import org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCParameterUtilities;
  24. import org.openspcoop2.generic_project.exception.ServiceException;

  25. import java.sql.ResultSet;
  26. import java.util.Map;

  27. import org.openspcoop2.utils.TipiDatabase;
  28. import org.openspcoop2.utils.jdbc.IKeyGeneratorObject;

  29. import org.openspcoop2.core.commons.search.PortaDelegata;
  30. import org.openspcoop2.core.commons.search.PortaDelegataServizioApplicativo;
  31. import org.openspcoop2.core.constants.CostantiDB;
  32. import org.openspcoop2.core.commons.search.PortaDelegataAzione;


  33. /**    
  34.  * PortaDelegataFetch
  35.  *
  36.  * @author Poli Andrea (poli@link.it)
  37.  * @author $Author$
  38.  * @version $Rev$, $Date$
  39.  */
  40. public class PortaDelegataFetch extends AbstractJDBCFetch {

  41.     @Override
  42.     public Object fetch(TipiDatabase tipoDatabase, IModel<?> model , ResultSet rs) throws ServiceException {
  43.        
  44.         try{
  45.             GenericJDBCParameterUtilities jdbcParameterUtilities =  
  46.                     new GenericJDBCParameterUtilities(tipoDatabase);

  47.             if(model.equals(PortaDelegata.model())){
  48.                 PortaDelegata object = new PortaDelegata();
  49.                 setParameter(object, "setId", Long.class,
  50.                     jdbcParameterUtilities.readParameter(rs, "id", Long.class));
  51.                 setParameter(object, "setNome", PortaDelegata.model().NOME.getFieldType(),
  52.                     jdbcParameterUtilities.readParameter(rs, "nome_porta", PortaDelegata.model().NOME.getFieldType()));
  53.                 setParameter(object, "setStato", PortaDelegata.model().STATO.getFieldType(),
  54.                     jdbcParameterUtilities.readParameter(rs, "stato", PortaDelegata.model().STATO.getFieldType()));
  55.                 setParameter(object, "setTipoSoggettoErogatore", PortaDelegata.model().TIPO_SOGGETTO_EROGATORE.getFieldType(),
  56.                     jdbcParameterUtilities.readParameter(rs, "tipo_soggetto_erogatore", PortaDelegata.model().TIPO_SOGGETTO_EROGATORE.getFieldType()));
  57.                 setParameter(object, "setNomeSoggettoErogatore", PortaDelegata.model().NOME_SOGGETTO_EROGATORE.getFieldType(),
  58.                     jdbcParameterUtilities.readParameter(rs, "nome_soggetto_erogatore", PortaDelegata.model().NOME_SOGGETTO_EROGATORE.getFieldType()));
  59.                 setParameter(object, "setTipoServizio", PortaDelegata.model().TIPO_SERVIZIO.getFieldType(),
  60.                     jdbcParameterUtilities.readParameter(rs, "tipo_servizio", PortaDelegata.model().TIPO_SERVIZIO.getFieldType()));
  61.                 setParameter(object, "setNomeServizio", PortaDelegata.model().NOME_SERVIZIO.getFieldType(),
  62.                     jdbcParameterUtilities.readParameter(rs, "nome_servizio", PortaDelegata.model().NOME_SERVIZIO.getFieldType()));
  63.                 setParameter(object, "setVersioneServizio", PortaDelegata.model().VERSIONE_SERVIZIO.getFieldType(),
  64.                     jdbcParameterUtilities.readParameter(rs, "versione_servizio", PortaDelegata.model().VERSIONE_SERVIZIO.getFieldType()));
  65.                 setParameter(object, "setModeAzione", PortaDelegata.model().MODE_AZIONE.getFieldType(),
  66.                     jdbcParameterUtilities.readParameter(rs, "mode_azione", PortaDelegata.model().MODE_AZIONE.getFieldType()));
  67.                 setParameter(object, "setNomeAzione", PortaDelegata.model().NOME_AZIONE.getFieldType(),
  68.                     jdbcParameterUtilities.readParameter(rs, "nome_azione", PortaDelegata.model().NOME_AZIONE.getFieldType()));
  69.                 setParameter(object, "setNomePortaDeleganteAzione", PortaDelegata.model().NOME_PORTA_DELEGANTE_AZIONE.getFieldType(),
  70.                     jdbcParameterUtilities.readParameter(rs, "nome_porta_delegante_azione", PortaDelegata.model().NOME_PORTA_DELEGANTE_AZIONE.getFieldType()));
  71.                 setParameter(object, "setCanale", PortaDelegata.model().CANALE.getFieldType(),
  72.                     jdbcParameterUtilities.readParameter(rs, "canale", PortaDelegata.model().CANALE.getFieldType()));
  73.                 return object;
  74.             }
  75.             if(model.equals(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO)){
  76.                 PortaDelegataServizioApplicativo object = new PortaDelegataServizioApplicativo();
  77.                 setParameter(object, "setId", Long.class,
  78.                     jdbcParameterUtilities.readParameter(rs, "id", Long.class));
  79.                 return object;
  80.             }
  81.             if(model.equals(PortaDelegata.model().PORTA_DELEGATA_AZIONE)){
  82.                 PortaDelegataAzione object = new PortaDelegataAzione();
  83.                 setParameter(object, "setId", Long.class,
  84.                     jdbcParameterUtilities.readParameter(rs, "id", Long.class));
  85.                 setParameter(object, "setNome", PortaDelegata.model().PORTA_DELEGATA_AZIONE.NOME.getFieldType(),
  86.                     jdbcParameterUtilities.readParameter(rs, "azione", PortaDelegata.model().PORTA_DELEGATA_AZIONE.NOME.getFieldType()));
  87.                 return object;
  88.             }
  89.            
  90.             else{
  91.                 throw new ServiceException("Model ["+model.toString()+"] not supported by fetch: "+this.getClass().getName());
  92.             }  
  93.                    
  94.         }catch(Exception e){
  95.             throw new ServiceException("Model ["+model.toString()+"] occurs error in fetch: "+e.getMessage(),e);
  96.         }
  97.        
  98.     }
  99.    
  100.     @Override
  101.     public Object fetch(TipiDatabase tipoDatabase, IModel<?> model , Map<String,Object> map ) throws ServiceException {
  102.        
  103.         try{

  104.             if(model.equals(PortaDelegata.model())){
  105.                 PortaDelegata object = new PortaDelegata();
  106.                 setParameter(object, "setId", Long.class,
  107.                     this.getObjectFromMap(map,"id"));
  108.                 setParameter(object, "setNome", PortaDelegata.model().NOME.getFieldType(),
  109.                     this.getObjectFromMap(map,"nome"));
  110.                 setParameter(object, "setStato", PortaDelegata.model().STATO.getFieldType(),
  111.                     this.getObjectFromMap(map,"stato"));
  112.                 setParameter(object, "setTipoSoggettoErogatore", PortaDelegata.model().TIPO_SOGGETTO_EROGATORE.getFieldType(),
  113.                     this.getObjectFromMap(map,"tipo_soggetto_erogatore"));
  114.                 setParameter(object, "setNomeSoggettoErogatore", PortaDelegata.model().NOME_SOGGETTO_EROGATORE.getFieldType(),
  115.                     this.getObjectFromMap(map,"nome_soggetto_erogatore"));
  116.                 setParameter(object, "setTipoServizio", PortaDelegata.model().TIPO_SERVIZIO.getFieldType(),
  117.                     this.getObjectFromMap(map,"tipo_servizio"));
  118.                 setParameter(object, "setNomeServizio", PortaDelegata.model().NOME_SERVIZIO.getFieldType(),
  119.                     this.getObjectFromMap(map,"nome_servizio"));
  120.                 setParameter(object, "setVersioneServizio", PortaDelegata.model().VERSIONE_SERVIZIO.getFieldType(),
  121.                     this.getObjectFromMap(map,"versione_servizio"));
  122.                 setParameter(object, "setModeAzione", PortaDelegata.model().MODE_AZIONE.getFieldType(),
  123.                     this.getObjectFromMap(map,"mode_azione"));
  124.                 setParameter(object, "setNomeAzione", PortaDelegata.model().NOME_AZIONE.getFieldType(),
  125.                     this.getObjectFromMap(map,"nome_azione"));
  126.                 setParameter(object, "setNomePortaDeleganteAzione", PortaDelegata.model().NOME_PORTA_DELEGANTE_AZIONE.getFieldType(),
  127.                     this.getObjectFromMap(map,"nome_porta_delegante_azione"));
  128.                 setParameter(object, "setCanale", PortaDelegata.model().CANALE.getFieldType(),
  129.                     this.getObjectFromMap(map,"canale"));
  130.                 return object;
  131.             }
  132.             if(model.equals(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO)){
  133.                 PortaDelegataServizioApplicativo object = new PortaDelegataServizioApplicativo();
  134.                 setParameter(object, "setId", Long.class,
  135.                     this.getObjectFromMap(map,"porta-delegata-servizio-applicativo.id"));
  136.                 return object;
  137.             }
  138.             if(model.equals(PortaDelegata.model().PORTA_DELEGATA_AZIONE)){
  139.                 PortaDelegataAzione object = new PortaDelegataAzione();
  140.                 setParameter(object, "setId", Long.class,
  141.                     this.getObjectFromMap(map,"porta-delegata-azione.id"));
  142.                 setParameter(object, "setNome", PortaDelegata.model().PORTA_DELEGATA_AZIONE.NOME.getFieldType(),
  143.                     this.getObjectFromMap(map,"porta-delegata-azione.nome"));
  144.                 return object;
  145.             }
  146.            
  147.             else{
  148.                 throw new ServiceException("Model ["+model.toString()+"] not supported by fetch: "+this.getClass().getName());
  149.             }  
  150.                    
  151.         }catch(Exception e){
  152.             throw new ServiceException("Model ["+model.toString()+"] occurs error in fetch: "+e.getMessage(),e);
  153.         }
  154.        
  155.     }
  156.    
  157.    
  158.     @Override
  159.     public IKeyGeneratorObject getKeyGeneratorObject( IModel<?> model )  throws ServiceException {
  160.        
  161.         try{

  162.             if(model.equals(PortaDelegata.model())){
  163.                 return new org.openspcoop2.utils.jdbc.CustomKeyGeneratorObject(CostantiDB.PORTE_DELEGATE,"id","seq_"+CostantiDB.PORTE_DELEGATE,CostantiDB.PORTE_DELEGATE+"_init_seq");
  164.             }
  165.             if(model.equals(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO)){
  166.                 return new org.openspcoop2.utils.jdbc.CustomKeyGeneratorObject(CostantiDB.PORTE_DELEGATE_SA,"id","seq_"+CostantiDB.PORTE_DELEGATE_SA,CostantiDB.PORTE_DELEGATE_SA+"_init_seq");
  167.             }
  168.             if(model.equals(PortaDelegata.model().PORTA_DELEGATA_AZIONE)){
  169.                 return new org.openspcoop2.utils.jdbc.CustomKeyGeneratorObject(CostantiDB.PORTE_DELEGATE_AZIONI,"id","seq_"+CostantiDB.PORTE_DELEGATE_AZIONI,CostantiDB.PORTE_DELEGATE_AZIONI+"_init_seq");
  170.             }
  171.            
  172.             else{
  173.                 throw new ServiceException("Model ["+model.toString()+"] not supported by getKeyGeneratorObject: "+this.getClass().getName());
  174.             }

  175.         }catch(Exception e){
  176.             throw new ServiceException("Model ["+model.toString()+"] occurs error in getKeyGeneratorObject: "+e.getMessage(),e);
  177.         }
  178.        
  179.     }

  180. }