package info.globalcode.sql.dk;

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

import java.util.ArrayList;

import java.util.Collection;

import java.util.List;

/**

 *

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

 */

public class CLIOptions {

	private String sql;

	private String databaseName;

	private boolean batch;

	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<>();

	public void validate() throws InvalidOptionsException {

		InvalidOptionsException e = new InvalidOptionsException();

		if ( //

				(hasDb() ? 1 : 0) + //

				(hasSql() ? 1 : 0) + //

				(hasBatch() ? 1 : 0)

				!= 2) //

		{

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

		}

		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;

		}

	}

	public boolean hasSql() {

		return isNotEmpty(sql, true);

	}

	public boolean hasDb() {

		return isNotEmpty(databaseName, true);

	}

	public boolean hasBatch() {

		return batch;

	}

}