Examples with CQL2PgJSON org.folio.cql2pgjson.CQL2PgJSON used on opensource projects

Example 1 with CQL2PgJSON

use of org.folio.cql2pgjson.CQL2PgJSON in project raml-module-builder by folio-org.

the class PostgresClientIT method getCQLWrapperNoCount.

@Test
public void getCQLWrapperNoCount(TestContext context) throws Exception {
    final String tableDefiniton = "id UUID PRIMARY KEY, jsonb JSONB NOT NULL, distinct_test_field TEXT";
    createTableWithPoLines(context, MOCK_POLINES_TABLE, tableDefiniton);
    CQLWrapper cqlWrapper = new CQLWrapper(new CQL2PgJSON("jsonb"), "cql.allRecords=1").setTotalRecords("none");
    postgresClient.get(MOCK_POLINES_TABLE, Object.class, "*", cqlWrapper, false, false, null, null, context.asyncAssertSuccess(result -> {
        assertThat(result.getResultInfo().getTotalRecords(), is(nullValue()));
        assertThat(result.getResults().size(), is(6));
    }));
    postgresClient.get(MOCK_POLINES_TABLE, Object.class, cqlWrapper, false, false, context.asyncAssertSuccess(result -> {
        assertThat(result.getResultInfo().getTotalRecords(), is(nullValue()));
        assertThat(result.getResults().size(), is(6));
    }));
    postgresClient.get(MOCK_POLINES_TABLE, Object.class, cqlWrapper, false, context.asyncAssertSuccess(result -> {
        assertThat(result.getResultInfo().getTotalRecords(), is(nullValue()));
        assertThat(result.getResults().size(), is(6));
    }));
}

Example 2 with CQL2PgJSON

use of org.folio.cql2pgjson.CQL2PgJSON in project raml-module-builder by folio-org.

the class PostgresClientIT method closeAtEndException.

@Test
public void closeAtEndException(TestContext context) throws Exception {
    Async async = context.async();
    CQLWrapper cql = new CQLWrapper(new CQL2PgJSON("jsonb"), "id=*", 1, /* offset */
    0);
    postgresClient = createTable(context, TENANT, MOCK_POLINES_TABLE, "id UUID PRIMARY KEY, jsonb JSONB NOT NULL");
    postgresClient.streamGet(MOCK_POLINES_TABLE, Object.class, "jsonb", cql, false, null, 0, asyncResult -> {
        if (asyncResult.succeeded()) {
            throw new RuntimeException("foo");
        } else {
            context.assertEquals("foo", asyncResult.cause().getMessage());
            async.complete();
        }
    });
}

Example 3 with CQL2PgJSON

use of org.folio.cql2pgjson.CQL2PgJSON in project raml-module-builder by folio-org.

the class PostgresClientIT method getCQLWrapperNoFacets.

