/**

 * SQL-DK

 * Copyright © 2013 František Kučera (frantovo.cz)

 *

 * This program is free software: you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation, version 3 of the License.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program. If not, see <http://www.gnu.org/licenses/>.

 */

package info.globalcode.sql.dk;

import java.sql.Types;

/**

 * Data types of SQL parameters.

 *

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

 */

public enum SQLType {

	/**

	 * Names must be upper case – user input is also converted to upper case → case insensitive

	 */

	BIT(Types.BIT),

	TINYINT(Types.TINYINT),

	SMALLINT(Types.SMALLINT),

	INTEGER(Types.INTEGER),

	BIGINT(Types.BIGINT),

	FLOAT(Types.FLOAT),

	REAL(Types.REAL),

	DOUBLE(Types.DOUBLE),

	NUMERIC(Types.NUMERIC),

	DECIMAL(Types.DECIMAL),

	CHAR(Types.CHAR),

	VARCHAR(Types.VARCHAR),

	LONGVARCHAR(Types.LONGVARCHAR),

	DATE(Types.DATE),

	TIME(Types.TIME),

	TIMESTAMP(Types.TIMESTAMP),

	BINARY(Types.BINARY),

	VARBINARY(Types.VARBINARY),

	LONGVARBINARY(Types.LONGVARBINARY),

	NULL(Types.NULL),

	OTHER(Types.OTHER),

	JAVA_OBJECT(Types.JAVA_OBJECT),

	DISTINCT(Types.DISTINCT),

	STRUCT(Types.STRUCT),

	ARRAY(Types.ARRAY),

	BLOB(Types.BLOB),

	CLOB(Types.CLOB),

	REF(Types.REF),

	DATALINK(Types.DATALINK),

	BOOLEAN(Types.BOOLEAN),

	ROWID(Types.ROWID),

	NCHAR(Types.NCHAR),

	NVARCHAR(Types.NVARCHAR),

	LONGNVARCHAR(Types.LONGNVARCHAR),

	NCLOB(Types.NCLOB),

	SQLXML(Types.SQLXML);

	/** value from java.sql.Types */

	private int code;

	private SQLType(int code) {

		this.code = code;

	}

	/**

	 * @see java.sql.Types.Types

	 */

	public int getCode() {

		return code;

	}

	/**

	 * @param code see {@linkplain java.sql.Types.Types}

	 * @return found SQLType

	 * @throws IllegalArgumentException if no data type has given code

	 */

	public static SQLType valueOf(int code) {

		for (SQLType t : values()) {

			if (t.code == code) {

				return t;

			}

		}

		throw new IllegalArgumentException("No data type has code: " + code);

	}

}