示例#1
0
  @Test
  public void createAndQueryPageTest() throws Exception {
    final int COUNT = 35;
    for (int i = 0; i < COUNT; i++) {
      final Writer w = LibraryModelPackage.MODELFACTORY.createWriter();
      w.setName("name" + i); // $NON-NLS-1$
      final String content = serialize(w);
      doContentRequest(
          ModelUtils.getQualifiedNameFromEClass(LibraryModelPackage.INSTANCE.getWriterEClass()),
          content,
          HttpServletResponse.SC_OK,
          null,
          HttpMethod.POST);
    }

    // get all the writers which start with a 2, in total there are 11 (the ones 20-29 and 2)
    {
      final String wsPartUrl =
          ModelUtils.getQualifiedNameFromEClass(LibraryModelPackage.INSTANCE.getWriterEClass())
              + "?query=" //$NON-NLS-1$
              + URLEncoder.encode("select e from library_Writer e where e.name like :name", "UTF-8")
              + "&firstResult=0" //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
              + "&maxResults=5&childLevels=3&qp.name="
              + URLEncoder.encode("name2%", "UTF-8"); // $NON-NLS-1$
      final String content = doGetRequest(wsPartUrl, null, HttpServletResponse.SC_OK);
      final ResponseType result = (ResponseType) deserialize(content).get(0);
      Assert.assertEquals(11, result.getTotalRows());
      Assert.assertEquals(5, result.getData().size());
      Assert.assertEquals(4, result.getEndRow());
      for (Object o : result.getData()) {
        Writer w = (Writer) o;
        Assert.assertTrue(w.getName().startsWith("name2")); // $NON-NLS-1$
      }
    }

    // query for an array of results, writer, name
    if (!isXmlTest()) {
      final String wsPartUrl =
          ModelUtils.getQualifiedNameFromEClass(LibraryModelPackage.INSTANCE.getWriterEClass())
              + "?query=" //$NON-NLS-1$
              + URLEncoder.encode(
                  "select e, e.name from library_Writer e where e.name like :name", "UTF-8")
              + "&firstResult=0" //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
              + "&maxResults=5&childLevels=3&qp.name="
              + URLEncoder.encode("name2%", "UTF-8"); // $NON-NLS-1$
      final String content = doGetRequest(wsPartUrl, null, HttpServletResponse.SC_OK);
      final ResponseType result = (ResponseType) deserialize(content).get(0);
      for (Object o : result.getData()) {
        Object[] os = (Object[]) o;

        Writer w = (Writer) os[0];
        String name = (String) os[1];

        Assert.assertTrue(w.getName().startsWith("name2")); // $NON-NLS-1$
        Assert.assertEquals(name, w.getName());
      }
    }

    // test querytype
    if (!isXmlTest()) {
      final QueryType queryType = RequestModelPackage.INSTANCE.getModelFactory().createQueryType();
      queryType.setQuery("select e, e.name from library_Writer e where e.name like :name");
      // test named query, add this snippet to library-orm.xml:
      // <orm:named-query name="testWriter">
      // <orm:query>select e, e.name from Writer e where e.name like :name</orm:query>
      // </orm:named-query>
      // queryType.setNamedQuery("testWriter");
      final Parameter parameter = RequestModelPackage.INSTANCE.getModelFactory().createParameter();
      parameter.setName("name");
      parameter.setValue("name2%");
      queryType.getParameters().add(parameter);

      final String content = serialize(queryType);
      final String resultStr =
          doContentRequest(
              "?" + ServiceConstants.PARAM_RETRIEVAL + "=true",
              content,
              HttpServletResponse.SC_OK,
              null,
              HttpMethod.POST);
      final ResponseType result = (ResponseType) deserialize(resultStr).get(0);
      Assert.assertEquals(11, result.getTotalRows());
      Assert.assertEquals(11, result.getData().size());
      for (Object o : result.getData()) {
        final Object[] os = (Object[]) o;
        Writer w = (Writer) os[0];
        String n = (String) os[1];
        Assert.assertTrue(w.getName().startsWith("name2")); // $NON-NLS-1$
        Assert.assertEquals(n, w.getName());
      }
    }

    // named query with post
    if (!isXmlTest()) {
      final QueryType queryType = RequestModelPackage.INSTANCE.getModelFactory().createQueryType();
      queryType.setNamedQuery("testWriter");
      final Parameter parameter = RequestModelPackage.INSTANCE.getModelFactory().createParameter();
      parameter.setName("name");
      parameter.setValue("name2%");
      queryType.getParameters().add(parameter);

      final String content = serialize(queryType);
      final String resultStr =
          doContentRequest(
              "?" + ServiceConstants.PARAM_RETRIEVAL + "=true",
              content,
              HttpServletResponse.SC_OK,
              null,
              HttpMethod.POST);
      final ResponseType result = (ResponseType) deserialize(resultStr).get(0);
      Assert.assertEquals(11, result.getTotalRows());
      Assert.assertEquals(11, result.getData().size());
      for (Object o : result.getData()) {
        final Object[] os = (Object[]) o;
        Writer w = (Writer) os[0];
        String n = (String) os[1];
        Assert.assertTrue(w.getName().startsWith("name2")); // $NON-NLS-1$
        Assert.assertEquals(n, w.getName());
      }
    }

    // named query with get
    if (!isXmlTest()) {
      final String wsPartUrl =
          LibraryModelPackage.INSTANCE.getWriterEClass().getName()
              + "?namedQuery=testWriter&firstResult=0" //$NON-NLS-1$
              + "&maxResults=5&noCount=true&qp.name="
              + URLEncoder.encode("name3%", "UTF-8"); // $NON-NLS-1$
      final String content = doGetRequest(wsPartUrl, null, HttpServletResponse.SC_OK);
      final ResponseType result = (ResponseType) deserialize(content).get(0);
      // as there are more than 5 writers, the result is one more than the maxResults
      Assert.assertEquals(6, result.getTotalRows());
      Assert.assertEquals(5, result.getData().size());
      for (Object o : result.getData()) {
        final Object[] os = (Object[]) o;
        Writer w = (Writer) os[0];
        Assert.assertEquals(os[1], w.getName());
        Assert.assertTrue(w.getName().startsWith("name3")); // $NON-NLS-1$
      }
    }

    // get all the writers which start with name2, in total there are 11
    // do not do the count, so the total rows should be equal to the maxResults
    {
      final String wsPartUrl =
          LibraryModelPackage.INSTANCE.getWriterEClass().getName()
              + "?query="
              + URLEncoder.encode("select e from library_Writer e where e.name like :name", "UTF-8")
              + "&firstResult=0" //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$
              + "&maxResults=5&noCount=true&qp.name="
              + URLEncoder.encode("name3%", "UTF-8"); // $NON-NLS-1$
      final String content = doGetRequest(wsPartUrl, null, HttpServletResponse.SC_OK);
      final ResponseType result = (ResponseType) deserialize(content).get(0);
      // as there are more than 5 writers, the result is one more than the maxResults
      Assert.assertEquals(6, result.getTotalRows());
      Assert.assertEquals(5, result.getData().size());
      for (Object o : result.getData()) {
        Writer w = (Writer) o;
        Assert.assertTrue(w.getName().startsWith("name3")); // $NON-NLS-1$
      }
    }
  }