@Test
public void getCQLWrapperNoFacets(TestContext context) throws FieldException {
    final String tableDefiniton = "id UUID PRIMARY KEY , jsonb JSONB NOT NULL, distinct_test_field TEXT";
    createTableWithPoLines(context, MOCK_POLINES_TABLE, tableDefiniton);
    List<FacetField> facets = null;
    CQL2PgJSON cql2pgJson = new CQL2PgJSON("jsonb");
    {
        CQLWrapper cqlWrapper = new CQLWrapper(cql2pgJson, "cql.allRecords=1");
        Async async = context.async();
        postgresClient.get(MOCK_POLINES_TABLE, Object.class, "*", cqlWrapper, true, true, facets, null, handler -> {
            context.assertTrue(handler.succeeded());
            ResultInfo resultInfo = handler.result().getResultInfo();
            context.assertEquals(6, resultInfo.getTotalRecords());
            List<Facet> retFacets = resultInfo.getFacets();
            context.assertEquals(0, retFacets.size());
            async.complete();
        });
        async.awaitSuccess();
    }
    String distinctOn = "jsonb->>'order_format'";
    List<FacetField> emptyFacets = new ArrayList<FacetField>();
    {
        CQLWrapper cqlWrapper = new CQLWrapper(cql2pgJson, "cql.allRecords=1");
        Async async = context.async();
        postgresClient.get(MOCK_POLINES_TABLE, Object.class, "*", cqlWrapper, true, true, emptyFacets, distinctOn, handler -> {
            context.assertTrue(handler.succeeded());
            ResultInfo resultInfo = handler.result().getResultInfo();
            context.assertEquals(4, resultInfo.getTotalRecords());
            List<Facet> retFacets = resultInfo.getFacets();
            context.assertEquals(0, retFacets.size());
            async.complete();
        });
        async.awaitSuccess();
    }
    {
        Async async = context.async();
        CQLWrapper cqlWrapperNull = null;
        postgresClient.get(MOCK_POLINES_TABLE, Object.class, "*", cqlWrapperNull, true, true, facets, null, handler -> {
            context.assertTrue(handler.succeeded());
            ResultInfo resultInfo = handler.result().getResultInfo();
            context.assertEquals(6, resultInfo.getTotalRecords());
            List<Facet> retFacets = resultInfo.getFacets();
            context.assertEquals(0, retFacets.size());
            async.complete();
        });
        async.awaitSuccess();
    }
    {
        Async async = context.async();
        CQLWrapper cqlWrapperNull = null;
        postgresClient.get(MOCK_POLINES_TABLE, Object.class, "*", cqlWrapperNull, true, true, facets, distinctOn, handler -> {
            context.assertTrue(handler.succeeded());
            ResultInfo resultInfo = handler.result().getResultInfo();
            context.assertEquals(4, resultInfo.getTotalRecords());
            try {
                List<Object> objs = handler.result().getResults();
                context.assertEquals(4, objs.size());
            } catch (Exception ex) {
                context.fail(ex);
            }
            List<Facet> retFacets = resultInfo.getFacets();
            context.assertEquals(0, retFacets.size());
            async.complete();
        });
        async.awaitSuccess();
    }
}

Example 4 with CQL2PgJSON

use of org.folio.cql2pgjson.CQL2PgJSON in project raml-module-builder by folio-org.

the class PostgresClientIT method testCacheResultCQLSyntaxError.

@Test
public void testCacheResultCQLSyntaxError(TestContext context) throws FieldException {
    final String tableDefiniton = "id UUID PRIMARY KEY , jsonb JSONB NOT NULL, distinct_test_field TEXT";
    createTableWithPoLines(context, MOCK_POLINES_TABLE, tableDefiniton);
    CQLWrapper wrapper = new CQLWrapper(new CQL2PgJSON("jsonb"), "edition=");
    postgresClient.persistentlyCacheResult("cache_polines", MOCK_POLINES_TABLE, wrapper, context.asyncAssertFailure(res -> context.assertTrue(res.getMessage().contains("expected index or term"))));
}

Example 5 with CQL2PgJSON

use of org.folio.cql2pgjson.CQL2PgJSON in project raml-module-builder by folio-org.

the class PostgresClientIT method deleteByCqlWrapper.

private void deleteByCqlWrapper(TestContext context, String key) throws FieldException {
    Async async = context.async();
    CQL2PgJSON cql2pgJson = new CQL2PgJSON("jsonb");
    CQLWrapper cqlWrapper = new CQLWrapper(cql2pgJson, "key==" + key);
    PostgresClient postgresClient = insertXAndSingleQuotePojo(context, new JsonArray().add(randomUuid()).add(randomUuid()));
    postgresClient.delete(FOO, cqlWrapper, context.asyncAssertSuccess(delete -> {
        context.assertEquals(1, delete.rowCount(), "number of records deleted");
        postgresClient.selectSingle("SELECT count(*) FROM " + FOO, context.asyncAssertSuccess(select -> {
            context.assertEquals(1, select.getInteger(0), "remaining records");
            async.complete();
        }));
    }));
    async.await(5000);
}