Maximum

Maximum

Exposes API's to returns the maximum value of all values in the group. The maximum value is the value that would be returned last in an ORDER BY on the same column. Aggregate max() returns NULL if and only if there are no non-NULL values in the group.

Android API: Maximum

    public IMax max() throws DatabaseException;

• Android: IMax Interface

    public interface IMax {

        public IMaxClause where(String column);
	
        public IMax whereClause(String whereClause);
	
        public IMaxClause and(String column);
	
        public IMaxClause or(String column);

        public IMax groupBy(String...columns);
	
        public IMaxClause having(String column);

        public IMax havingClause(String havingClause);
	
        public IMax column(String column);
	
        public Object execute() throws DatabaseException;
	
    }

• Android: IMaxClause Interface

    public interface IMaxClause {

        public IMax equalTo(String value);

        public IMax notEqualTo(String value);
	
        public IMax greaterThan(String value);
	
        public IMax greaterThanEqual(String value);
	
        public IMax lessThan(String value);
	
        public IMax lessThanEqual(String value);
	
        public IMax between(String start, String end);
	
        public IMax like(String like);
	
        public IMax in(String...values);
	
    }

Android Sample: Get Maximum

    int maximum = 0;
	
    try {
        maximum = new Book().max().column(Book.COLUMN_NAME_WHICH_CONTAIN_NUMBRIC_VALUE).where(Book.TITLE).equalTo("C").execute();
    } catch(DatabaseException de) {
		//Log it.
    }
	

iOS API: Maximum

    - (id<SICIMax>)max;

• iOS: IMax Interface

    @protocol SICIMax <NSObject>

    - (id<SICIMaxClause>)where:(NSString *)column;

    - (id<SICIMax>)whereClause:(NSString *)whereClause;

    - (id<SICIMaxClause>)and:(NSString*)column;

    - (id<SICIMaxClause>)or:(NSString *)column;

    - (id<SICIMax>)groupBy:(NSArray *)columns;

    - (id<SICIMaxClause>)having:(NSString *)column;

    - (id<SICIMax>)havingClause:(NSString *)havingClause;

    - (id<SICIMax>)column:(NSString *)column;

    - (id)execute;

    @end

• iOS: SICIMaxClause Interface

    @protocol SICIMaxClause <NSObject>

    - (id<SICIMax>)equalTo:(id)value;

    - (id<SICIMax>)notEqualTo:(id)value;

    - (id<SICIMax>)greaterThan:(id)value;

    - (id<SICIMax>)greaterThan:(id)value;

    - (id<SICIMax>)lessThan:(id)value;

    - (id<SICIMax>)lessThanEqual:(id)value;

    - (id<SICIMax>)between:(id)start end:(id)end;

    - (id<SICIMax>)like:(id)like;

    - (id<SICIMax>)in:(id)values;

    @end

iOS Sample: Get Maximum

    double maximum = 0;
	
    @try {
        maximum = [[[[[[[Book alloc] init] max] column:[Book COLUMN_NAME_WHICH_CONTAIN_NUMBRIC_VALUE]] where:[Book TITLE]] equalTo:@"C"] execute];
    } @catch(SICDatabaseException *databaseException) {
		//Log it.
    }
	

Windows API: Maximum

    public IMax Max();

• Windows: IMax Interface

    public interface IMax 
    {

        IMaxClause Where(String column);
	
        IMax WhereClause(String whereClause);
	
        IMaxClause And(String column);
	
        IMaxClause Or(String column);

        IMax GroupBy(String[] columns);
	
        IMaxClause Having(String column);

        IMax HavingClause(String havingClause);
	
        IMax Column(String column);
	
        double Execute();
	 
    }

• Windows: IMaxClause Interface

    public interface IMaxClause 
    {
 
        IMax EqualTo(String value);

        IMax NotEqualTo(String value);
	
        IMax GreaterThan(String value);
	
        IMax GreaterThanEqual(String value);
	
        IMax LessThan(String value);
	
        IMax LessThanEqual(String value);
	
        IMax Between(String start, String end);
	
        IMax Like(String like);
	
        IMax In(String[] values);
	
    }

Windows Sample: Get Maximum

    double maximum = 0;
	
    try 
    {
        maximum = new Book().Max().Column(Book.COLUMN_NAME_WHICH_CONTAIN_NUMBRIC_VALUE).Where(Book.TITLE).EqualTo("C").Execute();
    } 
    catch(DatabaseException de) 
    {
		//Log it.
    }
	

JavaScript API: Maximum

    this.max = function();

• JavaScript: IMax Interface

    function IMax() {

        this.where = function(column);
	
        this.whereClause = function(whereClause);
	
        this.and = function(column);
	
        this.or = function(column);

        this.groupBy = function(columns);
	
        this.having = function(column);

        this.havingClause = function(havingClause);
	
        this.column = function(column);
	
        this.execute = function();

        this.executeAsync = function(callback, transaction);
	 
    }

• JavaScript: IMaxClause Interface

    function IMaxClause() {
 
        this.equalTo = function(value);

        this.notEqualTo = function(value);
	
        this.greaterThan = function(value);
	
        this.greaterThanEqual = function(value);
	
        this.lessThan = function(value);
	
        this.lessThanEqual = function(value);
	
        this.between = function(start, end);
	
        this.like(like);
	
        this.in = function(values);
	
    }

JavaScript Sample: Get Maximum

            /** Maximum Sample **/

    double maximum = 0;
	
    try {
        maximum = new Book().max().column(Book.COLUMN_NAME_WHICH_CONTAIN_NUMBRIC_VALUE).where(Book.TITLE).equalTo("C").execute();
    } catch(de) {
		//Log it.
    }
	

            /** Maximum Async Sample **/

    var callback = new Callback();
    callback.onSuccess = function(max) {

    }

    new Book().max().executeAsync(callback);

            /** Maximum Async Transaction Sample **/

    var callback = new Callback();
    callback.onExecute = function(transaction) {

        var maxCallback = new Callback();
        maxCallback.onSuccess = function() {

        }

        new Book().max().executeAsync(maxCallback, transaction);
    }

    callback.onSuccess = function() {

    }

    var databaseDescriptor = new Lession().getDatabaseDescriptor();
    Database.beginTransactionAsync(databaseDescriptor, callback);