package frame.data.meta;

import java.math.BigDecimal;
import java.sql.PreparedStatement;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.text.ParseException;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import org.apache.log4j.Logger;

import frame.data.convert.Convertor;
import frame.persist.SQLRunner;
import frame.persist.loader.ResultMetaFieldReader;
import frame.util.Util;

public class EntityMeta implements Iterable<Field> {

	protected static Logger logger;
	
	private String name;
	private List<Field> fieldList;
	private String[] names;
	private String[] lowerNames;
	private int index_key;
	private Map<String, Integer> nameIndexMap;

	static {
		logger = Logger.getLogger(EntityMeta.class);
	}

	public static EntityMeta getInstance(String tableName) throws Exception {
		return MetaContainer.get(tableName);
	}

	public static EntityMeta getInstance(String tableName, boolean refresh) throws Exception {
		return MetaContainer.get(tableName, refresh);
	}
	
	public EntityMeta(String tableName, IFieldReader fieldReader) throws SQLException {
		this.name = tableName;
		nameIndexMap = new HashMap<String, Integer>();
		fieldList = new ArrayList<Field>();

		initFields(fieldReader);
	}
	
	public static EntityMeta getInstance(ResultSetMetaData metaData) throws Exception {
		ResultMetaFieldReader fieldReader = new ResultMetaFieldReader(metaData);
		return new EntityMeta("tablemeta", fieldReader);
	}

	private void initFields(IFieldReader fieldReader) throws SQLException {
		String fieldName;
		int columnType;
		int fieldLength;
		int nullable;
		Field field;

		fieldReader.first();

		while (fieldReader.next()) {
			fieldName = fieldReader.getFieldName();
			columnType = fieldReader.getFieldType();
			fieldLength = fieldReader.getFieldLength();
			nullable = fieldReader.getNullable();

			if (fieldName == null) {
				continue;
			}

			field = new Field(fieldName);
			fieldList.add(field);

			field.setType(columnType);
			field.setLength(fieldLength);
			field.setNullable(nullable);
		}

		int fieldCount = fieldList.size();
		names = new String[fieldCount];
		lowerNames = new String[fieldCount];

		String name;
		for (int i = 0; i < fieldCount; i++) {
			field = fieldList.get(i);
			name = field.getName();
			names[i] = name;

			name = name.toLowerCase();
			lowerNames[i] = name;
			nameIndexMap.put(name, i);
		}
	}

	public int getFieldCount() {
		return fieldList.size();
	}

	public Iterator<Field> iterator() {
		return fieldList.iterator();
	}

	public String getName() {
		return name;
	}

	public void setPrimaryKey(String keyField) {
		if (keyField == null) {
			return;
		}

		Integer idx = nameIndexMap.get(keyField.toLowerCase());

		if (idx != null) {
			index_key = idx;
		}
	}

	public List<Field> getFields() {
		return fieldList;
	}

	public Field get(String name) {
		if (name == null)
			return null;

		Integer idx = nameIndexMap.get(name.toLowerCase());

		if (idx == null) {
			return null;
		}

		return fieldList.get(idx);
	}

	public Field get(int idx) {
		return fieldList.get(idx);
	}

	public synchronized String getFiledName_Key() throws Exception {
		if (index_key >= 0) {
			String keyName = SQLRunner.getPrimaryKeyField(null, name);

			if (keyName == null) {
				return null;
			}

			Integer idx = nameIndexMap.get(keyName.toLowerCase());

			if (idx == null) {
				return null;
			}
		}

		if (index_key >= 0) {
			Field field = fieldList.get(index_key);
			return field.getName();
		}

		return "id";
	}

	public int getIndex_Key() {
		return index_key;
	}

	public int getIndex(String fieldName) {
		if (fieldName == null) {
			return -2;
		}
		
		return nameIndexMap.get(fieldName.toLowerCase());
	}

	public String[] getLowerNames() {
		return lowerNames;
	}

	public boolean contains(String name) {
		if (name == null) {
			return false;
		}

		name = name.toLowerCase();
		return nameIndexMap.containsKey(name);
	}

	public void setObject(Object[] dataArray, String name, Object object) {
		if (name == null) {
			return;
		}

		name = name.toLowerCase();
		Integer idx = nameIndexMap.get(name);

		if (idx == null) {
			return;
		}

		dataArray[idx] = object;
	}

