public int intForQuery(String querySql) { Number result = SQLSelect.scalarQuery(Number.class, querySql).selectOne(newContext()); return result != null ? result.intValue() : -1; }
public long longForQuery(String querySql) { Number result = SQLSelect.scalarQuery(Number.class, querySql).selectOne(newContext()); return result != null ? result.longValue() : -1; }
public String stringForQuery(String querySql) { return SQLSelect.scalarQuery(String.class, querySql).selectOne(newContext()); }
@Test public void testPost_WriteConstraints_Id_Allowed() { ObjectContext context = newContext(); Response r1 = target("/e8/w/constrainedid/578").request() .post(Entity.json("{\"name\":\"zzz\"}")); assertEquals(Status.CREATED.getStatusCode(), r1.getStatus()); assertEquals(Integer.valueOf(1), SQLSelect.scalarQuery(Integer.class, "SELECT count(1) FROM utest.e8").selectOne(context)); assertEquals("zzz", SQLSelect.scalarQuery(String.class, "SELECT name FROM utest.e8").selectOne(context)); assertEquals(578, intForQuery("SELECT id FROM utest.e8")); }
chain.addQuery(SQLSelect.scalarQuery(Object.class, "delete from utest.e15_e5"));