com.reinaldoarrosi.android.querybuilder.sqlite.projection.AggregateProjection Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of query-builder Show documentation

Fluent Android library to build SQLite select statements

The newest version!

package com.reinaldoarrosi.android.querybuilder.sqlite.projection;

import java.util.List;

import com.reinaldoarrosi.android.querybuilder.Utils;

public class AggregateProjection extends Projection {
	public static class Type {
		public static final int MIN = 1;
		public static final int MAX = 2;
		public static final int SUM = 3;
		public static final int AVG = 4;
		public static final int COUNT = 5;
	}
	
	private Projection projection;
	private int type;
	
	public AggregateProjection(Projection projection, int type) {
		this.projection = projection;
		this.type = type;
	}

	@Override
	public String build() {
		String ret = (projection != null ? projection.build() : "");
		
		if(type == Type.MIN)
			return "MIN(" + ret + ")";
		else if(type == Type.MAX)
			return "MAX(" + ret + ")";
		else if(type == Type.SUM)
			return "SUM(" + ret + ")";
		else if(type == Type.AVG)
			return "AVG(" + ret + ")";
		else if(type == Type.COUNT)
			return "COUNT(" + ret + ")";
		else
			return ret;
	}

	@Override
	public List