public void testSelectLiteral() { StringProperty literal = StringProperty.literal("literal", "name"); LongProperty literalLong = LongProperty.literal(12, "twelve"); SquidCursor<?> c = database.query(null, Query.select(literal, literalLong)); try { assertEquals(1, c.getCount()); c.moveToFirst(); assertEquals("literal", c.get(literal)); assertEquals(12, c.get(literalLong).longValue()); } finally { if (c != null) { c.close(); } } }
public void testLiteralProperties() { StringProperty stringLiteral = StringProperty.literal("abc", "strLit"); assertEquals("SELECT 'abc' AS strLit", Query.select(stringLiteral).toString()); IntegerProperty intLiteral = IntegerProperty.literal(1, "intLit"); assertEquals("SELECT 1 AS intLit", Query.select(intLiteral).toString()); long longVal = System.currentTimeMillis(); LongProperty longLiteral = LongProperty.literal(longVal, "longLit"); assertEquals("SELECT " + longVal + " AS longLit", Query.select(longLiteral).toString()); DoubleProperty doubleLiteral = DoubleProperty.literal(1.1, "doubleLit"); assertEquals("SELECT 1.1 AS doubleLit", Query.select(doubleLiteral).toString()); BooleanProperty trueLiteral = BooleanProperty.literal(true, "trueLit"); assertEquals("SELECT 1 AS trueLit", Query.select(trueLiteral).toString()); BooleanProperty falseLiteral = BooleanProperty.literal(false, "falseLit"); assertEquals("SELECT 0 AS falseLit", Query.select(falseLiteral).toString()); EnumProperty enumLiteral = EnumProperty.literal(TestEnum.APPLE, "enumLit"); assertEquals("SELECT 'APPLE' AS enumLit", Query.select(enumLiteral).toString()); }