Search in sources :

Example 6 with HintProvider

use of com.haulmont.cuba.gui.components.autocomplete.impl.HintProvider in project cuba by cuba-platform.

the class HintProviderTest method requestHint_fieldNameHint_where_in_topLevelVariablesUse.

@Test
public void requestHint_fieldNameHint_where_in_topLevelVariablesUse() 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();
    model.add(teamEntity);
    model.add(playerEntity);
    HintProvider hintProvider = createTestHintProvider(model);
    HintResponse response = hintProvider.requestHint("select p.name from Player p " + "where p.nickname in " + "(select t.name " + "from Team t " + "where t.onwer = p.~)");
    List<String> options = response.getOptions();
    assertEquals(3, options.size());
    assertEquals("name", options.get(0));
    assertEquals("nickname", options.get(1));
    assertEquals("team", options.get(2));
    response = hintProvider.requestHint("select t.~ from Player p " + "where p.nickname in " + "(select t.name " + "from Team t " + "where t.onwer = p.name)");
    options = response.getOptions();
    assertEquals(0, options.size());
    assertEquals("Query error", response.getErrorMessage());
    assertEquals(1, response.getCauseErrorMessages().size());
    assertEquals("Cannot parse [t.]", response.getCauseErrorMessages().get(0));
    hintProvider = createTestHintProvider(model);
    response = hintProvider.requestHint("select p from Player p where p.team.name in (select a.~ from Team a where a.name = 'KS')");
    options = response.getOptions();
    assertEquals(2, options.size());
    assertEquals("name", options.get(0));
    assertEquals("owner", options.get(1));
}
Also used : DomainModel(com.haulmont.cuba.core.sys.jpql.DomainModel) EntityBuilder(com.haulmont.cuba.core.sys.jpql.model.EntityBuilder) HintProvider(com.haulmont.cuba.gui.components.autocomplete.impl.HintProvider) JpqlEntityModel(com.haulmont.cuba.core.sys.jpql.model.JpqlEntityModel) HintResponse(com.haulmont.cuba.gui.components.autocomplete.impl.HintResponse) Test(org.junit.Test)

Example 7 with HintProvider

use of com.haulmont.cuba.gui.components.autocomplete.impl.HintProvider in project cuba by cuba-platform.

the class HintProviderTest method requestHint_betweenMacro.

@Test
public void requestHint_betweenMacro() throws RecognitionException {
    EntityBuilder builder = new EntityBuilder();
    builder.startNewEntity("Player");
    builder.addStringAttribute("nickname");
    builder.addStringAttribute("name");
    builder.addSingleValueAttribute(Date.class, "joinDate");
    JpqlEntityModel playerEntity = builder.produce();
    DomainModel model = new DomainModel();
    model.add(playerEntity);
    HintProvider hintProvider = createTestHintProvider(model);
    HintResponse response = hintProvider.requestHint("select p.~ from Player p where @between(p.joinDate, now, now+1, day)");
    List<String> options = response.getOptions();
    assertEquals(3, options.size());
    assertEquals("joinDate", options.get(0));
    assertEquals("name", options.get(1));
    assertEquals("nickname", options.get(2));
    hintProvider = createTestHintProvider(model);
    response = hintProvider.requestHint("select p.name from Player p where @between(p.~, now, now+1, day)");
    options = response.getOptions();
    assertEquals(1, options.size());
    assertEquals("joinDate", options.get(0));
}
Also used : DomainModel(com.haulmont.cuba.core.sys.jpql.DomainModel) EntityBuilder(com.haulmont.cuba.core.sys.jpql.model.EntityBuilder) HintProvider(com.haulmont.cuba.gui.components.autocomplete.impl.HintProvider) JpqlEntityModel(com.haulmont.cuba.core.sys.jpql.model.JpqlEntityModel) HintResponse(com.haulmont.cuba.gui.components.autocomplete.impl.HintResponse) Test(org.junit.Test)

Example 8 with HintProvider

use of com.haulmont.cuba.gui.components.autocomplete.impl.HintProvider in project cuba by cuba-platform.

the class HintProviderTest method requestHint_erroneous.

