use of io.vertigo.dynamo.task.metamodel.TaskDefinition in project vertigo by KleeGroup.
the class TaskEngineSelectDynamicTest method testWhereInPrimitive.
/**
* Test exécution d'une tache.
*/
@Test
public void testWhereInPrimitive() {
try (final VTransactionWritable transaction = transactionManager.createCurrentTransaction()) {
final TaskDefinition taskDefinition = registerTaskListPrimitive("TK_WHERE_IN_PRIMITIVE_TEST", "select * from SUPER_HERO where ID in (#SUPER_HERO_ID_LIST.ROWNUM#)");
final List<Long> ids = Arrays.asList(10001L + 1, 10001L + 3);
final Task task = Task.builder(taskDefinition).addValue(SUPER_HERO_ID_LIST, ids).build();
final DtList<SuperHero> resultList = taskManager.execute(task).getResult();
Assert.assertEquals(2, resultList.size());
Assert.assertEquals(10001L + 1, resultList.get(0).getId().longValue());
Assert.assertEquals(10001L + 3, resultList.get(1).getId().longValue());
}
}
use of io.vertigo.dynamo.task.metamodel.TaskDefinition in project vertigo by KleeGroup.
the class TaskEngineSelectDynamicTest method testScript.
/**
* Test de double exécution d'une tache.
*/
@Test
public void testScript() {
try (final VTransactionWritable transaction = transactionManager.createCurrentTransaction()) {
final TaskDefinition taskDefinition = registerTaskObject("TK_SCRIPT_TEST", "select * from SUPER_HERO <%if(false) {%>where ID = #DTO_SUPER_HERO.ID#<%}%>");
final SuperHero superHero = createSuperHero(10001L + 1);
final Task task = Task.builder(taskDefinition).addValue(DTO_SUPER_HERO, superHero).build();
final DtList<SuperHero> resultList = taskManager.execute(task).getResult();
Assert.assertEquals(10, resultList.size());
}
}
use of io.vertigo.dynamo.task.metamodel.TaskDefinition in project vertigo by KleeGroup.
the class TaskEngineSelectDynamicTest method testWhereNotIn.
/**
* Test exécution d'une tache.
*/
@Test
public void testWhereNotIn() {
try (final VTransactionWritable transaction = transactionManager.createCurrentTransaction()) {
final TaskDefinition taskDefinition = registerTaskList("TK_WHERE_ID_TEST", "select * from SUPER_HERO where ID not in (#DTC_SUPER_HERO_IN.ROWNUM.ID#)");
final DtList<SuperHero> ids = new DtList<>(SuperHero.class);
final Task task = Task.builder(taskDefinition).addValue(DTC_SUPER_HERO_IN, ids).build();
ids.add(createSuperHero(10001L + 1));
ids.add(createSuperHero(10001L + 3));
ids.add(createSuperHero(10001L + 5));
ids.add(createSuperHero(10001L + 6));
ids.add(createSuperHero(10001L + 7));
ids.add(createSuperHero(10001L + 8));
final DtList<SuperHero> resultList = taskManager.execute(task).getResult();
Assert.assertEquals(4, resultList.size());
Assert.assertEquals(10001L + 0, resultList.get(0).getId().longValue());
Assert.assertEquals(10001L + 2, resultList.get(1).getId().longValue());
Assert.assertEquals(10001L + 4, resultList.get(2).getId().longValue());
Assert.assertEquals(10001L + 9, resultList.get(3).getId().longValue());
}
}
use of io.vertigo.dynamo.task.metamodel.TaskDefinition in project vertigo by KleeGroup.
the class TaskEngineSelectDynamicTest method testWhereNotIn2200.
/**
* Test where in avec 2200 Id a exclure.
*/
@Test
public void testWhereNotIn2200() {
superHeroDataBase.populateSuperHero(storeManager, 4500);
try (final VTransactionWritable transaction = transactionManager.createCurrentTransaction()) {
final TaskDefinition taskDefinition = registerTaskList("TK_WHERE_ID_TEST", "select * from SUPER_HERO where ID not in (#DTC_SUPER_HERO_IN.ROWNUM.ID#)");
final DtList<SuperHero> ids = new DtList<>(SuperHero.class);
for (int i = 0; i < 2200; i++) {
ids.add(createSuperHero(10001L + 2 * i));
}
final Task task = Task.builder(taskDefinition).addValue(DTC_SUPER_HERO_IN, ids).build();
final DtList<SuperHero> resultList = taskManager.execute(task).getResult();
Assert.assertEquals(10 + 4500 - 2200, resultList.size());
}
}
use of io.vertigo.dynamo.task.metamodel.TaskDefinition in project vertigo by KleeGroup.
the class TaskEngineSelectDynamicTest method testWhereNotInEmpty.
/**
* Test exécution d'une tache.
*/
@Test
public void testWhereNotInEmpty() {
try (final VTransactionWritable transaction = transactionManager.createCurrentTransaction()) {
final TaskDefinition taskDefinition = registerTaskList("TK_WHERE_ID_TEST", "select * from SUPER_HERO where ID not in (#DTC_SUPER_HERO_IN.ROWNUM.ID#)");
final DtList<SuperHero> ids = new DtList<>(SuperHero.class);
final Task task = Task.builder(taskDefinition).addValue(DTC_SUPER_HERO_IN, ids).build();
final DtList<SuperHero> resultList = taskManager.execute(task).getResult();
Assert.assertEquals(10, resultList.size());
}
}
Aggregations