package foundation.translator;

import java.math.BigDecimal;
import java.sql.Timestamp;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

import foundation.server.config.DBaseType;
import foundation.util.Util;


public class TimeStampTranslator extends ITranslator {

	private static String DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
	private static String DateFormat = "yyyy-MM-dd";
	private DateFormat dateFormater;
	
			
	public TimeStampTranslator() {
		dateFormater = new SimpleDateFormat(DateFormat);
	}
	
	public String toString(Object value) throws Exception {
		if (value == null || value == ValueType.Null) {
			return null;
		}
		
		Date date = (Date)value;
		return dateFormater.format(date);
	}
	
	public String toSqlString(DBaseType dbaseType, Object value) throws Exception {
		if (value == null || value == ValueType.Null) {
			return "null";
		}
		
		Date date = toDate(value);
		return Util.quotedStr(dateFormater.format(date));
	}
	
	public String toJSONString(Object value) throws Exception {
		if (value == null || value == ValueType.Null) {
			return "null";
		}
		
		Date date = (Date)value;
		return "\"" + dateFormater.format(date) + "\"";
	}
	
	public String toSchemaString(Object value) throws Exception {
		if (value == null || value == ValueType.Null) {
			return "";
		}
		
		Date date = (Date)value;
		return "\"" + dateFormater.format(date) + "\"";
	}

	@Override
	public Integer toInteger(Object object) throws Exception {
		throw new Exception("can not translate date (" + object + ") to Integer");
	}

	@Override
	public Double toDouble(Object object) throws Exception {
		throw new Exception("can not translate date (" + object + ") to Double");
	}

	@Override
	public BigDecimal toBigDecimal(Object object) throws Exception {
		throw new Exception("can not translate date (" + object + ") to BigDecimal");
	}
	
	@Override
	public Boolean toBoolean(Object object) throws Exception {
		throw new Exception("can not translate date (" + object + ") to BigDecimal");
	}

	@Override
	public Date toDate(Object object) throws Exception {
		Timestamp date = (Timestamp)object;
		Date result = new Date(date.getTime());
		return result;
	}

	@Override
	public Object toTranslatorTypeValue(Object value) throws Exception {
		return toDate(value);
	}
	
	@Override
	public Object loadObjectFrom(String value) throws Exception {
		if (Util.isEmpty(value)) {
			return null;
		}
		
		return dateFormater.parse(value);
	}
	
	@Override
	public void setFormat(String format) {
		if (Util.isEmpty(format)) {
			format = DateTimeFormat;
		}
		
		this.format = format;
		dateFormater = new SimpleDateFormat(format);
	}

	@Override
	public Class<?> getDataClass() {
		return Date.class;
	}
	
	public static void main(String[] args) throws ParseException {
		DateFormat dateFormater = new SimpleDateFormat("yyyy-MM-dd");
		Date parsedDate = dateFormater.parse("2021-03-09");
		System.out.println(parsedDate);
	}
}