/** * Determines if the currently inquiring user has associated temporary pending entries in the temporary pending entry table * * @param sessionId the unique web id of the inquiring user * @return true if this inquiring user has temporary pending entries, false otherwise */ protected boolean hasEntriesInPendingTable(String sessionId) { return getSimpleJdbcTemplate().queryForInt("select count(*) as COUNT from GL_PENDING_ENTRY_MT WHERE sesid = ?", sessionId) != 0; }
public Problem[] isPrepared() { if (ds == null) return new Problem[] {new Problem("dataSource is not set")}; try { jdbc.queryForInt("SELECT count(*) FROM "+TABLE); } catch (DataAccessException e) { return new Problem[] {new Problem("Database is not configured")}; } return null; }
@Override public FlowCollection getFlows(CriteriaAdapter criteria) { FlowCollection flowCollection = new FlowCollection(); final String whereClause = criteria.getWhereClause(); final String countQuery = dialect.getCountQuery().replaceAll(DatabaseDialect.SUBSTITUTION_STRING, (whereClause != null && whereClause.length() > 0) ? " AND " + whereClause : ""); int rowCount = getSimpleJdbcTemplate().queryForInt(countQuery, criteria); int offset = Integer.parseInt(criteria.getValue("offset").toString()); int limit = Integer.parseInt(criteria.getValue("limit").toString()); List<Flow> flows = null; if (offset < rowCount) { String dataQuery = dialect.getDataQuery(criteria); if ((rowCount - offset) < limit) limit = rowCount - offset; String soffset = String.valueOf(offset); String slimit = String.valueOf(limit); dataQuery = dataQuery.replaceAll(SUBSTITUTION_STRING_LIMIT, slimit).replaceAll(SUBSTITUTION_STRING_OFFSET, soffset); flows = getSimpleJdbcTemplate().query(dataQuery, flowMapper, criteria); } if(flows == null) flows = new ArrayList<Flow>(); flowCollection.setFlows(flows); flowCollection.setCount(rowCount); return flowCollection; }
public int getMessageContentSize(int id) throws DataAccessException { try { MapSqlParameterSource params = new MapSqlParameterSource(); params.addValue(ID, id, Types.INTEGER); SimpleJdbcTemplate template = new SimpleJdbcTemplate( getNamedParameterJdbcTemplate()); return template.queryForInt(SELECT_CONTENT_SIZE, params); } catch (EmptyResultDataAccessException erdae) { return -1; } }
public int getMessageContentId(int headerId) throws DataAccessException { try { MapSqlParameterSource params = new MapSqlParameterSource(); params.addValue(ID, headerId, Types.INTEGER); SimpleJdbcTemplate template = new SimpleJdbcTemplate( getNamedParameterJdbcTemplate()); return template.queryForInt(SELECT_CONTENT_ID, params); } catch (EmptyResultDataAccessException erdae) { return -1; } }
/** * This method purges all records in the Prior Year Account table in the DB. * * @return Number of records that were purged. */ public int purgePriorYearAccounts() { final String priorYrAcctTableName = getPersistenceStructureService().getTableName(PriorYearAccount.class); // 1. Count how many rows are currently in the prior year acct table int count = getSimpleJdbcTemplate().queryForInt("SELECT COUNT(1) FROM " + priorYrAcctTableName); // 2. Purge all the rows from the prior year acct table getSimpleJdbcTemplate().update("DELETE FROM " + priorYrAcctTableName); return count; }
/** * This method copies all organization records from the current Account table to the Prior Year Account table. * * @return Number of records that were copied. */ public int copyCurrentAccountsToPriorYearTable() { final String priorYrAcctTableName = getPersistenceStructureService().getTableName(PriorYearAccount.class); final String acctTableName = getPersistenceStructureService().getTableName(Account.class); // 1. Copy all the rows from the current org table to the prior year acct table getSimpleJdbcTemplate().update( "INSERT INTO " + priorYrAcctTableName + "(FIN_COA_CD, ACCOUNT_NBR, OBJ_ID, VER_NBR, ACCOUNT_NM, ACCT_FSC_OFC_UID, ACCT_SPVSR_UNVL_ID, ACCT_MGR_UNVL_ID, ORG_CD, ACCT_TYP_CD, ACCT_PHYS_CMP_CD, SUB_FUND_GRP_CD, ACCT_FRNG_BNFT_CD, FIN_HGH_ED_FUNC_CD, ACCT_RSTRC_STAT_CD, ACCT_RSTRC_STAT_DT, ACCT_CITY_NM, ACCT_STATE_CD, ACCT_STREET_ADDR, ACCT_ZIP_CD, RPTS_TO_FIN_COA_CD, RPTS_TO_ACCT_NBR, ACCT_CREATE_DT, ACCT_EFFECT_DT, ACCT_EXPIRATION_DT, CONT_FIN_COA_CD, CONT_ACCOUNT_NBR, ENDOW_FIN_COA_CD, ENDOW_ACCOUNT_NBR, CONTR_CTRL_FCOA_CD, CONTR_CTRLACCT_NBR, INCOME_FIN_COA_CD, INCOME_ACCOUNT_NBR, ACCT_ICR_TYP_CD, AC_CSTM_ICREXCL_CD, FIN_SERIES_ID, ICR_FIN_COA_CD, ICR_ACCOUNT_NBR, ACCT_IN_FP_CD, BDGT_REC_LVL_CD, ACCT_SF_CD, ACCT_PND_SF_CD, FIN_EXT_ENC_SF_CD, FIN_INT_ENC_SF_CD, FIN_PRE_ENC_SF_CD, FIN_OBJ_PRSCTRL_CD, CG_CFDA_NBR, ACCT_OFF_CMP_IND, ACCT_CLOSED_IND) " + " SELECT FIN_COA_CD, ACCOUNT_NBR, OBJ_ID, VER_NBR, ACCOUNT_NM, ACCT_FSC_OFC_UID, ACCT_SPVSR_UNVL_ID, ACCT_MGR_UNVL_ID, ORG_CD, ACCT_TYP_CD, ACCT_PHYS_CMP_CD, SUB_FUND_GRP_CD, ACCT_FRNG_BNFT_CD, FIN_HGH_ED_FUNC_CD, ACCT_RSTRC_STAT_CD, ACCT_RSTRC_STAT_DT, ACCT_CITY_NM, ACCT_STATE_CD, ACCT_STREET_ADDR, ACCT_ZIP_CD, RPTS_TO_FIN_COA_CD, RPTS_TO_ACCT_NBR, ACCT_CREATE_DT, ACCT_EFFECT_DT, ACCT_EXPIRATION_DT, CONT_FIN_COA_CD, CONT_ACCOUNT_NBR, ENDOW_FIN_COA_CD, ENDOW_ACCOUNT_NBR, CONTR_CTRL_FCOA_CD, CONTR_CTRLACCT_NBR, INCOME_FIN_COA_CD, INCOME_ACCOUNT_NBR, ACCT_ICR_TYP_CD, AC_CSTM_ICREXCL_CD, FIN_SERIES_ID, ICR_FIN_COA_CD, ICR_ACCOUNT_NBR, ACCT_IN_FP_CD, BDGT_REC_LVL_CD, ACCT_SF_CD, ACCT_PND_SF_CD, FIN_EXT_ENC_SF_CD, FIN_INT_ENC_SF_CD, FIN_PRE_ENC_SF_CD, FIN_OBJ_PRSCTRL_CD, CG_CFDA_NBR, ACCT_OFF_CMP_IND, ACCT_CLOSED_IND " + " FROM " + acctTableName); // 2. Count how many rows are currently in the prior year acct table return getSimpleJdbcTemplate().queryForInt("SELECT COUNT(1) FROM " + priorYrAcctTableName); }
/** * This method purges all records in the Prior Year Organization table in the DB. * * @return Number of records that were purged. * @see org.kuali.kfs.coa.dataaccess.PriorYearOrganizationDao#purgePriorYearOrganizations() */ public int purgePriorYearOrganizations() { String priorYrOrgTableName = MetadataManager.getInstance().getGlobalRepository().getDescriptorFor(PriorYearOrganization.class).getFullTableName(); // 1. Count how many rows are currently in the prior year org table int count = getSimpleJdbcTemplate().queryForInt("SELECT COUNT(" + OBJ_ID + ") from " + priorYrOrgTableName); // 2. Purge all the rows from the prior year org table getSimpleJdbcTemplate().update("DELETE from " + priorYrOrgTableName); return count; }
/** * This method copies all organization records from the current Org table to the Prior Year Organization table. * * @return Number of records that were copied. * @see org.kuali.kfs.coa.dataaccess.PriorYearOrganizationDao#copyCurrentOrganizationsToPriorYearTable() */ public int copyCurrentOrganizationsToPriorYearTable() { String priorYrOrgTableName = MetadataManager.getInstance().getGlobalRepository().getDescriptorFor(PriorYearOrganization.class).getFullTableName(); String orgTableName = MetadataManager.getInstance().getGlobalRepository().getDescriptorFor(Organization.class).getFullTableName(); // 1. Copy all the rows from the current org table to the prior year org table getSimpleJdbcTemplate().update("INSERT into " + priorYrOrgTableName + " SELECT * from " + orgTableName); // 2. Count how many rows are currently in the prior year org table return getSimpleJdbcTemplate().queryForInt("SELECT COUNT(" + OBJ_ID + ") from " + priorYrOrgTableName); }