/** * 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); }