use of com.haulmont.cuba.core.sys.jpql.model.EntityBuilder in project cuba by cuba-platform.
the class QueryTransformerAstBasedTest method transformationsUsingSelectedEntity.
@Test
public void transformationsUsingSelectedEntity() throws RecognitionException {
EntityBuilder builder = new EntityBuilder();
builder.startNewEntity("sec$Car");
builder.addStringAttribute("model");
builder.addReferenceAttribute("colour", "sec$Colour");
JpqlEntityModel car = builder.produce();
builder.startNewEntity("sec$Colour");
builder.addStringAttribute("name");
builder.addStringAttribute("createdBy");
builder.addSingleValueAttribute(Integer.class, "version");
builder.addReferenceAttribute("manufacturer", "Manufacturer");
JpqlEntityModel colour = builder.produce();
JpqlEntityModel manufacturer = builder.produceImmediately("Manufacturer", "companyName");
DomainModel model = new DomainModel(car, colour, manufacturer);
QueryTransformerAstBased transformer = new QueryTransformerAstBased(model, "select c.colour from sec$Car c where c.colour.createdBy = :p");
transformer.addWhere("{E}.colour.createdBy = :session$userLogin");
String res = transformer.getResult();
assertEquals("select c.colour from sec$Car c where (c.colour.createdBy = :p) and (c.colour.createdBy = :session$userLogin)", res);
transformer = new QueryTransformerAstBased(model, "select c.colour from sec$Car c where c.colour.createdBy = :p");
transformer.addJoinAndWhere("join {E}.manufacturer m", "m.companyName = :par1");
res = transformer.getResult();
assertEquals("select c.colour from sec$Car c join c.manufacturer m where (c.colour.createdBy = :p) and (m.companyName = :par1)", res);
// todo eude: fix the following
// transformer = new QueryTransformerAstBased(model,
// "select c.colour from sec$Car c where c.colour.createdBy = :p");
// transformer.mergeWhere("select gh from sec$Colour gh where gh.version between 1 and 2");
//
// res = transformer.getResult();
// assertEquals(
// "select c.colour from sec$Car c where (c.colour.createdBy = :p) and (c.colour.version between 1 and 2)",
// res);
// transformer = new QueryTransformerAstBased(model,
// "select c.colour from sec$Car c where c.colour.createdBy = :p order by c.colour.name");
// transformer.replaceOrderBy(true, "version");
//
// res = transformer.getResult();
// assertEquals(
// "select c.colour from sec$Car c left join c.colour c_colour where c.colour.createdBy = :p order by c_colour.version desc",
// res);
//
//
// transformer = new QueryTransformerAstBased(model,
// "select c.colour from sec$Car c where c.colour.createdBy = :p");
// transformer.replaceWithCount();
//
// res = transformer.getResult();
// assertEquals(
// "select count(c.colour) from sec$Car c where c.colour.createdBy = :p",
// res);
}
use of com.haulmont.cuba.core.sys.jpql.model.EntityBuilder in project cuba by cuba-platform.
the class QueryTransformerAstBasedTest method getResult_noChangesMade_update.
@Test
public void getResult_noChangesMade_update() throws RecognitionException {
EntityBuilder builder = new EntityBuilder();
builder.startNewEntity("sec$Car");
builder.addStringAttribute("model");
builder.addStringAttribute("vin");
JpqlEntityModel car = builder.produce();
DomainModel model = new DomainModel(car);
QueryTransformerAstBased transformer = new QueryTransformerAstBased(model, "update sec$Car c set c.model = :model, c.vin = :vin");
assertEquals("update sec$Car c set c.model=:model,c.vin=:vin", transformer.getResult());
transformer = new QueryTransformerAstBased(model, "update sec$Car c set c.model = :model, c.vin = :vin where c.vin = :oldVin");
assertEquals("update sec$Car c set c.model=:model,c.vin=:vin where c.vin = :oldVin", transformer.getResult());
}
use of com.haulmont.cuba.core.sys.jpql.model.EntityBuilder in project cuba by cuba-platform.
the class QueryTransformerAstBasedTest method getResult_noChangesMade_withMultiEntitySelect.
@Test
public void getResult_noChangesMade_withMultiEntitySelect() throws RecognitionException {
EntityBuilder builder = new EntityBuilder();
JpqlEntityModel teamEntity = builder.produceImmediately("Team");
JpqlEntityModel playerEntity = builder.produceImmediately("Player");
DomainModel model = new DomainModel(playerEntity, teamEntity);
assertTransformsToSame(model, "SELECT p, t FROM Player p, Team t");
}
use of com.haulmont.cuba.core.sys.jpql.model.EntityBuilder in project cuba by cuba-platform.
the class QueryTransformerAstBasedTest method getResult_noChangesMade.
@Test
public void getResult_noChangesMade() throws RecognitionException {
EntityBuilder builder = new EntityBuilder();
JpqlEntityModelImpl playerEntity = builder.produceImmediately("Player");
DomainModel model = new DomainModel(playerEntity);
assertTransformsToSame(model, "SELECT p FROM Player p");
}
use of com.haulmont.cuba.core.sys.jpql.model.EntityBuilder in project cuba by cuba-platform.
the class QueryTransformerAstBasedTest method getResult_noChangesMade_subqueries.
// The following functions are not supported by JPA2 JPQL (see jpql21.bnf)
// @Test
// public void getResult_noChangesMade_withSubqueries() throws RecognitionException {
// EntityBuilder builder = new EntityBuilder();
// JpqlEntityModel teamEntity = builder.produceImmediately("Team", "name", "owner");
//
// builder.startNewEntity("Player");
// builder.addStringAttribute("name");
// builder.addStringAttribute("nickname");
// builder.addReferenceAttribute("team", "Team");
// JpqlEntityModel playerEntity = builder.produce();
//
// DomainModel model = new DomainModel(playerEntity, teamEntity);
//
// assertTransformsToSame(model, "select p.name from (select t.name from Team t) p");
// assertTransformsToSame(model, "select p.owner from (select t.name, t.owner from Team t) p");
// assertTransformsToSame(model, "select g.owner from (select t.name, t.owner from Team t) p, (select t.name from Team t) g");
// }
// The following functions are not supported by JPA2 JPQL (see jpql21.bnf)
// @Test
// public void getResult_noChangesMade_severalLevelsOfSubquery() throws RecognitionException {
// EntityBuilder builder = new EntityBuilder();
// JpqlEntityModel teamEntity = builder.produceImmediately("Team", "name", "owner");
//
// builder.startNewEntity("Player");
// builder.addStringAttribute("name");
// builder.addStringAttribute("nickname");
// builder.addReferenceAttribute("team", "Team");
// JpqlEntityModel playerEntity = builder.produce();
//
// DomainModel model = new DomainModel(playerEntity, teamEntity);
//
// assertTransformsToSame(model, "select p.owner from (select t from Team t where t.name in (select a.name from Player a)) p");
// // 'as' skipped
// QueryTransformerAstBased transformerAstBased = new QueryTransformerAstBased(model, "select p.owner from (select t.owner from Team as t where t.name = '1') p", "AsdfAsdfAsdf");
// String result = transformerAstBased.getResult();
// assertEquals("select p.owner from (select t.owner from Team t where t.name = '1') p", result);
// }
@Test
public void getResult_noChangesMade_subqueries() throws RecognitionException {
EntityBuilder builder = new EntityBuilder();
JpqlEntityModel teamEntity = builder.produceImmediately("Team", "name", "owner");
builder.startNewEntity("Player");
builder.addStringAttribute("name");
builder.addStringAttribute("nickname");
builder.addReferenceAttribute("team", "Team");
JpqlEntityModel playerEntity = builder.produce();
DomainModel model = new DomainModel(playerEntity, teamEntity);
assertTransformsToSame(model, "select p.owner from Player pl where exists (select t from Team t where t.name = 'Team1' and pl.team.id = t.id)");
assertTransformsToSame(model, "select p.owner from Player pl where pl.team.id in (select t.id from Team t where t.name = 'Team1')");
assertTransformsToSame(model, "select t.name from Team t where (select count(p) from Player p where p.team.id = t.id) > 10");
}
Aggregations