Revision 914 org.gvsig.oracle/trunk/org.gvsig.oracle/org.gvsig.oracle.provider/src/test/java/org/gvsig/oracle/dal/OracleSQLBuilderTest.java
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