private static SelectConditionStep<Record1<Integer>> countLayerData(Field<Integer> datasetId) { return DSL.selectCount() .from(LAYER) .join(DATA) .on(LAYER.DATA.eq(DATA.ID)) // layer -> data .where(DATA.DATASET_ID.eq(datasetId)) .and(isIncludedAndNotHidden(DATA)); }
private static SelectConditionStep<Record1<Integer>> countSensorData(Field<Integer> datasetId) { return DSL.selectCount() .from(SENSORED_DATA) .join(DATA) .on(SENSORED_DATA.DATA.eq(DATA.ID)) // sensored_data -> data .where(DATA.DATASET_ID.eq(datasetId)) .and(isIncludedAndNotHidden(DATA)); }
private static SelectConditionStep<Record1<Integer>> countDataOfType( Field<Integer> datasetId, String type) { return DSL.selectCount() .from(DATA) .where(DATA.DATASET_ID.eq(datasetId)) .and(isIncludedAndNotHidden(DATA)) .and(DATA.TYPE.eq(type)); }