[prev in list] [next in list] [prev in thread] [next in thread] 

List:       jboss-cvs-commits
Subject:    [jboss-cvs] jbosstest/src/main/org/jboss/test/cmp2/ejbselect ABean.java EJBSelectUnitTestCase.java
From:       Alexey Loubyansky <loubyansky () users ! sourceforge ! net>
Date:       2003-09-30 13:37:01
[Download RAW message or body]

  User: loubyansky
  Date: 03/09/30 06:37:01

  Modified:    src/main/org/jboss/test/cmp2/ejbselect Tag: Branch_3_2
                        ABean.java EJBSelectUnitTestCase.java
  Log:
  added tests for SUM, AVG, MAX, MIN JBossQL functions
  
  Revision  Changes    Path
  No                   revision
  
  
  No                   revision
  
  
  1.5.2.2   +11 -0     jbosstest/src/main/org/jboss/test/cmp2/ejbselect/ABean.java
  
  Index: ABean.java
  ===================================================================
  RCS file: /cvsroot/jboss/jbosstest/src/main/org/jboss/test/cmp2/ejbselect/ABean.java,v
  retrieving revision 1.5.2.1
  retrieving revision 1.5.2.2
  diff -u -r1.5.2.1 -r1.5.2.2
  --- ABean.java	24 Aug 2003 16:34:09 -0000	1.5.2.1
  +++ ABean.java	30 Sep 2003 13:37:01 -0000	1.5.2.2
  @@ -44,6 +44,17 @@
      public abstract void setId(String id);

   

      /**

  +    * @ejb.persistent-field

  +    * @ejb.interface-method

  +    * @ejb.persistence  column-name="INT_FIELD"

  +    */

  +   public abstract int getIntField();

  +   /**

  +    * @ejb.interface-method

  +    */

  +   public abstract void setIntField(int value);

  +

  +   /**

       * @ejb.relation

       *    name="A-B"

       *    role-name="A-has-Bs"

  
  
  
  1.7.2.2   +34 -0     jbosstest/src/main/org/jboss/test/cmp2/ejbselect/EJBSelectUnitTestCase.java
  
  Index: EJBSelectUnitTestCase.java
  ===================================================================
  RCS file: /cvsroot/jboss/jbosstest/src/main/org/jboss/test/cmp2/ejbselect/EJBSelectUnitTestCase.java,v
  retrieving revision 1.7.2.1
  retrieving revision 1.7.2.2
  diff -u -r1.7.2.1 -r1.7.2.2
  --- EJBSelectUnitTestCase.java	24 Aug 2003 16:34:09 -0000	1.7.2.1
  +++ EJBSelectUnitTestCase.java	30 Sep 2003 13:37:01 -0000	1.7.2.2
  @@ -38,6 +38,7 @@
         BLocalHome bhome = BUtil.getLocalHome();

   

         a1 = ahome.create("A1");

  +      a1.setIntField(3);

         Collection bs = a1.getBs();

         b1 = bhome.create("B1", "Alice", true);

         bs.add(b1);

  @@ -49,6 +50,7 @@
         bs.add(b4);

   

         a2 = ahome.create("A2");

  +      a2.setIntField(9);

      }

   

      public void tearDownEJB() throws Exception

  @@ -173,6 +175,38 @@
            "SELECT COUNT(b.id) FROM B AS b", new Object[]{}

         );

         assertTrue("COUNT(b.id) = 4", ((Long)result.iterator().next()).longValue() == 4);

  +   }

  +

  +   public void testMaxInSelectClause() throws Exception

  +   {

  +      Collection result = BUtil.getLocalHome().selectDynamic(

  +         "SELECT MAX(a.intField) FROM A AS a", new Object[]{}

  +      );

  +      assertTrue("MAX(a.id) = 9", ((Double)result.iterator().next()).doubleValue() == 9.0);

  +   }

  +

  +   public void testMinInSelectClause() throws Exception

  +   {

  +      Collection result = BUtil.getLocalHome().selectDynamic(

  +         "SELECT MIN(a.intField) FROM A AS a", new Object[]{}

  +      );

  +      assertTrue("MIN(a.id) = 3", ((Double)result.iterator().next()).doubleValue() == 3.0);

  +   }

  +

  +   public void testSumInSelectClause() throws Exception

  +   {

  +      Collection result = BUtil.getLocalHome().selectDynamic(

  +         "SELECT SUM(a.intField) FROM A AS a", new Object[]{}

  +      );

  +      assertTrue("SUM(a.id) = 12", ((Double)result.iterator().next()).doubleValue() == 12.0);

  +   }

  +

  +   public void testAvgInSelectClause() throws Exception

  +   {

  +      Collection result = BUtil.getLocalHome().selectDynamic(

  +         "SELECT AVG(a.intField) FROM A AS a", new Object[]{}

  +      );

  +      assertTrue("AVG(a.id) = 6", ((Double)result.iterator().next()).doubleValue() == 6.0);

      }

   

      public void testSqrtInSelectClause() throws Exception

  
  
  


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
jboss-cvs-commits mailing list
jboss-cvs-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-cvs-commits
[prev in list] [next in list] [prev in thread] [next in thread]