public void testBuildLikeIn() { log("to test buildLikeIn()... "); String[] values = {"a", "b", "c"}; ISQLLogic logic = SQLLogicBuilder.buildLikeIn("field", values); String strSQL = logic.toSQL(null); System.out.println(strSQL); assertEquals("((field LIKE '%a%') OR (field LIKE '%b%') OR (field LIKE '%c%'))", strSQL); }
public void testAnd() { log("to test and()... "); ISQLLogic logic1 = SQLLogicBuilder.build("field", SQLOperator.GREATER_OR_EQUAL, 100); ISQLLogic logic2 = SQLLogicBuilder.build("filed", SQLOperator.NOT_EQUAL, false); // 1. and TRUE ISQLLogic logic = SQLLogicBuilder.and(logic1, SQLLogicString.TRUE); List params = new ArrayList(); assertTrue(logic == logic1); // 2. and FALSE logic = SQLLogicBuilder.and(logic1, SQLLogicString.FALSE); assertTrue(logic == SQLLogicString.FALSE); // 3. TRUE and logic = SQLLogicBuilder.and(SQLLogicString.TRUE, logic2); assertTrue(logic == logic2); // 4. FALSE and logic = SQLLogicBuilder.and(SQLLogicString.FALSE, logic2); assertTrue(logic == SQLLogicString.FALSE); // 5. 1 and 2 logic = SQLLogicBuilder.and(logic1, logic2); params.clear(); assertEquals("field>=? AND filed<>?", logic.toSQL(params)); }
/* * Class under test for ISQLLogic build(String, int, int, Object) */ public void testBuildStringintintObject() { Object values = new String[] {"1000", "150000"}; ISQLLogic logic = SQLLogicBuilder.build("total", SQLOperator.BETWEEN, DataTypes.DOUBLE, values); List params = new ArrayList(2); System.out.println("SQL=" + logic.toSQL(params)); for (int i = 0; i < params.size(); i++) { System.out.println("[param-" + i + "]=" + params.get(i).toString()); } }
public void testBuildIn() { Object[][] data = { // {new String[] {"a", "b", "c"}, "(f IN ('a','b','c'))"}, // {new String[] {"a", "b", null}, "((f IN ('a','b')) OR (f IS NULL))"}, // }; for (int i = 0; i < data.length; i++) { ISQLLogic logic = SQLLogicBuilder.buildIn("f", DataTypes.STRING, (Object[]) data[i][0]); String strSQL = logic.toSQL(null); System.out.println("[" + i + "]SQL=" + strSQL); assertEquals((String) data[i][1], strSQL); } }
public void testBuildInclude() { Object[] values = new Object[] { // new String[] {"a"}, // new String[] {"a", "b"}, // new String[] {"a", "b", "c"}, // }; for (int i = 0; i < values.length; i++) { ISQLLogic logic = SQLLogicBuilder.buildInclude("embodyType", (Object[]) values[i]); System.out.println("[" + i + "]SQL=" + logic.toSQL(null)); } }
public void testBuildMultiple() { String[] values = {"a", "b", "c"}; ISQLLogic logic = SQLLogicBuilder.build("x", SQLOperator.START_WITH, DataTypes.STRING, values); System.out.println(logic.toSQL(null)); }