Java tutorial
/* * Seldon -- open source prediction engine * ======================================= * * Copyright 2011-2015 Seldon Technologies Ltd and Rummble Ltd (http://www.seldon.io/) * * ******************************************************************************************** * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. * * ******************************************************************************************** */ package io.seldon.similarity.item; import io.seldon.api.Constants; import io.seldon.db.jdo.ClientPersistable; import java.util.ArrayList; import java.util.Collection; import java.util.HashMap; import java.util.Map; import java.util.Set; import javax.jdo.Query; import org.apache.commons.lang.StringUtils; import org.apache.log4j.Logger; public class JdoItemSimilarityPeer extends ClientPersistable implements IItemSimilarityPeer { private static Logger logger = Logger.getLogger(JdoItemSimilarityPeer.class.getName()); public JdoItemSimilarityPeer(String clientName) { super(clientName); } @Override public Map<Long, Double> getSimilarItems(long itemId, Set<Integer> dimensions, int max) { Collection<Object[]> results; Query query; if (dimensions.isEmpty() || (dimensions.size() == 1 && dimensions.iterator().next() == Constants.DEFAULT_DIMENSION)) { String sql = "select isim.item_id2 as item_id,score from item_similarity isim where isim.item_id=? union select isim.item_id,score from item_similarity isim where isim.item_id2=? order by score desc"; if (max > 0) sql = sql + " limit " + max; query = getPM().newQuery("javax.jdo.query.SQL", sql); ArrayList<Object> args = new ArrayList<>(); args.add(itemId); args.add(itemId); results = (Collection<Object[]>) query.executeWithArray(args.toArray()); } else { String dimensionsStr = StringUtils.join(dimensions, ","); String sql = "select isim.item_id2 as item_id,score from item_similarity isim join item_map_enum ime on (isim.item_id2=ime.item_id) join dimension d on (ime.attr_id=d.attr_id and ime.value_id=d.value_id) where dim_id in (" + dimensionsStr + ") and isim.item_id=? union select isim.item_id,score from item_similarity isim join item_map_enum ime on (isim.item_id=ime.item_id) join dimension d on (ime.attr_id=d.attr_id and ime.value_id=d.value_id) where dim_id in (" + dimensionsStr + ") and isim.item_id2=? order by score desc"; if (max > 0) sql = sql + " limit " + max; query = getPM().newQuery("javax.jdo.query.SQL", sql); ArrayList<Object> args = new ArrayList<>(); args.add(itemId); args.add(itemId); results = (Collection<Object[]>) query.executeWithArray(args.toArray()); } Map<Long, Double> map = new HashMap<>(); for (Object[] res : results) { Long item = (Long) res[0]; Double score = (Double) res[1]; map.put(item, score); } query.closeAll(); return map; } @Override public Map<Long, Double> getRecommendations(long userId, int dimension, int max) { String sql = "select r.item_id,score from recommendations r join item_map_enum ime on (r.item_id=ime.item_id) join dimension d on (ime.attr_id=d.attr_id and ime.value_id=d.value_id) where dim_id=? and user_id=? order by score desc"; if (max > 0) sql = sql + " limit " + max; Query query = getPM().newQuery("javax.jdo.query.SQL", sql); Collection<Object[]> results = (Collection<Object[]>) query.execute(dimension, userId); Map<Long, Double> map = new HashMap<>(); for (Object[] res : results) { Long item = (Long) res[0]; Double score = (Double) res[1]; map.put(item, score); } query.closeAll(); return map; } }