All Downloads are FREE. Search and download functionalities are using the official Maven repository.

nosi.base.ActiveRecord.ActiveRecordIterface Maven / Gradle / Ivy

Go to download

IGRP Framework is a powerful and highly customizable platform developed by the Operational Nucleus for the Information Society (NOSi) to create web applications, it provides out of box, several modules to make easy to create stand-alone, production-grade web applications: authentication and access-control, business processes automation, reporting, page builder with automatic code generation and incorporation of the Once-Only-Principle, written in Java. IGRP Framework WAR - Contains some keys resources that give UI to IGRP Framework and others supports files.

There is a newer version: 2.0.0.240912-RCM
Show newest version
package nosi.base.ActiveRecord;
import java.sql.Date;
/**
 * @author: Emanuel Pereira
 * 29 Jun 2017
 */
import java.util.List;
import java.util.UUID;

import javax.persistence.criteria.CriteriaQuery;

public interface ActiveRecordIterface extends CommonRestriction{

	public T where(String condition);
	
	public T andWhereNotNull(String name);
	
	public T andWhereIsNull(String name);
	
	public T where();
	
	public T and();
	
	public T or();
	
	public T where(String name,String operator,String value);
	
	public T where(String name,String operator,String[] values);
	
	public T where(String name,String operator,Integer[] values);
	
	public T where(String name,String operator,Double[] values);
	
	public T where(String name,String operator,Float[] values);
	
	public T where(String name,String operator,Short[] values);
	
	public T where(String name,String operator,Integer value);
	
	public T where(String name,String operator,Float value);
	
	public T where(String name,String operator,Double value);

	public T where(String name, String operator, Short value);
	
	public T where(String name,String operator,Date value);
	
	public T andWhere(String name,String operator,String value);
	
	public T andWhere(String name,String operator,Object value);
	
	public T andWhere(String name,String paramName,String operator,Object value);
	
	public T andWhere(String name,String operator,String[] values);
	
	public T andWhere(String name,String operator,Integer[] values);
	
	public T andWhere(String name,String operator,Double[] values);
	
	public T andWhere(String name,String operator,Float[] values);
	
	public T andWhere(String name,String operator,Short[] values);
	
	public T andWhere(String name,String operator,Integer value);
	
	public T andWhere(String name,String operator,Float value);
	
	public T andWhere(String name,String operator,Double value);
	
	public T andWhere(String name,String operator,Date value);
	
	public T andWhere(String name,String operator,Short value);

	public T where(String name,String operator,Object value);
	
	public T where(String name,String paramName,String operator,Object value);
	
    public T where(String name,String paramName,String operator,String value);
	
	public T where(String name,String paramName,String operator,Integer value);
	
	public T where(String name,String paramName,String operator,Float value);
	
	public T where(String name,String paramName,String operator,Double value);
	
	public T where(String name,String paramName,String operator,Date value);
	
	public T where(String name,String paramName,String operator,Short value);
	
	public T whereIn(String columnName, Number... numbers);
	
	public T whereIn(String columnName, String... strings);
	
	public T whereIn(String columnName, UUID... uuIds);
	
	public T whereNotIn(String columnName, UUID... uuIds);
	
	public T whereNotIn(String columnName, String... strings);
	
	public T whereNotIn(String columnName, Number... numbers);

	public T whereBetween(String columnName, Object o1, Object o2);
	
	public T orWhereBetween(String columnName, Object o1, Object o2);
	
	public T andWhereBetween(String columnName, Object o1, Object o2);
	
	public T andWhere(String name,String paramName,String operator,String value);
	
	public T andWhere(String name,String paramName,String operator,Integer value);
	
	public T andWhere(String name,String paramName,String operator,Float value);
	
	public T andWhere(String name,String paramName,String operator,Double value);
	
	public T andWhere(String name,String paramName,String operator,Date value);
	
	public T andWhere(String name,String paramName,String operator,Short value);
	
	public T andWhere(String name, String operator, Number value);
	
	public T orWhereNotNull(String name);
	
	public T orWhereIsNull(String name);

	public T orWhere(String name,String operator,Object value);
	
	public T orWhere(String name,String paramName,String operator,Object value);
	
	public T orWhere(String name,String operator,String value);
	
	public T orWhere(String name,String operator,String[] values);
	
	public T orWhere(String name,String operator,Integer[] values);
	
	public T orWhere(String name,String operator,Double[] values);
	
	public T orWhere(String name,String operator,Float[] values);
	
	public T orWhere(String name,String operator,Short[] values);
	
	public T orWhere(String name,String operator,Integer value);
	
	public T orWhere(String name,String operator,Float value);
	
	public T orWhere(String name,String operator,Double value);

	public T orWhere(String name,String operator,Date value);
	
	public T orWhere(String name,String operator,Short value);
	
    public T orWhere(String name,String paramName,String operator,String value);
	
	public T orWhere(String name,String paramName,String operator,Integer value);
	
	public T orWhere(String name,String paramName,String operator,Float value);
	
	public T orWhere(String name,String paramName,String operator,Double value);

	public T orWhere(String name,String paramName,String operator,Date value);
	
	public T orWhere(String name,String paramName,String operator,Short value);
	
	public T having(String name,String operator,String value);
	
	public T having(String name,String operator,Integer value);
	
	public T having(String name,String operator,Double value);
	
	public T having(String name,String operator,Float value);

	public T having(String name,String operator,Date value);
	
	public T having(String name,String operator,Short value);
		
	public T orderBy(String...orderByNames);
	
	public T orderBy(String[] ...orderByNames);
	
	public T groupBy(String ...groupByNames);

	public T exists(String subQuery);	
	
	public T notExists(String subQuery);	
	
	public T limit(int limit);
	
	public T offset(int offset);
	
	public T any(String subQuery);
	
	public T all(String subQuery);
	
	public T find();
	
	public T findOne(Object value);
	
	public List findAll();
	
	public T one();
	
	public List all();
	
	public T where(RestrictionImpl restrition);
	
	public T andWhere(RestrictionImpl restrition);
	
	public T orWhere(RestrictionImpl restrition);
	
	public List findAll(CriteriaQuery criteria);

	public T findOne(CriteriaQuery criteria);
	
	public T insert();
	
	public T update();
	
	public boolean delete(Object id);
	
	public boolean delete();
	
	public T setConnectionName(String connectionName);
	
	public String getConnectionName();
	
	public Object getValuePrimaryKey();
	
	public String getNamePrimaryKey();
	
	public Long getCount();
	
	public Object getMax(String columnName);

	public Object getMin(String columnName);

	public Double getAvg(String columnName);
	
	public Object getSum(String columnName);

	public T orderByAsc(String...columns);
	
	public T orderByDesc(String...columns);
	
	public T keepConnection();//keep connection open
	/*
	public T sum(String name);

	public T avg(String name);
	
	public T min(String name);
	
	public T max(String name);
	
	public T count(String name);
	
	*/
	
}




© 2015 - 2024 Weber Informatics LLC | Privacy Policy