@Test
public void requestHint_erroneous() throws RecognitionException {
    EntityBuilder builder = new EntityBuilder();
    JpqlEntityModelImpl playerEntity = builder.produceImmediately("Player");
    DomainModel model = new DomainModel();
    model.add(playerEntity);
    HintProvider hintProvider = createTestHintProvider(model);
    HintResponse response = hintProvider.requestHint("select t FROM p...~");
    List<String> options = response.getOptions();
    assertEquals(0, options.size());
    assertEquals("Query error", response.getErrorMessage());
    assertArrayEquals(new String[] { "Cannot parse [p...]", "Error near: \"p\"" }, response.getCauseErrorMessages().toArray());
}
Also used : DomainModel(com.haulmont.cuba.core.sys.jpql.DomainModel) JpqlEntityModelImpl(com.haulmont.cuba.core.sys.jpql.model.JpqlEntityModelImpl) EntityBuilder(com.haulmont.cuba.core.sys.jpql.model.EntityBuilder) HintProvider(com.haulmont.cuba.gui.components.autocomplete.impl.HintProvider) HintResponse(com.haulmont.cuba.gui.components.autocomplete.impl.HintResponse) Test(org.junit.Test)

Example 9 with HintProvider

use of com.haulmont.cuba.gui.components.autocomplete.impl.HintProvider in project cuba by cuba-platform.

the class HintProviderTest method requestHint_fieldNameHint_returnedFieldOrder.

@Test
public void requestHint_fieldNameHint_returnedFieldOrder() throws RecognitionException {
    EntityBuilder builder = new EntityBuilder();
    JpqlEntityModel playerEntity = builder.produceImmediately("Player", "nickname", "name");
    DomainModel model = new DomainModel();
    model.add(playerEntity);
    HintProvider hintProvider = createTestHintProvider(model);
    HintResponse response = hintProvider.requestHint("select p.~ from Player p");
    List<String> options = response.getOptions();
    assertEquals(2, options.size());
    assertEquals("name", options.get(0));
    assertEquals("nickname", options.get(1));
}
Also used : DomainModel(com.haulmont.cuba.core.sys.jpql.DomainModel) EntityBuilder(com.haulmont.cuba.core.sys.jpql.model.EntityBuilder) HintProvider(com.haulmont.cuba.gui.components.autocomplete.impl.HintProvider) JpqlEntityModel(com.haulmont.cuba.core.sys.jpql.model.JpqlEntityModel) HintResponse(com.haulmont.cuba.gui.components.autocomplete.impl.HintResponse) Test(org.junit.Test)

Example 10 with HintProvider

use of com.haulmont.cuba.gui.components.autocomplete.impl.HintProvider in project cuba by cuba-platform.

the class HintProviderTest method requestHint_fieldNameHint_keywordCaseInsensitivity.

@Test
public void requestHint_fieldNameHint_keywordCaseInsensitivity() throws RecognitionException {
    EntityBuilder builder = new EntityBuilder();
    JpqlEntityModel playerEntity = builder.produceImmediately("Player", "name", "nickname");
    DomainModel model = new DomainModel();
    model.add(playerEntity);
    HintProvider hintProvider = createTestHintProvider(model);
    HintResponse response = hintProvider.requestHint("select p.~ from Player p");
    List<String> options = response.getOptions();
    assertEquals(2, options.size());
    assertEquals("name", options.get(0));
    assertEquals("nickname", options.get(1));
}
Also used : DomainModel(com.haulmont.cuba.core.sys.jpql.DomainModel) EntityBuilder(com.haulmont.cuba.core.sys.jpql.model.EntityBuilder) HintProvider(com.haulmont.cuba.gui.components.autocomplete.impl.HintProvider) JpqlEntityModel(com.haulmont.cuba.core.sys.jpql.model.JpqlEntityModel) HintResponse(com.haulmont.cuba.gui.components.autocomplete.impl.HintResponse) Test(org.junit.Test)

Aggregations

DomainModel (com.haulmont.cuba.core.sys.jpql.DomainModel)21 HintProvider (com.haulmont.cuba.gui.components.autocomplete.impl.HintProvider)21 EntityBuilder (com.haulmont.cuba.core.sys.jpql.model.EntityBuilder)20 HintResponse (com.haulmont.cuba.gui.components.autocomplete.impl.HintResponse)20 Test (org.junit.Test)20 JpqlEntityModel (com.haulmont.cuba.core.sys.jpql.model.JpqlEntityModel)17 JpqlEntityModelImpl (com.haulmont.cuba.core.sys.jpql.model.JpqlEntityModelImpl)3 DomainModelBuilder (com.haulmont.cuba.core.sys.jpql.DomainModelBuilder)1 HintRequest (com.haulmont.cuba.gui.components.autocomplete.impl.HintRequest)1 Option (com.haulmont.cuba.gui.components.autocomplete.impl.Option)1 ArrayList (java.util.ArrayList)1