db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From b..@apache.org
Subject cvs commit: db-ojb/src/test/org/apache/ojb/broker QueryTest.java
Date Fri, 14 Jan 2005 20:49:42 GMT
brj         2005/01/14 12:49:42

  Modified:    src/test/org/apache/ojb/broker Tag: OJB_1_0_RELEASE
                        QueryTest.java
  Log:
  added testcase for attributes in expressions (price + 1.0)
  
  Revision  Changes    Path
  No                   revision
  No                   revision
  1.61.2.8  +21 -0     db-ojb/src/test/org/apache/ojb/broker/QueryTest.java
  
  Index: QueryTest.java
  ===================================================================
  RCS file: /home/cvs/db-ojb/src/test/org/apache/ojb/broker/QueryTest.java,v
  retrieving revision 1.61.2.7
  retrieving revision 1.61.2.8
  diff -u -r1.61.2.7 -r1.61.2.8
  --- QueryTest.java	12 Dec 2004 01:35:12 -0000	1.61.2.7
  +++ QueryTest.java	14 Jan 2005 20:49:41 -0000	1.61.2.8
  @@ -11,6 +11,7 @@
   import java.util.Vector;
   
   import org.apache.commons.lang.time.StopWatch;
  +import org.apache.ojb.broker.accesslayer.sql.SqlGenerator;
   import org.apache.ojb.broker.metadata.ClassDescriptor;
   import org.apache.ojb.broker.platforms.PlatformHsqldbImpl;
   import org.apache.ojb.broker.query.Criteria;
  @@ -1542,6 +1543,26 @@
           // Groups: 3 Books , 1 Dairy Product
           assertEquals("check size", list.size(), 2);
       }
  +
  +    /**
  +     * ReportQuery with Expression in column need to add table alias to the field (price)
  +     **/
  +    public void testReportQueryExpressionInStatement()
  +    {
  +        // TODO: make path expressions extent aware
  +        if(ojbSkipKnownIssueProblem("Resolve attributes of expressions")) return;
  +
  +        Criteria crit = new Criteria();
  +        ReportQueryByCriteria q = QueryFactory.newReportQuery(Article.class, crit);
  +        q.setAttributes(new String[]{"articleId", "price + 0"});
  +        ClassDescriptor cd = broker.getClassDescriptor(q.getBaseClass());
  +        SqlGenerator sqlg = broker.serviceSqlGenerator();
  +        String sql = sqlg.getPreparedSelectStatement(q, cd);
  +        
  +        assertTrue("Bad query generated. the 'price' field has not table prefix. SQL Output:
" + sql, sql
  +                .equalsIgnoreCase("SELECT A0.Artikel_Nr,A0.PRICE + 0 FROM Artikel A0"));
  +    }
  +     
   
       /**
        * Test pathExpression and Extents
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Mime
View raw message