EasySqlAttributes.java

package org.theonefx.wcframework.jdbc.easyjsql;

import java.util.ArrayList;
import java.util.LinkedList;
import java.util.List;

/**
 * @author TheoneFx
 * 
 */
public class EasySqlAttributes {
	private String from;

	private String select = "*";

	private List<WhereEntry> where = null;

	private List<OrderEntry> orderBy = null;

	private List<JoinEntry> join = null;
	
	private List<SetEntry> sets = null;
	
	private LimitEntry limitEntry = null;
	
	private ACTION action;

	public String getFrom() {
		return from;
	}

	public void setFrom(String from) {
		this.from = from;
	}

	public String getSelect() {
		return select;
	}

	public void setSelect(String select) {
		this.select = select;
	}

	public ACTION getAction() {
		return action;
	}

	public void setAction(ACTION action) {
		this.action = action;
	}

	public List<JoinEntry> getJoin() {
		return join;
	}
	
	public List<WhereEntry> getWhere() {
		return where;
	}

	public List<OrderEntry> getOrderBy() {
		return orderBy;
	}

	public LimitEntry getLimitEntry() {
		return limitEntry;
	}

	public void setLimitEntry(LimitEntry limitEntry) {
		this.limitEntry = limitEntry;
	}
	
	public List<SetEntry> getSets() {
		return sets;
	}

	public void addWhereEntry(WhereEntry entry){
		if(where == null){
			where = new LinkedList<WhereEntry>();
		}
		where.add(entry);
	}

	public void addJoinEntry(JoinEntry entry){
		if(join == null){
			join = new LinkedList<JoinEntry>();
		}
		join.add(entry);
	}
	
	public void addSet(SetEntry entry){
		if(sets == null){
			sets = new LinkedList<SetEntry>();
		}
		sets.add(entry);
	}
	
	public void addOrderBy(String fieldname){
		addOrderBy(fieldname, OrderType.DESC);
	}
	
	public void addOrderBy(String fieldname, OrderType type){
		if(orderBy == null){
			orderBy = new ArrayList<OrderEntry>();
		}
		orderBy.add(new OrderEntry(fieldname, type));
	}

}