Revision 914 org.gvsig.oracle/trunk/org.gvsig.oracle/org.gvsig.oracle.provider/src/test/java/org/gvsig/oracle/dal/OracleSQLBuilderTest.java

View differences:

OracleSQLBuilderTest.java
651 651
        );
652 652
    }
653 653

  
654
    
654
    public void testWhereTRUE() throws Exception {
655
        SQLBuilder sqlbuilder = createSQLBuilder();
656
        GeometryExpressionBuilder expbuilder = sqlbuilder.expression();
657

  
658
        sqlbuilder.update().table().database("master").schema("dbo").name("test1");
659
        sqlbuilder.update().where().set(expbuilder.constant(true));
660
        sqlbuilder.update().column().name("name").with_value(expbuilder.parameter("name"));
661

  
662
        System.out.println("# Test:: testTRUE");
663
        System.out.println("# SQL:: " + sqlbuilder.toString());
664
        System.out.println("# Variables:: " + ArrayUtils.toString(sqlbuilder.variables_names()));
665
        System.out.println("# Parametros:: " + ArrayUtils.toString(sqlbuilder.parameters_names()));
666
        assertEquals(
667
                "UPDATE \"dbo\".\"test1\" SET \"name\" = ? WHERE (1=1)",
668
                sqlbuilder.toString()
669
        );
670
        assertEquals(
671
                "[name]",
672
                ArrayUtils.toString(sqlbuilder.variables_names())
673
        );
674
        assertEquals(
675
                "[\"name\"]",
676
                ArrayUtils.toString(sqlbuilder.parameters_names())
677
        );
678
    }
655 679
}

Also available in: Unified diff