@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$
}
}
}
@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());
}
