Revision 44682 trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.db/org.gvsig.fmap.dal.db.jdbc/src/test/java/org/gvsig/fmap/dal/store/jdbc2/SQLBuilderTest.java

View differences:

SQLBuilderTest.java
1 1 
package org.gvsig.fmap.dal.store.jdbc2;
2 2 

  		




  
  3
  
    
import java.util.ArrayList;


  		




  
  4
  
    
import java.util.List;


  		




  3
  5
  
    
import junit.framework.TestCase;


  		




  
  6
  
    
import org.apache.commons.collections.CollectionUtils;


  		




  
  7
  
    
import org.apache.commons.collections.ListUtils;


  		




  4
  8
  
    
import org.apache.commons.lang3.ArrayUtils;


  		




  
  9
  
    
import org.apache.commons.lang3.StringUtils;


  		




  5
  10
  
    
import org.cresques.cts.IProjection;


  		




  6
  11
  
    
import org.gvsig.expressionevaluator.ExpressionBuilder;


  		




  7
  12
  
    
import org.gvsig.expressionevaluator.GeometryExpressionBuilder;


  		




  ......




  568
  573
  
    
        System.out.println("# Test:: testForeingValue");


  		




  569
  574
  
    
        System.out.println("# SQL1:: " + sqlbuilder.toString());        


  		




  570
  575
  
    

  		




  571
  
  
    
        String[] attrNames = helper.replaceForeingValueFunction(sqlbuilder, ft);


  		




  
  576
  
    
        List<String> attrNames = new ArrayList<>();


  		




  
  577
  
    
        helper.replaceForeingValueFunction(sqlbuilder, ft, attrNames);


  		




  572
  578
  
    
        


  		




  573
  579
  
    
        System.out.println("# SQL2:: " + sqlbuilder.toString());


  		




  574
  580
  
    
        System.out.println("# Variables:: " + ArrayUtils.toString(sqlbuilder.variables_names()));


  		




  575
  581
  
    
        System.out.println("# Parametros:: " + ArrayUtils.toString(sqlbuilder.parameters_names()));


  		




  576
  
  
    
        System.out.println("# attrNames:: " + ArrayUtils.toString(attrNames));


  		




  
  582
  
    
        System.out.println("# attrNames:: " + StringUtils.join(attrNames,","));


  		




  577
  583
  
    

  		




  578
  584
  
    
        //# Test:: testForeingValue


  		




  579
  585
  
    
        //# SQL1:: SELECT "ID", "NAME", "DESCRIPTION", "TYPE" FROM "dbo"."test1" WHERE (( (FOREING_VALUE('TYPE.DESCRIPTION')) LIKE ('A%') ) AND ( (FOREING_VALUE('PHONE_TYPE.DESCRIPTION')) = ('mobile') ))


  		




  ......




  595
  601
  
    
                ArrayUtils.toString(sqlbuilder.parameters_names())


  		




  596
  602
  
    
        );


  		




  597
  603
  
    
        assertEquals(


  		




  598
  
  
    
                "{TYPE.DESCRIPTION,PHONE_TYPE.DESCRIPTION}",


  		




  599
  
  
    
                ArrayUtils.toString(attrNames)


  		




  
  604
  
    
                "TYPE.DESCRIPTION,PHONE_TYPE.DESCRIPTION",


  		




  
  605
  
    
                StringUtils.join(attrNames,",")


  		




  600
  606
  
    
        );


  		




  601
  607
  
    
    }


  		




  602
  608
  
    
    


  		












Also available in:  Unified diff