PluginFetch.java

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

import org.openspcoop2.core.constants.CostantiDB;
import org.openspcoop2.generic_project.beans.IModel;
import org.openspcoop2.generic_project.dao.jdbc.utils.AbstractJDBCFetch;
import org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCParameterUtilities;
import org.openspcoop2.generic_project.exception.ServiceException;

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

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

import org.openspcoop2.core.plugins.PluginServizioCompatibilita;
import org.openspcoop2.core.plugins.PluginProprietaCompatibilita;
import org.openspcoop2.core.plugins.PluginServizioAzioneCompatibilita;
import org.openspcoop2.core.plugins.Plugin;


/**     
 * PluginFetch
 *
 * @author Poli Andrea (poli@link.it)
 * @author $Author$
 * @version $Rev$, $Date$
 */
public class PluginFetch extends AbstractJDBCFetch {

	@Override
	public Object fetch(TipiDatabase tipoDatabase, IModel<?> model , ResultSet rs) throws ServiceException {
		
		try{
			GenericJDBCParameterUtilities jdbcParameterUtilities =  
					new GenericJDBCParameterUtilities(tipoDatabase);

			if(model.equals(Plugin.model())){
				Plugin object = new Plugin();
				setParameter(object, "setId", Long.class,
					jdbcParameterUtilities.readParameter(rs, "id", Long.class));
				setParameter(object, "setTipoPlugin", Plugin.model().TIPO_PLUGIN.getFieldType(),
					jdbcParameterUtilities.readParameter(rs, "tipo_plugin", Plugin.model().TIPO_PLUGIN.getFieldType()));
				setParameter(object, "setClassName", Plugin.model().CLASS_NAME.getFieldType(),
					jdbcParameterUtilities.readParameter(rs, "class_name", Plugin.model().CLASS_NAME.getFieldType()));
				setParameter(object, "setTipo", Plugin.model().TIPO.getFieldType(),
					jdbcParameterUtilities.readParameter(rs, "tipo", Plugin.model().TIPO.getFieldType()));
				setParameter(object, "setDescrizione", Plugin.model().DESCRIZIONE.getFieldType(),
					jdbcParameterUtilities.readParameter(rs, "descrizione", Plugin.model().DESCRIZIONE.getFieldType()));
				setParameter(object, "setLabel", Plugin.model().LABEL.getFieldType(),
					jdbcParameterUtilities.readParameter(rs, "label", Plugin.model().LABEL.getFieldType()));
				setParameter(object, "setStato", Plugin.model().STATO.getFieldType(),
					jdbcParameterUtilities.readParameter(rs, "stato", Plugin.model().STATO.getFieldType()));
				return object;
			}
			if(model.equals(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA)){
				PluginServizioCompatibilita object = new PluginServizioCompatibilita();
				setParameter(object, "setId", Long.class,
					jdbcParameterUtilities.readParameter(rs, "id", Long.class));
				setParameter(object, "setUriAccordo", Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.URI_ACCORDO.getFieldType(),
					jdbcParameterUtilities.readParameter(rs, "uri_accordo", Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.URI_ACCORDO.getFieldType()));
				setParameter(object, "setServizio", Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.SERVIZIO.getFieldType(),
					jdbcParameterUtilities.readParameter(rs, "servizio", Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.SERVIZIO.getFieldType()));
				return object;
			}
			if(model.equals(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA)){
				PluginServizioAzioneCompatibilita object = new PluginServizioAzioneCompatibilita();
				setParameter(object, "setId", Long.class,
					jdbcParameterUtilities.readParameter(rs, "id", Long.class));
				setParameter(object, "setAzione", Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA.AZIONE.getFieldType(),
					jdbcParameterUtilities.readParameter(rs, "azione", Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA.AZIONE.getFieldType()));
				return object;
			}
			if(model.equals(Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA)){
				PluginProprietaCompatibilita object = new PluginProprietaCompatibilita();
				setParameter(object, "setId", Long.class,
					jdbcParameterUtilities.readParameter(rs, "id", Long.class));
				setParameter(object, "setNome", Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA.NOME.getFieldType(),
					jdbcParameterUtilities.readParameter(rs, "nome", Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA.NOME.getFieldType()));
				setParameter(object, "setValore", Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA.VALORE.getFieldType(),
					jdbcParameterUtilities.readParameter(rs, "valore", Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA.VALORE.getFieldType()));
				return object;
			}
			
			else{
				throw new ServiceException("Model ["+model.toString()+"] not supported by fetch: "+this.getClass().getName());
			}	
					
		}catch(Exception e){
			throw new ServiceException("Model ["+model.toString()+"] occurs error in fetch: "+e.getMessage(),e);
		}
		
	}
	
