QueryBuilder.groovy

@Canonical
class QueryBuilder {
	
	String spreadsheet
	String worksheet
	String query
	String order
	String contains
	
	boolean all
	boolean reverse
	int limit
	int offset
	
	
	List<Object> columns = []

	QueryBuilder sheet(String worksheet){
		this.worksheet = worksheet
		this
	}
	
	QueryBuilder sort(Sort ascOrDesc){
		reverse = ascOrDesc == Sort.DESC
		this
	}
	
	QueryBuilder limit(int limit){
		this.limit = limit
		this
	}
	
	QueryBuilder offset(int offset){
		this.offset = offset
		this
	}
	
	QueryBuilder where(String spreadSheetQuery){
		this.query = spreadSheetQuery
		this
	}
	
	QueryBuilder contains(String contains){
		this.contains = contains
		this
	}
	
	OrderBuilder order(By by){
		new OrderBuilder(queryBuilder: this)
	}
	
	
	Worksheet build(GData gdata){
		// the magic happens here based on collected properties
	}
	
}