io.vertx.up.uca.jooq.AggregatorCount Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of vertx-up Show documentation

There is a newer version: 0.9.0

package io.vertx.up.uca.jooq;

import io.vertx.core.Future;
import io.vertx.core.json.JsonArray;
import io.vertx.core.json.JsonObject;
import org.jooq.Condition;
import org.jooq.Field;

import java.util.concurrent.ConcurrentMap;

/**
 * @author Lang
 * SQL Statement:
 * -- SELECT COUNT(*) FROM 
 */
@SuppressWarnings("all")
class AggregatorCount extends AbstractAggregator {

    private static final String FIELD_COUNT = "COUNT";

    AggregatorCount(final JqAnalyzer analyzer) {
        super(analyzer);
    }

    // ------------- Count Operation --------------
    /*
     * All count
     */
    Long count() {
        Long rows = Long.valueOf(this.context().fetchCount(this.analyzer.table()));
        this.logging("[ Jq ] count() rows: {0}", String.valueOf(rows));
        return rows;
    }

    Future countAsync() {
        return this.dsl.executeBlocking(h -> h.complete(this.count()));
    }

    /*
     * Count by criteria
     */
    Long count(final JsonObject criteria) {
        final Condition condition = this.analyzer.condition(criteria);
        Long rows = Long.valueOf(this.context().fetchCount(this.analyzer.table(), condition));
        this.logging("[ Jq ] count(JsonObject) rows: {0}", String.valueOf(rows));
        return rows;
    }

     Future countAsync(final JsonObject criteria) {
        return this.dsl.executeBlocking(h -> h.complete(this.count(criteria)));
    }

    /*
     * Single group
     */
    ConcurrentMap countBy(final JsonObject criteria, final String groupField) {
        final String primary = this.analyzer.primary();
        final Field countField = this.analyzer.column(primary).count().as(FIELD_COUNT);
        return this.aggregateBy(countField, criteria, groupField);
    }

    /*
     * Multi group
     */
    JsonArray countBy(final JsonObject criteria, final String... groupFields) {
        final String primary = this.analyzer.primary();
        final Field countField = this.analyzer.column(primary).count().as(FIELD_COUNT);
        return this.aggregateBy(countField, criteria, groupFields);
    }

}