org.apache.camel.component.sql.SqlHelper Maven / Gradle / Ivy
/*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed with
* this work for additional information regarding copyright ownership.
* The ASF licenses this file to You under the Apache License, Version 2.0
* (the "License"); you may not use this file except in compliance with
* the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.apache.camel.component.sql;
import java.io.IOException;
import java.io.InputStream;
import java.util.StringJoiner;
import org.apache.camel.CamelContext;
import org.apache.camel.NoTypeConversionAvailableException;
import org.apache.camel.support.ResourceHelper;
public final class SqlHelper {
private SqlHelper() {
}
/**
* Resolve the query by loading the query from the classpath or file resource if needed.
*/
public static String resolveQuery(CamelContext camelContext, String query, String placeholder)
throws NoTypeConversionAvailableException, IOException {
String answer = query;
if (ResourceHelper.hasScheme(query)) {
InputStream is = ResourceHelper.resolveMandatoryResourceAsInputStream(camelContext, query);
answer = camelContext.getTypeConverter().mandatoryConvertTo(String.class, is);
if (placeholder != null) {
answer = answer.replaceAll(placeholder, "?");
}
// skip lines with comments
StringJoiner sj = new StringJoiner("\n");
String[] lines = answer.split("\n");
for (String line : lines) {
String trim = line.trim();
if (!trim.isEmpty() && !trim.startsWith("--")) {
sj.add(line);
}
}
answer = sj.toString();
}
return answer;
}
}