Home | History | Annotate | Download | only in sql

Lines Matching defs:rating

395         String selectQuery = "SELECT rating, SUM(snum) AS sum FROM "
396 + DatabaseCreator.CUSTOMERS_TABLE + " GROUP BY rating";
405 int rating = result.getInt("rating");
407 assertTrue("Wrong value of rating field", values
408 .containsKey(rating));
409 assertEquals("Wrong value of sum field", values.get(rating),
411 assertEquals(new Integer(sum), values.remove(rating));
455 String selectQuery = "SELECT DISTINCT rating FROM "
465 Integer rating = result.getInt("rating");
467 .contains(rating));
468 assertTrue("wrong value in the result set", values.remove(rating));