Examples of com.gnizr.db.dao.UserTag

com.gnizr.db.dao.UserTag
This class provides the representation for describing a relationship betwen a user and a tag. @author Harry Chen @since 2.2

    assertEquals("wii",wii.getTag().getLabel());
  }
  
  public void testFindSKOSBroader() throws Exception{
    User user = new User((1));
    UserTag tag = new UserTag("hchen1","wii");
    List<UserTag> broaderTags = tagPager.findSKOSBroader(user,tag);
    assertEquals(2,broaderTags.size());
    UserTag videoGame = broaderTags.get(0);
    assertEquals("videogame",videoGame.getTag().getLabel());
    UserTag games = broaderTags.get(1);
    assertEquals("games",games.getTag().getLabel());
  }

View Full Code Here

    assertEquals("games",games.getTag().getLabel());
  }
  
  public void testFindUserTagInstance() throws Exception{
    User user = new User(1);
    UserTag clsTag = new UserTag(3);
    List<UserTag> results = tagPager.findUserTagInstance(user,clsTag);
    assertFalse(results.isEmpty());
    assertEquals(1,results.size());
    UserTag ut = results.get(0);
    assertEquals(2,ut.getId());
  }

View Full Code Here

    assertEquals(2,ut.getId());
  }
  
  public void testFindRDFType() throws Exception{
    User user = new User(1);
    UserTag userTag = new UserTag(2);
    List<UserTag> results = tagPager.findRDFType(user, userTag);
    assertEquals(1,results.size());
    UserTag clsTag = results.get(0);
    assertEquals(3,clsTag.getId());
    assertEquals("videogame",clsTag.getTag().getLabel());
  }

View Full Code Here

      stmt = conn.prepareStatement("call findUserTag(?,?)");
      stmt.setInt(1,user.getId());
      stmt.setInt(2,tag.getId());
      ResultSet rs = stmt.executeQuery();
      while(rs.next()){
        UserTag aTag = createUserTagObject(rs);
        tags.add(aTag);
        logger.debug("found: " + aTag);
      }
      if(tags.size() == 0){
        logger.debug("found no matching user tags");

View Full Code Here

  }
  
  
  public UserTag getUserTag(int id) {
    logger.debug("input: id="+id);
    UserTag tag = null;
    PreparedStatement stmt = null;
    Connection conn = null;
    try{            
      conn = dataSource.getConnection();
      stmt = conn.prepareStatement("call getUserTag(?);");

View Full Code Here

    return tag;
  }


  public static UserTag createUserTagObject(String idCol, ResultSet rs) throws SQLException {
    if(rs == null) return null;
    UserTag userTag = new UserTag();
    if(idCol != null){
      userTag.setId(rs.getInt(idCol));
    }else{
      userTag.setId(rs.getInt(UserTagIdxSchema.ID));  
    }
    userTag.setCount(rs.getInt(UserTagIdxSchema.COUNT));
    
    Tag t = createTagObject(rs);
    userTag.setTag(t);
    
    User u = UserDBDao.createUserObject(rs);
    userTag.setUser(u);
    
    return userTag;
  }

View Full Code Here

    return createNamedUserTagObject(userTagTblAlias, tagTblAlias, userTblAlias, rs,false);
  }
  
  public static UserTag createNamedUserTagObject(String userTagTblAlias, String tagTblAlias, String userTblAlias, ResultSet rs, boolean noColumnRef) throws SQLException{
    if(rs == null) return null;
    UserTag userTag = new UserTag();    
    Tag tag = createNamedTagObject(tagTblAlias, rs, noColumnRef);
    userTag.setTag(tag);
    User user = UserDBDao.createNamedUserObject(userTblAlias, rs, noColumnRef);    
    userTag.setUser(user);    
    
    String idCol = userTagTblAlias+UserTagIdxSchema.ID_COL;
    String countCol = userTagTblAlias+UserTagIdxSchema.COUNT_COL;
    if(noColumnRef == true){
      idCol = idCol.replaceAll("\\.","_");
      countCol = countCol.replaceAll("\\.","_");
    }    
    userTag.setId(rs.getInt(idCol));
    userTag.setCount(rs.getInt(countCol));
    return userTag;  
  }

View Full Code Here

      conn = dataSource.getConnection();
      stmt = conn.prepareStatement("call findUserTagAll(?)");
      stmt.setInt(1,user.getId());
      ResultSet rs = stmt.executeQuery();
      while(rs.next()){
        UserTag aTag = createUserTagObject(rs);
        tags.add(aTag);
        logger.debug("found: " + aTag);
      }
      if(tags.size() == 0){
        logger.debug("found no matching user tags");

View Full Code Here

      }
      stmt.setInt(1,user.getId());
      stmt.setInt(2,minFreq);
      ResultSet rs = stmt.executeQuery();
      while(rs.next()){
        UserTag aTag = createUserTagObject(rs);
        tags.add(aTag);
        logger.debug("found: " + aTag);
      }
      if(tags.size() == 0){
        logger.debug("found no matching user tags");

View Full Code Here

  
  public static TagAssertion createTagAssertionObject(ResultSet rs) throws SQLException {
    if(rs == null) return null;
    TagAssertion assertion = new TagAssertion();
    assertion.setId(rs.getInt(TagAssertionSchema.ID));      
    UserTag subjectUserTag = TagDBDao.createNamedUserTagObject("s_user_tag", "s_tag", "s_user", rs);
    UserTag objectUserTag = TagDBDao.createNamedUserTagObject("o_user_tag", "o_tag", "o_user", rs);
    TagProperty prpt = TagPropertyDBDao.createTagPropertyObject(rs);
    User user = UserDBDao.createUserObject("tag_assertion_user", rs);    
    assertion.setSubject(subjectUserTag);
    assertion.setProperty(prpt);
    assertion.setObject(objectUserTag);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of com.gnizr.db.dao.UserTag

com.gnizr.core.bookmark.BookmarkManager

com.gnizr.core.bookmark.BookmarkPager

com.gnizr.core.bookmark.TestBookmarkManager

com.gnizr.core.bookmark.TestBookmarkPager

com.gnizr.core.managers.TestTagManager

com.gnizr.core.pagers.TestTagPager

com.gnizr.core.pagers.TestTagPager2

com.gnizr.core.tag.TagManager

com.gnizr.core.tag.TagPager

com.gnizr.core.TestTagCloud

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.