@Test
public void testSubsituteSql()
{

    Map<String, String> variables = new HashMap<>();
    variables.put( "level", "4" );
    variables.put( "id", "abc" );
    String sql = "select * from datavalue where level=${level} and id='${id}'";
    String expected = "select * from datavalue where level=4 and id='abc'";
    String actual = SqlViewUtils.substituteSqlVariables( sql, variables );
    assertEquals( expected, actual );
}