package com.tyndalehouse.step.dataloader.beans;


//TODO: Refactor eventually so use as we load data out of the database...
public class TimelineEventBean extends DbBean {
	private String ID;	
	private String name;	
	private String from;
	private String to;	
	private String from2;	
	private String to2;
	private String importance;	
	private String certainty;	
	private String flags;
	private String timeline;	
	private String type;
	private String description;	
	private String refs;
	private String source;
	private String notes;
	private String timebandId;

	private static final String alternativeDateInsertStatement = "insert into step.alternative_date" +
			"(event_id, from_date, to_date, from_date_precision, to_date_precision) values" +
			"(?,?,?,?,?)";
	
	private static final String eventInsert = "insert into step.event(" +
		"event_id, event_text_id, name, from_date, to_date, from_precision, to_precision, timeband_id, sub_timeband_id, importance_id, certainty, " +
		"flags, event_type_id, description, source, notes) values(" +
		"?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
	
	private static final String scriptureReferenceInsertStatement = "insert into scripture_reference(" +
			"target_id, target_type, start_verse_id, end_verse_id) values (?, ?, ?, ?)";
	
	/*create table scripture_reference (
	target_id						int,
	target_type						int,
	verse_id						int

);*/
	
	public static String getInsertStatement() {
		return eventInsert;
	}





	/**
	 * @return the notes
	 */
	public String getNotes() {
		return notes;
	}
	/**
	 * @param notes the notes to set
	 */
	public void setNotes(String notes) {
		this.notes = notes;
	}
	/**
	 * @return the iD
	 */
	public String getID() {
		return ID;
	}
	/**
	 * @param id the iD to set
	 */
	public void setID(String id) {
		ID = id;
	}
	/**
	 * @return the name
	 */
	public String getName() {
		return name;
	}
	/**
	 * @param name the name to set
	 */
	public void setName(String name) {
		this.name = name;
	}
	/**
	 * @return the from
	 */
	public String getFrom() {
		return from;
	}
	/**
	 * @param from the from to set
	 */
	public void setFrom(String from) {
		this.from = from;
	}
	/**
	 * @return the to
	 */
	public String getTo() {
		return to;
	}
	/**
	 * @param to the to to set
	 */
	public void setTo(String to) {
		this.to = to;
	}
	/**
	 * @return the from2
	 */
	public String getFrom2() {
		return from2;
	}
	/**
	 * @param from2 the from2 to set
	 */
	public void setFrom2(String from2) {
		this.from2 = from2;
	}
	/**
	 * @return the to2
	 */
	public String getTo2() {
		return to2;
	}
	/**
	 * @param to2 the to2 to set
	 */
	public void setTo2(String to2) {
		this.to2 = to2;
	}
	/**
	 * @return the importance
	 */
	public String getImportance() {
		return importance;
	}
	/**
	 * @param importance the importance to set
	 */
	public void setImportance(String importance) {
		this.importance = importance;
	}
	/**
	 * @return the certainty
	 */
	public String getCertainty() {
		return certainty;
	}
	/**
	 * @param certainty the certainty to set
	 */
	public void setCertainty(String certainty) {
		this.certainty = certainty;
	}
	/**
	 * @return the flags
	 */
	public String getFlags() {
		return flags;
	}
	/**
	 * @param flags the flags to set
	 */
	public void setFlags(String flags) {
		this.flags = flags;
	}
	/**
	 * @return the timeline
	 */
	public String getTimeline() {
		return timeline;
	}
	/**
	 * @param timeline the timeline to set
	 */
	public void setTimeline(String timeline) {
		this.timeline = timeline;
	}
	/**
	 * @return the type
	 */
	public String getType() {
		return type;
	}
	/**
	 * @param type the type to set
	 */
	public void setType(String type) {
		this.type = type;
	}
	/**
	 * @return the description
	 */
	public String getDescription() {
		return description;
	}
	/**
	 * @param description the description to set
	 */
	public void setDescription(String description) {
		this.description = description;
	}
	/**
	 * @return the refs
	 */
	public String getRefs() {
		return refs;
	}
	/**
	 * @param refs the refs to set
	 */
	public void setRefs(String refs) {
		this.refs = refs;
	}
	/**
	 * @return the source
	 */
	public String getSource() {
		return source;
	}
	/**
	 * @param source the source to set
	 */
	public void setSource(String source) {
		this.source = source;
	}



	/**
	 * @return the timeband_id
	 */
	public String getTimebandId() {
		return timebandId;
	}





	/**
	 * @param timebandId the timeband_id to set
	 */
	public void setTimebandId(String timebandId) {
		this.timebandId = timebandId;
	}



	public static String getAlternativeDateStatement() {
		return alternativeDateInsertStatement;
	}




	//TODO: move this out to a seperate logical unit
	public static String getScriptureReferenceStatement() {
		return scriptureReferenceInsertStatement;
	}
	
}