Revision 46505 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
550 550
551 551 
        sqlbuilder.select().column().name("ID");
552 552 
        sqlbuilder.select().column().name("NAME");
553 
        sqlbuilder.select().column().name("DESCRIPTION");
553 
//        sqlbuilder.select().column().name("DESCRIPTION");
554 
        sqlbuilder.select().column().value(
555 
                expbuilder.function(
556 
                        "FOREING_VALUE",
557 
                        expbuilder.constant("TYPE.DESCRIPTION")
558 
                )
559 
        );
554 560 
        sqlbuilder.select().column().name("TYPE");
561 
        sqlbuilder.select().column().name("TYPE").as("TYPE1");
555 562 
        sqlbuilder.select().from().table().schema("dbo").name("test1");
556 563 
        sqlbuilder.select().where().set(
557 564 
            expbuilder.and(
......
571 578 
                )
572 579 
            )
573 580 
        );
581 
        sqlbuilder.select().order_by().column("TYPE");
574 582 
        System.out.println("# Test:: testForeingValue");
575 583 
        System.out.println("# SQL1:: " + sqlbuilder.toString());
576 584 

  		




  ......




  590
  598
  
    
        //# attrNames:: [TYPE.DESCRIPTION, PHONE_TYPE.DESCRIPTION]


  		




  591
  599
  
    

  		




  592
  600
  
    
        assertEquals(


  		




  593
  
  
    
                "SELECT \"dbo\".\"test1\".\"ID\", \"dbo\".\"test1\".\"NAME\", \"dbo\".\"test1\".\"DESCRIPTION\", \"dbo\".\"test1\".\"TYPE\", \"dbo\".\"TYPES\".\"DESCRIPTION\", \"dbo\".\"PHONE_TYPES\".\"DESCRIPTION\" FROM \"dbo\".\"test1\" LEFT JOIN \"dbo\".\"TYPES\" ON ( (\"dbo\".\"test1\".\"TYPE\") = (\"dbo\".\"TYPES\".\"ID\") ) LEFT JOIN \"dbo\".\"PHONE_TYPES\" ON ( (\"dbo\".\"test1\".\"PHONE_TYPE\") = (\"dbo\".\"PHONE_TYPES\".\"ID\") ) WHERE (( (\"dbo\".\"TYPES\".\"DESCRIPTION\") LIKE ('A%') ) AND ( (\"dbo\".\"PHONE_TYPES\".\"DESCRIPTION\") = ('mobile') ))",


  		




  
  601
  
    
                "SELECT \"dbo\".\"test1\".\"ID\", \"dbo\".\"test1\".\"NAME\", \"dbo\".\"TYPES\".\"DESCRIPTION\", \"dbo\".\"test1\".\"TYPE\", \"dbo\".\"test1\".\"TYPE\" AS \"TYPE1\" FROM \"dbo\".\"test1\" LEFT JOIN \"dbo\".\"TYPES\" ON ( (\"dbo\".\"test1\".\"TYPE\") = (\"dbo\".\"TYPES\".\"ID\") ) LEFT JOIN \"dbo\".\"PHONE_TYPES\" ON ( (\"dbo\".\"test1\".\"PHONE_TYPE\") = (\"dbo\".\"PHONE_TYPES\".\"ID\") ) WHERE (( (\"dbo\".\"TYPES\".\"DESCRIPTION\") LIKE ('A%') ) AND ( (\"dbo\".\"PHONE_TYPES\".\"DESCRIPTION\") = ('mobile') )) ORDER BY \"TYPE\" ASC NULLS LAST",


  		




  594
  602
  
    
                sqlbuilder.toString()


  		




  595
  603
  
    
        );


  		




  596
  604
  
    
        assertEquals(


  		




  597
  
  
    
                "[DESCRIPTION, DESCRIPTION, DESCRIPTION, ID, NAME, TYPE]",


  		




  
  605
  
    
                "[DESCRIPTION, DESCRIPTION, ID, NAME, TYPE]",


  		




  598
  606
  
    
                ArrayUtils.toString(sqlbuilder.variables_names())


  		




  599
  607
  
    
        );


  		




  600
  608
  
    
        assertEquals(


  		












Also available in:  Unified diff