Java CQL2PgJSON类代码示例

import org.z3950.zing.cql.cql2pgjson.CQL2PgJSON; //导入依赖的package包/类
/**
 * Append field.cql2pgJson(query) to sb.
 *
 * @param sb where to append
 * @param query CQL query
 * @param field field the query is based on
 * @throws CQLQueryValidationException when the underlying CQL2PgJSON throws a QueryValidationException
 */
private void append(StringBuilder sb, String query, CQL2PgJSON field) {
  if(query == null || field == null) {
    return;
  }
  try {
    sb.append(field.cql2pgJson(query));
  } catch (QueryValidationException e) {
    throw new CQLQueryValidationException(e);
  }
}
 

import org.z3950.zing.cql.cql2pgjson.CQL2PgJSON; //导入依赖的package包/类
@Test
public void invalidCQLvalidation() throws FieldException {
  CQLWrapper wrapper = new CQLWrapper().setField(new CQL2PgJSON("field")).setQuery("or name=miller");
  try {
    wrapper.toString();
    fail("exception expected");
  }
  catch (CQLQueryValidationException e) {
    assertThat(e.getMessage(), allOf(containsString("ParseException"), containsString("unexpected relation")));
  }
}
 

import org.z3950.zing.cql.cql2pgjson.CQL2PgJSON; //导入依赖的package包/类
@Test
public void wrap() throws FieldException {
  CQLWrapper wrapper = new CQLWrapper().setField(new CQL2PgJSON("field")).setQuery("cql.allRecords=1");
  wrapper.addWrapper(wrapper);
  wrapper.addWrapper(wrapper, "or");
  assertThat(wrapper.toString(), is(" WHERE true and true or true"));
}
 

import org.z3950.zing.cql.cql2pgjson.CQL2PgJSON; //导入依赖的package包/类
private CQLWrapper getCQL(String query, int limit, int offset) throws FieldException {
  CQL2PgJSON cql2pgJson = new CQL2PgJSON(MATERIAL_TYPE_TABLE+".jsonb");
  return new CQLWrapper(cql2pgJson, query).setLimit(new Limit(limit)).setOffset(new Offset(offset));
}
 

import org.z3950.zing.cql.cql2pgjson.CQL2PgJSON; //导入依赖的package包/类
private CQLWrapper getCQL(String query, int limit, int offset) throws FieldException {
  CQL2PgJSON cql2pgJson = new CQL2PgJSON(LOAN_TYPE_TABLE+".jsonb");
  return new CQLWrapper(cql2pgJson, query).setLimit(new Limit(limit)).setOffset(new Offset(offset));
}
 

import org.z3950.zing.cql.cql2pgjson.CQL2PgJSON; //导入依赖的package包/类
public static void main(String args[]) throws Exception {

    FacetManager fm = new FacetManager("myuniversity_new1_mod_users.users");

    List<FacetField> facets = new ArrayList<>();
    facets.add(new FacetField("jsonb->>'lastUpdateDate'", 5));
    facets.add(new FacetField("jsonb->'personal'->>'phone'", 5));
    facets.add(new FacetField("jsonb->>'username'", 5));

    fm.setSupportFacets(facets);

    fm.setWhere(new CQLWrapper(new CQL2PgJSON("jsonb"), "username=jha* OR username=szeev*").toString());

    fm.setMainQuery("SELECT jsonb FROM myuniversity_new1_mod_users.users where jsonb->>'username' like 'jha%' OR jsonb->>'username' like 'szeev%'" );

    System.out.println(fm.generateFacetQuery());

  }
 

import org.z3950.zing.cql.cql2pgjson.CQL2PgJSON; //导入依赖的package包/类
public CQLWrapper(CQL2PgJSON field, String query) {
  super();
  this.field = field;
  this.query = query;
}
 

import org.z3950.zing.cql.cql2pgjson.CQL2PgJSON; //导入依赖的package包/类
public CQL2PgJSON getField() {
  return field;
}
 

import org.z3950.zing.cql.cql2pgjson.CQL2PgJSON; //导入依赖的package包/类
public CQLWrapper setField(CQL2PgJSON field) {
  this.field = field;
  return this;
}
 

import org.z3950.zing.cql.cql2pgjson.CQL2PgJSON; //导入依赖的package包/类
@Test
public void returnsWhere() throws FieldException {
  CQLWrapper wrapper = new CQLWrapper().setField(new CQL2PgJSON("field")).setQuery("name=miller");
  assertThat(wrapper.toString(), startsWith(" WHERE "));
}
 

import org.z3950.zing.cql.cql2pgjson.CQL2PgJSON; //导入依赖的package包/类
@Test
public void allRecords() throws FieldException {
  CQLWrapper wrapper = new CQLWrapper().setField(new CQL2PgJSON("field")).setQuery("cql.allRecords=1");
  assertThat(wrapper.toString(), is(" WHERE true"));
}
 

import org.z3950.zing.cql.cql2pgjson.CQL2PgJSON; //导入依赖的package包/类
@Test(expected = IllegalStateException.class)
public void invalidCQL() throws FieldException {
  CQLWrapper wrapper = new CQLWrapper().setField(new CQL2PgJSON("field")).setQuery("or name=miller");
  wrapper.toString();
}
 

import org.z3950.zing.cql.cql2pgjson.CQL2PgJSON; //导入依赖的package包/类
@Test
public void sortBy() throws FieldException {
  CQL2PgJSON cql2pgJson = new CQL2PgJSON("field");
  CQLWrapper wrapper = new CQLWrapper().setField(cql2pgJson).setQuery("cql.allRecords=1 sortBy name");
  assertThat(wrapper.toString(), stringContainsInOrder(" WHERE true ORDER BY ", "name"));
}