	public void setString(Object[] dataArray, String name, String value) throws ParseException {
		if (name == null) {
			return;
		}

		name = name.toLowerCase();
		Integer idx = nameIndexMap.get(name);

		if (idx == null) {
			return;
		}

		Field field = fieldList.get(idx);
		Object obj = field.StringToObject(value);

		dataArray[idx] = obj;
	}

	public String getString(Object[] dataArray, String name, String defaultValue) throws Exception {
		if (name == null) {
			return null;
		}

		name = name.toLowerCase();
		Integer idx = nameIndexMap.get(name);

		if (idx == null) {
			return null;
		}

		Field field = fieldList.get(idx);
		Object obj = dataArray[idx];

		if (obj == null) {
			return defaultValue;
		}

		return field.objectToString(obj);
	}

	public String getString(Object[] dataArray, int idx, String defaultValue) throws Exception {
		Field field = fieldList.get(idx);
		Object obj = dataArray[idx];

		if (obj == null) {
			return defaultValue;
		}

		return field.objectToString(obj);
	}

	public boolean getBoolean(Object[] dataArray, String name) {
		if (name == null) {
			return false;
		}

		name = name.toLowerCase();
		Integer idx = nameIndexMap.get(name);

		if (idx == null) {
			return false;
		}

		Field field = fieldList.get(idx);
		Object obj = dataArray[idx];

		return field.objectToBoolean(obj);
	}

	public Date getDate(Object[] dataArray, String name) throws ParseException {
		if (name == null) {
			return null;
		}

		name = name.toLowerCase();
		Integer idx = nameIndexMap.get(name);

		if (idx == null) {
			return null;
		}

		Field field = fieldList.get(idx);
		Object obj = dataArray[idx];

		return field.objectToDate(obj);
	}

	public Integer getInteger(Object[] dataArray, String name) {
		if (name == null) {
			return null;
		}

		name = name.toLowerCase();
		Integer idx = nameIndexMap.get(name);

		if (idx == null) {
			return null;
		}

		Field field = fieldList.get(idx);
		Object obj = dataArray[idx];

		return field.objectToInteger(obj);
	}
	
	public BigDecimal getBigDecimal(Object[] dataArray, String name) {
		if (name == null) {
			return null;
		}

		name = name.toLowerCase();
		Integer idx = nameIndexMap.get(name);

		if (idx == null) {
			return null;
		}

		Field field = fieldList.get(idx);
		Object obj = dataArray[idx];

		return field.objectToBigDecimal(obj);
	}

	public String getSchemaString(Object[] dataArray, int idx) throws Exception {
		Field field = fieldList.get(idx);
		Object obj = dataArray[idx];

		return field.objectToSchemaString(obj);
	}

	public String getJSONSString(Object[] dataArray, int idx) throws SQLException {
		Field field = fieldList.get(idx);
		Object obj = dataArray[idx];

		return field.objectToJSONSString(obj);
	}

	public String getSqlString(Object value, String name) throws Exception {
		if (name == null) {
			return null;
		}

		name = name.toLowerCase();
		Integer idx = nameIndexMap.get(name);

		if (idx == null) {
			return null;
		}

		Field field = fieldList.get(idx);
		return field.objectToSQLString(value);
	}

	public String getSQLString(Object[] dataArray, int idx) throws Exception {
		Field field = fieldList.get(idx);
		Object obj = dataArray[idx];

		return field.objectToSQLString(obj);
	}

	public void setValueToStatement(Object[] dataArray, int dataIdx, PreparedStatement stmt, int paramIdx)
			throws SQLException {
		Field field = fieldList.get(dataIdx);
		Object obj = dataArray[dataIdx];

		field.setValueToStatement(obj, stmt, paramIdx);
	}

	public String getFieldNames() {
		StringBuffer result = new StringBuffer();

		boolean empty = true;

		for (String name : names) {
			if (!empty) {
				result.append(", ");
			}

			result.append(name);
			empty = false;
		}

		return result.toString();
	}

	public String getDoubleQuotedFieldNames() {
		StringBuffer result = new StringBuffer();

		boolean empty = true;

		for (String name : names) {
			if (!empty) {
				result.append(", ");
			}

			result.append(Util.doubleQuotedStr(name));
			empty = false;
		}

		return result.toString();
	}

	public Convertor getConvertor(int idx) {
		// TODO Auto-generated method stub
		return null;
	}

}