	@Override
	public Object fetch(TipiDatabase tipoDatabase, IModel<?> model , Map<String,Object> map ) throws ServiceException {
		
		try{

			if(model.equals(Plugin.model())){
				Plugin object = new Plugin();
				setParameter(object, "setId", Long.class,
					this.getObjectFromMap(map,"id"));
				setParameter(object, "setTipoPlugin", Plugin.model().TIPO_PLUGIN.getFieldType(),
					this.getObjectFromMap(map,"tipo-plugin"));
				setParameter(object, "setClassName", Plugin.model().CLASS_NAME.getFieldType(),
					this.getObjectFromMap(map,"class-name"));
				setParameter(object, "setTipo", Plugin.model().TIPO.getFieldType(),
					this.getObjectFromMap(map,"tipo"));
				setParameter(object, "setDescrizione", Plugin.model().DESCRIZIONE.getFieldType(),
					this.getObjectFromMap(map,"descrizione"));
				setParameter(object, "setLabel", Plugin.model().LABEL.getFieldType(),
					this.getObjectFromMap(map,"label"));
				setParameter(object, "setStato", Plugin.model().STATO.getFieldType(),
					this.getObjectFromMap(map,"stato"));
				return object;
			}
			if(model.equals(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA)){
				PluginServizioCompatibilita object = new PluginServizioCompatibilita();
				setParameter(object, "setId", Long.class,
					this.getObjectFromMap(map,"plugin-servizio-compatibilita.id"));
				setParameter(object, "setUriAccordo", Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.URI_ACCORDO.getFieldType(),
					this.getObjectFromMap(map,"plugin-servizio-compatibilita.uri-accordo"));
				setParameter(object, "setServizio", Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.SERVIZIO.getFieldType(),
					this.getObjectFromMap(map,"plugin-servizio-compatibilita.servizio"));
				return object;
			}
			if(model.equals(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA)){
				PluginServizioAzioneCompatibilita object = new PluginServizioAzioneCompatibilita();
				setParameter(object, "setId", Long.class,
					this.getObjectFromMap(map,"plugin-servizio-compatibilita.plugin-servizio-azione-compatibilita.id"));
				setParameter(object, "setAzione", Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA.AZIONE.getFieldType(),
					this.getObjectFromMap(map,"plugin-servizio-compatibilita.plugin-servizio-azione-compatibilita.azione"));
				return object;
			}
			if(model.equals(Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA)){
				PluginProprietaCompatibilita object = new PluginProprietaCompatibilita();
				setParameter(object, "setId", Long.class,
					this.getObjectFromMap(map,"plugin-proprieta-compatibilita.id"));
				setParameter(object, "setNome", Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA.NOME.getFieldType(),
					this.getObjectFromMap(map,"plugin-proprieta-compatibilita.nome"));
				setParameter(object, "setValore", Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA.VALORE.getFieldType(),
					this.getObjectFromMap(map,"plugin-proprieta-compatibilita.valore"));
				return object;
			}
			
			else{
				throw new ServiceException("Model ["+model.toString()+"] not supported by fetch: "+this.getClass().getName());
			}	
					
		}catch(Exception e){
			throw new ServiceException("Model ["+model.toString()+"] occurs error in fetch: "+e.getMessage(),e);
		}
		
	}
	
	
	@Override
	public IKeyGeneratorObject getKeyGeneratorObject( IModel<?> model )  throws ServiceException {
		
		try{

			if(model.equals(Plugin.model())){
				return new org.openspcoop2.utils.jdbc.CustomKeyGeneratorObject(CostantiDB.REGISTRO_CLASSI,"id","seq_plugins","plugins_init_seq");
			}
			if(model.equals(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA)){
				return new org.openspcoop2.utils.jdbc.CustomKeyGeneratorObject(CostantiDB.REGISTRO_CLASSI_COMPATIBILITA_SERVIZIO,"id","seq_plugins_servizi_comp","plugins_servizi_comp_init_seq");
			}
			if(model.equals(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA)){
				return new org.openspcoop2.utils.jdbc.CustomKeyGeneratorObject(CostantiDB.REGISTRO_CLASSI_COMPATIBILITA_AZIONE,"id","seq_plugins_azioni_comp","plugins_azioni_comp_init_seq");
			}
			if(model.equals(Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA)){
				return new org.openspcoop2.utils.jdbc.CustomKeyGeneratorObject(CostantiDB.REGISTRO_CLASSI_COMPATIBILITA_PROPRIETA,"id","seq_plugins_props_comp","plugins_props_comp_init_seq");
			}
			
			else{
				throw new ServiceException("Model ["+model.toString()+"] not supported by getKeyGeneratorObject: "+this.getClass().getName());
			}

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

}