com.pslib.jtool.db.sqlformatter.SqlFormatter Maven / Gradle / Ivy

Go to download
package com.pslib.jtool.db.sqlformatter;

import java.util.List;
import java.util.Map;

import com.pslib.jtool.db.sqlformatter.core.FormatConfig;
import com.pslib.jtool.db.sqlformatter.languages.AbstractFormatter;
import com.pslib.jtool.db.sqlformatter.languages.Db2Formatter;
import com.pslib.jtool.db.sqlformatter.languages.N1qlFormatter;
import com.pslib.jtool.db.sqlformatter.languages.PlSqlFormatter;
import com.pslib.jtool.db.sqlformatter.languages.StandardSqlFormatter;

public class SqlFormatter {
	/**
	 * FormatConfig whitespaces in a query to make it easier to read.
	 *
	 * @param query sql
	 * @param cfg   cfg.indent Characters used for indentation, default is " " (2 spaces) cfg.params Collection of params for placeholder replacement
	 * @return {String}
	 */
	public static String format(String query, FormatConfig cfg) {
		return standard().format(query, cfg);
	}

	public static String format(String query, String indent, List params) {
		return standard().format(query, indent, params);
	}

	public static String format(String query, List params) {
		return standard().format(query, params);
	}

	public static String format(String query, String indent, Map params) {
		return standard().format(query, indent, params);
	}

	public static String format(String query, Map params) {
		return standard().format(query, params);
	}

	public static String format(String query, String indent) {
		return standard().format(query, indent);
	}

	public static String format(String query) {
		return standard().format(query);
	}

	public static AbstractFormatter standard() {
		return of("sql");
	}

	public static AbstractFormatter of(String name) {
		switch (name) {
		case "db2":
			return new Db2Formatter();
		case "n1ql":
			return new N1qlFormatter();
		case "pl/sql":
			return new PlSqlFormatter();
		case "sql":
			return new StandardSqlFormatter();
		default:
			throw new RuntimeException("Unsupported SQL dialect: " + name);
		}
	}
}