package info.globalcode.sql.dk;

import static info.globalcode.sql.dk.Functions.isNotEmpty;

import static info.globalcode.sql.dk.Functions.isEmpty;

import static info.globalcode.sql.dk.Functions.equalz;

import java.util.ArrayList;

import java.util.Collection;

import java.util.EnumSet;

import java.util.List;

/**

 *

 * @author Ing. František Kučera (frantovo.cz)

 */

public class CLIOptions {

	public static final String DEFAULT_NAME_PREFIX = ":";

	private String sql;

	private String databaseName;

	private String databaseNameToTest;

	private String namePrefix = DEFAULT_NAME_PREFIX;

	private String formatterName;

	private boolean batch;

	public enum MODE {

		QUERY_NOW,

		PREPARE_BATCH,

		EXECUTE_BATCH,

		JUST_SHOW_INFO

	}

	public enum INFO_TYPE {

		HELP,

		VERSION,

		LICENSE,

		FORMATTERS,

		TYPES,

		DATABASES,

		CONNECTION

	}

	public enum COMMAND_TYPE {

		/** SELECT */

		QUERY,

		/** INSERT, UPDATE, DELETE */

		UPDATE

	};

	private COMMAND_TYPE commandType;

	private final Collection<NamedParameter> namedParameters = new ArrayList<>();

	private final List<Parameter> numberedParameters = new ArrayList<>();

	private final EnumSet<INFO_TYPE> showInfo = EnumSet.noneOf(INFO_TYPE.class);

	public void validate() throws InvalidOptionsException {

		InvalidOptionsException e = new InvalidOptionsException();

		MODE mode = getMode();

		if (mode == null) {

			e.addProblem(new InvalidOptionsException.OptionProblem("Invalid combination of DB, SQL and BATCH – please specify just 2 of this 3 options"));

		} else if (mode == MODE.JUST_SHOW_INFO) {

			if (!namedParameters.isEmpty()) {

				e.addProblem(new InvalidOptionsException.OptionProblem("Do not use named parameters if just showing info."));

			}

			if (!numberedParameters.isEmpty()) {

				e.addProblem(new InvalidOptionsException.OptionProblem("Do not use numbered parameters if just showing info."));

			}

			if (isNotEmpty(sql, false)) {

				e.addProblem(new InvalidOptionsException.OptionProblem("Do not specify SQL if just showing info."));

			}

			if (isNotEmpty(databaseName, false)) {

				e.addProblem(new InvalidOptionsException.OptionProblem("Do not specify database if just showing info."));

			}

			if (batch) {

				e.addProblem(new InvalidOptionsException.OptionProblem("Do not specify batch if just showing info."));

			}

			if (isNotEmpty(formatterName, false)) {

				e.addProblem(new InvalidOptionsException.OptionProblem("Do not specify formatter if just showing info."));

			}

			if (!equalz(namePrefix, DEFAULT_NAME_PREFIX)) {

				e.addProblem(new InvalidOptionsException.OptionProblem("Do not specify name prefix if just showing info."));

			}

			if (showInfo.contains(INFO_TYPE.CONNECTION) && isEmpty(databaseNameToTest, false)) {

				e.addProblem(new InvalidOptionsException.OptionProblem("Please specify which database should be tested."));

			}

		}

		if (!namedParameters.isEmpty() && !numberedParameters.isEmpty()) {

			e.addProblem(new InvalidOptionsException.OptionProblem("Named and numbered parameters can not be used together in one command."));

		}

		if (e.hasProblems()) {

			throw e;

		}

	}

	private boolean hasSql() {

		return isNotEmpty(getSql(), true);

	}

	private boolean hasDb() {

		return isNotEmpty(getDatabaseName(), true);

	}

	/**

	 * Depends on options: DB, BATCH, SQL

	 *

	 * @return mode | or null if options are not yet initialized or combination of options is

	 * invalid

	 */

	public MODE getMode() {

		if (hasDb() && !batch && hasSql()) {

			return MODE.QUERY_NOW;

		} else if (!hasDb() && batch && hasSql()) {

			return MODE.PREPARE_BATCH;

		} else if (hasDb() && batch && !hasSql()) {

			return MODE.EXECUTE_BATCH;

		} else {

			return showInfo.isEmpty() ? null : MODE.JUST_SHOW_INFO;

		}

	}

	public String getSql() {

		return sql;

	}

	public void setSql(String sql) {

		this.sql = sql;

	}

	public String getDatabaseName() {

		return databaseName;

	}

	public void setDatabaseName(String databaseName) {

		this.databaseName = databaseName;

	}

	public void setBatch(boolean batch) {

		this.batch = batch;

	}

	public COMMAND_TYPE getCommandType() {

		return commandType;

	}

	public void setCommandType(COMMAND_TYPE commandType) {

		this.commandType = commandType;

	}

	public Collection<NamedParameter> getNamedParameters() {

		return namedParameters;

	}

	public List<Parameter> getNumberedParameters() {

		return numberedParameters;

	}

	public void addNumberedParameter(Parameter p) {

		numberedParameters.add(p);

	}

	public void addNamedParameter(NamedParameter p) {

		namedParameters.add(p);

	}

	public String getNamePrefix() {

		return namePrefix;

	}

	public void setNamePrefix(String namePrefix) {

		this.namePrefix = namePrefix;

	}

	public String getFormatterName() {

		return formatterName;

	}

	public void setFormatterName(String formatterName) {

		this.formatterName = formatterName;

	}

	public void addShowInfo(INFO_TYPE info) {

		showInfo.add(info);

	}

	public EnumSet<INFO_TYPE> getShowInfo() {

		return showInfo;

	}

	public String getDatabaseNameToTest() {

		return databaseNameToTest;

	}

	public void setDatabaseNameToTest(String databaseNameToTest) {

		this.databaseNameToTest = databaseNameToTest;

	}

}