package org.synchronoss.cpo.cassandra;
   
   /*-
    * [[
    * cassandra
    * ==
    * 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 java.util.ArrayList;
  import java.util.Collection;
  import org.synchronoss.cpo.core.CpoAdapter;
  import org.synchronoss.cpo.core.CpoAdapterFactoryManager;
  import org.synchronoss.cpo.core.CpoOrderBy;
  import org.testng.annotations.AfterClass;
  import org.testng.annotations.BeforeClass;
  import org.testng.annotations.Test;
  
  /**
   * BlobTest is a test class for testing the JdbcAdapter class Constructors
   *
   * @author david berry
   */
  public class OrderByTest {
  
    // unique id base so this class's rows never collide with another test class's
    private static final int IDB = 900000;
  
    private CpoAdapter cpoAdapter = null;
    private ArrayList<ValueObject> al = new ArrayList<>();
  
    public OrderByTest() {}
  
    /**
     * <code>setUp</code> Load the datasource from the properties in the property file
     * jdbc_en_US.properties
     */
    @BeforeClass
    public void setUp() {
      String method = "setUp:";
  
      try {
        cpoAdapter = CpoAdapterFactoryManager.getCpoAdapter(CassandraStatics.ADAPTER_CONTEXT_DEFAULT);
        assertNotNull(cpoAdapter, method + "CpoAdapter is null");
        // Add the test valueObjects
      } catch (Exception e) {
        fail(method + e.getMessage());
      }
  
      al.add(ValueObjectFactory.createValueObject(IDB + 1));
      al.add(ValueObjectFactory.createValueObject(IDB + 2));
      al.add(ValueObjectFactory.createValueObject(IDB + 3));
      al.add(ValueObjectFactory.createValueObject(IDB + 4));
      al.add(ValueObjectFactory.createValueObject(IDB + 5));
      try {
        cpoAdapter.insertBeans("TestOrderByInsert", al);
      } catch (Exception e) {
        fail(method + e.getMessage());
      }
    }
  
    @AfterClass
    public void tearDown() {
      String method = "tearDown:";
      try {
        cpoAdapter.deleteBeans("TestOrderByDelete", al);
      } catch (Exception e) {
        fail(method + e.getMessage());
      }
      cpoAdapter = null;
    }
  
    @Test
    public void testNewOrderBy() {
      String method = "testOrderByAscending:";
      Collection<ValueObject> col;
      String marker = "MY_MARKER";
      String attribute = "MY_ATTRIBUTE";
      String function = "MY_FUNCTION";
      boolean ascending = false;
  
      try {
       CpoOrderBy cob = cpoAdapter.newOrderBy(marker, attribute, ascending, function);
       assertEquals(marker, cob.getMarker());
       assertEquals(attribute, cob.getAttribute());
       assertEquals(ascending, cob.getAscending());
       assertEquals(function, cob.getFunction());
     } catch (Exception e) {
       fail(method + e.getMessage());
     }
   }
 
   /** TODO - add back in when you get the tables correct */
   @Test
   public void testOrderByAscending() {
     //    String method = "testOrderByAscending:";
     //    Collection<ValueObject> col;
     //
     //
     //    try {
     //      Collection<Integer> inColl = new ArrayList<Integer>();
     //      inColl.add(new Integer(1));
     //      inColl.add(new Integer(3));
     //      inColl.add(new Integer(5));
     //
     ////      CpoWhere cw = cpoAdapter.newWhere();
     //      CpoWhere cw = cpoAdapter.newWhere(Logical.NONE, "id", Comparison.IN, inColl);
     //      ArrayList<CpoWhere> wheres = new ArrayList<CpoWhere>();
     //      wheres.add(cw);
     //
     //      CpoOrderBy cob = cpoAdapter.newOrderBy("id", true);
     //      Collection<CpoOrderBy> colCob = new ArrayList<CpoOrderBy>();
     //      colCob.add(cob);
     //      ValueObject valObj = ValueObjectFactory.createValueObject();
     //      col = cpoAdapter.retrieveBeans("TestOrderByRetrieve", valObj, wheres, colCob);
     //
     //      int id = 1;
     //      for (ValueObject vo : col) {
     //        assertEquals(id, vo.getId());
     //        id++;
     //      }
     //    } catch (Exception e) {
     //      fail(method + e.getMessage());
     //    }
   }
 
   /** TODO - add back in when you get the tables correct */
   @Test
   public void testOrderByDescending() {
     //    String method = "testOrderByDescending:";
     //    List<ValueObject> col;
     //
     //    try {
     //      CpoOrderBy cob = cpoAdapter.newOrderBy("id", false, null);
     //      CpoOrderBy cob2 = cpoAdapter.newOrderBy(CpoOrderBy.DEFAULT_MARKER, "attrVarChar", false,
     // null);
     //      Collection<CpoOrderBy> colCob = new ArrayList<CpoOrderBy>();
     //      colCob.add(cob);
     //      colCob.add(cob2);
     //      ValueObject valObj = ValueObjectFactory.createValueObject();
     //      col = cpoAdapter.retrieveBeans("TestOrderByRetrieve", valObj, colCob);
     //      int id = 5;
     //      for (ValueObject vo : col) {
     //        assertEquals(id, vo.getId());
     //        id--;
     //      }
     //    } catch (Exception e) {
     //      fail(method + e.getMessage());
     //    }
   }
 
   @Test
   public void testOrderByFunction() {
     //    String method = "testOrderByAscending:";
     //    Collection<ValueObject> col;
     //
     //    ValueObject vobj = ValueObjectFactory.createValueObject(IDB + -6);
     //    try {
     //      cpoAdapter.insertObject("TestOrderByInsert", vobj);
     //    } catch (Exception e) {
     //      fail(method + e.getMessage());
     //    }
     //    try {
     //      CpoOrderBy cob = cpoAdapter.newOrderBy("id", true, "ABS(id)");
     //      Collection<CpoOrderBy> colCob = new ArrayList<CpoOrderBy>();
     //      colCob.add(cob);
     //      ValueObject valObj = ValueObjectFactory.createValueObject();
     //      col = cpoAdapter.retrieveBeans("TestOrderByRetrieve", valObj, colCob);
     //
     //      int id = 1;
     //      for (ValueObject vo : col) {
     //        int voId = vo.getId();
     //        if (voId < 0) {
     //          voId *= -1;
     //        }
     //        assertEquals(id, voId);
     //        id++;
     //      }
     //    } catch (Exception e) {
     //      fail(method + e.getMessage());
     //    }
     //
     //    try {
     //      cpoAdapter.deleteObject("TestOrderByDelete", vobj);
     //
     //    } catch (Exception e) {
     //      fail(method + e.getMessage());
     //    }
   }
 }