Пример #1
0
 @Override
 protected SearchStoredQueries createQuery() throws Exception {
   SearchStoredQueries q = new SearchStoredQueries();
   q.setValue("test");
   Assert.assertEquals(
       "select idquery,count(idstructure) as rows,name,content from query_results join query using(idquery) join sessions using (idsessions) where user_name=SUBSTRING_INDEX(user(),'@',1)  and name regexp ? group by idquery order by idquery desc",
       q.getSQL());
   Assert.assertEquals("^test", q.getValue());
   return q;
 }
Пример #2
0
  @Override
  protected void verify(SearchStoredQueries query, ResultSet rs) throws Exception {
    int count = 0;
    while (rs.next()) {
      IStoredQuery q = query.getObject(rs);

      Assert.assertTrue(
          ((q.getId() == 1) && (q.getName().equals("test query 1")))
              || ((q.getId() == 2) && (q.getName().equals("test query 2"))));
      count++;
    }
    Assert.assertEquals(2, count);
  }