@Test(enabled = false, groups = "p2") // 目前测试环境没有该功能代码
  public void category_and_query() {
    long d = System.currentTimeMillis();
    DBAction dba = new DBAction();
    dba.setFuncCondition("module = 'q_and_c'");
    dba.setFvpCondition("fvp_id = 29");
    List<FuncCatePath> categorys = dba.getFuncCatePath();
    List<FuncVP> fvps = dba.getFVP();
    String subject = "【搜索后台自动化测试】基础功能回归测试结果";
    StringBuffer content = new StringBuffer();
    content.append(
        "<html><head><meta http-equiv=Content-Type content='text/html; charset=utf-8'></head><body><table border=1 cellspacing=0 cellpadding=0><tr><th>功能模块</th><th>通过category</th><th>失败category</th><th>跳过category</th><th>总计</th><th>耗时</th></tr>");
    for (FuncVP fvp : fvps) {
      int passed = 0, failed = 0, skiped = 0;
      for (FuncCatePath category : categorys) {
        int rt = doQuery(category, fvp);
        switch (rt) {
          case 0:
            passed += 1;
            break;
          case -1:
            failed += 1;
            break;
          case -2:
            skiped += 1;
            break;

          default:
            failed += 1;
            break;
        }
      }
      logger.fatal(
          String.format(
              " - [LOG_SUMMARY] - vp: %s, passed: %s, failed: %s, skiped: %s",
              fvp.getFvpname(), passed, failed, skiped));
      long d2 = System.currentTimeMillis();
      int d4 = (int) ((d2 - d) / 60000 + 1);
      logger.fatal("总耗时:" + d4 + "分钟");
      String d3 = String.valueOf(d4) + "分钟";
      content.append(
          String.format(
              "<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>",
              fvp.getFvpname(), passed, failed, skiped, passed + failed + skiped, d3));
    }
    content.append("</table></body></html>");
    Utils.sendMail(subject, content.toString(), "HTML");
  }