JDBCPluginServiceImpl.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.plugins.dao.jdbc;

  22. import java.sql.Connection;

  24. import org.openspcoop2.utils.sql.ISQLQueryObject;

  26. import org.slf4j.Logger;

  28. import org.openspcoop2.generic_project.dao.jdbc.IJDBCServiceCRUDWithId;
  29. import org.openspcoop2.core.plugins.IdPlugin;
  30. import org.openspcoop2.generic_project.beans.NonNegativeNumber;
  31. import org.openspcoop2.generic_project.beans.UpdateField;
  32. import org.openspcoop2.generic_project.beans.UpdateModel;

  34. import org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities;
  35. import org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject;
  36. import org.openspcoop2.generic_project.exception.NotFoundException;
  37. import org.openspcoop2.generic_project.exception.NotImplementedException;
  38. import org.openspcoop2.generic_project.exception.ServiceException;
  39. import org.openspcoop2.generic_project.expression.IExpression;
  40. import org.openspcoop2.generic_project.dao.jdbc.JDBCExpression;
  41. import org.openspcoop2.generic_project.dao.jdbc.JDBCPaginatedExpression;

  43. import org.openspcoop2.generic_project.dao.jdbc.JDBCServiceManagerProperties;

  45. import org.openspcoop2.core.plugins.PluginProprietaCompatibilita;
  46. import org.openspcoop2.core.plugins.Plugin;
  47. import org.openspcoop2.core.plugins.PluginServizioAzioneCompatibilita;
  48. import org.openspcoop2.core.plugins.PluginServizioCompatibilita;

  50. /**     
  51.  * JDBCPluginServiceImpl
  52.  *
  53.  * @author Poli Andrea (poli@link.it)
  54.  * @author $Author$
  55.  * @version $Rev$, $Date$
  56.  */
  57. public class JDBCPluginServiceImpl extends JDBCPluginServiceSearchImpl
  58.     implements IJDBCServiceCRUDWithId<Plugin, IdPlugin, JDBCServiceManager> {

  60.     @Override
  61.     public void create(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, Plugin plugin, org.openspcoop2.generic_project.beans.IDMappingBehaviour idMappingResolutionBehaviour) throws NotImplementedException,ServiceException,Exception {

  63.         org.openspcoop2.generic_project.dao.jdbc.utils.JDBCPreparedStatementUtilities jdbcUtilities = 
  64.                 new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCPreparedStatementUtilities(sqlQueryObject.getTipoDatabaseOpenSPCoop2(), log, connection);
  65.         
  66.         ISQLQueryObject sqlQueryObjectInsert = sqlQueryObject.newSQLQueryObject();
  67.                 


  70.         // Object plugin
  71.         sqlQueryObjectInsert.addInsertTable(this.getPluginFieldConverter().toTable(Plugin.model()));
  72.         sqlQueryObjectInsert.addInsertField(this.getPluginFieldConverter().toColumn(Plugin.model().TIPO_PLUGIN,false),"?");
  73.         sqlQueryObjectInsert.addInsertField(this.getPluginFieldConverter().toColumn(Plugin.model().CLASS_NAME,false),"?");
  74.         sqlQueryObjectInsert.addInsertField(this.getPluginFieldConverter().toColumn(Plugin.model().TIPO,false),"?");
  75.         sqlQueryObjectInsert.addInsertField(this.getPluginFieldConverter().toColumn(Plugin.model().DESCRIZIONE,false),"?");
  76.         sqlQueryObjectInsert.addInsertField(this.getPluginFieldConverter().toColumn(Plugin.model().LABEL,false),"?");
  77.         sqlQueryObjectInsert.addInsertField(this.getPluginFieldConverter().toColumn(Plugin.model().STATO,false),"?");

  79.         // Insert plugin
  80.         org.openspcoop2.utils.jdbc.IKeyGeneratorObject keyGenerator = this.getPluginFetch().getKeyGeneratorObject(Plugin.model());
  81.         long id = jdbcUtilities.insertAndReturnGeneratedKey(sqlQueryObjectInsert, keyGenerator, jdbcProperties.isShowSql(),
  82.             new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin.getTipoPlugin(),Plugin.model().TIPO_PLUGIN.getFieldType()),
  83.             new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin.getClassName(),Plugin.model().CLASS_NAME.getFieldType()),
  84.             new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin.getTipo(),Plugin.model().TIPO.getFieldType()),
  85.             new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin.getDescrizione(),Plugin.model().DESCRIZIONE.getFieldType()),
  86.             new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin.getLabel(),Plugin.model().LABEL.getFieldType()),
  87.             new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin.getStato(),Plugin.model().STATO.getFieldType())
  88.         );
  89.         plugin.setId(id);

  91.         // for plugin
  92.         for (int i = 0; i < plugin.getPluginProprietaCompatibilitaList().size(); i++) {


  95.             // Object plugin.getPluginProprietaCompatibilitaList().get(i)
  96.             ISQLQueryObject sqlQueryObjectInsert_pluginProprietaCompatibilita = sqlQueryObjectInsert.newSQLQueryObject();
  97.             sqlQueryObjectInsert_pluginProprietaCompatibilita.addInsertTable(this.getPluginFieldConverter().toTable(Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA));
  98.             sqlQueryObjectInsert_pluginProprietaCompatibilita.addInsertField(this.getPluginFieldConverter().toColumn(Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA.NOME,false),"?");
  99.             sqlQueryObjectInsert_pluginProprietaCompatibilita.addInsertField(this.getPluginFieldConverter().toColumn(Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA.VALORE,false),"?");
  100.             sqlQueryObjectInsert_pluginProprietaCompatibilita.addInsertField("id_plugin","?");

  102.             // Insert plugin.getPluginProprietaCompatibilitaList().get(i)
  103.             org.openspcoop2.utils.jdbc.IKeyGeneratorObject keyGenerator_pluginProprietaCompatibilita = this.getPluginFetch().getKeyGeneratorObject(Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA);
  104.             long id_pluginProprietaCompatibilita = jdbcUtilities.insertAndReturnGeneratedKey(sqlQueryObjectInsert_pluginProprietaCompatibilita, keyGenerator_pluginProprietaCompatibilita, jdbcProperties.isShowSql(),
  105.                 new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin.getPluginProprietaCompatibilitaList().get(i).getNome(),Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA.NOME.getFieldType()),
  106.                 new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin.getPluginProprietaCompatibilitaList().get(i).getValore(),Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA.VALORE.getFieldType()),
  107.                 new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(Long.valueOf(id),Long.class)
  108.             );
  109.             plugin.getPluginProprietaCompatibilitaList().get(i).setId(id_pluginProprietaCompatibilita);
  110.         } // fine for 

  112.         // for plugin
  113.         for (int i = 0; i < plugin.getPluginServizioCompatibilitaList().size(); i++) {


  116.             // Object plugin.getPluginServizioCompatibilitaList().get(i)
  117.             ISQLQueryObject sqlQueryObjectInsert_pluginServizioCompatibilita = sqlQueryObjectInsert.newSQLQueryObject();
  118.             sqlQueryObjectInsert_pluginServizioCompatibilita.addInsertTable(this.getPluginFieldConverter().toTable(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA));
  119.             sqlQueryObjectInsert_pluginServizioCompatibilita.addInsertField(this.getPluginFieldConverter().toColumn(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.URI_ACCORDO,false),"?");
  120.             sqlQueryObjectInsert_pluginServizioCompatibilita.addInsertField(this.getPluginFieldConverter().toColumn(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.SERVIZIO,false),"?");
  121.             sqlQueryObjectInsert_pluginServizioCompatibilita.addInsertField("id_plugin","?");

  123.             // Insert plugin.getPluginServizioCompatibilitaList().get(i)
  124.             org.openspcoop2.utils.jdbc.IKeyGeneratorObject keyGenerator_pluginServizioCompatibilita = this.getPluginFetch().getKeyGeneratorObject(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA);
  125.             long id_pluginServizioCompatibilita = jdbcUtilities.insertAndReturnGeneratedKey(sqlQueryObjectInsert_pluginServizioCompatibilita, keyGenerator_pluginServizioCompatibilita, jdbcProperties.isShowSql(),
  126.                 new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin.getPluginServizioCompatibilitaList().get(i).getUriAccordo(),Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.URI_ACCORDO.getFieldType()),
  127.                 new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin.getPluginServizioCompatibilitaList().get(i).getServizio(),Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.SERVIZIO.getFieldType()),
  128.                 new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(Long.valueOf(id),Long.class)
  129.             );
  130.             plugin.getPluginServizioCompatibilitaList().get(i).setId(id_pluginServizioCompatibilita);

  132.             // for plugin.getPluginServizioCompatibilitaList().get(i)
  133.             for (int i_pluginServizioCompatibilita = 0; i_pluginServizioCompatibilita < plugin.getPluginServizioCompatibilitaList().get(i).getPluginServizioAzioneCompatibilitaList().size(); i_pluginServizioCompatibilita++) {


  136.                 // Object plugin.getPluginServizioCompatibilitaList().get(i).getPluginServizioAzioneCompatibilitaList().get(i_pluginServizioCompatibilita)
  137.                 ISQLQueryObject sqlQueryObjectInsert_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita = sqlQueryObjectInsert.newSQLQueryObject();
  138.                 sqlQueryObjectInsert_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.addInsertTable(this.getPluginFieldConverter().toTable(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA));
  139.                 sqlQueryObjectInsert_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.addInsertField(this.getPluginFieldConverter().toColumn(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA.AZIONE,false),"?");
  140.                 sqlQueryObjectInsert_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.addInsertField("id_plugin_servizio_comp","?");

  142.                 // Insert plugin.getPluginServizioCompatibilitaList().get(i).getPluginServizioAzioneCompatibilitaList().get(i_pluginServizioCompatibilita)
  143.                 org.openspcoop2.utils.jdbc.IKeyGeneratorObject keyGenerator_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita = this.getPluginFetch().getKeyGeneratorObject(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA);
  144.                 long id_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita = jdbcUtilities.insertAndReturnGeneratedKey(sqlQueryObjectInsert_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita, keyGenerator_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita, jdbcProperties.isShowSql(),
  145.                     new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin.getPluginServizioCompatibilitaList().get(i).getPluginServizioAzioneCompatibilitaList().get(i_pluginServizioCompatibilita).getAzione(),Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA.AZIONE.getFieldType()),
  146.                     new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(Long.valueOf(id_pluginServizioCompatibilita),Long.class)
  147.                 );
  148.                 plugin.getPluginServizioCompatibilitaList().get(i).getPluginServizioAzioneCompatibilitaList().get(i_pluginServizioCompatibilita).setId(id_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita);
  149.             } // fine for _pluginServizioCompatibilita
  150.         } // fine for 

  152.         
  153.     }

  155.     @Override
  156.     public void update(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, IdPlugin oldId, Plugin plugin, org.openspcoop2.generic_project.beans.IDMappingBehaviour idMappingResolutionBehaviour) throws NotFoundException, NotImplementedException, ServiceException, Exception {
  157.         ISQLQueryObject sqlQueryObjectUpdate = sqlQueryObject.newSQLQueryObject();
  158.         Long longIdByLogicId = this.findIdPlugin(jdbcProperties, log, connection, sqlQueryObjectUpdate.newSQLQueryObject(), oldId, true);
  159.         Long tableId = plugin.getId();
  160.         if(tableId != null && tableId.longValue() > 0) {
  161.             if(tableId.longValue() != longIdByLogicId.longValue()) {
  162.                 throw new Exception("Ambiguous parameter: plugin.id ["+tableId+"] does not match logic id ["+longIdByLogicId+"]");
  163.             }
  164.         } else {
  165.             tableId = longIdByLogicId;
  166.             plugin.setId(tableId);
  167.         }
  168.         if(tableId==null || tableId<=0){
  169.             throw new Exception("Retrieve tableId failed");
  170.         }

  172.         this.update(jdbcProperties, log, connection, sqlQueryObject, tableId, plugin, idMappingResolutionBehaviour);
  173.     }
  174.     @Override
  175.     public void update(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, long tableId, Plugin plugin, org.openspcoop2.generic_project.beans.IDMappingBehaviour idMappingResolutionBehaviour) throws NotFoundException, NotImplementedException, ServiceException, Exception {
  176.     
  177.         org.openspcoop2.generic_project.dao.jdbc.utils.JDBCPreparedStatementUtilities jdbcUtilities = 
  178.                 new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCPreparedStatementUtilities(sqlQueryObject.getTipoDatabaseOpenSPCoop2(), log, connection);
  179.         
  180.         ISQLQueryObject sqlQueryObjectInsert = sqlQueryObject.newSQLQueryObject();
  181.         ISQLQueryObject sqlQueryObjectDelete = sqlQueryObjectInsert.newSQLQueryObject();
  182.         ISQLQueryObject sqlQueryObjectGet = sqlQueryObjectDelete.newSQLQueryObject();
  183.         ISQLQueryObject sqlQueryObjectUpdate = sqlQueryObjectGet.newSQLQueryObject();
  184.         


  187.         // Object plugin
  188.         sqlQueryObjectUpdate.setANDLogicOperator(true);
  189.         sqlQueryObjectUpdate.addUpdateTable(this.getPluginFieldConverter().toTable(Plugin.model()));
  190.         boolean isUpdate_plugin = true;
  191.         java.util.List<JDBCObject> lstObjects_plugin = new java.util.ArrayList<>();
  192.         sqlQueryObjectUpdate.addUpdateField(this.getPluginFieldConverter().toColumn(Plugin.model().TIPO_PLUGIN,false), "?");
  193.         lstObjects_plugin.add(new JDBCObject(plugin.getTipoPlugin(), Plugin.model().TIPO_PLUGIN.getFieldType()));
  194.         sqlQueryObjectUpdate.addUpdateField(this.getPluginFieldConverter().toColumn(Plugin.model().CLASS_NAME,false), "?");
  195.         lstObjects_plugin.add(new JDBCObject(plugin.getClassName(), Plugin.model().CLASS_NAME.getFieldType()));
  196.         sqlQueryObjectUpdate.addUpdateField(this.getPluginFieldConverter().toColumn(Plugin.model().TIPO,false), "?");
  197.         lstObjects_plugin.add(new JDBCObject(plugin.getTipo(), Plugin.model().TIPO.getFieldType()));
  198.         sqlQueryObjectUpdate.addUpdateField(this.getPluginFieldConverter().toColumn(Plugin.model().DESCRIZIONE,false), "?");
  199.         lstObjects_plugin.add(new JDBCObject(plugin.getDescrizione(), Plugin.model().DESCRIZIONE.getFieldType()));
  200.         sqlQueryObjectUpdate.addUpdateField(this.getPluginFieldConverter().toColumn(Plugin.model().LABEL,false), "?");
  201.         lstObjects_plugin.add(new JDBCObject(plugin.getLabel(), Plugin.model().LABEL.getFieldType()));
  202.         sqlQueryObjectUpdate.addUpdateField(this.getPluginFieldConverter().toColumn(Plugin.model().STATO,false), "?");
  203.         lstObjects_plugin.add(new JDBCObject(plugin.getStato(), Plugin.model().STATO.getFieldType()));
  204.         sqlQueryObjectUpdate.addWhereCondition("id=?");
  205.         lstObjects_plugin.add(new JDBCObject(tableId, Long.class));

  207.         if(isUpdate_plugin) {
  208.             // Update plugin
  209.             jdbcUtilities.executeUpdate(sqlQueryObjectUpdate.createSQLUpdate(), jdbcProperties.isShowSql(), 
  210.                 lstObjects_plugin.toArray(new JDBCObject[]{}));
  211.         }
  212.         // for plugin_pluginServizioCompatibilita

  214.         java.util.List<Long> ids_plugin_pluginServizioCompatibilita_da_non_eliminare = new java.util.ArrayList<Long>();
  215.         for (Object plugin_pluginServizioCompatibilita_object : plugin.getPluginServizioCompatibilitaList()) {
  216.             PluginServizioCompatibilita plugin_pluginServizioCompatibilita = (PluginServizioCompatibilita) plugin_pluginServizioCompatibilita_object;
  217.             if(plugin_pluginServizioCompatibilita.getId() == null || plugin_pluginServizioCompatibilita.getId().longValue() <= 0) {

  219.                 long id = plugin.getId();           

  221.                 // Object plugin_pluginServizioCompatibilita
  222.                 ISQLQueryObject sqlQueryObjectInsert_plugin_pluginServizioCompatibilita = sqlQueryObjectInsert.newSQLQueryObject();
  223.                 sqlQueryObjectInsert_plugin_pluginServizioCompatibilita.addInsertTable(this.getPluginFieldConverter().toTable(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA));
  224.                 sqlQueryObjectInsert_plugin_pluginServizioCompatibilita.addInsertField(this.getPluginFieldConverter().toColumn(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.URI_ACCORDO,false),"?");
  225.                 sqlQueryObjectInsert_plugin_pluginServizioCompatibilita.addInsertField(this.getPluginFieldConverter().toColumn(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.SERVIZIO,false),"?");
  226.                 sqlQueryObjectInsert_plugin_pluginServizioCompatibilita.addInsertField("id_plugin","?");

  228.                 // Insert plugin_pluginServizioCompatibilita
  229.                 org.openspcoop2.utils.jdbc.IKeyGeneratorObject keyGenerator_plugin_pluginServizioCompatibilita = this.getPluginFetch().getKeyGeneratorObject(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA);
  230.                 long id_plugin_pluginServizioCompatibilita = jdbcUtilities.insertAndReturnGeneratedKey(sqlQueryObjectInsert_plugin_pluginServizioCompatibilita, keyGenerator_plugin_pluginServizioCompatibilita, jdbcProperties.isShowSql(),
  231.                     new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin_pluginServizioCompatibilita.getUriAccordo(),Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.URI_ACCORDO.getFieldType()),
  232.                     new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin_pluginServizioCompatibilita.getServizio(),Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.SERVIZIO.getFieldType()),
  233.                     new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(Long.valueOf(id),Long.class)
  234.                 );
  235.                 plugin_pluginServizioCompatibilita.setId(id_plugin_pluginServizioCompatibilita);

  237.                 // for plugin_pluginServizioCompatibilita
  238.                 for (int i_plugin_pluginServizioCompatibilita = 0; i_plugin_pluginServizioCompatibilita < plugin_pluginServizioCompatibilita.getPluginServizioAzioneCompatibilitaList().size(); i_plugin_pluginServizioCompatibilita++) {


  241.                     // Object plugin_pluginServizioCompatibilita.getPluginServizioAzioneCompatibilitaList().get(i_plugin_pluginServizioCompatibilita)
  242.                     ISQLQueryObject sqlQueryObjectInsert_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita = sqlQueryObjectInsert.newSQLQueryObject();
  243.                     sqlQueryObjectInsert_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.addInsertTable(this.getPluginFieldConverter().toTable(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA));
  244.                     sqlQueryObjectInsert_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.addInsertField(this.getPluginFieldConverter().toColumn(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA.AZIONE,false),"?");
  245.                     sqlQueryObjectInsert_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.addInsertField("id_plugin_servizio_comp","?");

  247.                     // Insert plugin_pluginServizioCompatibilita.getPluginServizioAzioneCompatibilitaList().get(i_plugin_pluginServizioCompatibilita)
  248.                     org.openspcoop2.utils.jdbc.IKeyGeneratorObject keyGenerator_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita = this.getPluginFetch().getKeyGeneratorObject(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA);
  249.                     long id_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita = jdbcUtilities.insertAndReturnGeneratedKey(sqlQueryObjectInsert_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita, keyGenerator_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita, jdbcProperties.isShowSql(),
  250.                         new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin_pluginServizioCompatibilita.getPluginServizioAzioneCompatibilitaList().get(i_plugin_pluginServizioCompatibilita).getAzione(),Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA.AZIONE.getFieldType()),
  251.                         new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(Long.valueOf(id_plugin_pluginServizioCompatibilita),Long.class)
  252.                     );
  253.                     plugin_pluginServizioCompatibilita.getPluginServizioAzioneCompatibilitaList().get(i_plugin_pluginServizioCompatibilita).setId(id_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita);
  254.                 } // fine for _plugin_pluginServizioCompatibilita

  256.                 ids_plugin_pluginServizioCompatibilita_da_non_eliminare.add(plugin_pluginServizioCompatibilita.getId());
  257.             } else {


  260.                 // Object plugin_pluginServizioCompatibilita
  261.                 ISQLQueryObject sqlQueryObjectUpdate_plugin_pluginServizioCompatibilita = sqlQueryObjectUpdate.newSQLQueryObject();
  262.                 sqlQueryObjectUpdate_plugin_pluginServizioCompatibilita.setANDLogicOperator(true);
  263.                 sqlQueryObjectUpdate_plugin_pluginServizioCompatibilita.addUpdateTable(this.getPluginFieldConverter().toTable(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA));
  264.                 boolean isUpdate_plugin_pluginServizioCompatibilita = true;
  265.                 java.util.List<JDBCObject> lstObjects_plugin_pluginServizioCompatibilita = new java.util.ArrayList<>();
  266.                 sqlQueryObjectUpdate_plugin_pluginServizioCompatibilita.addUpdateField(this.getPluginFieldConverter().toColumn(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.URI_ACCORDO,false), "?");
  267.                 lstObjects_plugin_pluginServizioCompatibilita.add(new JDBCObject(plugin_pluginServizioCompatibilita.getUriAccordo(), Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.URI_ACCORDO.getFieldType()));
  268.                 sqlQueryObjectUpdate_plugin_pluginServizioCompatibilita.addUpdateField(this.getPluginFieldConverter().toColumn(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.SERVIZIO,false), "?");
  269.                 lstObjects_plugin_pluginServizioCompatibilita.add(new JDBCObject(plugin_pluginServizioCompatibilita.getServizio(), Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.SERVIZIO.getFieldType()));
  270.                 sqlQueryObjectUpdate_plugin_pluginServizioCompatibilita.addWhereCondition("id=?");
  271.                 ids_plugin_pluginServizioCompatibilita_da_non_eliminare.add(plugin_pluginServizioCompatibilita.getId());
  272.                 lstObjects_plugin_pluginServizioCompatibilita.add(new JDBCObject(plugin_pluginServizioCompatibilita.getId(),Long.class));

  274.                 if(isUpdate_plugin_pluginServizioCompatibilita) {
  275.                     // Update plugin_pluginServizioCompatibilita
  276.                     jdbcUtilities.executeUpdate(sqlQueryObjectUpdate_plugin_pluginServizioCompatibilita.createSQLUpdate(), jdbcProperties.isShowSql(), 
  277.                         lstObjects_plugin_pluginServizioCompatibilita.toArray(new JDBCObject[]{}));
  278.                 }
  279.                 // for plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita

  281.                 java.util.List<Long> ids_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita_da_non_eliminare = new java.util.ArrayList<Long>();
  282.                 for (Object plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita_object : plugin_pluginServizioCompatibilita.getPluginServizioAzioneCompatibilitaList()) {
  283.                     PluginServizioAzioneCompatibilita plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita = (PluginServizioAzioneCompatibilita) plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita_object;
  284.                     if(plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.getId() == null || plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.getId().longValue() <= 0) {

  286.                         long id_plugin_pluginServizioCompatibilita = plugin_pluginServizioCompatibilita.getId();                    

  288.                         // Object plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita
  289.                         ISQLQueryObject sqlQueryObjectInsert_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita = sqlQueryObjectInsert.newSQLQueryObject();
  290.                         sqlQueryObjectInsert_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.addInsertTable(this.getPluginFieldConverter().toTable(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA));
  291.                         sqlQueryObjectInsert_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.addInsertField(this.getPluginFieldConverter().toColumn(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA.AZIONE,false),"?");
  292.                         sqlQueryObjectInsert_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.addInsertField("id_plugin_servizio_comp","?");

  294.                         // Insert plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita
  295.                         org.openspcoop2.utils.jdbc.IKeyGeneratorObject keyGenerator_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita = this.getPluginFetch().getKeyGeneratorObject(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA);
  296.                         long id_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita = jdbcUtilities.insertAndReturnGeneratedKey(sqlQueryObjectInsert_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita, keyGenerator_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita, jdbcProperties.isShowSql(),
  297.                             new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.getAzione(),Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA.AZIONE.getFieldType()),
  298.                             new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(Long.valueOf(id_plugin_pluginServizioCompatibilita),Long.class)
  299.                         );
  300.                         plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.setId(id_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita);

  302.                         ids_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita_da_non_eliminare.add(plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.getId());
  303.                     } else {


  306.                         // Object plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita
  307.                         ISQLQueryObject sqlQueryObjectUpdate_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita = sqlQueryObjectUpdate.newSQLQueryObject();
  308.                         sqlQueryObjectUpdate_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.setANDLogicOperator(true);
  309.                         sqlQueryObjectUpdate_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.addUpdateTable(this.getPluginFieldConverter().toTable(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA));
  310.                         boolean isUpdate_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita = true;
  311.                         java.util.List<JDBCObject> lstObjects_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita = new java.util.ArrayList<>();
  312.                         sqlQueryObjectUpdate_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.addUpdateField(this.getPluginFieldConverter().toColumn(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA.AZIONE,false), "?");
  313.                         lstObjects_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.add(new JDBCObject(plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.getAzione(), Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA.AZIONE.getFieldType()));
  314.                         sqlQueryObjectUpdate_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.addWhereCondition("id=?");
  315.                         ids_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita_da_non_eliminare.add(plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.getId());
  316.                         lstObjects_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.add(new JDBCObject(plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.getId(),Long.class));

  318.                         if(isUpdate_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita) {
  319.                             // Update plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita
  320.                             jdbcUtilities.executeUpdate(sqlQueryObjectUpdate_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.createSQLUpdate(), jdbcProperties.isShowSql(), 
  321.                                 lstObjects_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.toArray(new JDBCObject[]{}));
  322.                         }
  323.                     }
  324.                 } // fine for plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita

  326.                 // elimino tutte le occorrenze di plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita non presenti nell'update

  328.                 ISQLQueryObject sqlQueryObjectUpdate_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilitadeleteEngineList = sqlQueryObjectUpdate.newSQLQueryObject();
  329.                 sqlQueryObjectUpdate_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilitadeleteEngineList.setANDLogicOperator(true);
  330.                 sqlQueryObjectUpdate_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilitadeleteEngineList.addDeleteTable(this.getPluginFieldConverter().toTable(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA));
  331.                 java.util.List<JDBCObject> jdbcObjects_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilitadeleteEngine = new java.util.ArrayList<>();

  333.                 sqlQueryObjectUpdate_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilitadeleteEngineList.addWhereCondition("id_plugin_servizio_comp=?");
  334.                 jdbcObjects_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilitadeleteEngine.add(new JDBCObject(plugin_pluginServizioCompatibilita.getId(), Long.class));

  336.                 StringBuilder marks_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita = new StringBuilder();
  337.                 if(ids_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita_da_non_eliminare.size() > 0) {
  338.                     for(Long ids : ids_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita_da_non_eliminare) {
  339.                         if(marks_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.length() > 0) {
  340.                             marks_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.append(",");
  341.                         }
  342.                         marks_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.append("?");
  343.                         jdbcObjects_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilitadeleteEngine.add(new JDBCObject(ids, Long.class));

  345.                     }
  346.                     sqlQueryObjectUpdate_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilitadeleteEngineList.addWhereCondition("id NOT IN ("+marks_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.toString()+")");
  347.                 }

  349.                 jdbcUtilities.execute(sqlQueryObjectUpdate_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilitadeleteEngineList.createSQLDelete(), jdbcProperties.isShowSql(), jdbcObjects_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilitadeleteEngine.toArray(new JDBCObject[]{}));

  351.             }
  352.         } // fine for plugin_pluginServizioCompatibilita

  354.         // elimino tutte le occorrenze di plugin_pluginServizioCompatibilita non presenti nell'update

  356.         ISQLQueryObject sqlQueryObjectUpdate_pluginServizioCompatibilitadeleteEngineList = sqlQueryObjectUpdate.newSQLQueryObject();
  357.         sqlQueryObjectUpdate_pluginServizioCompatibilitadeleteEngineList.setANDLogicOperator(true);
  358.         sqlQueryObjectUpdate_pluginServizioCompatibilitadeleteEngineList.addDeleteTable(this.getPluginFieldConverter().toTable(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA));
  359.         java.util.List<JDBCObject> jdbcObjects_plugin_pluginServizioCompatibilitadeleteEngine = new java.util.ArrayList<>();

  361.         sqlQueryObjectUpdate_pluginServizioCompatibilitadeleteEngineList.addWhereCondition("id_plugin=?");
  362.         jdbcObjects_plugin_pluginServizioCompatibilitadeleteEngine.add(new JDBCObject(plugin.getId(), Long.class));

  364.         StringBuilder marks_plugin_pluginServizioCompatibilita = new StringBuilder();
  365.         if(ids_plugin_pluginServizioCompatibilita_da_non_eliminare.size() > 0) {
  366.             for(Long ids : ids_plugin_pluginServizioCompatibilita_da_non_eliminare) {
  367.                 if(marks_plugin_pluginServizioCompatibilita.length() > 0) {
  368.                     marks_plugin_pluginServizioCompatibilita.append(",");
  369.                 }
  370.                 marks_plugin_pluginServizioCompatibilita.append("?");
  371.                 jdbcObjects_plugin_pluginServizioCompatibilitadeleteEngine.add(new JDBCObject(ids, Long.class));

  373.             }
  374.             sqlQueryObjectUpdate_pluginServizioCompatibilitadeleteEngineList.addWhereCondition("id NOT IN ("+marks_plugin_pluginServizioCompatibilita.toString()+")");
  375.         }

  377.         jdbcUtilities.execute(sqlQueryObjectUpdate_pluginServizioCompatibilitadeleteEngineList.createSQLDelete(), jdbcProperties.isShowSql(), jdbcObjects_plugin_pluginServizioCompatibilitadeleteEngine.toArray(new JDBCObject[]{}));

  379.         // for plugin_pluginProprietaCompatibilita

  381.         java.util.List<Long> ids_plugin_pluginProprietaCompatibilita_da_non_eliminare = new java.util.ArrayList<Long>();
  382.         for (Object plugin_pluginProprietaCompatibilita_object : plugin.getPluginProprietaCompatibilitaList()) {
  383.             PluginProprietaCompatibilita plugin_pluginProprietaCompatibilita = (PluginProprietaCompatibilita) plugin_pluginProprietaCompatibilita_object;
  384.             if(plugin_pluginProprietaCompatibilita.getId() == null || plugin_pluginProprietaCompatibilita.getId().longValue() <= 0) {

  386.                 long id = plugin.getId();           

  388.                 // Object plugin_pluginProprietaCompatibilita
  389.                 ISQLQueryObject sqlQueryObjectInsert_plugin_pluginProprietaCompatibilita = sqlQueryObjectInsert.newSQLQueryObject();
  390.                 sqlQueryObjectInsert_plugin_pluginProprietaCompatibilita.addInsertTable(this.getPluginFieldConverter().toTable(Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA));
  391.                 sqlQueryObjectInsert_plugin_pluginProprietaCompatibilita.addInsertField(this.getPluginFieldConverter().toColumn(Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA.NOME,false),"?");
  392.                 sqlQueryObjectInsert_plugin_pluginProprietaCompatibilita.addInsertField(this.getPluginFieldConverter().toColumn(Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA.VALORE,false),"?");
  393.                 sqlQueryObjectInsert_plugin_pluginProprietaCompatibilita.addInsertField("id_plugin","?");

  395.                 // Insert plugin_pluginProprietaCompatibilita
  396.                 org.openspcoop2.utils.jdbc.IKeyGeneratorObject keyGenerator_plugin_pluginProprietaCompatibilita = this.getPluginFetch().getKeyGeneratorObject(Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA);
  397.                 long id_plugin_pluginProprietaCompatibilita = jdbcUtilities.insertAndReturnGeneratedKey(sqlQueryObjectInsert_plugin_pluginProprietaCompatibilita, keyGenerator_plugin_pluginProprietaCompatibilita, jdbcProperties.isShowSql(),
  398.                     new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin_pluginProprietaCompatibilita.getNome(),Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA.NOME.getFieldType()),
  399.                     new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin_pluginProprietaCompatibilita.getValore(),Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA.VALORE.getFieldType()),
  400.                     new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(Long.valueOf(id),Long.class)
  401.                 );
  402.                 plugin_pluginProprietaCompatibilita.setId(id_plugin_pluginProprietaCompatibilita);

  404.                 ids_plugin_pluginProprietaCompatibilita_da_non_eliminare.add(plugin_pluginProprietaCompatibilita.getId());
  405.             } else {


  408.                 // Object plugin_pluginProprietaCompatibilita
  409.                 ISQLQueryObject sqlQueryObjectUpdate_plugin_pluginProprietaCompatibilita = sqlQueryObjectUpdate.newSQLQueryObject();
  410.                 sqlQueryObjectUpdate_plugin_pluginProprietaCompatibilita.setANDLogicOperator(true);
  411.                 sqlQueryObjectUpdate_plugin_pluginProprietaCompatibilita.addUpdateTable(this.getPluginFieldConverter().toTable(Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA));
  412.                 boolean isUpdate_plugin_pluginProprietaCompatibilita = true;
  413.                 java.util.List<JDBCObject> lstObjects_plugin_pluginProprietaCompatibilita = new java.util.ArrayList<>();
  414.                 sqlQueryObjectUpdate_plugin_pluginProprietaCompatibilita.addUpdateField(this.getPluginFieldConverter().toColumn(Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA.NOME,false), "?");
  415.                 lstObjects_plugin_pluginProprietaCompatibilita.add(new JDBCObject(plugin_pluginProprietaCompatibilita.getNome(), Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA.NOME.getFieldType()));
  416.                 sqlQueryObjectUpdate_plugin_pluginProprietaCompatibilita.addUpdateField(this.getPluginFieldConverter().toColumn(Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA.VALORE,false), "?");
  417.                 lstObjects_plugin_pluginProprietaCompatibilita.add(new JDBCObject(plugin_pluginProprietaCompatibilita.getValore(), Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA.VALORE.getFieldType()));
  418.                 sqlQueryObjectUpdate_plugin_pluginProprietaCompatibilita.addWhereCondition("id=?");
  419.                 ids_plugin_pluginProprietaCompatibilita_da_non_eliminare.add(plugin_pluginProprietaCompatibilita.getId());
  420.                 lstObjects_plugin_pluginProprietaCompatibilita.add(new JDBCObject(plugin_pluginProprietaCompatibilita.getId(),Long.class));

  422.                 if(isUpdate_plugin_pluginProprietaCompatibilita) {
  423.                     // Update plugin_pluginProprietaCompatibilita
  424.                     jdbcUtilities.executeUpdate(sqlQueryObjectUpdate_plugin_pluginProprietaCompatibilita.createSQLUpdate(), jdbcProperties.isShowSql(), 
  425.                         lstObjects_plugin_pluginProprietaCompatibilita.toArray(new JDBCObject[]{}));
  426.                 }
  427.             }
  428.         } // fine for plugin_pluginProprietaCompatibilita

  430.         // elimino tutte le occorrenze di plugin_pluginProprietaCompatibilita non presenti nell'update

  432.         ISQLQueryObject sqlQueryObjectUpdate_pluginProprietaCompatibilitadeleteEngineList = sqlQueryObjectUpdate.newSQLQueryObject();
  433.         sqlQueryObjectUpdate_pluginProprietaCompatibilitadeleteEngineList.setANDLogicOperator(true);
  434.         sqlQueryObjectUpdate_pluginProprietaCompatibilitadeleteEngineList.addDeleteTable(this.getPluginFieldConverter().toTable(Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA));
  435.         java.util.List<JDBCObject> jdbcObjects_plugin_pluginProprietaCompatibilitadeleteEngine = new java.util.ArrayList<>();

  437.         sqlQueryObjectUpdate_pluginProprietaCompatibilitadeleteEngineList.addWhereCondition("id_plugin=?");
  438.         jdbcObjects_plugin_pluginProprietaCompatibilitadeleteEngine.add(new JDBCObject(plugin.getId(), Long.class));

  440.         StringBuilder marks_plugin_pluginProprietaCompatibilita = new StringBuilder();
  441.         if(ids_plugin_pluginProprietaCompatibilita_da_non_eliminare.size() > 0) {
  442.             for(Long ids : ids_plugin_pluginProprietaCompatibilita_da_non_eliminare) {
  443.                 if(marks_plugin_pluginProprietaCompatibilita.length() > 0) {
  444.                     marks_plugin_pluginProprietaCompatibilita.append(",");
  445.                 }
  446.                 marks_plugin_pluginProprietaCompatibilita.append("?");
  447.                 jdbcObjects_plugin_pluginProprietaCompatibilitadeleteEngine.add(new JDBCObject(ids, Long.class));

  449.             }
  450.             sqlQueryObjectUpdate_pluginProprietaCompatibilitadeleteEngineList.addWhereCondition("id NOT IN ("+marks_plugin_pluginProprietaCompatibilita.toString()+")");
  451.         }

  453.         jdbcUtilities.execute(sqlQueryObjectUpdate_pluginProprietaCompatibilitadeleteEngineList.createSQLDelete(), jdbcProperties.isShowSql(), jdbcObjects_plugin_pluginProprietaCompatibilitadeleteEngine.toArray(new JDBCObject[]{}));



  457.     }
  458.     
  459.     @Override
  460.     public void updateFields(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, IdPlugin id, UpdateField ... updateFields) throws NotFoundException, NotImplementedException, ServiceException, Exception {
  461.         
  462.         GenericJDBCUtilities.updateFields(jdbcProperties, log, connection, sqlQueryObject, 
  463.                 this.getPluginFieldConverter().toTable(Plugin.model()), 
  464.                 this.getMapTableToPKColumnEngine(), 
  465.                 this.getRootTablePrimaryKeyValuesEngine(jdbcProperties, log, connection, sqlQueryObject, id),
  466.                 this.getPluginFieldConverter(), this, null, updateFields);
  467.     }
  468.     
  469.     @Override
  470.     public void updateFields(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, IdPlugin id, IExpression condition, UpdateField ... updateFields) throws NotFoundException, NotImplementedException, ServiceException, Exception {
  471.         
  472.         GenericJDBCUtilities.updateFields(jdbcProperties, log, connection, sqlQueryObject, 
  473.                 this.getPluginFieldConverter().toTable(Plugin.model()), 
  474.                 this.getMapTableToPKColumnEngine(), 
  475.                 this.getRootTablePrimaryKeyValuesEngine(jdbcProperties, log, connection, sqlQueryObject, id),
  476.                 this.getPluginFieldConverter(), this, condition, updateFields);
  477.     }
  478.     
  479.     @Override
  480.     public void updateFields(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, IdPlugin id, UpdateModel ... updateModels) throws NotFoundException, NotImplementedException, ServiceException, Exception {
  481.         
  482.         GenericJDBCUtilities.updateFields(jdbcProperties, log, connection, sqlQueryObject, 
  483.                 this.getPluginFieldConverter().toTable(Plugin.model()), 
  484.                 this.getMapTableToPKColumnEngine(), 
  485.                 this.getRootTablePrimaryKeyValuesEngine(jdbcProperties, log, connection, sqlQueryObject, id),
  486.                 this.getPluginFieldConverter(), this, updateModels);
  487.     }   
  488.     
  489.     @Override
  490.     public void updateFields(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, long tableId, UpdateField ... updateFields) throws NotFoundException, NotImplementedException, ServiceException, Exception {
  491.         java.util.List<Object> ids = new java.util.ArrayList<>();
  492.         ids.add(tableId);
  493.         GenericJDBCUtilities.updateFields(jdbcProperties, log, connection, sqlQueryObject, 
  494.                 this.getPluginFieldConverter().toTable(Plugin.model()), 
  495.                 this.getMapTableToPKColumnEngine(), 
  496.                 ids,
  497.                 this.getPluginFieldConverter(), this, null, updateFields);
  498.     }
  499.     
  500.     @Override
  501.     public void updateFields(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, long tableId, IExpression condition, UpdateField ... updateFields) throws NotFoundException, NotImplementedException, ServiceException, Exception {
  502.         java.util.List<Object> ids = new java.util.ArrayList<>();
  503.         ids.add(tableId);
  504.         GenericJDBCUtilities.updateFields(jdbcProperties, log, connection, sqlQueryObject, 
  505.                 this.getPluginFieldConverter().toTable(Plugin.model()), 
  506.                 this.getMapTableToPKColumnEngine(), 
  507.                 ids,
  508.                 this.getPluginFieldConverter(), this, condition, updateFields);
  509.     }
  510.     
  511.     @Override
  512.     public void updateFields(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, long tableId, UpdateModel ... updateModels) throws NotFoundException, NotImplementedException, ServiceException, Exception {
  513.         java.util.List<Object> ids = new java.util.ArrayList<>();
  514.         ids.add(tableId);
  515.         GenericJDBCUtilities.updateFields(jdbcProperties, log, connection, sqlQueryObject, 
  516.                 this.getPluginFieldConverter().toTable(Plugin.model()), 
  517.                 this.getMapTableToPKColumnEngine(), 
  518.                 ids,
  519.                 this.getPluginFieldConverter(), this, updateModels);
  520.     }
  521.     
  522.     @Override
  523.     public void updateOrCreate(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, IdPlugin oldId, Plugin plugin, org.openspcoop2.generic_project.beans.IDMappingBehaviour idMappingResolutionBehaviour) throws NotImplementedException,ServiceException,Exception {
  524.     
  525.         if(this.exists(jdbcProperties, log, connection, sqlQueryObject, oldId)) {
  526.             this.update(jdbcProperties, log, connection, sqlQueryObject, oldId, plugin,idMappingResolutionBehaviour);
  527.         } else {
  528.             this.create(jdbcProperties, log, connection, sqlQueryObject, plugin,idMappingResolutionBehaviour);
  529.         }
  530.         
  531.     }
  532.     
  533.     @Override
  534.     public void updateOrCreate(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, long tableId, Plugin plugin, org.openspcoop2.generic_project.beans.IDMappingBehaviour idMappingResolutionBehaviour) throws NotImplementedException,ServiceException,Exception {
  535.         if(this.exists(jdbcProperties, log, connection, sqlQueryObject, tableId)) {
  536.             this.update(jdbcProperties, log, connection, sqlQueryObject, tableId, plugin,idMappingResolutionBehaviour);
  537.         } else {
  538.             this.create(jdbcProperties, log, connection, sqlQueryObject, plugin,idMappingResolutionBehaviour);
  539.         }
  540.     }
  541.     
  542.     @Override
  543.     public void delete(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, Plugin plugin) throws NotImplementedException,ServiceException,Exception {
  544.         
  545.         
  546.         Long longId = null;
  547.         if( (plugin.getId()!=null) && (plugin.getId()>0) ){
  548.             longId = plugin.getId();
  549.         }
  550.         else{
  551.             IdPlugin idPlugin = this.convertToId(jdbcProperties,log,connection,sqlQueryObject,plugin);
  552.             longId = this.findIdPlugin(jdbcProperties,log,connection,sqlQueryObject,idPlugin,false);
  553.             if(longId == null){
  554.                 return; // entry not exists
  555.             }
  556.         }       
  557.         
  558.         this.deleteEngine(jdbcProperties, log, connection, sqlQueryObject, longId);
  559.         
  560.     }

  562.     private void deleteEngine(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, Long id) throws NotImplementedException,ServiceException,Exception {
  563.     
  564.         if(id==null){
  565.             throw new ServiceException("Id is null");
  566.         }
  567.         if(id!=null && id.longValue()<=0){
  568.             throw new ServiceException("Id is less equals 0");
  569.         }
  570.         
  571.         org.openspcoop2.generic_project.dao.jdbc.utils.JDBCPreparedStatementUtilities jdbcUtilities = 
  572.                 new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCPreparedStatementUtilities(sqlQueryObject.getTipoDatabaseOpenSPCoop2(), log, connection);
  573.         
  574.         ISQLQueryObject sqlQueryObjectDelete = sqlQueryObject.newSQLQueryObject();
  575.         

  577.         //Recupero oggetto _plugin_pluginServizioCompatibilita
  578.         ISQLQueryObject sqlQueryObjectDelete_plugin_pluginServizioCompatibilitagetEngineToDelete = sqlQueryObjectDelete.newSQLQueryObject();
  579.         sqlQueryObjectDelete_plugin_pluginServizioCompatibilitagetEngineToDelete.setANDLogicOperator(true);
  580.         sqlQueryObjectDelete_plugin_pluginServizioCompatibilitagetEngineToDelete.addFromTable(this.getPluginFieldConverter().toTable(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA));
  581.         sqlQueryObjectDelete_plugin_pluginServizioCompatibilitagetEngineToDelete.addWhereCondition("id_plugin=?");
  582.         java.util.List<Object> plugin_pluginServizioCompatibilita_toDelete_list = jdbcUtilities.executeQuery(sqlQueryObjectDelete_plugin_pluginServizioCompatibilitagetEngineToDelete.createSQLQuery(), jdbcProperties.isShowSql(), Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA, this.getPluginFetch(),
  583.             new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(id,Long.class));

  585.         // for plugin_pluginServizioCompatibilita
  586.         for (Object plugin_pluginServizioCompatibilita_object : plugin_pluginServizioCompatibilita_toDelete_list) {
  587.             PluginServizioCompatibilita plugin_pluginServizioCompatibilita = (PluginServizioCompatibilita) plugin_pluginServizioCompatibilita_object;
  588.             if(plugin_pluginServizioCompatibilita==null) {
  589.                 continue;
  590.             }

  592.             //Recupero oggetto _plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita
  593.             ISQLQueryObject sqlQueryObjectDelete_plugin_pluginServizioCompatibilita_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilitagetEngineToDelete = sqlQueryObjectDelete.newSQLQueryObject();
  594.             sqlQueryObjectDelete_plugin_pluginServizioCompatibilita_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilitagetEngineToDelete.setANDLogicOperator(true);
  595.             sqlQueryObjectDelete_plugin_pluginServizioCompatibilita_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilitagetEngineToDelete.addFromTable(this.getPluginFieldConverter().toTable(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA));
  596.             sqlQueryObjectDelete_plugin_pluginServizioCompatibilita_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilitagetEngineToDelete.addWhereCondition("id_plugin_servizio_comp=?");
  597.             java.util.List<Object> plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita_toDelete_list = jdbcUtilities.executeQuery(sqlQueryObjectDelete_plugin_pluginServizioCompatibilita_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilitagetEngineToDelete.createSQLQuery(), jdbcProperties.isShowSql(), Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA, this.getPluginFetch(),
  598.                 new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin_pluginServizioCompatibilita.getId(),Long.class));

  600.             // for plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita
  601.             for (Object plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita_object : plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita_toDelete_list) {
  602.                 PluginServizioAzioneCompatibilita plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita = (PluginServizioAzioneCompatibilita) plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita_object;

  604.                 // Object plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita
  605.                 ISQLQueryObject sqlQueryObjectDelete_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita = sqlQueryObjectDelete.newSQLQueryObject();
  606.                 sqlQueryObjectDelete_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.setANDLogicOperator(true);
  607.                 sqlQueryObjectDelete_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.addDeleteTable(this.getPluginFieldConverter().toTable(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA.PLUGIN_SERVIZIO_AZIONE_COMPATIBILITA));
  608.                 sqlQueryObjectDelete_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.addWhereCondition("id=?");

  610.                 // Delete plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita
  611.                 if(plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita != null){
  612.                     jdbcUtilities.execute(sqlQueryObjectDelete_plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.createSQLDelete(), jdbcProperties.isShowSql(), 
  613.                     new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita.getId(),Long.class));
  614.                 }
  615.             } // fine for plugin_pluginServizioCompatibilita_pluginServizioAzioneCompatibilita

  617.             // Object plugin_pluginServizioCompatibilita
  618.             ISQLQueryObject sqlQueryObjectDelete_plugin_pluginServizioCompatibilita = sqlQueryObjectDelete.newSQLQueryObject();
  619.             sqlQueryObjectDelete_plugin_pluginServizioCompatibilita.setANDLogicOperator(true);
  620.             sqlQueryObjectDelete_plugin_pluginServizioCompatibilita.addDeleteTable(this.getPluginFieldConverter().toTable(Plugin.model().PLUGIN_SERVIZIO_COMPATIBILITA));
  621.             sqlQueryObjectDelete_plugin_pluginServizioCompatibilita.addWhereCondition("id=?");

  623.             // Delete plugin_pluginServizioCompatibilita
  624.             jdbcUtilities.execute(sqlQueryObjectDelete_plugin_pluginServizioCompatibilita.createSQLDelete(), jdbcProperties.isShowSql(), 
  625.                 new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin_pluginServizioCompatibilita.getId(),Long.class));
  626.         } // fine for plugin_pluginServizioCompatibilita

  628.         //Recupero oggetto _plugin_pluginProprietaCompatibilita
  629.         ISQLQueryObject sqlQueryObjectDelete_plugin_pluginProprietaCompatibilitagetEngineToDelete = sqlQueryObjectDelete.newSQLQueryObject();
  630.         sqlQueryObjectDelete_plugin_pluginProprietaCompatibilitagetEngineToDelete.setANDLogicOperator(true);
  631.         sqlQueryObjectDelete_plugin_pluginProprietaCompatibilitagetEngineToDelete.addFromTable(this.getPluginFieldConverter().toTable(Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA));
  632.         sqlQueryObjectDelete_plugin_pluginProprietaCompatibilitagetEngineToDelete.addWhereCondition("id_plugin=?");
  633.         java.util.List<Object> plugin_pluginProprietaCompatibilita_toDelete_list = (java.util.List<Object>) jdbcUtilities.executeQuery(sqlQueryObjectDelete_plugin_pluginProprietaCompatibilitagetEngineToDelete.createSQLQuery(), jdbcProperties.isShowSql(), Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA, this.getPluginFetch(),
  634.             new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(id,Long.class));

  636.         // for plugin_pluginProprietaCompatibilita
  637.         for (Object plugin_pluginProprietaCompatibilita_object : plugin_pluginProprietaCompatibilita_toDelete_list) {
  638.             PluginProprietaCompatibilita plugin_pluginProprietaCompatibilita = (PluginProprietaCompatibilita) plugin_pluginProprietaCompatibilita_object;

  640.             // Object plugin_pluginProprietaCompatibilita
  641.             ISQLQueryObject sqlQueryObjectDelete_plugin_pluginProprietaCompatibilita = sqlQueryObjectDelete.newSQLQueryObject();
  642.             sqlQueryObjectDelete_plugin_pluginProprietaCompatibilita.setANDLogicOperator(true);
  643.             sqlQueryObjectDelete_plugin_pluginProprietaCompatibilita.addDeleteTable(this.getPluginFieldConverter().toTable(Plugin.model().PLUGIN_PROPRIETA_COMPATIBILITA));
  644.             sqlQueryObjectDelete_plugin_pluginProprietaCompatibilita.addWhereCondition("id=?");

  646.             // Delete plugin_pluginProprietaCompatibilita
  647.             if(plugin_pluginProprietaCompatibilita != null){
  648.                 jdbcUtilities.execute(sqlQueryObjectDelete_plugin_pluginProprietaCompatibilita.createSQLDelete(), jdbcProperties.isShowSql(), 
  649.                 new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(plugin_pluginProprietaCompatibilita.getId(),Long.class));
  650.             }
  651.         } // fine for plugin_pluginProprietaCompatibilita

  653.         // Object plugin
  654.         sqlQueryObjectDelete.setANDLogicOperator(true);
  655.         sqlQueryObjectDelete.addDeleteTable(this.getPluginFieldConverter().toTable(Plugin.model()));
  656.         if(id != null)
  657.             sqlQueryObjectDelete.addWhereCondition("id=?");

  659.         // Delete plugin
  660.         jdbcUtilities.execute(sqlQueryObjectDelete.createSQLDelete(), jdbcProperties.isShowSql(), 
  661.             new JDBCObject(id,Long.class));

  663.     }

  665.     @Override
  666.     public void deleteById(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, IdPlugin idPlugin) throws NotImplementedException,ServiceException,Exception {

  668.         Long id = null;
  669.         try{
  670.             id = this.findIdPlugin(jdbcProperties, log, connection, sqlQueryObject, idPlugin, true);
  671.         }catch(NotFoundException notFound){
  672.             return;
  673.         }
  674.         this.deleteEngine(jdbcProperties, log, connection, sqlQueryObject, id);
  675.         
  676.     }
  677.     
  678.     @Override
  679.     public NonNegativeNumber deleteAll(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject) throws NotImplementedException,ServiceException,Exception {
  680.         
  681.         return this.deleteAll(jdbcProperties, log, connection, sqlQueryObject, new JDBCExpression(this.getPluginFieldConverter()));

  683.     }

  685.     @Override
  686.     public NonNegativeNumber deleteAll(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, JDBCExpression expression) throws NotImplementedException, ServiceException,Exception {

  688.         java.util.List<Long> lst = this.findAllTableIds(jdbcProperties, log, connection, sqlQueryObject, new JDBCPaginatedExpression(expression));
  689.         
  690.         for(Long id : lst) {
  691.             this.deleteEngine(jdbcProperties, log, connection, sqlQueryObject, id);
  692.         }
  693.         
  694.         return new NonNegativeNumber(lst.size());
  695.     
  696.     }



  700.     // -- DB
  701.     
  702.     @Override
  703.     public void deleteById(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, long tableId) throws ServiceException, NotImplementedException, Exception {
  704.         this.deleteEngine(jdbcProperties, log, connection, sqlQueryObject, Long.valueOf(tableId));
  705.     }
  706.     
  707.     @Override
  708.     public int nativeUpdate(JDBCServiceManagerProperties jdbcProperties, Logger log,Connection connection,ISQLQueryObject sqlObject, String sql,Object ... param) throws ServiceException,NotImplementedException, Exception {
  709.     
  710.         return org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.nativeUpdate(jdbcProperties, log, connection, sqlObject,
  711.                                                                                             sql,param);
  712.     
  713.     }
  714. }
Created with JaCoCo 0.8.8.202204050719