示例#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 insertComplexStructureTest() throws Exception {
    Library lib = null;
    {
      final String content = serialize(createTestDataInstance());
      final String resultStr =
          doContentRequest(
              ModelUtils.getQualifiedNameFromEClass(LibraryModelPackage.INSTANCE.getWriterEClass()),
              content,
              HttpServletResponse.SC_OK,
              null,
              HttpMethod.POST);
      final ResultType result = (ResultType) deserialize(resultStr).get(0);
      lib = (Library) result.getInserted().get(0);
      Assert.assertTrue(lib.getDb_Id() != null);
      for (Book bk : lib.getBooks()) {
        Assert.assertTrue(bk.getDb_Id() != null);
        checkExists(bk, true);
      }
      for (Writer w : lib.getWriters()) {
        Assert.assertTrue(w.getDb_Id() != null);
        checkExists(w, true);
      }
    }

    // remove all books
    Writer w = lib.getWriters().get(0);
    final String newName = "" + System.currentTimeMillis(); // $NON-NLS-1$
    w.setName(newName);
    final Book bk = w.getBooks().get(0);
    w.getBooks().clear();

    {
      final String content = serialize(w);
      final String resultStr =
          doContentRequest(
              ModelUtils.getQualifiedNameFromEClass(LibraryModelPackage.INSTANCE.getWriterEClass()),
              content,
              HttpServletResponse.SC_OK,
              null,
              HttpMethod.POST);
      final ResultType resultType = (ResultType) deserialize(resultStr).get(0);
      final Writer wResult = (Writer) resultType.getUpdated().get(0);
      Assert.assertNotSame(w, wResult);
      Assert.assertEquals(w.getDb_Id(), wResult.getDb_Id());
      Assert.assertEquals(0, wResult.getBooks().size());

      // use the new writer as the version may have changed
      w = wResult;
      checkExists(w, true);
    }

    {
      final String content =
          doGetRequest(
              ModelUtils.getQualifiedNameFromEClass(LibraryModelPackage.INSTANCE.getWriterEClass()),
              null,
              HttpServletResponse.SC_OK);
      final List<Object> objects = deserialize(content);
      System.err.println(objects.size());
    }

    // and add one book again
    {
      w.getBooks().add(bk);
      bk.setAuthor(w);
      final String content = serialize(w);
      final String resultStr =
          doContentRequest(
              ModelUtils.getQualifiedNameFromEClass(LibraryModelPackage.INSTANCE.getWriterEClass()),
              content,
              HttpServletResponse.SC_OK,
              null,
              HttpMethod.POST);
      final ResultType resultType = (ResultType) deserialize(resultStr).get(0);
      final Writer wResult = (Writer) resultType.getUpdated().get(0);
      Assert.assertNotSame(w, wResult);
      Assert.assertEquals(w.getDb_Id(), wResult.getDb_Id());
      Assert.assertEquals(1, wResult.getBooks().size());
      // disabled test as books of a writer are proxied
      // Assert.assertEquals(wResult.getBooks().get(0).getAuthor(), wResult);
    }

    {
      final Writer w2 = (Writer) deserialize(getOneObject(w)).get(0);
      Assert.assertNotSame(w, w2);
      Assert.assertEquals(newName, w2.getName());
      Assert.assertEquals(w.getDb_Id(), w2.getDb_Id());
      Assert.assertEquals(1, w2.getBooks().size());
      Assert.assertEquals(bk.getDb_Id(), w2.getBooks().get(0).getDb_Id());
    }
  }
示例#3
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());
  }