framework/db/src/com/cloud/utils/db/GroupBy.java

// Licensed to the Apache Software Foundation (ASF) under one
// or more contributor license agreements.  See the NOTICE file
// distributed with this work for additional information
// regarding copyright ownership.  The ASF licenses this file
// to you under the Apache License, Version 2.0 (the
// "License"); you may not use this file except in compliance
// the License.  You may obtain a copy of the License at
//
// http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing,
// software distributed under the License is distributed on an
// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
// KIND, either express or implied.  See the License for the
// specific language governing permissions and limitations
// under the License.
package com.cloud.utils.db;

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

import com.cloud.utils.Pair;
import com.cloud.utils.db.SearchCriteria.Func;
import com.cloud.utils.db.SearchCriteria.Op;

public class GroupBy<J extends SearchBase<?, T, R>, T, R> {
    J _builder;
    List<Pair<Func, Attribute>> _groupBys;
    Having _having;

    public GroupBy(final J builder) {
        init(builder);
    }

    protected void init(final J builder) {
        _builder = builder;
        _groupBys = new ArrayList<Pair<Func, Attribute>>();
        _having = null;
        for (final Attribute attr : _builder.getSpecifiedAttributes()) {
            _groupBys.add(new Pair<Func, Attribute>(null, attr));
        }
        _builder.getSpecifiedAttributes().clear();
    }

    public GroupBy<J, T, R> group(final Object useless) {
        _groupBys.add(new Pair<Func, Attribute>(null, _builder.getSpecifiedAttributes().get(0)));
        _builder.getSpecifiedAttributes().clear();
        return this;
    }

    public GroupBy<J, T, R> group(final Func func, final Object useless) {
        _groupBys.add(new Pair<Func, Attribute>(func, _builder.getSpecifiedAttributes().get(0)));
        _builder.getSpecifiedAttributes().clear();
        return this;
    }

    public J having(final Func func, final Attribute obj, final Op op) {
        assert (_having == null) : "You can only specify one having in a group by";
        _having = new Having(func, obj, op);
        _builder.getSpecifiedAttributes().clear();
        return _builder;
    }

    public void toSql(final StringBuilder builder) {
        builder.append(" GROUP BY ");
        for (final Pair<Func, Attribute> groupBy : _groupBys) {
            if (groupBy.first() != null) {
                String func = groupBy.first().toString();
                func = func.replaceFirst("@", groupBy.second().table + "." + groupBy.second().columnName);
                builder.append(func);
            } else {
                builder.append(groupBy.second().table + "." + groupBy.second().columnName);
            }

            builder.append(", ");
        }

        builder.delete(builder.length() - 2, builder.length());
        if (_having != null) {
            _having.toSql(builder);
        }
    }

    protected class Having {
        public Func func;
        public Attribute attr;
        public Op op;

        public Having(final Func func, final Attribute attr, final Op op) {
            this.func = func;
            this.attr = attr;
            this.op = op;
        }

        public void toSql(final StringBuilder builder) {
            builder.append(" HAVING ");
            if (func != null) {
                String f = func.toString();
                f = f.replaceFirst("@", attr.toString());
                builder.append(f);
            } else {
                builder.append(attr.toString());
            }

            builder.append(op.toString());
        }
    }
}