@Override public int getCount(DaoFilter daoFilter) throws DaoException{ DSLContext context = getJooq(); try { Collection<Condition> conditions = new ArrayList<Condition>(); if (daoFilter.getLangIds() != null) { conditions.add(Tables.REDIRECT.LANG_ID.in(daoFilter.getLangIds())); } return context.select(). from(Tables.REDIRECT). where(conditions). fetchCount(); } finally { freeJooq(context); } }
@Override public int getCount(DaoFilter daoFilter) throws DaoException{ DSLContext context = getJooq(); try { Collection<Condition> conditions = new ArrayList<Condition>(); if (daoFilter.getLangIds() != null) { conditions.add(Tables.REDIRECT.LANG_ID.in(daoFilter.getLangIds())); } return context.select(). from(Tables.REDIRECT). where(conditions). fetchCount(); } finally { freeJooq(context); } }
@Override public int getCount(DaoFilter daoFilter) throws DaoException{ DSLContext context = getJooq(); try { Collection<Condition> conditions = new ArrayList<Condition>(); if (daoFilter.getNameSpaceIds() != null) { conditions.add(Tables.UNIVERSAL_PAGE.NAME_SPACE.in(daoFilter.getNameSpaceIds())); } if (daoFilter.isRedirect() != null) { conditions.add(Tables.UNIVERSAL_PAGE.ALGORITHM_ID.eq(algorithmId)); } return context.selectDistinct(Tables.UNIVERSAL_PAGE.UNIV_ID, Tables.UNIVERSAL_PAGE.ALGORITHM_ID) .from(Tables.UNIVERSAL_PAGE) .where(conditions) .fetchCount(); } finally { freeJooq(context); } }
@Override public int getCount(DaoFilter daoFilter) throws DaoException { DSLContext context = getJooq(); try { Collection<Condition> conditions = new ArrayList<Condition>(); if (daoFilter.getSourceIds() != null) { conditions.add(Tables.UNIVERSAL_LINK.UNIV_SOURCE_ID.in(daoFilter.getSourceIds())); } if (daoFilter.getDestIds() != null) { conditions.add(Tables.UNIVERSAL_LINK.UNIV_DEST_ID.in(daoFilter.getDestIds())); } if (daoFilter.isRedirect() != null) { conditions.add(Tables.UNIVERSAL_LINK.ALGORITHM_ID.eq(algorithmId)); } return context.selectDistinct(Tables.UNIVERSAL_LINK.UNIV_SOURCE_ID, Tables.UNIVERSAL_LINK.UNIV_DEST_ID, Tables.UNIVERSAL_LINK.ALGORITHM_ID) .from(Tables.UNIVERSAL_LINK) .where(conditions) .fetchCount(); } finally { freeJooq(context); } }
@Override public int getCount(DaoFilter daoFilter) throws DaoException { DSLContext context = getJooq(); try { Collection<Condition> conditions = new ArrayList<Condition>(); if (daoFilter.getNameSpaceIds() != null) { conditions.add(Tables.UNIVERSAL_SKELETAL_LINK.SOURCE_ID.in(daoFilter.getSourceIds())); } if (daoFilter.getNameSpaceIds() != null) { conditions.add(Tables.UNIVERSAL_SKELETAL_LINK.DEST_ID.in(daoFilter.getDestIds())); } if (daoFilter.isRedirect() != null) { conditions.add(Tables.UNIVERSAL_SKELETAL_LINK.ALGORITHM_ID.eq(algorithmId)); } return context.select() .from(Tables.UNIVERSAL_SKELETAL_LINK) .where(conditions) .fetchCount(); } finally { freeJooq(context); } }
from(Tables.LOCAL_LINK). where(conditions). fetchCount(); } finally { freeJooq(context);