JDBCPortaDelegataServiceSearchImpl.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;

  22. import java.sql.Connection;
  23. import java.util.ArrayList;
  24. import java.util.List;
  25. import java.util.Map;

  27. import org.openspcoop2.core.commons.search.IdPortaDelegata;
  28. import org.openspcoop2.core.commons.search.IdServizioApplicativo;
  29. import org.openspcoop2.core.commons.search.IdSoggetto;
  30. import org.openspcoop2.core.commons.search.PortaDelegata;
  31. import org.openspcoop2.core.commons.search.PortaDelegataAzione;
  32. import org.openspcoop2.core.commons.search.PortaDelegataServizioApplicativo;
  33. import org.openspcoop2.core.commons.search.dao.IDBSoggettoServiceSearch;
  34. import org.openspcoop2.core.commons.search.dao.jdbc.converter.PortaDelegataFieldConverter;
  35. import org.openspcoop2.core.commons.search.dao.jdbc.fetch.PortaDelegataFetch;
  36. import org.openspcoop2.core.commons.search.utils.ExpressionProperties;
  37. import org.openspcoop2.generic_project.beans.AliasField;
  38. import org.openspcoop2.generic_project.beans.CustomField;
  39. import org.openspcoop2.generic_project.beans.FunctionField;
  40. import org.openspcoop2.generic_project.beans.IField;
  41. import org.openspcoop2.generic_project.beans.InUse;
  42. import org.openspcoop2.generic_project.beans.NonNegativeNumber;
  43. import org.openspcoop2.generic_project.beans.Union;
  44. import org.openspcoop2.generic_project.beans.UnionExpression;
  45. import org.openspcoop2.generic_project.dao.jdbc.IJDBCServiceSearchWithId;
  46. import org.openspcoop2.generic_project.dao.jdbc.JDBCExpression;
  47. import org.openspcoop2.generic_project.dao.jdbc.JDBCPaginatedExpression;
  48. import org.openspcoop2.generic_project.dao.jdbc.JDBCServiceManagerProperties;
  49. import org.openspcoop2.generic_project.dao.jdbc.utils.IJDBCFetch;
  50. import org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject;
  51. import org.openspcoop2.generic_project.exception.MultipleResultException;
  52. import org.openspcoop2.generic_project.exception.NotFoundException;
  53. import org.openspcoop2.generic_project.exception.NotImplementedException;
  54. import org.openspcoop2.generic_project.exception.ServiceException;
  55. import org.openspcoop2.generic_project.expression.IExpression;
  56. import org.openspcoop2.generic_project.expression.impl.sql.ISQLFieldConverter;
  57. import org.openspcoop2.generic_project.utils.UtilsTemplate;
  58. import org.openspcoop2.utils.sql.ISQLQueryObject;
  59. import org.slf4j.Logger;

  61. /**     
  62.  * JDBCPortaDelegataServiceSearchImpl
  63.  *
  64.  * @author Poli Andrea (poli@link.it)
  65.  * @author $Author$
  66.  * @version $Rev$, $Date$
  67.  */
  68. public class JDBCPortaDelegataServiceSearchImpl implements IJDBCServiceSearchWithId<PortaDelegata, IdPortaDelegata, JDBCServiceManager> {

  70.     private PortaDelegataFieldConverter _portaDelegataFieldConverter = null;
  71.     public PortaDelegataFieldConverter getPortaDelegataFieldConverter() {
  72.         if(this._portaDelegataFieldConverter==null){
  73.             this._portaDelegataFieldConverter = new PortaDelegataFieldConverter(this.jdbcServiceManager.getJdbcProperties().getDatabaseType());
  74.         }       
  75.         return this._portaDelegataFieldConverter;
  76.     }
  77.     @Override
  78.     public ISQLFieldConverter getFieldConverter() {
  79.         return this.getPortaDelegataFieldConverter();
  80.     }
  81.     
  82.     private PortaDelegataFetch portaDelegataFetch = new PortaDelegataFetch();
  83.     public PortaDelegataFetch getPortaDelegataFetch() {
  84.         return this.portaDelegataFetch;
  85.     }
  86.     @Override
  87.     public IJDBCFetch getFetch() {
  88.         return getPortaDelegataFetch();
  89.     }
  90.     
  91.     
  92.     private JDBCServiceManager jdbcServiceManager = null;

  94.     @Override
  95.     public void setServiceManager(JDBCServiceManager serviceManager) throws ServiceException{
  96.         this.jdbcServiceManager = serviceManager;
  97.     }
  98.     
  99.     @Override
  100.     public JDBCServiceManager getServiceManager() throws ServiceException{
  101.         return this.jdbcServiceManager;
  102.     }
  103.     public JDBCServiceManager getServiceManager(Connection connection, JDBCServiceManagerProperties jdbcProperties, Logger log) throws ServiceException{
  104.         return new JDBCServiceManager(connection, jdbcProperties, log);
  105.     }
  106.     

  108.     @Override
  109.     public IdPortaDelegata convertToId(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, PortaDelegata portaDelegata) throws NotImplementedException, ServiceException, Exception{
  110.     
  111.         IdPortaDelegata idPortaDelegata = new IdPortaDelegata();
  112.         idPortaDelegata.setNome(portaDelegata.getNome());
  113.         return idPortaDelegata;
  114.     }
  115.     
  116.     @Override
  117.     public PortaDelegata get(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, IdPortaDelegata id, org.openspcoop2.generic_project.beans.IDMappingBehaviour idMappingResolutionBehaviour) throws NotFoundException, MultipleResultException, NotImplementedException, ServiceException,Exception {
  118.         Long id_portaDelegata = ( (id!=null && id.getId()!=null && id.getId()>0) ? id.getId() : this.findIdPortaDelegata(jdbcProperties, log, connection, sqlQueryObject, id, true));
  119.         return this.getEngine(jdbcProperties, log, connection, sqlQueryObject, id_portaDelegata,idMappingResolutionBehaviour);
  120.         
  121.         
  122.     }
  123.     
  124.     @Override
  125.     public boolean exists(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, IdPortaDelegata id) throws MultipleResultException, NotImplementedException, ServiceException,Exception {

  127.         Long id_portaDelegata = this.findIdPortaDelegata(jdbcProperties, log, connection, sqlQueryObject, id, false);
  128.         return id_portaDelegata != null && id_portaDelegata > 0;
  129.         
  130.     }
  131.     
  132.     @Override
  133.     public List<IdPortaDelegata> findAllIds(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, JDBCPaginatedExpression expression, org.openspcoop2.generic_project.beans.IDMappingBehaviour idMappingResolutionBehaviour) throws NotImplementedException, ServiceException,Exception {

  135.         List<IdPortaDelegata> list = new ArrayList<IdPortaDelegata>();

  137.         // TODO: implementazione non efficiente. 
  138.         // Per ottenere una implementazione efficiente:
  139.         // 1. Usare metodo select di questa classe indirizzando esattamente i field necessari a create l'ID logico
  140.         // 2. Usare metodo getPortaDelegataFetch() sul risultato della select per ottenere un oggetto PortaDelegata
  141.         //    La fetch con la map inserirà nell'oggetto solo i valori estratti 
  142.         // 3. Usare metodo convertToId per ottenere l'id

  144.         List<Long> ids = this.findAllTableIds(jdbcProperties, log, connection, sqlQueryObject, expression);
  145.         
  146.         for(Long id: ids) {
  147.             PortaDelegata portaDelegata = this.get(jdbcProperties, log, connection, sqlQueryObject, id, idMappingResolutionBehaviour);
  148.             IdPortaDelegata idPortaDelegata = this.convertToId(jdbcProperties,log,connection,sqlQueryObject,portaDelegata);
  149.             list.add(idPortaDelegata);
  150.         }

  152.         return list;
  153.         
  154.     }
  155.     
  156.     @Override
  157.     public List<PortaDelegata> findAll(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, JDBCPaginatedExpression expression, 
  158.             org.openspcoop2.generic_project.beans.IDMappingBehaviour idMappingResolutionBehaviour) throws NotImplementedException, ServiceException,Exception {

  160.         List<PortaDelegata> list = new ArrayList<PortaDelegata>();
  161.         
  162.         boolean soloDatiIdentificativiServizio = ExpressionProperties.isEnabledSoloDatiIdentificativiServizio(expression); 
  163.         
  164.         if(soloDatiIdentificativiServizio){
  165.             
  166.             List<IField> fields = new ArrayList<IField>();
  167.             fields.add(PortaDelegata.model().NOME);
  168.             fields.add(PortaDelegata.model().STATO);
  169.             fields.add(PortaDelegata.model().TIPO_SOGGETTO_EROGATORE);
  170.             fields.add(PortaDelegata.model().NOME_SOGGETTO_EROGATORE);
  171.             fields.add(PortaDelegata.model().TIPO_SERVIZIO);
  172.             fields.add(PortaDelegata.model().NOME_SERVIZIO);
  173.             fields.add(PortaDelegata.model().VERSIONE_SERVIZIO);
  174.             fields.add(PortaDelegata.model().MODE_AZIONE);
  175.             fields.add(PortaDelegata.model().NOME_AZIONE);
  176.             fields.add(PortaDelegata.model().NOME_PORTA_DELEGANTE_AZIONE);
  177.             
  178.             String aliasSoggettoTipo = "proprietarioSoggettoTipo";
  179.             fields.add(new AliasField(PortaDelegata.model().ID_SOGGETTO.TIPO, aliasSoggettoTipo));
  180.             String aliasSoggettoNome = "proprietarioSoggettoNome";
  181.             fields.add(new AliasField(PortaDelegata.model().ID_SOGGETTO.NOME, aliasSoggettoNome));
  182.             
  183.             List<Map<String, Object>> returnMap = null;
  184.             try{
  185.                 // non usare true altrimenti non funzionano alcuni meccanismi di ricerca, ad es. la valorizzazione dei select field nel servizio della govwayMonitor.
  186.                 // Tanto le join non comportano righe multiple uguali
  187.                 boolean distinct = false; 
  188.                 returnMap = this.select(jdbcProperties, log, connection, sqlQueryObject, expression, distinct, fields.toArray(new IField[1]));
  189.                 
  190.                 for(Map<String, Object> map: returnMap) {
  191.                     
  192.                     PortaDelegata pd = (PortaDelegata) this.getPortaDelegataFetch().fetch(jdbcProperties.getDatabase(), PortaDelegata.model(), map);
  193.                     
  194.                     Object proprietarioSoggettoTipo = this.getObjectFromMap(map, aliasSoggettoTipo);
  195.                     Object proprietarioSoggettoNome = this.getObjectFromMap(map, aliasSoggettoNome);
  196.                     if(proprietarioSoggettoTipo!=null && proprietarioSoggettoNome!=null) {
  197.                         IdSoggetto idSoggetto = new IdSoggetto();
  198.                         if(proprietarioSoggettoTipo!=null && proprietarioSoggettoTipo instanceof String) {
  199.                             idSoggetto.setTipo((String) proprietarioSoggettoTipo);
  200.                         }
  201.                         if(proprietarioSoggettoNome!=null && proprietarioSoggettoNome instanceof String) {
  202.                             idSoggetto.setNome((String) proprietarioSoggettoNome);
  203.                         }
  204.                         pd.setIdSoggetto(idSoggetto);
  205.                     }           
  206.                     
  207.                     list.add(pd);
  208.                 }
  209.             }catch(NotFoundException notFound){}
  210.         }
  211.         else {
  212.             // TODO: implementazione non efficiente. 
  213.             // Per ottenere una implementazione efficiente:
  214.             // 1. Usare metodo select di questa classe indirizzando esattamente i field necessari
  215.             // 2. Usare metodo getPortaDelegataFetch() sul risultato della select per ottenere un oggetto PortaDelegata
  216.             //    La fetch con la map inserirà nell'oggetto solo i valori estratti 
  217.     
  218.             List<Long> ids = this.findAllTableIds(jdbcProperties, log, connection, sqlQueryObject, expression);
  219.             
  220.             for(Long id: ids) {
  221.                 list.add(this.get(jdbcProperties, log, connection, sqlQueryObject, id, idMappingResolutionBehaviour));
  222.             }
  223.         }

  225.         return list;      
  226.         
  227.     }
  228.     
  229.     private Object getObjectFromMap(Map<String,Object> map,String name){
  230.         if(map==null){
  231.             return null;
  232.         }
  233.         else if(map.containsKey(name)){
  234.             Object o = map.get(name);
  235.             if(o instanceof org.apache.commons.lang.ObjectUtils.Null){
  236.                 return null;
  237.             }
  238.             else{
  239.                 return o;
  240.             }
  241.         }
  242.         else{
  243.             return null;
  244.         }
  245.     }
  246.     
  247.     @Override
  248.     public PortaDelegata find(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, JDBCExpression expression, org.openspcoop2.generic_project.beans.IDMappingBehaviour idMappingResolutionBehaviour) 
  249.         throws NotFoundException, MultipleResultException, NotImplementedException, ServiceException,Exception {

  251.         long id = this.findTableId(jdbcProperties, log, connection, sqlQueryObject, expression);
  252.         if(id>0){
  253.             return this.get(jdbcProperties, log, connection, sqlQueryObject, id, idMappingResolutionBehaviour);
  254.         }else{
  255.             throw new NotFoundException("Entry with id["+id+"] not found");
  256.         }
  257.         
  258.     }
  259.     
  260.     @Override
  261.     public NonNegativeNumber count(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, JDBCExpression expression) throws NotImplementedException, ServiceException,Exception {
  262.         
  263.         List<Object> listaQuery = org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.prepareCount(jdbcProperties, log, connection, sqlQueryObject, expression,
  264.                                                 this.getPortaDelegataFieldConverter(), PortaDelegata.model());
  265.         
  266.         sqlQueryObject.addSelectCountField(this.getPortaDelegataFieldConverter().toTable(PortaDelegata.model())+".id","tot",true);
  267.         
  268.         joinEngine(expression,sqlQueryObject);
  269.         
  270.         return org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.count(jdbcProperties, log, connection, sqlQueryObject, expression,
  271.                                                                             this.getPortaDelegataFieldConverter(), PortaDelegata.model(),listaQuery);
  272.     }

  274.     @Override
  275.     public InUse inUse(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, IdPortaDelegata id) throws NotFoundException, NotImplementedException, ServiceException,Exception {
  276.         
  277.         Long id_portaDelegata = this.findIdPortaDelegata(jdbcProperties, log, connection, sqlQueryObject, id, true);
  278.         return this.inUseEngine(jdbcProperties, log, connection, sqlQueryObject, id_portaDelegata);
  279.         
  280.     }

  282.     @Override
  283.     public List<Object> select(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, 
  284.                                                     JDBCPaginatedExpression paginatedExpression, IField field) throws ServiceException,NotFoundException,NotImplementedException,Exception {
  285.         return this.select(jdbcProperties, log, connection, sqlQueryObject,
  286.                                 paginatedExpression, false, field);
  287.     }
  288.     
  289.     @Override
  290.     public List<Object> select(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, 
  291.                                                     JDBCPaginatedExpression paginatedExpression, boolean distinct, IField field) throws ServiceException,NotFoundException,NotImplementedException,Exception {
  292.         List<Map<String,Object>> map = 
  293.             this.select(jdbcProperties, log, connection, sqlQueryObject, paginatedExpression, distinct, new IField[]{field});
  294.         return org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.selectSingleObject(map);
  295.     }
  296.     
  297.     @Override
  298.     public List<Map<String,Object>> select(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, 
  299.                                                     JDBCPaginatedExpression paginatedExpression, IField ... field) throws ServiceException,NotFoundException,NotImplementedException,Exception {
  300.         return this.select(jdbcProperties, log, connection, sqlQueryObject,
  301.                                 paginatedExpression, false, field);
  302.     }
  303.     
  304.     @Override
  305.     public List<Map<String,Object>> select(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, 
  306.                                                     JDBCPaginatedExpression paginatedExpression, boolean distinct, IField ... field) throws ServiceException,NotFoundException,NotImplementedException,Exception {
  307.         
  308.         org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.setFields(sqlQueryObject,paginatedExpression,field);
  309.         try{
  310.         
  311.             ISQLQueryObject sqlQueryObjectDistinct = 
  312.                         org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.prepareSqlQueryObjectForSelectDistinct(distinct,sqlQueryObject, paginatedExpression, log,
  313.                                                 this.getPortaDelegataFieldConverter(), field);

  315.             return selectEngine(jdbcProperties, log, connection, sqlQueryObject, paginatedExpression, sqlQueryObjectDistinct);
  316.             
  317.         }finally{
  318.             org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.removeFields(sqlQueryObject,paginatedExpression,field);
  319.         }
  320.     }

  322.     @Override
  323.     public Object aggregate(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, 
  324.                                                     JDBCExpression expression, FunctionField functionField) throws ServiceException,NotFoundException,NotImplementedException,Exception {
  325.         Map<String,Object> map = 
  326.             this.aggregate(jdbcProperties, log, connection, sqlQueryObject, expression, new FunctionField[]{functionField});
  327.         return org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.selectAggregateObject(map,functionField);
  328.     }
  329.     
  330.     @Override
  331.     public Map<String,Object> aggregate(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, 
  332.                                                     JDBCExpression expression, FunctionField ... functionField) throws ServiceException,NotFoundException,NotImplementedException,Exception {                                                   
  333.         
  334.         org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.setFields(sqlQueryObject,expression,functionField);
  335.         try{
  336.             List<Map<String,Object>> list = selectEngine(jdbcProperties, log, connection, sqlQueryObject, expression);
  337.             return list.get(0);
  338.         }finally{
  339.             org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.removeFields(sqlQueryObject,expression,functionField);
  340.         }
  341.     }

  343.     @Override
  344.     public List<Map<String,Object>> groupBy(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, 
  345.                                                     JDBCExpression expression, FunctionField ... functionField) throws ServiceException,NotFoundException,NotImplementedException,Exception {
  346.         
  347.         if(expression.getGroupByFields().isEmpty()){
  348.             throw new ServiceException("GroupBy conditions not found in expression");
  349.         }
  350.         
  351.         org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.setFields(sqlQueryObject,expression,functionField);
  352.         try{
  353.             return selectEngine(jdbcProperties, log, connection, sqlQueryObject, expression);
  354.         }finally{
  355.             org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.removeFields(sqlQueryObject,expression,functionField);
  356.         }
  357.     }
  358.     

  360.     @Override
  361.     public List<Map<String,Object>> groupBy(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, 
  362.                                                     JDBCPaginatedExpression paginatedExpression, FunctionField ... functionField) throws ServiceException,NotFoundException,NotImplementedException,Exception {
  363.         
  364.         if(paginatedExpression.getGroupByFields().isEmpty()){
  365.             throw new ServiceException("GroupBy conditions not found in expression");
  366.         }
  367.         
  368.         org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.setFields(sqlQueryObject,paginatedExpression,functionField);
  369.         try{
  370.             return selectEngine(jdbcProperties, log, connection, sqlQueryObject, paginatedExpression);
  371.         }finally{
  372.             org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.removeFields(sqlQueryObject,paginatedExpression,functionField);
  373.         }
  374.     }
  375.     
  376.     protected List<Map<String,Object>> selectEngine(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, 
  377.                                                 IExpression expression) throws ServiceException,NotFoundException,NotImplementedException,Exception {
  378.         return selectEngine(jdbcProperties, log, connection, sqlQueryObject, expression, null);
  379.     }
  380.     protected List<Map<String,Object>> selectEngine(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, 
  381.                                                 IExpression expression, ISQLQueryObject sqlQueryObjectDistinct) throws ServiceException,NotFoundException,NotImplementedException,Exception {
  382.         
  383.         List<Object> listaQuery = new ArrayList<>();
  384.         List<JDBCObject> listaParams = new ArrayList<>();
  385.         List<Object> returnField = org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.prepareSelect(jdbcProperties, log, connection, sqlQueryObject, 
  386.                                 expression, this.getPortaDelegataFieldConverter(), PortaDelegata.model(), 
  387.                                 listaQuery,listaParams);
  388.         
  389.         joinEngine(expression,sqlQueryObject);
  390.         
  391.         List<Map<String,Object>> list = org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.select(jdbcProperties, log, connection,
  392.                                         org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.prepareSqlQueryObjectForSelectDistinct(sqlQueryObject,sqlQueryObjectDistinct), 
  393.                                         expression, this.getPortaDelegataFieldConverter(), PortaDelegata.model(),
  394.                                         listaQuery,listaParams,returnField);
  395.         if(list!=null && !list.isEmpty()){
  396.             return list;
  397.         }
  398.         else{
  399.             throw org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.newNotFoundException();
  400.         }
  401.     }
  402.     
  403.     @Override
  404.     public List<Map<String,Object>> union(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, 
  405.                                                 Union union, UnionExpression ... unionExpression) throws ServiceException,NotFoundException,NotImplementedException,Exception {     
  406.         
  407.         List<ISQLQueryObject> sqlQueryObjectInnerList = new ArrayList<>();
  408.         List<JDBCObject> jdbcObjects = new ArrayList<>();
  409.         List<Class<?>> returnClassTypes = org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.prepareUnion(jdbcProperties, log, connection, sqlQueryObject, 
  410.                                 this.getPortaDelegataFieldConverter(), PortaDelegata.model(), 
  411.                                 sqlQueryObjectInnerList, jdbcObjects, union, unionExpression);
  412.         
  413.         if(unionExpression!=null){
  414.             for (int i = 0; i < unionExpression.length; i++) {
  415.                 UnionExpression ue = unionExpression[i];
  416.                 IExpression expression = ue.getExpression();
  417.                 joinEngine(expression,sqlQueryObjectInnerList.get(i));
  418.             }
  419.         }
  420.         
  421.         List<Map<String,Object>> list = org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.union(jdbcProperties, log, connection, sqlQueryObject, 
  422.                                         this.getPortaDelegataFieldConverter(), PortaDelegata.model(), 
  423.                                         sqlQueryObjectInnerList, jdbcObjects, returnClassTypes, union, unionExpression);
  424.         if(list!=null && !list.isEmpty()){
  425.             return list;
  426.         }
  427.         else{
  428.             throw org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.newNotFoundException();
  429.         }                               
  430.     }
  431.     
  432.     @Override
  433.     public NonNegativeNumber unionCount(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, 
  434.                                                 Union union, UnionExpression ... unionExpression) throws ServiceException,NotFoundException,NotImplementedException,Exception {     
  435.         
  436.         List<ISQLQueryObject> sqlQueryObjectInnerList = new ArrayList<>();
  437.         List<JDBCObject> jdbcObjects = new ArrayList<>();
  438.         List<Class<?>> returnClassTypes = org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.prepareUnionCount(jdbcProperties, log, connection, sqlQueryObject, 
  439.                                 this.getPortaDelegataFieldConverter(), PortaDelegata.model(), 
  440.                                 sqlQueryObjectInnerList, jdbcObjects, union, unionExpression);
  441.         
  442.         if(unionExpression!=null){
  443.             for (int i = 0; i < unionExpression.length; i++) {
  444.                 UnionExpression ue = unionExpression[i];
  445.                 IExpression expression = ue.getExpression();
  446.                 joinEngine(expression,sqlQueryObjectInnerList.get(i));
  447.             }
  448.         }
  449.         
  450.         NonNegativeNumber number = org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.unionCount(jdbcProperties, log, connection, sqlQueryObject, 
  451.                                         this.getPortaDelegataFieldConverter(), PortaDelegata.model(), 
  452.                                         sqlQueryObjectInnerList, jdbcObjects, returnClassTypes, union, unionExpression);
  453.         if(number!=null && number.longValue()>=0){
  454.             return number;
  455.         }
  456.         else{
  457.             throw org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.newNotFoundException();
  458.         }
  459.     }



  463.     // -- ConstructorExpression 

  465.     @Override
  466.     public JDBCExpression newExpression(Logger log) throws NotImplementedException, ServiceException {
  467.         try{
  468.             return new JDBCExpression(this.getPortaDelegataFieldConverter());
  469.         }catch(Exception e){
  470.             throw new ServiceException(e);
  471.         }
  472.     }


  475.     @Override
  476.     public JDBCPaginatedExpression newPaginatedExpression(Logger log) throws NotImplementedException, ServiceException {
  477.         try{
  478.             return new JDBCPaginatedExpression(this.getPortaDelegataFieldConverter());
  479.         }catch(Exception e){
  480.             throw new ServiceException(e);
  481.         }
  482.     }
  483.     
  484.     @Override
  485.     public JDBCExpression toExpression(JDBCPaginatedExpression paginatedExpression, Logger log) throws NotImplementedException, ServiceException {
  486.         try{
  487.             return new JDBCExpression(paginatedExpression);
  488.         }catch(Exception e){
  489.             throw new ServiceException(e);
  490.         }
  491.     }

  493.     @Override
  494.     public JDBCPaginatedExpression toPaginatedExpression(JDBCExpression expression, Logger log) throws NotImplementedException, ServiceException {
  495.         try{
  496.             return new JDBCPaginatedExpression(expression);
  497.         }catch(Exception e){
  498.             throw new ServiceException(e);
  499.         }
  500.     }
  501.     
  502.     
  503.     
  504.     // -- DB

  506.     @Override
  507.     public void mappingTableIds(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, IdPortaDelegata id, PortaDelegata obj) throws NotFoundException,NotImplementedException,ServiceException,Exception{
  508.         _mappingTableIds(jdbcProperties,log,connection,sqlQueryObject,obj,
  509.                 this.get(jdbcProperties,log,connection,sqlQueryObject,id,null));
  510.     }
  511.     
  512.     @Override
  513.     public void mappingTableIds(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, long tableId, PortaDelegata obj) throws NotFoundException,NotImplementedException,ServiceException,Exception{
  514.         _mappingTableIds(jdbcProperties,log,connection,sqlQueryObject,obj,
  515.                 this.get(jdbcProperties,log,connection,sqlQueryObject,tableId,null));
  516.     }
  517.     private void _mappingTableIds(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, PortaDelegata obj, PortaDelegata imgSaved) throws NotFoundException,NotImplementedException,ServiceException,Exception{
  518.         if(imgSaved==null){
  519.             return;
  520.         }
  521.         obj.setId(imgSaved.getId());
  522.         if(obj.getIdSoggetto()!=null && 
  523.                 imgSaved.getIdSoggetto()!=null){
  524.             obj.getIdSoggetto().setId(imgSaved.getIdSoggetto().getId());
  525.         }
  526.         if(obj.getPortaDelegataServizioApplicativoList()!=null){
  527.             List<org.openspcoop2.core.commons.search.PortaDelegataServizioApplicativo> listObj_ = obj.getPortaDelegataServizioApplicativoList();
  528.             for(org.openspcoop2.core.commons.search.PortaDelegataServizioApplicativo itemObj_ : listObj_){
  529.                 org.openspcoop2.core.commons.search.PortaDelegataServizioApplicativo itemAlreadySaved_ = null;
  530.                 if(imgSaved.getPortaDelegataServizioApplicativoList()!=null){
  531.                     List<org.openspcoop2.core.commons.search.PortaDelegataServizioApplicativo> listImgSaved_ = imgSaved.getPortaDelegataServizioApplicativoList();
  532.                     for(org.openspcoop2.core.commons.search.PortaDelegataServizioApplicativo itemImgSaved_ : listImgSaved_){
  533.                         boolean objEqualsToImgSaved_ = false;
  534.                         if(itemObj_.getIdServizioApplicativo()!=null && itemObj_.getIdServizioApplicativo().getIdSoggetto()!=null &&
  535.                                 itemImgSaved_.getIdServizioApplicativo()!=null && itemImgSaved_.getIdServizioApplicativo().getIdSoggetto()!=null){
  536.                             objEqualsToImgSaved_ = org.openspcoop2.generic_project.utils.Utilities.equals(itemObj_.getIdServizioApplicativo().getNome(),itemImgSaved_.getIdServizioApplicativo().getNome()) &&
  537.                                                                 org.openspcoop2.generic_project.utils.Utilities.equals(itemObj_.getIdServizioApplicativo().getIdSoggetto().getTipo(),itemImgSaved_.getIdServizioApplicativo().getIdSoggetto().getTipo()) &&
  538.                                                                 org.openspcoop2.generic_project.utils.Utilities.equals(itemObj_.getIdServizioApplicativo().getIdSoggetto().getNome(),itemImgSaved_.getIdServizioApplicativo().getIdSoggetto().getNome());
  539.                         }
  540.                         if(objEqualsToImgSaved_){
  541.                             itemAlreadySaved_=itemImgSaved_;
  542.                             break;
  543.                         }
  544.                     }
  545.                 }
  546.                 if(itemAlreadySaved_!=null){
  547.                     itemObj_.setId(itemAlreadySaved_.getId());
  548.                     if(itemObj_.getIdServizioApplicativo()!=null && 
  549.                             itemAlreadySaved_.getIdServizioApplicativo()!=null){
  550.                         itemObj_.getIdServizioApplicativo().setId(itemAlreadySaved_.getIdServizioApplicativo().getId());
  551.                         if(itemObj_.getIdServizioApplicativo().getIdSoggetto()!=null && 
  552.                                 itemAlreadySaved_.getIdServizioApplicativo().getIdSoggetto()!=null){
  553.                             itemObj_.getIdServizioApplicativo().getIdSoggetto().setId(itemAlreadySaved_.getIdServizioApplicativo().getIdSoggetto().getId());
  554.                         }
  555.                     }
  556.                 }
  557.             }
  558.         }
  559.         if(obj.getPortaDelegataAzioneList()!=null){
  560.             List<org.openspcoop2.core.commons.search.PortaDelegataAzione> listObj_ = obj.getPortaDelegataAzioneList();
  561.             for(org.openspcoop2.core.commons.search.PortaDelegataAzione itemObj_ : listObj_){
  562.                 org.openspcoop2.core.commons.search.PortaDelegataAzione itemAlreadySaved_ = null;
  563.                 if(imgSaved.getPortaDelegataAzioneList()!=null){
  564.                     List<org.openspcoop2.core.commons.search.PortaDelegataAzione> listImgSaved_ = imgSaved.getPortaDelegataAzioneList();
  565.                     for(org.openspcoop2.core.commons.search.PortaDelegataAzione itemImgSaved_ : listImgSaved_){
  566.                         boolean objEqualsToImgSaved_ = false;
  567.                         objEqualsToImgSaved_ = org.openspcoop2.generic_project.utils.Utilities.equals(itemObj_.getNome(),itemImgSaved_.getNome());
  568.                         if(objEqualsToImgSaved_){
  569.                             itemAlreadySaved_=itemImgSaved_;
  570.                             break;
  571.                         }
  572.                     }
  573.                 }
  574.                 if(itemAlreadySaved_!=null){
  575.                     itemObj_.setId(itemAlreadySaved_.getId());
  576.                 }
  577.             }
  578.         }
  579.              
  580.     }
  581.     
  582.     @Override
  583.     public PortaDelegata get(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, long tableId, org.openspcoop2.generic_project.beans.IDMappingBehaviour idMappingResolutionBehaviour) throws NotFoundException, MultipleResultException, NotImplementedException, ServiceException, Exception {
  584.         return this.getEngine(jdbcProperties, log, connection, sqlQueryObject, Long.valueOf(tableId), idMappingResolutionBehaviour);
  585.     }
  586.     
  587.     private PortaDelegata getEngine(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, Long tableId, org.openspcoop2.generic_project.beans.IDMappingBehaviour idMappingResolutionBehaviour) throws NotFoundException, MultipleResultException, NotImplementedException, ServiceException, Exception {
  588.     
  589.         org.openspcoop2.generic_project.dao.jdbc.utils.JDBCPreparedStatementUtilities jdbcUtilities = 
  590.                     new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCPreparedStatementUtilities(sqlQueryObject.getTipoDatabaseOpenSPCoop2(), log, connection);
  591.         
  592.         ISQLQueryObject sqlQueryObjectGet = sqlQueryObject.newSQLQueryObject();
  593.                 
  594.         PortaDelegata portaDelegata = new PortaDelegata();
  595.         

  597.         // Object portaDelegata
  598.         ISQLQueryObject sqlQueryObjectGet_portaDelegata = sqlQueryObjectGet.newSQLQueryObject();
  599.         sqlQueryObjectGet_portaDelegata.setANDLogicOperator(true);
  600.         sqlQueryObjectGet_portaDelegata.addFromTable(this.getPortaDelegataFieldConverter().toTable(PortaDelegata.model()));
  601.         sqlQueryObjectGet_portaDelegata.addSelectField("id");
  602.         sqlQueryObjectGet_portaDelegata.addSelectField(this.getPortaDelegataFieldConverter().toColumn(PortaDelegata.model().NOME,true));
  603.         sqlQueryObjectGet_portaDelegata.addSelectField(this.getPortaDelegataFieldConverter().toColumn(PortaDelegata.model().STATO,true));
  604.         sqlQueryObjectGet_portaDelegata.addSelectField(this.getPortaDelegataFieldConverter().toColumn(PortaDelegata.model().TIPO_SOGGETTO_EROGATORE,true));
  605.         sqlQueryObjectGet_portaDelegata.addSelectField(this.getPortaDelegataFieldConverter().toColumn(PortaDelegata.model().NOME_SOGGETTO_EROGATORE,true));
  606.         sqlQueryObjectGet_portaDelegata.addSelectField(this.getPortaDelegataFieldConverter().toColumn(PortaDelegata.model().TIPO_SERVIZIO,true));
  607.         sqlQueryObjectGet_portaDelegata.addSelectField(this.getPortaDelegataFieldConverter().toColumn(PortaDelegata.model().NOME_SERVIZIO,true));
  608.         sqlQueryObjectGet_portaDelegata.addSelectField(this.getPortaDelegataFieldConverter().toColumn(PortaDelegata.model().VERSIONE_SERVIZIO,true));
  609.         sqlQueryObjectGet_portaDelegata.addSelectField(this.getPortaDelegataFieldConverter().toColumn(PortaDelegata.model().MODE_AZIONE,true));
  610.         sqlQueryObjectGet_portaDelegata.addSelectField(this.getPortaDelegataFieldConverter().toColumn(PortaDelegata.model().NOME_AZIONE,true));
  611.         sqlQueryObjectGet_portaDelegata.addSelectField(this.getPortaDelegataFieldConverter().toColumn(PortaDelegata.model().NOME_PORTA_DELEGANTE_AZIONE,true));
  612.         sqlQueryObjectGet_portaDelegata.addSelectField(this.getPortaDelegataFieldConverter().toColumn(PortaDelegata.model().CANALE,true));
  613.         sqlQueryObjectGet_portaDelegata.addWhereCondition("id=?");

  615.         // Get portaDelegata
  616.         portaDelegata = (PortaDelegata) jdbcUtilities.executeQuerySingleResult(sqlQueryObjectGet_portaDelegata.createSQLQuery(), jdbcProperties.isShowSql(), PortaDelegata.model(), this.getPortaDelegataFetch(),
  617.             new JDBCObject(tableId,Long.class));


  620.         // Object _portaDelegata_soggetto (recupero id)
  621.         ISQLQueryObject sqlQueryObjectGet_portaDelegata_soggetto_readFkId = sqlQueryObjectGet.newSQLQueryObject();
  622.         sqlQueryObjectGet_portaDelegata_soggetto_readFkId.addFromTable(this.getPortaDelegataFieldConverter().toTable(org.openspcoop2.core.commons.search.PortaDelegata.model()));
  623.         sqlQueryObjectGet_portaDelegata_soggetto_readFkId.addSelectField("id_soggetto");
  624.         sqlQueryObjectGet_portaDelegata_soggetto_readFkId.addWhereCondition("id=?");
  625.         sqlQueryObjectGet_portaDelegata_soggetto_readFkId.setANDLogicOperator(true);
  626.         Long idFK_portaDelegata_soggetto = (Long) jdbcUtilities.executeQuerySingleResult(sqlQueryObjectGet_portaDelegata_soggetto_readFkId.createSQLQuery(), jdbcProperties.isShowSql(),Long.class,
  627.                 new JDBCObject(portaDelegata.getId(),Long.class));
  628.         
  629.         // Object _portaDelegata_soggetto
  630.         ISQLQueryObject sqlQueryObjectGet_portaDelegata_soggetto = sqlQueryObjectGet.newSQLQueryObject();
  631.         sqlQueryObjectGet_portaDelegata_soggetto.addFromTable("soggetti");
  632.         sqlQueryObjectGet_portaDelegata_soggetto.addSelectField("tipo_soggetto");
  633.         sqlQueryObjectGet_portaDelegata_soggetto.addSelectField("nome_soggetto");
  634.         sqlQueryObjectGet_portaDelegata_soggetto.setANDLogicOperator(true);
  635.         sqlQueryObjectGet_portaDelegata_soggetto.addWhereCondition("id=?");

  637.         // Recupero _portaDelegata_soggetto
  638.         org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject [] searchParams_portaDelegata_soggetto = new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject [] { 
  639.             new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(idFK_portaDelegata_soggetto,Long.class)
  640.         };
  641.         List<Class<?>> listaFieldIdReturnType_portaDelegata_soggetto = new ArrayList<Class<?>>();
  642.         listaFieldIdReturnType_portaDelegata_soggetto.add(String.class);
  643.         listaFieldIdReturnType_portaDelegata_soggetto.add(String.class);
  644.         List<Object> listaFieldId_portaDelegata_soggetto = jdbcUtilities.executeQuerySingleResult(sqlQueryObjectGet_portaDelegata_soggetto.createSQLQuery(), jdbcProperties.isShowSql(),
  645.                 listaFieldIdReturnType_portaDelegata_soggetto, searchParams_portaDelegata_soggetto);
  646.         IdSoggetto idSoggetto = new IdSoggetto();
  647.         idSoggetto.setTipo((String)listaFieldId_portaDelegata_soggetto.get(0));
  648.         idSoggetto.setNome((String)listaFieldId_portaDelegata_soggetto.get(1));
  649.         portaDelegata.setIdSoggetto(idSoggetto);


  652.         // Object portaDelegata_portaDelegataServizioApplicativo
  653.         ISQLQueryObject sqlQueryObjectGet_portaDelegata_portaDelegataServizioApplicativo = sqlQueryObjectGet.newSQLQueryObject();
  654.         sqlQueryObjectGet_portaDelegata_portaDelegataServizioApplicativo.setANDLogicOperator(true);
  655.         sqlQueryObjectGet_portaDelegata_portaDelegataServizioApplicativo.addFromTable(this.getPortaDelegataFieldConverter().toTable(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO));
  656.         sqlQueryObjectGet_portaDelegata_portaDelegataServizioApplicativo.addSelectField("id");
  657.         sqlQueryObjectGet_portaDelegata_portaDelegataServizioApplicativo.addWhereCondition("id_porta=?");

  659.         // Get portaDelegata_portaDelegataServizioApplicativo
  660.         java.util.List<Object> portaDelegata_portaDelegataServizioApplicativo_list = jdbcUtilities.executeQuery(sqlQueryObjectGet_portaDelegata_portaDelegataServizioApplicativo.createSQLQuery(), jdbcProperties.isShowSql(), PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO, this.getPortaDelegataFetch(),
  661.             new JDBCObject(portaDelegata.getId(),Long.class));

  663.         if(portaDelegata_portaDelegataServizioApplicativo_list != null) {
  664.             for (Object portaDelegata_portaDelegataServizioApplicativo_object: portaDelegata_portaDelegataServizioApplicativo_list) {
  665.                 PortaDelegataServizioApplicativo portaDelegata_portaDelegataServizioApplicativo = (PortaDelegataServizioApplicativo) portaDelegata_portaDelegataServizioApplicativo_object;


  668.                 // Object _portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo (recupero id)
  669.                 ISQLQueryObject sqlQueryObjectGet_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo_readFkId = sqlQueryObjectGet.newSQLQueryObject();
  670.                 sqlQueryObjectGet_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo_readFkId.addFromTable(this.getPortaDelegataFieldConverter().toTable(org.openspcoop2.core.commons.search.PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO));
  671.                 sqlQueryObjectGet_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo_readFkId.addSelectField("id_servizio_applicativo");
  672.                 sqlQueryObjectGet_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo_readFkId.addWhereCondition("id=?");
  673.                 sqlQueryObjectGet_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo_readFkId.setANDLogicOperator(true);
  674.                 Long idFK_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo = (Long) jdbcUtilities.executeQuerySingleResult(sqlQueryObjectGet_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo_readFkId.createSQLQuery(), jdbcProperties.isShowSql(),Long.class,
  675.                         new JDBCObject(portaDelegata_portaDelegataServizioApplicativo.getId(),Long.class));
  676.                 
  677.                 // Object _portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo
  678.                 ISQLQueryObject sqlQueryObjectGet_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo = sqlQueryObjectGet.newSQLQueryObject();
  679.                 sqlQueryObjectGet_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo.addFromTable("servizi_applicativi");
  680.                 sqlQueryObjectGet_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo.addSelectField("nome");
  681.                 sqlQueryObjectGet_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo.addSelectField("id_soggetto");
  682.                 sqlQueryObjectGet_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo.setANDLogicOperator(true);
  683.                 sqlQueryObjectGet_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo.addWhereCondition("id=?");

  685.                 // Recupero _portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo
  686.                 org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject [] searchParams_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo = new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject [] { 
  687.                     new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(idFK_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo,Long.class)
  688.                 };
  689.                 List<Class<?>> listaFieldIdReturnType_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo = new ArrayList<Class<?>>();
  690.                 listaFieldIdReturnType_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo.add(String.class);
  691.                 listaFieldIdReturnType_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo.add(Long.class);
  692.                 List<Object> listaFieldId_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo = jdbcUtilities.executeQuerySingleResult(sqlQueryObjectGet_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo.createSQLQuery(), jdbcProperties.isShowSql(),
  693.                         listaFieldIdReturnType_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo, searchParams_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo);
  694.                 IdServizioApplicativo idServizioApplicativo = new IdServizioApplicativo();
  695.                 idServizioApplicativo.setNome((String)listaFieldId_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo.get(0));
  696.                 Long idSoggettoLong = (Long) listaFieldId_portaDelegata_portaDelegataServizioApplicativo_servizioApplicativo.get(1);
  697.                 IdSoggetto idSoggettoSA = this.jdbcServiceManager.getSoggettoServiceSearch().convertToId(
  698.                         ((IDBSoggettoServiceSearch)this.jdbcServiceManager.getSoggettoServiceSearch()).get(idSoggettoLong)
  699.                         );
  700.                 idServizioApplicativo.setIdSoggetto(idSoggettoSA);
  701.                 portaDelegata_portaDelegataServizioApplicativo.setIdServizioApplicativo(idServizioApplicativo);
  702.                 
  703.                 portaDelegata.addPortaDelegataServizioApplicativo(portaDelegata_portaDelegataServizioApplicativo);
  704.             }
  705.         }

  707.         // Object portaDelegata_portaDelegataAzione
  708.         ISQLQueryObject sqlQueryObjectGet_portaDelegata_portaDelegataAzione = sqlQueryObjectGet.newSQLQueryObject();
  709.         sqlQueryObjectGet_portaDelegata_portaDelegataAzione.setANDLogicOperator(true);
  710.         sqlQueryObjectGet_portaDelegata_portaDelegataAzione.addFromTable(this.getPortaDelegataFieldConverter().toTable(PortaDelegata.model().PORTA_DELEGATA_AZIONE));
  711.         sqlQueryObjectGet_portaDelegata_portaDelegataAzione.addSelectField("id");
  712.         sqlQueryObjectGet_portaDelegata_portaDelegataAzione.addSelectField(this.getPortaDelegataFieldConverter().toColumn(PortaDelegata.model().PORTA_DELEGATA_AZIONE.NOME,true));
  713.         sqlQueryObjectGet_portaDelegata_portaDelegataAzione.addWhereCondition("id_porta=?");

  715.         // Get portaDelegata_portaDelegataAzione
  716.         java.util.List<Object> portaDelegata_portaDelegataAzione_list = jdbcUtilities.executeQuery(sqlQueryObjectGet_portaDelegata_portaDelegataAzione.createSQLQuery(), jdbcProperties.isShowSql(), PortaDelegata.model().PORTA_DELEGATA_AZIONE, this.getPortaDelegataFetch(),
  717.             new JDBCObject(portaDelegata.getId(),Long.class));

  719.         if(portaDelegata_portaDelegataAzione_list != null) {
  720.             for (Object portaDelegata_portaDelegataAzione_object: portaDelegata_portaDelegataAzione_list) {
  721.                 PortaDelegataAzione portaDelegata_portaDelegataAzione = (PortaDelegataAzione) portaDelegata_portaDelegataAzione_object;


  724.                 portaDelegata.addPortaDelegataAzione(portaDelegata_portaDelegataAzione);
  725.             }
  726.         }      
  727.         
  728.         return portaDelegata;  
  729.     
  730.     } 
  731.     
  732.     @Override
  733.     public boolean exists(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, long tableId) throws MultipleResultException, NotImplementedException, ServiceException, Exception {
  734.         return this._exists(jdbcProperties, log, connection, sqlQueryObject, Long.valueOf(tableId));
  735.     }
  736.     
  737.     private boolean _exists(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, Long tableId) throws MultipleResultException, NotImplementedException, ServiceException, Exception {
  738.     
  739.         org.openspcoop2.generic_project.dao.jdbc.utils.JDBCPreparedStatementUtilities jdbcUtilities = 
  740.                     new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCPreparedStatementUtilities(sqlQueryObject.getTipoDatabaseOpenSPCoop2(), log, connection);
  741.                 
  742.         boolean existsPortaDelegata = false;

  744.         sqlQueryObject = sqlQueryObject.newSQLQueryObject();
  745.         sqlQueryObject.setANDLogicOperator(true);

  747.         sqlQueryObject.addFromTable(this.getPortaDelegataFieldConverter().toTable(PortaDelegata.model()));
  748.         sqlQueryObject.addSelectField(this.getPortaDelegataFieldConverter().toColumn(PortaDelegata.model().NOME,true));
  749.         sqlQueryObject.addWhereCondition("id=?");


  752.         // Exists portaDelegata
  753.         existsPortaDelegata = jdbcUtilities.exists(sqlQueryObject.createSQLQuery(), jdbcProperties.isShowSql(),
  754.             new JDBCObject(tableId,Long.class));

  756.         
  757.         return existsPortaDelegata;
  758.     
  759.     }
  760.     
  761.     private void joinEngine(IExpression expression, ISQLQueryObject sqlQueryObject) throws NotImplementedException, ServiceException, Exception{
  762.     
  763.         if(expression.inUseModel(PortaDelegata.model().ID_SOGGETTO,false)){
  764.             String tableName1 = this.getPortaDelegataFieldConverter().toAliasTable(PortaDelegata.model());
  765.             String tableName2 = this.getPortaDelegataFieldConverter().toAliasTable(PortaDelegata.model().ID_SOGGETTO);
  766.             sqlQueryObject.addWhereCondition(tableName1+".id_soggetto="+tableName2+".id");
  767.         }
  768.         if(expression.inUseModel(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO,false)){
  769.             String tableName1 = this.getPortaDelegataFieldConverter().toAliasTable(PortaDelegata.model());
  770.             String tableName2 = this.getPortaDelegataFieldConverter().toAliasTable(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO);
  771.             sqlQueryObject.addWhereCondition(tableName1+".id="+tableName2+".id_porta");
  772.         }
  773.         if(expression.inUseModel(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO.ID_SERVIZIO_APPLICATIVO,false)){
  774.             String tableName1 = this.getPortaDelegataFieldConverter().toAliasTable(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO);
  775.             String tableName2 = this.getPortaDelegataFieldConverter().toAliasTable(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO.ID_SERVIZIO_APPLICATIVO);
  776.             sqlQueryObject.addWhereCondition(tableName1+".id_servizio_applicativo="+tableName2+".id");
  777.         }
  778.         if(expression.inUseModel(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO.ID_SERVIZIO_APPLICATIVO.ID_SOGGETTO,false)){
  779.             String tableName1 = this.getPortaDelegataFieldConverter().toAliasTable(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO.ID_SERVIZIO_APPLICATIVO);
  780.             String tableName2 = this.getPortaDelegataFieldConverter().toAliasTable(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO.ID_SERVIZIO_APPLICATIVO.ID_SOGGETTO);
  781.             sqlQueryObject.addWhereCondition(tableName1+".id_soggetto="+tableName2+".id");
  782.         }
  783.         if(expression.inUseModel(PortaDelegata.model().PORTA_DELEGATA_AZIONE,false)){
  784.             String tableName1 = this.getPortaDelegataFieldConverter().toAliasTable(PortaDelegata.model());
  785.             String tableName2 = this.getPortaDelegataFieldConverter().toAliasTable(PortaDelegata.model().PORTA_DELEGATA_AZIONE);
  786.             sqlQueryObject.addWhereCondition(tableName1+".id="+tableName2+".id_porta");
  787.         }
  788.         
  789.         
  790.         boolean addFromPDSA = false;
  791.         if(expression.inUseModel(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO.ID_SERVIZIO_APPLICATIVO,false)){
  792.             if(expression.inUseModel(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO,false)==false){
  793.                 
  794.                 sqlQueryObject.addFromTable(this.getPortaDelegataFieldConverter().toTable(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO));
  795.                 
  796.                 String tableName1 = this.getPortaDelegataFieldConverter().toAliasTable(PortaDelegata.model());
  797.                 String tableName2 = this.getPortaDelegataFieldConverter().toAliasTable(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO);
  798.                 try{
  799.                     sqlQueryObject.addWhereCondition(tableName1+".id="+tableName2+".id_porta");
  800.                 }catch(Exception e){
  801.                     // exception se gia' esiste
  802.                 }
  803.                 
  804.                 addFromPDSA = true;
  805.             }
  806.         }
  807.         if(expression.inUseModel(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO.ID_SERVIZIO_APPLICATIVO.ID_SOGGETTO,false)){
  808.             if(expression.inUseModel(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO.ID_SERVIZIO_APPLICATIVO,false)==false){
  809.                 
  810.                 sqlQueryObject.addFromTable(this.getPortaDelegataFieldConverter().toTable(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO.ID_SERVIZIO_APPLICATIVO));
  811.                 
  812.                 String tableName1 = this.getPortaDelegataFieldConverter().toAliasTable(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO);
  813.                 String tableName2 = this.getPortaDelegataFieldConverter().toAliasTable(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO.ID_SERVIZIO_APPLICATIVO);
  814.                 try{
  815.                     sqlQueryObject.addWhereCondition(tableName1+".id_servizio_applicativo="+tableName2+".id");
  816.                 }catch(Exception e){
  817.                     // exception se gia' esiste
  818.                 }
  819.             
  820.             }
  821.             if(addFromPDSA==false){
  822.                 sqlQueryObject.addFromTable(this.getPortaDelegataFieldConverter().toTable(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO));
  823.             }
  824.         }
  825.         
  826.     }
  827.     
  828.     protected java.util.List<Object> getRootTablePrimaryKeyValuesEngine(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, IdPortaDelegata id) throws NotFoundException, ServiceException, NotImplementedException, Exception{
  829.         // Identificativi
  830.         java.util.List<Object> rootTableIdValues = new java.util.ArrayList<>();
  831.         Long longId = this.findIdPortaDelegata(jdbcProperties, log, connection, sqlQueryObject.newSQLQueryObject(), id, true);
  832.         rootTableIdValues.add(longId);        
  833.         return rootTableIdValues;
  834.     }
  835.     
  836.     protected Map<String, List<IField>> getMapTableToPKColumnEngine() throws NotImplementedException, Exception{
  837.     
  838.         PortaDelegataFieldConverter converter = this.getPortaDelegataFieldConverter();
  839.         Map<String, List<IField>> mapTableToPKColumn = new java.util.HashMap<>();
  840.         UtilsTemplate<IField> utilities = new UtilsTemplate<>();

  842.         // PortaDelegata.model()
  843.         mapTableToPKColumn.put(converter.toTable(PortaDelegata.model()),
  844.             utilities.newList(
  845.                 new CustomField("id", Long.class, "id", converter.toTable(PortaDelegata.model()))
  846.             ));

  848.         // PortaDelegata.model().ID_SOGGETTO
  849.         mapTableToPKColumn.put(converter.toTable(PortaDelegata.model().ID_SOGGETTO),
  850.             utilities.newList(
  851.                 new CustomField("id", Long.class, "id", converter.toTable(PortaDelegata.model().ID_SOGGETTO))
  852.             ));

  854.         // PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO
  855.         mapTableToPKColumn.put(converter.toTable(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO),
  856.             utilities.newList(
  857.                 new CustomField("id", Long.class, "id", converter.toTable(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO))
  858.             ));

  860.         // PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO.ID_SERVIZIO_APPLICATIVO
  861.         mapTableToPKColumn.put(converter.toTable(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO.ID_SERVIZIO_APPLICATIVO),
  862.             utilities.newList(
  863.                 new CustomField("id", Long.class, "id", converter.toTable(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO.ID_SERVIZIO_APPLICATIVO))
  864.             ));

  866.         // PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO.ID_SERVIZIO_APPLICATIVO.ID_SOGGETTO
  867.         mapTableToPKColumn.put(converter.toTable(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO.ID_SERVIZIO_APPLICATIVO.ID_SOGGETTO),
  868.             utilities.newList(
  869.                 new CustomField("id", Long.class, "id", converter.toTable(PortaDelegata.model().PORTA_DELEGATA_SERVIZIO_APPLICATIVO.ID_SERVIZIO_APPLICATIVO.ID_SOGGETTO))
  870.             ));

  872.         // PortaDelegata.model().PORTA_DELEGATA_AZIONE
  873.         mapTableToPKColumn.put(converter.toTable(PortaDelegata.model().PORTA_DELEGATA_AZIONE),
  874.             utilities.newList(
  875.                 new CustomField("id", Long.class, "id", converter.toTable(PortaDelegata.model().PORTA_DELEGATA_AZIONE))
  876.             ));
  877.         
  878.         return mapTableToPKColumn;      
  879.     }
  880.     
  881.     @Override
  882.     public List<Long> findAllTableIds(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, JDBCPaginatedExpression paginatedExpression) throws ServiceException, NotImplementedException, Exception {
  883.         
  884.         List<Long> list = new ArrayList<Long>();

  886.         sqlQueryObject.setSelectDistinct(true);
  887.         sqlQueryObject.setANDLogicOperator(true);
  888.         sqlQueryObject.addSelectField(this.getPortaDelegataFieldConverter().toTable(PortaDelegata.model())+".id");
  889.         Class<?> objectIdClass = Long.class;
  890.         
  891.         List<Object> listaQuery = org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.prepareFindAll(jdbcProperties, log, connection, sqlQueryObject, paginatedExpression,
  892.                                                 this.getPortaDelegataFieldConverter(), PortaDelegata.model());
  893.         
  894.         joinEngine(paginatedExpression,sqlQueryObject);
  895.         
  896.         List<Object> listObjects = org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.findAll(jdbcProperties, log, connection, sqlQueryObject, paginatedExpression,
  897.                                                                             this.getPortaDelegataFieldConverter(), PortaDelegata.model(), objectIdClass, listaQuery);
  898.         for(Object object: listObjects) {
  899.             list.add((Long)object);
  900.         }

  902.         return list;
  903.         
  904.     }
  905.     
  906.     @Override
  907.     public long findTableId(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, JDBCExpression expression) throws ServiceException, NotFoundException, MultipleResultException, NotImplementedException, Exception {
  908.     
  909.         sqlQueryObject.setSelectDistinct(true);
  910.         sqlQueryObject.setANDLogicOperator(true);
  911.         sqlQueryObject.addSelectField(this.getPortaDelegataFieldConverter().toTable(PortaDelegata.model())+".id");
  912.         Class<?> objectIdClass = Long.class;
  913.         
  914.         List<Object> listaQuery = org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.prepareFind(jdbcProperties, log, connection, sqlQueryObject, expression,
  915.                                                 this.getPortaDelegataFieldConverter(), PortaDelegata.model());
  916.         
  917.         joinEngine(expression,sqlQueryObject);

  919.         Object res = org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.find(jdbcProperties, log, connection, sqlQueryObject, expression,
  920.                                                         this.getPortaDelegataFieldConverter(), PortaDelegata.model(), objectIdClass, listaQuery);
  921.         if(res!=null && (((Long) res).longValue()>0) ){
  922.             return ((Long) res).longValue();
  923.         }
  924.         else{
  925.             throw org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.newNotFoundException();
  926.         }
  927.         
  928.     }

  930.     @Override
  931.     public InUse inUse(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, long tableId) throws ServiceException, NotFoundException, NotImplementedException, Exception {
  932.         return this.inUseEngine(jdbcProperties, log, connection, sqlQueryObject, Long.valueOf(tableId));
  933.     }

  935.     private InUse inUseEngine(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, Long tableId) throws ServiceException, NotFoundException, NotImplementedException, Exception {

  937.         InUse inUse = new InUse();
  938.         inUse.setInUse(false);
  939.         
  940.         /* 
  941.          * TODO: implement code that checks whether the object identified by the id parameter is used by other objects
  942.         */
  943.         
  944.         // Delete this line when you have implemented the method
  945.         int throwNotImplemented = 1;
  946.         if(throwNotImplemented==1){
  947.                 throw new NotImplementedException("NotImplemented");
  948.         }
  949.         // Delete this line when you have implemented the method

  951.         return inUse;

  953.     }
  954.     
  955.     @Override
  956.     public IdPortaDelegata findId(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, long tableId, boolean throwNotFound)
  957.             throws NotFoundException, ServiceException, NotImplementedException, Exception {
  958.         
  959.         org.openspcoop2.generic_project.dao.jdbc.utils.JDBCPreparedStatementUtilities jdbcUtilities = 
  960.             new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCPreparedStatementUtilities(sqlQueryObject.getTipoDatabaseOpenSPCoop2(), log, connection);

  962.         ISQLQueryObject sqlQueryObjectGet = sqlQueryObject.newSQLQueryObject();            

  964.         // Object _portaDelegata
  965.         sqlQueryObjectGet.addFromTable(this.getPortaDelegataFieldConverter().toTable(PortaDelegata.model()));
  966.         sqlQueryObjectGet.addSelectField(this.getPortaDelegataFieldConverter().toColumn(PortaDelegata.model().NOME,true));
  967.         sqlQueryObjectGet.setANDLogicOperator(true);
  968.         sqlQueryObjectGet.addWhereCondition("id=?");

  970.         // Recupero _portaDelegata
  971.         org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject [] searchParams_portaDelegata = new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject [] { 
  972.             new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(tableId,Long.class)
  973.         };
  974.         List<Class<?>> listaFieldIdReturnType_portaDelegata = new ArrayList<Class<?>>();
  975.         listaFieldIdReturnType_portaDelegata.add(String.class);
  976.         org.openspcoop2.core.commons.search.IdPortaDelegata id_portaDelegata = null;
  977.         List<Object> listaFieldId_portaDelegata = jdbcUtilities.executeQuerySingleResult(sqlQueryObjectGet.createSQLQuery(), jdbcProperties.isShowSql(),
  978.                 listaFieldIdReturnType_portaDelegata, searchParams_portaDelegata);
  979.         if(listaFieldId_portaDelegata==null || listaFieldId_portaDelegata.size()<=0){
  980.             if(throwNotFound){
  981.                 throw org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.newNotFoundException();
  982.             }
  983.         }
  984.         else{
  985.             // set _portaDelegata
  986.             id_portaDelegata = new org.openspcoop2.core.commons.search.IdPortaDelegata();
  987.             id_portaDelegata.setNome((String)listaFieldId_portaDelegata.get(0));
  988.             
  989.         }
  990.         
  991.         return id_portaDelegata;
  992.         
  993.     }

  995.     @Override
  996.     public Long findTableId(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, IdPortaDelegata id, boolean throwNotFound)
  997.             throws NotFoundException, ServiceException, NotImplementedException, Exception {
  998.     
  999.         return this.findIdPortaDelegata(jdbcProperties,log,connection,sqlQueryObject,id,throwNotFound);
  1000.             
  1001.     }
  1002.     
  1003.     @Override
  1004.     public List<List<Object>> nativeQuery(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, 
  1005.                                             String sql,List<Class<?>> returnClassTypes,Object ... param) throws ServiceException,NotFoundException,NotImplementedException,Exception{
  1006.         
  1007.         return org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.nativeQuery(jdbcProperties, log, connection, sqlQueryObject,
  1008.                                                                                             sql,returnClassTypes,param);
  1009.                                                         
  1010.     }
  1011.     
  1012.     protected Long findIdPortaDelegata(JDBCServiceManagerProperties jdbcProperties, Logger log, Connection connection, ISQLQueryObject sqlQueryObject, IdPortaDelegata id, boolean throwNotFound) throws NotFoundException, ServiceException, NotImplementedException, Exception {

  1014.         org.openspcoop2.generic_project.dao.jdbc.utils.JDBCPreparedStatementUtilities jdbcUtilities = 
  1015.             new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCPreparedStatementUtilities(sqlQueryObject.getTipoDatabaseOpenSPCoop2(), log, connection);

  1017.         ISQLQueryObject sqlQueryObjectGet = sqlQueryObject.newSQLQueryObject();


  1020.         if(id==null){
  1021.             throw new ServiceException("Id not defined");
  1022.         }
  1023.         if(id.getNome()==null){
  1024.             throw new ServiceException("Id.nome not defined");
  1025.         }

  1027.         // Object _portaDelegata
  1028.         sqlQueryObjectGet.addFromTable(this.getPortaDelegataFieldConverter().toTable(PortaDelegata.model()));
  1029.         sqlQueryObjectGet.addSelectField("id");
  1030.         // Devono essere mappati nella where condition i metodi dell'oggetto id.getXXX
  1031.         sqlQueryObjectGet.setANDLogicOperator(true);
  1032.         sqlQueryObjectGet.setSelectDistinct(true);
  1033.         sqlQueryObjectGet.addWhereCondition(this.getPortaDelegataFieldConverter().toColumn(PortaDelegata.model().NOME,true)+"=?");

  1035.         // Recupero _portaDelegata
  1036.         org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject [] searchParams_portaDelegata = new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject [] { 
  1037.             new org.openspcoop2.generic_project.dao.jdbc.utils.JDBCObject(id.getNome(),String.class)
  1038.         };
  1039.         Long id_portaDelegata = null;
  1040.         try{
  1041.             id_portaDelegata = (Long) jdbcUtilities.executeQuerySingleResult(sqlQueryObjectGet.createSQLQuery(), jdbcProperties.isShowSql(),
  1042.                         Long.class, searchParams_portaDelegata);
  1043.         }catch(NotFoundException notFound){
  1044.             if(throwNotFound){
  1045.                 throw new NotFoundException(notFound);
  1046.             }
  1047.         }
  1048.         if(id_portaDelegata==null || id_portaDelegata<=0){
  1049.             if(throwNotFound){
  1050.                 throw org.openspcoop2.generic_project.dao.jdbc.utils.GenericJDBCUtilities.newNotFoundException();
  1051.             }
  1052.         }
  1053.         
  1054.         return id_portaDelegata;
  1055.     }
  1056. }
Created with JaCoCo 0.8.8.202204050719