public RatingVO<Integer, Integer> mapRow(ResultSet rs, int rowNum) throws SQLException { int tenantId = rs.getInt(COLUMN_TENANTID); int userId = rs.getInt(COLUMN_USERID); int itemId = rs.getInt(COLUMN_ITEMID); int itemTypeId = rs.getInt(COLUMN_ITEMTYPEID); double ratingValue = rs.getDouble(COLUMN_RATINGVALUE); Date actionTime = DaoUtils.getDate(rs, COLUMN_ACTIONTIME); ItemVO<Integer, Integer> item = new ItemVO<Integer, Integer>(tenantId, itemId, itemTypeId); return new RatingVO<Integer, Integer>(item, ratingValue, 0, actionTime, userId); } }
public List<RatingVO<Integer, Integer>> getAverageRatingsForUser(final Integer tenantId, final Integer itemTypeId) { Map<Integer, Double> sum = new HashMap<Integer, Double>(); Map<Integer, Integer> count = new HashMap<Integer, Integer>(); for (RatingVO<Integer, Integer> rating : ratings) { if (!tenantId.equals(rating.getItem().getTenant())) continue; if (!itemTypeId.equals(rating.getItem().getType())) continue; Integer key = rating.getUser(); if (!sum.containsKey(key)) { sum.put(key, 0.0); count.put(key, 0); } sum.put(key, sum.get(key) + rating.getRatingValue()); count.put(key, count.get(key) + 1); } List<RatingVO<Integer, Integer>> result = new ArrayList<RatingVO<Integer, Integer>>( sum.size()); for (Integer key : sum.keySet()) { RatingVO<Integer, Integer> rating = new RatingVO<Integer, Integer>(null, sum.get(key) / count.get(key), count.get(key), null, key, null); result.add(rating); } return result; }
public RatingVO<Integer, Integer> mapRow(final ResultSet rs, final int rowNum) throws SQLException { final Integer userId = DaoUtils.getInteger(rs, COLUMN_USERID); final Double averageRatingValue = DaoUtils.getDouble(rs, COLUMN_RATINGVALUE); final Integer count = DaoUtils.getInteger(rs, "count"); final RatingVO<Integer, Integer> rating = new RatingVO<Integer, Integer>( null, averageRatingValue, count, null, userId); return rating; } };
public List<RatingVO<Integer, Integer>> getAverageRatingsForItem(final Integer tenantId, final Integer itemTypeId) { Map<Integer, Double> sum = new HashMap<Integer, Double>(); Map<Integer, Integer> count = new HashMap<Integer, Integer>(); for (RatingVO<Integer, Integer> rating : ratings) { if (!tenantId.equals(rating.getItem().getTenant())) continue; if (!itemTypeId.equals(rating.getItem().getType())) continue; Integer key = rating.getItem().getItem(); if (!sum.containsKey(key)) { sum.put(key, 0.0); count.put(key, 0); } sum.put(key, sum.get(key) + rating.getRatingValue()); count.put(key, count.get(key) + 1); } List<RatingVO<Integer, Integer>> result = new ArrayList<RatingVO<Integer, Integer>>( sum.size()); for (Integer key : sum.keySet()) { RatingVO<Integer, Integer> rating = new RatingVO<Integer, Integer>( new ItemVO<Integer, Integer>(tenantId, key, itemTypeId), sum.get(key) / count.get(key), count.get(key), null, null, null); result.add(rating); } return result; }
public Object mapRow(final ResultSet rs, final int rowNum) throws SQLException { final Integer userId = DaoUtils.getInteger(rs, DEFAULT_USER_COLUMN_NAME); final Double averageRatingValue = DaoUtils.getDouble(rs, DEFAULT_RATING_VALUE_COLUMN_NAME); final Integer count = DaoUtils.getInteger(rs, "count"); final RatingVO<Integer, Integer> rating = new RatingVO<Integer, Integer>( null, averageRatingValue, count, null, userId); return rating; } };
public Object mapRow(final ResultSet rs, final int rowNum) throws SQLException { final Integer itemId = DaoUtils.getInteger(rs, DEFAULT_ITEM_COLUMN_NAME); final Double averageRatingValue = DaoUtils.getDouble(rs, DEFAULT_RATING_VALUE_COLUMN_NAME); final Integer count = DaoUtils.getInteger(rs, "count"); final ItemVO<Integer, Integer> item = new ItemVO<Integer, Integer>(tenantId, itemId, itemTypeId); final RatingVO<Integer, Integer> rating = new RatingVO<Integer, Integer>( item, averageRatingValue, count, null); return rating; } };
public RatingVO<Integer, Integer> mapRow(final ResultSet rs, final int rowNum) throws SQLException { final Integer itemId = DaoUtils.getInteger(rs, COLUMN_ITEMID); final Double averageRatingValue = DaoUtils.getDouble(rs, COLUMN_RATINGVALUE); final Integer count = DaoUtils.getInteger(rs, "count"); final ItemVO<Integer, Integer> item = new ItemVO<Integer, Integer>(tenantId, itemId, itemTypeId); return new RatingVO<Integer, Integer>(item, averageRatingValue, count, null); } };
action = currentAction; return new RatingVO<Integer, String>(action.getItem(), ((double) (sumCurrentRatingValues / (double) countCurrentActions)), actionsForTenantUserItemTriple.size(), action.getActionTime(), action.getUser()); return new RatingVO<Integer, String>(action.getItem(), actionMapping.get(action.getActionType()), actionsForTenantUserItemTriple.size(), action.getActionTime(), action.getUser()); return new RatingVO<Integer, String>(action.getItem(), actionMapping.get(action.getActionType()), actionsForTenantUserItemTriple.size(), action.getActionTime(), action.getUser()); return new RatingVO<Integer, String>(currentAction.getItem(), actionMapping.get(currentAction.getActionType()), actionsForTenantUserItemTriple.size(), action.getActionTime(), currentAction.getUser()); return new RatingVO<Integer, String>(action.getItem(), actionMapping.get(action.getActionType()), actionsForTenantUserItemTriple.size(), action.getActionTime(), action.getUser()); return new RatingVO<Integer, String>(action.getItem(), actionMapping.get(action.getActionType()), actionsForTenantUserItemTriple.size(), action.getActionTime(), action.getUser());
@Override public RatingVO<Integer, Integer> convertTypedRatingVO(Integer tenantId, RatingVO<Integer, String> typedRating) { if (typedRating == null) { return null; } return new RatingVO<Integer, Integer>( convertTypedItemVO(tenantId, typedRating.getItem()), typedRating.getRatingValue(), typedRating.getCount(), typedRating.getLastActionTime(), typedRating.getUser(), typedRating.getSessionId()); }
@Override public RatingVO<Integer, String> convertRatingVO(Integer tenantId, RatingVO<Integer, Integer> rating) { if (rating == null) { return null; } return new RatingVO<Integer, String>( convertItemVO(tenantId, rating.getItem()), rating.getRatingValue(), rating.getCount(), rating.getLastActionTime(), rating.getUser(), rating.getSessionId()); }
public Object mapRow(final ResultSet rs, final int rowNum) throws SQLException { final Integer tenantId = DaoUtils.getInteger(rs, DEFAULT_TENANT_COLUMN_NAME); final Integer userId = DaoUtils.getInteger(rs, DEFAULT_USER_COLUMN_NAME); final Integer itemId = DaoUtils.getInteger(rs, DEFAULT_ITEM_COLUMN_NAME); final Integer itemTypeId = DaoUtils.getInteger(rs, DEFAULT_ITEM_TYPE_COLUMN_NAME); final Integer ratingValue = DaoUtils.getInteger(rs, ratingValueColName); final Date actionTime = DaoUtils.getDate(rs, actionTimeColName); final ItemVO<Integer, Integer> item = new ItemVO<Integer, Integer>(tenantId, itemId, itemTypeId); final RatingVO<Integer, Integer> rating = new RatingVO<Integer, Integer>( item, (double) ratingValue, null, actionTime, userId); return rating; } }
public RatedTogether<Integer, Integer> mapRow(final ResultSet rs, final int rowNum) throws SQLException { final Integer itemId1 = DaoUtils.getInteger(rs, COLUMN_ITEMID + "1"); final Integer itemId2 = DaoUtils.getInteger(rs, COLUMN_ITEMID + "2"); final Integer itemTypeId1 = DaoUtils.getInteger(rs, COLUMN_ITEMTYPEID + "1"); final Integer itemTypeId2 = DaoUtils.getInteger(rs, COLUMN_ITEMTYPEID + "2"); final Integer tenantId = DaoUtils.getInteger(rs, COLUMN_TENANTID); final ItemVO<Integer, Integer> item1 = new ItemVO<Integer, Integer>(tenantId, itemId1, itemTypeId1); final ItemVO<Integer, Integer> item2 = new ItemVO<Integer, Integer>(tenantId, itemId2, itemTypeId2); final Double ratingValue1 = DaoUtils.getDouble(rs, COLUMN_RATINGVALUE + "1"); final Double ratingValue2 = DaoUtils.getDouble(rs, COLUMN_RATINGVALUE + "2"); final Integer userId1 = DaoUtils.getInteger(rs, COLUMN_USERID + "1"); final Integer userId2 = DaoUtils.getInteger(rs, COLUMN_USERID + "2"); final RatingVO<Integer, Integer> rating1 = new RatingVO<Integer, Integer>( item1, ratingValue1, null, null, userId1); final RatingVO<Integer, Integer> rating2 = new RatingVO<Integer, Integer>( item2, ratingValue2, null, null, userId2); final RatedTogether<Integer, Integer> ratedTogether = new RatedTogether<Integer, Integer>( rating1, rating2); return ratedTogether; } }
public RatingVO<Integer, Integer> mapRow(final ResultSet rs, final int rowNum) throws SQLException { final Integer tenantId = DaoUtils.getInteger(rs, COLUMN_TENANTID); final Integer userId = DaoUtils.getInteger(rs, COLUMN_USERID); final Integer itemId = DaoUtils.getInteger(rs, COLUMN_ITEMID); final Integer itemTypeId = DaoUtils.getInteger(rs, COLUMN_ITEMTYPEID); final Integer ratingValue = DaoUtils.getInteger(rs, ratingValueColName); final Date actionTime = DaoUtils.getDate(rs, actionTimeColName); final ItemVO<Integer, Integer> item = new ItemVO<Integer, Integer>(tenantId, itemId, itemTypeId); final RatingVO<Integer, Integer> rating = new RatingVO<Integer, Integer>( item, (double) ratingValue, null, actionTime, userId); return rating; } }
public Object mapRow(final ResultSet rs, final int rowNum) throws SQLException { final Integer itemId1 = DaoUtils.getInteger(rs, DEFAULT_ITEM_COLUMN_NAME + "1"); final Integer itemId2 = DaoUtils.getInteger(rs, DEFAULT_ITEM_COLUMN_NAME + "2"); final Integer itemTypeId1 = DaoUtils.getInteger(rs, DEFAULT_ITEM_TYPE_COLUMN_NAME + "1"); final Integer itemTypeId2 = DaoUtils.getInteger(rs, DEFAULT_ITEM_TYPE_COLUMN_NAME + "2"); final Integer tenantId = DaoUtils.getInteger(rs, DEFAULT_TENANT_COLUMN_NAME); final ItemVO<Integer, Integer> item1 = new ItemVO<Integer, Integer>(tenantId, itemId1, itemTypeId1); final ItemVO<Integer, Integer> item2 = new ItemVO<Integer, Integer>(tenantId, itemId2, itemTypeId2); final Double ratingValue1 = DaoUtils.getDouble(rs, DEFAULT_RATING_VALUE_COLUMN_NAME + "1"); final Double ratingValue2 = DaoUtils.getDouble(rs, DEFAULT_RATING_VALUE_COLUMN_NAME + "2"); final Integer userId1 = DaoUtils.getInteger(rs, DEFAULT_USER_COLUMN_NAME + "1"); final Integer userId2 = DaoUtils.getInteger(rs, DEFAULT_USER_COLUMN_NAME + "2"); final RatingVO<Integer, Integer> rating1 = new RatingVO<Integer, Integer>( item1, ratingValue1, null, null, userId1); final RatingVO<Integer, Integer> rating2 = new RatingVO<Integer, Integer>( item2, ratingValue2, null, null, userId2); final RatedTogether<Integer, Integer> ratedTogether = new RatedTogether<Integer, Integer>( rating1, rating2); return ratedTogether; } }
public RatingVO<Integer, Integer> mapRow(ResultSet rs, int rowNum) throws SQLException { RatingVO<Integer, Integer> rating = new RatingVO<Integer, Integer>( new ItemVO<Integer, Integer>(DaoUtils.getInteger(rs, DEFAULT_TENANT_COLUMN_NAME), DaoUtils.getInteger(rs, DEFAULT_ITEM_COLUMN_NAME), DaoUtils.getInteger(rs, DEFAULT_ITEM_TYPE_COLUMN_NAME)), DaoUtils.getDouble(rs, DEFAULT_RATING_ALIAS_NAME), DaoUtils.getInteger(rs, DEFAULT_COUNT_ALIAS_NAME), DaoUtils.getDate(rs, DEFAULT_LAST_ACTION_TIME_ALIAS_NAME), DaoUtils.getIntegerIfPresent(rs, DEFAULT_USER_COLUMN_NAME), DaoUtils.getStringIfPresent(rs, DEFAULT_SESSION_COLUMN_NAME)); return rating; } }