@Test
public void testSelectQueryWithOrderBy() throws Exception {
List<OrderByField> orderByFields = Arrays.asList(OrderByField.of("foo", true),
OrderByField.of("bar"));
MySqlSelectQuery mySqlSelectQuery = new MySqlSelectQuery("topic", orderByFields);
String parametrizedSql = mySqlSelectQuery.getParametrizedSql();
Assert.assertEquals("SELECT * FROM topic ORDER BY `foo` DESC, ORDER BY `bar` ASC", parametrizedSql);
Map<Schema.Field, Object> fieldToObjectMap = new HashMap<>();
fieldToObjectMap.put(new Schema.Field("foo", Schema.Type.LONG), 1);
mySqlSelectQuery = new MySqlSelectQuery(new StorableKey(nameSpace, new PrimaryKey(fieldToObjectMap)), orderByFields);
parametrizedSql = mySqlSelectQuery.getParametrizedSql();
Assert.assertEquals("SELECT * FROM topic WHERE `foo` = ? ORDER BY `foo` DESC, ORDER BY `bar` ASC", parametrizedSql);
}
}