示例#2
0
  @Test
  public void createAndPageTest() {
    final int COUNT = 35;
    final List<Writer> insertedWs = new ArrayList<Writer>();
    for (int i = 0; i < COUNT; i++) {
      final Writer w = LibraryModelPackage.MODELFACTORY.createWriter();
      w.setName("name" + i); // $NON-NLS-1$
      final String content = serialize(w);
      final String resultStr =
          doContentRequest(
              LibraryModelPackage.INSTANCE.getWriterEClass().getName(),
              content,
              HttpServletResponse.SC_OK,
              null,
              HttpMethod.POST);
      final ResultType result = (ResultType) deserialize(resultStr).get(0);
      Assert.assertEquals(1, result.getInserted().size());
      Assert.assertEquals(0, result.getUpdated().size());
      Assert.assertEquals(0, result.getDeleted().size());
      final Writer insertedW = (Writer) result.getInserted().get(0);
      Assert.assertEquals(w.getName(), insertedW.getName());
      checkExists(insertedW, true);
      insertedWs.add(insertedW);
    }

    final int[] expectedCount = new int[] {10, 10, 10, 5, 0};
    int startRow = 0;
    final List<Writer> checkedWs = new ArrayList<Writer>(insertedWs);
    for (int i = 0; i < expectedCount.length; i++) {
      final String wsPartUrl =
          ModelUtils.getQualifiedNameFromEClass(LibraryModelPackage.INSTANCE.getWriterEClass())
              + "?firstResult="
              + startRow //$NON-NLS-1$
              + "&maxResults=10"; //$NON-NLS-1$
      final String content = doGetRequest(wsPartUrl, null, HttpServletResponse.SC_OK);

      final ResponseType result = (ResponseType) deserialize(content).get(0);
      Assert.assertEquals(COUNT, result.getTotalRows());
      Assert.assertEquals(expectedCount[i], result.getData().size());
      if (result.getData().size() > 0) {
        Assert.assertEquals(startRow, result.getStartRow());
        Assert.assertEquals(startRow + expectedCount[i] - 1, result.getEndRow());
      }

      // check that the data exists
      for (Object o : result.getData()) {
        final Writer w = (Writer) o;
        boolean found = false;
        for (Writer insertedW : insertedWs) {
          if (w.getDb_Id() == insertedW.getDb_Id()) {
            checkedWs.remove(insertedW);
            found = true;
            break;
          }
        }
        Assert.assertTrue(found);
      }
      startRow += expectedCount[i];
    }
    Assert.assertTrue(checkedWs.isEmpty());
  }