/**
* Test method for {@link org.melati.poem.dbms.Dbms# givesCapabilitySQL(java.lang.Integer,
* java.lang.String)}.
*/
public void testGivesCapabilitySQL() {
String actual = it.givesCapabilitySQL(new Integer(42), "hello");
String expected =
"SELECT * FROM "
+ it.getQuotedName("groupmembership")
+ " WHERE "
+ it.getQuotedName("user")
+ " = 42 AND "
+ "EXISTS ( SELECT "
+ it.getQuotedName("groupcapability")
+ "."
+ it.getQuotedName("group")
+ " FROM "
+ it.getQuotedName("groupcapability")
+ " WHERE "
+ it.getQuotedName("groupcapability")
+ "."
+ it.getQuotedName("group")
+ " = "
+ it.getQuotedName("groupmembership")
+ "."
+ it.getQuotedName("group")
+ " AND "
+ it.getQuotedName("capability")
+ " = hello)";
assertEquals(expected, actual);
}
