package org.synchronoss.cpo.jdbc.adapter;
   
   /*-
    * [[
    * jdbc
    * ==
    * Copyright (C) 2003 - 2026 Exaxis LLC, Synchronoss Technologies Inc
    * ==
    * This program is free software: you can redistribute it and/or modify
   * it under the terms of the GNU Lesser General Public License as
   * published by the Free Software Foundation, either version 3 of the
   * License, or (at your option) any later version.
   *
   * This program is distributed in the hope that it will be useful,
   * but WITHOUT ANY WARRANTY; without even the implied warranty of
   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   * GNU General Lesser Public License for more details.
   *
   * You should have received a copy of the GNU General Lesser Public
   * License along with this program.  If not, see
   * <http://www.gnu.org/licenses/lgpl-3.0.html>.
   * ]]
   */
  
  import static org.testng.Assert.*;
  
  import org.slf4j.Logger;
  import org.slf4j.LoggerFactory;
  import org.synchronoss.cpo.core.CpoAdapterFactoryManager;
  import org.synchronoss.cpo.core.CpoQuery;
  import org.synchronoss.cpo.core.CpoTrxAdapter;
  import org.synchronoss.cpo.core.helper.ExceptionHelper;
  import org.synchronoss.cpo.jdbc.ValueObject;
  import org.testng.annotations.AfterClass;
  import org.testng.annotations.BeforeClass;
  import org.testng.annotations.Parameters;
  import org.testng.annotations.Test;
  
  /**
   * BlobTest is a test class for testing the JdbcAdapter class Constructors
   *
   * @author david berry
   */
  public class ExecuteTrxTest {
  
    // unique id base so this class's rows never collide with another test class's
    private static final int IDB = 1000000;
  
    private static final Logger logger = LoggerFactory.getLogger(ExecuteTrxTest.class);
    //  private CpoAdapter cpoAdapter = null;
    private CpoTrxAdapter trxAdapter = null;
    private boolean isSupportsCalls = true;
  
    /** Creates a new RollbackTest object. */
    public ExecuteTrxTest() {}
  
    /**
     * <code>setUp</code> Load the datasource from the properties in the property file
     * jdbc_en_US.properties
     */
    @Parameters({"db.callsupport"})
    @BeforeClass
    public void setUp(boolean callSupport) {
      String method = "setUp:";
      isSupportsCalls = callSupport;
  
      try {
        //      cpoAdapter = CpoAdapterFactoryManager.getCpoAdapter(JdbcStatics.ADAPTER_CONTEXT_JDBC);
        trxAdapter = CpoAdapterFactoryManager.getCpoTrxAdapter(JdbcStatics.ADAPTER_CONTEXT_JDBC);
        //      assertNotNull(method + "CpoAdapter is null", cpoAdapter);
        assertNotNull(trxAdapter, method + "trxAdapter is null");
      } catch (Exception e) {
        fail(method + e.getMessage());
      }
    }
  
    /** DOCUMENT ME! */
    @AfterClass
    public void tearDown() {
      try {
        trxAdapter.close();
      } catch (Exception e) {
      }
      trxAdapter = null;
    }
  
    /** DOCUMENT ME! */
    @Test
    public void testExecuteTrx() {
      if (isSupportsCalls) {
        String method = "testExecuteTrx:";
        ValueObject vo = ValueObjectFactory.createValueObject(IDB + 1);
        vo.setAttrInteger(3);
        ValueObject rvo;
  
        try {
          rvo = trxAdapter.executeBean(ValueObject.FG_EXECUTE_TESTEXECUTEOBJECT, vo);
          trxAdapter.commit();
          assertNotNull(rvo, method + "Returned Value object is null");
         assertEquals(rvo.getAttrDouble(), 27, "power(3,3)=" + rvo.getAttrDouble());
       } catch (Exception e) {
         try {
           trxAdapter.rollback();
         } catch (Exception ex) {
         }
         logger.error(ExceptionHelper.getLocalizedMessage(e));
         fail(method + e.getMessage());
       }
 
       try {
         vo = ValueObjectFactory.createValueObject(IDB + 1);
         vo.setAttrSmallInt((short) 3);
         rvo = trxAdapter.executeBean(ValueObject.FG_EXECUTE_TESTEXECUTEOBJECTNOTRANSFORM, vo);
         trxAdapter.commit();
         assertNotNull(method + "Returned Value object is null");
         assertEquals(rvo.getAttrDouble(), 27, "power(3,3)=" + rvo.getAttrDouble());
       } catch (Exception e) {
         try {
           trxAdapter.rollback();
         } catch (Exception ex) {
         }
         logger.error(ExceptionHelper.getLocalizedMessage(e));
         fail(method + e.getMessage());
       }
     } else {
       logger.error(trxAdapter.getDataSourceName() + " does not support CallableStatements");
     }
   }
 
   @Test
   public void testExecute2() {
     if (isSupportsCalls) {
       String method = "testExecuteObject:";
       ValueObject vo = ValueObjectFactory.createValueObject(IDB + 1);
       vo.setAttrInteger(3);
       ValueObject rvo;
 
       try {
         rvo =
             trxAdapter.executeBean(
                 CpoQuery.group(ValueObject.FG_EXECUTE_TESTEXECUTEOBJECT), vo, vo);
         trxAdapter.commit();
         assertNotNull(method + "Returned Value object is null");
         assertEquals(rvo.getAttrDouble(), 27, "power(3,3)=" + rvo.getAttrDouble());
       } catch (Exception e) {
         try {
           trxAdapter.rollback();
         } catch (Exception ex) {
         }
         logger.error(ExceptionHelper.getLocalizedMessage(e));
         fail(method + e.getMessage());
       }
     }
   }
 }