com.github.paganini2008.devtools.db4j.ParsedSql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of devtools-db4j Show documentation

a concise jdbc tools for quick developing

There is a newer version: 2.0.5

/**
* Copyright 2021 Fred Feng ([email protected])

* Licensed 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 com.github.paganini2008.devtools.db4j;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;

import com.github.paganini2008.devtools.PlaceholderTokenParser;
import com.github.paganini2008.devtools.collection.LruMap;

/**
 * ParsedSql
 * 
 * @author Fred Feng
 * @version 1.0
 */
public final class ParsedSql implements Serializable {

	private static final long serialVersionUID = -7823481840053509465L;
	private static final LruMap parsedSqlCache = new LruMap(1024);
	private static final String DEFAULT_PLACEHOLDER_PREFIX = "{";
	private static final String DEFAULT_PLACEHOLDER_SUFFEX = "}";
	final StringBuilder rawSql = new StringBuilder();
	final List parameterNames = new ArrayList();
	final List defaultValues = new ArrayList();

	ParsedSql() {
	}

	public String[] getParameterNames() {
		return parameterNames.toArray(new String[0]);
	}

	public String[] getDefaultValues() {
		return defaultValues.toArray(new String[0]);
	}

	public StringBuilder getRawSql() {
		return rawSql;
	}

	public String toString() {
		return rawSql.toString();
	}

	public static ParsedSql parse(String sql) {
		return parsedSqlCache.getOrDefault(sql, doParse(sql));
	}

	private static ParsedSql doParse(String sql) {
		ParsedSql parsedSql = new ParsedSql();
		PlaceholderTokenParser placeholderTokenizer = new PlaceholderTokenParser(DEFAULT_PLACEHOLDER_PREFIX, DEFAULT_PLACEHOLDER_SUFFEX);
		parsedSql.rawSql.append(placeholderTokenizer.parse(sql, variable -> {
			String parameterName = variable;
			String defaultValue = null;
			int index;
			if ((index = variable.indexOf(':')) > 0) {
				parameterName = variable.substring(0, index);
				defaultValue = variable.substring(index + 1);
			}
			parsedSql.parameterNames.add(parameterName);
			parsedSql.defaultValues.add(defaultValue);
			return "?";
		}));
		return parsedSql;
	}

}