importPackage(java.io);
importPackage(java.lang);
private static final String MARS_SQL_TEMPLATE_TWO = "select\n" +
" id_delivery_area,\n" +
" id_country,\n" +
" id_gate_sites_group,\n" +
" free_shipping_bill,\n" +
" id_territory,\n" +
" price,\n" +
" id_mtt_type,\n" +
" id_gt_service_level,\n" +
" extract (hour from delivery_trigger_time)\n" +
" ||':'\n" +
" ||extract (minute from delivery_trigger_time)\n" +
" delivery_trigger_time,\n" +
" delivery_period_to_hours,\n" +
" delivery_period_from_days,\n" +
" delivery_period_to_days,\n" +
" '%s' as brand,\n" +
" '%s' as country\n" +
" from :param";
Создаю Роут
DirectRouteUtil.addDirectSQLRoute(this, MARS_ROUTE, MARS_SQL_TEMPLATE_TWO, MarsDeliveryArea.class, "marsDb");
Вызываю его
String a = marsDeliveryZoneViewNames.stream().map(viewName->viewName.getZone()).findFirst().get();
String b = "MARS."+ a;
List<MarsDeliveryArea> finalList = (List<MarsDeliveryArea>) routeService.executeRoute(MARS_ROUTE, "param", b);
Сам метод который запускает роут и должен подставить на место ? значение
public Object executeRoute(String endpointName, String headerKey, Object headerValue) {
val template = DefaultFluentProducerTemplate.on(camelContext);
if (headerKey != null) template.withHeader(headerKey, headerValue);
return template.to("direct://" + endpointName).request();
// return producerTemplate.withBody("start").to("direct://" + endpointName).send().getMessage().getBody();
}
aW1wb3J0UGFja2FnZShqYXZhLmlvKTsKaW1wb3J0UGFja2FnZShqYXZhLmxhbmcpOwoKICBwcml2YXRlIHN0YXRpYyBmaW5hbCBTdHJpbmcgTUFSU19TUUxfVEVNUExBVEVfVFdPID0gInNlbGVjdFxuIiArCiAgICAgICAgICAgICIgaWRfZGVsaXZlcnlfYXJlYSxcbiIgKwogICAgICAgICAgICAiIGlkX2NvdW50cnksXG4iICsKICAgICAgICAgICAgIiBpZF9nYXRlX3NpdGVzX2dyb3VwLFxuIiArCiAgICAgICAgICAgICIgZnJlZV9zaGlwcGluZ19iaWxsLFxuIiArCiAgICAgICAgICAgICIgaWRfdGVycml0b3J5LFxuIiArCiAgICAgICAgICAgICIgcHJpY2UsXG4iICsKICAgICAgICAgICAgIiBpZF9tdHRfdHlwZSxcbiIgKwogICAgICAgICAgICAiIGlkX2d0X3NlcnZpY2VfbGV2ZWwsXG4iICsKICAgICAgICAgICAgIiBleHRyYWN0IChob3VyIGZyb20gZGVsaXZlcnlfdHJpZ2dlcl90aW1lKVxuIiArCiAgICAgICAgICAgICIgfHwnOidcbiIgKwogICAgICAgICAgICAiIHx8ZXh0cmFjdCAobWludXRlIGZyb20gZGVsaXZlcnlfdHJpZ2dlcl90aW1lKVxuIiArCiAgICAgICAgICAgICIgZGVsaXZlcnlfdHJpZ2dlcl90aW1lLFxuIiArCiAgICAgICAgICAgICIgZGVsaXZlcnlfcGVyaW9kX3RvX2hvdXJzLFxuIiArCiAgICAgICAgICAgICIgZGVsaXZlcnlfcGVyaW9kX2Zyb21fZGF5cyxcbiIgKwogICAgICAgICAgICAiIGRlbGl2ZXJ5X3BlcmlvZF90b19kYXlzLFxuIiArCiAgICAgICAgICAgICIgJyVzJyBhcyBicmFuZCxcbiIgKwogICAgICAgICAgICAiICclcycgYXMgY291bnRyeVxuIiArCiAgICAgICAgICAgICIgZnJvbSA6cGFyYW0iOwogICAgICAgICAgICAKICAgICAgICAgICAgCiAg0KHQvtC30LTQsNGOINCg0L7Rg9GCCiAgRGlyZWN0Um91dGVVdGlsLmFkZERpcmVjdFNRTFJvdXRlKHRoaXMsIE1BUlNfUk9VVEUsIE1BUlNfU1FMX1RFTVBMQVRFX1RXTywgTWFyc0RlbGl2ZXJ5QXJlYS5jbGFzcywgIm1hcnNEYiIpOwogICAg0JLRi9C30YvQstCw0Y4g0LXQs9C+CiAgIFN0cmluZyBhID0gbWFyc0RlbGl2ZXJ5Wm9uZVZpZXdOYW1lcy5zdHJlYW0oKS5tYXAodmlld05hbWUtPnZpZXdOYW1lLmdldFpvbmUoKSkuZmluZEZpcnN0KCkuZ2V0KCk7CiAgIFN0cmluZyBiID0gIk1BUlMuIisgYTsKICAgIExpc3Q8TWFyc0RlbGl2ZXJ5QXJlYT4gZmluYWxMaXN0ID0gKExpc3Q8TWFyc0RlbGl2ZXJ5QXJlYT4pIHJvdXRlU2VydmljZS5leGVjdXRlUm91dGUoTUFSU19ST1VURSwgInBhcmFtIiwgYik7CiAgICAKICAg0KHQsNC8INC80LXRgtC+0LQg0LrQvtGC0L7RgNGL0Lkg0LfQsNC/0YPRgdC60LDQtdGCINGA0L7Rg9GCINC4INC00L7Qu9C20LXQvSDQv9C+0LTRgdGC0LDQstC40YLRjCDQvdCwINC80LXRgdGC0L4gPyDQt9C90LDRh9C10L3QuNC1CiAgICAgIHB1YmxpYyBPYmplY3QgZXhlY3V0ZVJvdXRlKFN0cmluZyBlbmRwb2ludE5hbWUsIFN0cmluZyBoZWFkZXJLZXksIE9iamVjdCBoZWFkZXJWYWx1ZSkgewogICAgICAgIHZhbCB0ZW1wbGF0ZSA9IERlZmF1bHRGbHVlbnRQcm9kdWNlclRlbXBsYXRlLm9uKGNhbWVsQ29udGV4dCk7CiAgICAgICAgaWYgKGhlYWRlcktleSAhPSBudWxsKSB0ZW1wbGF0ZS53aXRoSGVhZGVyKGhlYWRlcktleSwgaGVhZGVyVmFsdWUpOwogICAgICAgIHJldHVybiB0ZW1wbGF0ZS50bygiZGlyZWN0Oi8vIiArIGVuZHBvaW50TmFtZSkucmVxdWVzdCgpOwovLyAgICAgICAgcmV0dXJuIHByb2R1Y2VyVGVtcGxhdGUud2l0aEJvZHkoInN0YXJ0IikudG8oImRpcmVjdDovLyIgKyBlbmRwb2ludE5hbWUpLnNlbmQoKS5nZXRNZXNzYWdlKCkuZ2V0Qm9keSgpOwogICAgfQ==
js: "prog.js", line 4: missing ; before statement
js: private static final String MARS_SQL_TEMPLATE_TWO = "select\n" +
js: ................^
js: "prog.js", line 25: missing ; before statement
js: Создаю Роут
js: ............^
js: "prog.js", line 26: syntax error
js: DirectRouteUtil.addDirectSQLRoute(this, MARS_ROUTE, MARS_SQL_TEMPLATE_TWO, MarsDeliveryArea.class, "marsDb");
js: ..................^
js: "prog.js", line 27: missing ; before statement
js: Вызываю его
js: ..............^
js: "prog.js", line 28: syntax error
js: String a = marsDeliveryZoneViewNames.stream().map(viewName->viewName.getZone()).findFirst().get();
js: ...............................................................^
js: "prog.js", line 29: missing ; before statement
js: String b = "MARS."+ a;
js: ...........^
js: "prog.js", line 30: syntax error
js: List<MarsDeliveryArea> finalList = (List<MarsDeliveryArea>) routeService.executeRoute(MARS_ROUTE, "param", b);
js: ..............................................................^
js: "prog.js", line 32: missing ; before statement
js: Сам метод который запускает роут и должен подставить на место ? значение
js: ............^
js: "prog.js", line 33: missing ; before statement
js: public Object executeRoute(String endpointName, String headerKey, Object headerValue) {
js: ................................^
js: "prog.js", line 36: invalid return
js: return template.to("direct://" + endpointName).request();
js: ..............^
js: "prog.js", line 38: syntax error
js: }
js: ....^
js: "prog.js", line 1: Compilation produced 11 syntax errors.