@Override public int getCountByTag(String tagKeyword) { if (tagKeyword != null) { tagKeyword = tagKeyword.toLowerCase(); } Tag tag = tagRepository.getByKeyword(tagKeyword); Query query = manager.createNamedQuery(JpaWidget.WIDGET_COUNT_BY_TAG); query.setParameter(JpaWidget.PARAM_TAG_ID, tag == null ? null : Long.parseLong(tag.getId())); Number countResult = (Number) query.getSingleResult(); return countResult.intValue(); }
@Override public void delete(Tag item) { manager.remove(item instanceof JpaTag ? item : getByKeyword(item.getKeyword())); } }
public WidgetTagImpl(User user, Date createdDate, Tag tag) { this.userId = user.getId(); this.tagId = tag.getId(); this.createdDate = createdDate; }
private void updateProperties(Tag source, JpaTag jpaTag) { jpaTag.setKeyword(source.getKeyword()); }
@Override public WidgetTag getTagByWidgetIdAndKeyword(String widgetId, String keyword) { if (keyword != null) { keyword = keyword.trim(); } Tag tag = tagRepository.getByKeyword(keyword); TypedQuery<JpaWidgetTag> query = manager.createNamedQuery(JpaWidgetTag.FIND_BY_WIDGETID_AND_TAGID, JpaWidgetTag.class); query.setParameter(JpaWidgetTag.TAG_ID_PARAM, tag == null ? null : Long.parseLong(tag.getId())); query.setParameter(JpaWidgetTag.WIDGET_ID_PARAM, widgetId == null ? null : Long.parseLong(widgetId)); return getSingleResult(query.getResultList()); }
private JpaTag createEntity(Tag source) { JpaTag convertedTag; TypedQuery<JpaTag> query = manager.createNamedQuery(JpaTag.FIND_BY_KEYWORD, JpaTag.class); query.setParameter(JpaTag.KEYWORD_PARAM, source.getKeyword()); convertedTag = JpaUtil.getSingleResult(query.getResultList()); if (convertedTag == null){ convertedTag = new JpaTag(); } updateProperties(source, convertedTag); return convertedTag; }
@Override public List<Widget> getWidgetsByTag(String tagKeyword, int offset, int pageSize) { if (tagKeyword != null) { tagKeyword = tagKeyword.toLowerCase(); } Tag tag = tagRepository.getByKeyword(tagKeyword); TypedQuery<JpaWidget> query = manager.createNamedQuery(JpaWidget.WIDGET_GET_BY_TAG, JpaWidget.class); query.setParameter(JpaWidget.PARAM_TAG_ID, tag == null ? null : Long.parseLong(tag.getId())); return expandProperties(getPagedResultList(query, offset, pageSize)); }