Revision 914
org.gvsig.oracle/trunk/org.gvsig.oracle/org.gvsig.oracle.provider/src/main/java/org/gvsig/oracle/dal/expressionbuilderformatter/OracleConstant.java | ||
---|---|---|
38 | 38 |
@Override |
39 | 39 |
public String format(ExpressionBuilder.Value function) { |
40 | 40 |
Object value = ((Constant) function).value(); |
41 |
if (value instanceof Geometry) { |
|
41 |
if( value instanceof Boolean ) { |
|
42 |
if( (Boolean)value ) { |
|
43 |
return "(1=1)"; |
|
44 |
} |
|
45 |
return "(1<>1)"; |
|
46 |
} else if (value instanceof Geometry) { |
|
42 | 47 |
Geometry geom = (Geometry) value; //function; |
43 | 48 |
try { |
44 | 49 |
switch (this.builder.geometry_support_type()) { |
org.gvsig.oracle/trunk/org.gvsig.oracle/org.gvsig.oracle.provider/src/test/java/org/gvsig/oracle/dal/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