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;

 	}

 }