本文整理汇总了Java中org.easyrec.plugin.arm.model.ARMConfigurationInt.getRatingNeutral方法的典型用法代码示例。如果您正苦于以下问题:Java ARMConfigurationInt.getRatingNeutral方法的具体用法?Java ARMConfigurationInt.getRatingNeutral怎么用?Java ARMConfigurationInt.getRatingNeutral使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.easyrec.plugin.arm.model.ARMConfigurationInt
的用法示例。
在下文中一共展示了ARMConfigurationInt.getRatingNeutral方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: defineL1
import org.easyrec.plugin.arm.model.ARMConfigurationInt; //导入方法依赖的package包/类
@Override
public TObjectIntHashMap<ItemVO<Integer, Integer>> defineL1(ARMConfigurationInt configuration, int offset, int batchSize) {
ActionResultSetExtractor rse = new ActionResultSetExtractor();
List<Object> args = Lists.newArrayList();
List<Integer> argt = Lists.newArrayList();
StringBuilder query = new StringBuilder("SELECT ");
query.append(BaseActionDAO.DEFAULT_ITEM_COLUMN_NAME).append(", ");
query.append(BaseActionDAO.DEFAULT_ITEM_TYPE_COLUMN_NAME).append(", ");
query.append(BaseActionDAO.DEFAULT_TENANT_COLUMN_NAME).append(", ");
query.append("count(*) as cnt FROM ");
query.append(BaseActionDAO.DEFAULT_TABLE_NAME);
query.append(" WHERE ").append(BaseActionDAO.DEFAULT_TENANT_COLUMN_NAME).append("=")
.append(configuration.getTenantId());
query.append(" AND ").append(BaseActionDAO.DEFAULT_ACTION_TYPE_COLUMN_NAME).append("=")
.append(configuration.getActionType());
if (configuration.getRatingNeutral() != null) {
query.append(" AND ").append(BaseActionDAO.DEFAULT_RATING_VALUE_COLUMN_NAME).append(">")
.append(configuration.getRatingNeutral());
}
if (!configuration.getItemTypes().isEmpty()) {
query.append(" AND ").append(BaseActionDAO.DEFAULT_ITEM_TYPE_COLUMN_NAME).append(" IN (");
for (int i = 0; i < configuration.getItemTypes().size(); i++) {
query.append("?");
args.add(configuration.getItemTypes().get(i));
argt.add(Types.INTEGER);
if (i < configuration.getItemTypes().size() - 1) {
query.append(",");
} else {
query.append(")");
}
}
}
query.append(" GROUP BY ").append(BaseActionDAO.DEFAULT_ITEM_COLUMN_NAME).append(",").append(BaseActionDAO.DEFAULT_ITEM_TYPE_COLUMN_NAME)
.append(" HAVING cnt >= ? ORDER BY cnt DESC");
args.add(configuration.getSupport());
argt.add(Types.INTEGER);
query.append(" LIMIT ?,?");
args.add(offset);
argt.add(Types.INTEGER);
args.add(Math.min(offset+batchSize, configuration.getMaxSizeL1()));
argt.add(Types.INTEGER);
TObjectIntHashMap<ItemVO<Integer, Integer>> ret = getJdbcTemplate()
.query(query.toString(), args.toArray(), Ints.toArray(argt), rse);
return ret;
}
示例2: defineL1
import org.easyrec.plugin.arm.model.ARMConfigurationInt; //导入方法依赖的package包/类
public TObjectIntHashMap<ItemVO<Integer, Integer>> defineL1(ARMConfigurationInt configuration) {
ActionResultSetExtractor rse = new ActionResultSetExtractor();
List<Object> args = Lists.newArrayList();
List<Integer> argt = Lists.newArrayList();
StringBuilder query = new StringBuilder("SELECT ");
query.append(BaseActionDAO.DEFAULT_ITEM_COLUMN_NAME).append(", ");
query.append(BaseActionDAO.DEFAULT_ITEM_TYPE_COLUMN_NAME).append(", ");
query.append(BaseActionDAO.DEFAULT_TENANT_COLUMN_NAME).append(", ");
query.append("count(*) as cnt FROM ");
query.append(BaseActionDAO.DEFAULT_TABLE_NAME);
query.append(" WHERE ").append(BaseActionDAO.DEFAULT_TENANT_COLUMN_NAME).append("=")
.append(configuration.getTenantId());
query.append(" AND ").append(BaseActionDAO.DEFAULT_ACTION_TYPE_COLUMN_NAME).append("=")
.append(configuration.getActionType());
if (configuration.getRatingNeutral() != null) {
query.append(" AND ").append(BaseActionDAO.DEFAULT_RATING_VALUE_COLUMN_NAME).append(">")
.append(configuration.getRatingNeutral());
}
if (!configuration.getItemTypes().isEmpty()) {
query.append(" AND ").append(BaseActionDAO.DEFAULT_ITEM_TYPE_COLUMN_NAME).append(" IN (");
for (int i = 0; i < configuration.getItemTypes().size(); i++) {
query.append("?");
args.add(configuration.getItemTypes().get(i));
argt.add(Types.INTEGER);
if (i < configuration.getItemTypes().size() - 1) {
query.append(",");
} else {
query.append(")");
}
}
}
query.append(" GROUP BY ").append(BaseActionDAO.DEFAULT_ITEM_COLUMN_NAME).append(",").append(BaseActionDAO.DEFAULT_ITEM_TYPE_COLUMN_NAME)
.append(" HAVING cnt >= ? ORDER BY cnt DESC");
args.add(configuration.getSupport());
argt.add(Types.INTEGER);
query.append(" LIMIT ?");
args.add(configuration.getMaxSizeL1());
argt.add(Types.INTEGER);
TObjectIntHashMap<ItemVO<Integer, Integer>> ret = getJdbcTemplate()
.query(query.toString(), args.toArray(), Ints.toArray(argt), rse);
//if (ret.size() == configuration.getMaxSizeL1()) configuration.setSupport(rse.getMinSupp());
return ret;
}