com.tsc9526.monalisa.orm.criteria.QEH Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of monalisa-orm Show documentation

Very simple database ORM

There is a newer version: 2.2.0

/*******************************************************************************************
 *	Copyright (c) 2016, zzg.zhou([email protected])
 * 
 *  Monalisa is free software: you can redistribute it and/or modify
 *	it under the terms of the GNU Lesser General Public License as published by
 *	the Free Software Foundation, either version 3 of the License, or
 *	(at your option) any later version.

 *	This program is distributed in the hope that it will be useful,
 *	but WITHOUT ANY WARRANTY; without even the implied warranty of
 *	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *	GNU Lesser General Public License for more details.

 *	You should have received a copy of the GNU Lesser General Public License
 *	along with this program.  If not, see .
 *******************************************************************************************/
package com.tsc9526.monalisa.orm.criteria;

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

import com.tsc9526.monalisa.orm.Query;

/**
 * Do not use this class
 *
 * @author zzg.zhou([email protected])
 */
public class QEH {

	public static Query getQuery(Criteria criteria){	
		return criteria.q;
	}
	
	public static Query getQuery(Example,?> example){		
		Query  q=new Query();
		
		List orderBy=new ArrayList();
	 	for(int i=0;i c=example.cs.get(i);
	 		
	 		Query cq=c.q;
	 		if(cq.isEmpty()==false){	 			
				if(q.isEmpty()){
					if(example.cs.size()>1){
						q.add("(");
						q.add(cq.getSql(),cq.getParameters());
						q.add(")");
					}else{
						q.add(cq.getSql(),cq.getParameters());
					}
				}else{
					q.add(" OR (");
					q.add(cq.getSql(),cq.getParameters());
					q.add(")");
				}				 
	 		}
	 		
	 		for(String by:c.getOrderBy()){
	 			if(!orderBy.contains(by)){ 
	 				orderBy.add(by);
	 			}
	 		}
		}
	 	
		if(orderBy.size()>0){
			q.add(" ORDER BY ");
			for(int i=0;i0){
					q.add(", ");
				}
				q.add(orderBy.get(i));
			}
		}
		
		return q;
	}	 

}