"Expect name but could not find it in property tag"); params.add(new VirtualTableParameter(pname, defaultValue, validator)); } else if (reader.getNodeName().equals("escapeSql")) { escapeSql = Boolean.valueOf(reader.getValue());
String value = values.get(param.getName()); if (value == null) { value = param.getDefaultValue(); if (value == null) { value = ""; if (param.getValidator() != null) { try { param.getValidator().validate(value); Level.SEVERE, "Invalid value for parameter " + param.getName(), e); throw new SQLException("Invalid value for parameter " + param.getName()); result = result.replace("%" + param.getName() + "%", value);
writer.setValue(name); writer.endNode(); if (param.getDefaultValue() != null) { writer.startNode("defaultValue"); writer.setValue(param.getDefaultValue()); writer.endNode(); if (param.getValidator() != null) { if (param.getValidator() instanceof RegexpValidator) { writer.startNode("regexpValidator"); writer.setValue( ((RegexpValidator) param.getValidator()) .getPattern() .pattern()); "Cannot handle this type of validator," + " please extend the VirtualTableConverter " + param.getValidator().getClass());
public VirtualTableParameter toVirtualTableParameter() { VirtualTableParameter result = new VirtualTableParameter(name, defaultValue); if (regexp != null) { result.setValidator(new RegexpValidator(regexp)); } return result; }
/** * Adds a parameter to the virtual table * * @param param */ public void addParameter(VirtualTableParameter param) { parameters.put(param.getName(), param); }
public VirtualTableParameter toVirtualTableParameter() { VirtualTableParameter result = new VirtualTableParameter(name, defaultValue); if(regexp != null) { result.setValidator(new RegexpValidator(regexp)); } return result; }
/** * Adds a parameter to the virtual table * @param param */ public void addParameter(VirtualTableParameter param) { parameters.put(param.getName(), param); }
public Parameter(VirtualTableParameter param) { this.name = param.getName(); this.defaultValue = param.getDefaultValue(); Validator validator = param.getValidator(); if (validator != null) { if (validator instanceof RegexpValidator) { this.regexp = ((RegexpValidator) validator).getPattern().pattern(); } else { SQLViewParamProvider.LOGGER.log( Level.WARNING, "Skipping unknown validator type " + validator.getClass()); } } }
VT_NAME, "select \"name\", \"pointProperty\" from \"pgeo\" where \"booleanProperty\" = %bool% and \"name\" = '%name%'"); vt.addParameter(new VirtualTableParameter("bool", "true")); vt.addParameter(new VirtualTableParameter("name", "name-f001")); vt.addGeometryMetadatata("pointProperty", Point.class, 4326); jds.createVirtualTable(vt);
public Parameter(VirtualTableParameter param) { this.name = param.getName(); this.defaultValue = param.getDefaultValue(); Validator validator = param.getValidator(); if (validator != null) { if (validator instanceof RegexpValidator) { this.regexp = ((RegexpValidator) validator).getPattern().pattern(); } else { SQLViewParamProvider.LOGGER.log(Level.WARNING, "Skipping unknown validator type " + validator.getClass()); } } }
vt.addGeometryMetadatata("geom", LineString.class, 4326); vt.setPrimaryKeyColumns(Arrays.asList("a", "b")); vt.addParameter(new VirtualTableParameter("mulparam", "1", new RegexpValidator("\\d+"))); vt.addParameter(new VirtualTableParameter("andparam", null));
String value = values.get(param.getName()); if(value == null) { value = param.getDefaultValue(); if(value == null) { value = ""; if(param.getValidator() != null) { try { param.getValidator().validate(value); } catch(IllegalArgumentException e) { LOGGER.log(Level.SEVERE, "Invalid value for parameter " + param.getName(), e); throw new SQLException("Invalid value for parameter " + param.getName()); result = result.replace("%" + param.getName() + "%", value);
vt.addGeometryMetadatata(aname("geom"), LineString.class, 4326); vt.addParameter( new VirtualTableParameter("mul", "1", new RegexpValidator("[\\d\\.e\\+-]+"))); vt.addParameter(new VirtualTableParameter("where", "")); dataStore.addVirtualTable(vt);
vt.setEscapeSql(true); vt.addParameter( new VirtualTableParameter("param1", "default_value", new RegexpValidator(".*"))); String singleQuote = vt.expandParameters(
"pgeo_view", "select \"name\", \"pointProperty\" from \"pgeo\" where \"booleanProperty\" = %bool% and \"name\" = '%name%'"); vt.addParameter(new VirtualTableParameter("bool", "true")); vt.addParameter(new VirtualTableParameter("name", "name-f001")); vt.addGeometryMetadatata("pointProperty", Point.class, 4326); jds.addVirtualTable(vt);