@Override public SelectSelectStep<Record1<Integer>> selectCount() { return delegate.selectCount(); }
@Override public Integer getProjectsCount() { return create.selectCount().from(PROJECT).fetchOneInto(Integer.class); }
public static <P extends VertxPojo, R extends UpdatableRecord<R>,T,F> F countAsync(DAO<R,P,T> dao,BiFunction<Query, Function<JsonObject, Optional<Object>>, F> function){ return function.apply(DSL.using(dao.configuration()).selectCount().from(dao.getTable()), json -> json.getMap().values().stream().findFirst()); }
@Override public int numPreferences() { return dsl .selectCount() .from(DATA) .fetchOne().value1(); }
@Override public int numUsers() { return dsl .selectCount() .from(USERS) .fetchOne().value1(); }
@Override public final long count() { return using(configuration) .selectCount() .from(table) .fetchOne(0, Long.class); }
@Override public /* non-final */ long count() { return using(configuration) .selectCount() .from(table) .fetchOne(0, Long.class); }
@Override public int numItems() { return dsl .selectCount() .from(ITEMS) .fetchOne().value1(); }
@Override public int numItems(int uidx) { return dsl .selectCount() .from(DATA) .where(UIDX.eq(uidx)) .fetchOne().value1(); }
@Override public int numUsers(int iidx) { return dsl .selectCount() .from(DATA) .where(IIDX.eq(iidx)) .fetchOne().value1(); }
private boolean existsSqliteSequence() { if (existsSqliteSequence == null) { existsSqliteSequence = create() .selectCount() .from(SQLITE_MASTER) .where(SQLiteMaster.NAME.lower().eq("sqlite_sequence")) .fetchOne(0, boolean.class); } return existsSqliteSequence; } }
private int countRunning(DSLContext tx, UUID prjId) { return tx.selectCount() .from(PROCESS_QUEUE) .where(PROCESS_QUEUE.PROJECT_ID.eq(prjId).and(PROCESS_QUEUE.CURRENT_STATUS.in(RUNNING_PROCESS_STATUSES))) .fetchOne(0, int.class); }
@Override public int numUsers(String i) { return dsl .selectCount() .from(DATA).naturalJoin(ITEMS) .where(ITEM_ID.eq(i)) .fetchOne().value1(); }
@Override public int numItems(String u) { return dsl .selectCount() .from(DATA).naturalJoin(USERS) .where(USER_ID.eq(u)).fetchOne().value1(); }
@Override public /* non-final */ boolean existsById(T id) { Field<?>[] pk = pk(); if (pk != null) { return using(configuration) .selectCount() .from(table) .where(equal(pk, id)) .fetchOne(0, Integer.class) > 0; } else { return false; } }
@Override public final boolean existsById(T id) { Field<?> pk = pk(); if (pk != null) { return using(configuration) .selectCount() .from(table) .where(equal(pk, id)) .fetchOne(0, Integer.class) > 0; } else { return false; } }
private Field<Number> count(DSLContext tx, Field<UUID> parentInstanceId, ProcessKind kind) { return tx.selectCount() .from(PROCESS_QUEUE) .where(PROCESS_QUEUE.PARENT_INSTANCE_ID.eq(parentInstanceId) .and(PROCESS_QUEUE.PROCESS_KIND.eq(kind.toString()))) .asField(); }
@Override public int getCount(DaoFilter daoFilter) throws DaoException{ DSLContext context = getJooq(); try { Collection<Condition> conditions = getConditions(daoFilter); return context.selectCount(). from(Tables.RAW_PAGE). where(conditions). fetchOne().value1(); } finally { freeJooq(context); } }
public boolean hasActiveProcess(DSLContext tx, Timestamp fromTime, Timestamp toTime) { int count = tx.selectCount() .from(PROCESS_QUEUE) .where(PROCESS_QUEUE.CREATED_AT.between(fromTime, toTime) .and(PROCESS_QUEUE.CURRENT_STATUS.notIn(ProcessStatus.FINISHED.name(), ProcessStatus.FAILED.name(), ProcessStatus.CANCELLED.name(), ProcessStatus.TIMED_OUT.name()))) .fetchOne(Record1::value1); return count > 0; }
@Override public boolean isVolumeInUseByRunningInstance(long volumeId) { Result<Record1<Integer>> result = create() .selectCount() .from(INSTANCE) .join(MOUNT) .on(MOUNT.INSTANCE_ID.eq(INSTANCE.ID)) .where(INSTANCE.STATE.notIn(INSTANCE_STATES)) .and(INSTANCE.REMOVED.isNull()) .and(MOUNT.REMOVED.isNull()) .and(MOUNT.VOLUME_ID.eq(volumeId)) .fetch(); Integer inUseCount = (Integer)result.getValue(0, 0); return inUseCount > 0; }