public static String updateComment(String table, Comment comment) {
   return new Sql()
       .update(table)
       .setValues(
           valueIf("target_id", comment.getTarget().id, comment.getTarget().id != null),
           valueIf("target_type", comment.getTarget().type, comment.getTarget().type > 0),
           valueIf("destroyed_time", comment.getDestroyedTime(), comment.getDestroyedTime() > 0),
           valueIf("commenter", comment.getCommenterId(), comment.getCommenterId() > 0),
           valueIf("message", comment.getMessage(), comment.getMessage() != null),
           valueIf("can_like", comment.getCanLike(), true))
       .where("comment_id=:comment_id AND destroyed_time=0", "comment_id", comment.getCommentId())
       .and(" commenter=:commenter", "commenter", comment.getCommenterId())
       .toString();
 }
 public static String saveComment(String table, Comment comment) {
   return new Sql()
       .insertInto(table)
       .values(
           value("comment_id", comment.getCommentId()),
           value("can_like", comment.getCanLike()),
           value("commenter", comment.getCommenterId()),
           value("created_time", comment.getCreatedTime()),
           value("destroyed_time", 0),
           value("device", comment.getDevice()),
           value("message", comment.getMessage()),
           value("target_id", comment.getTarget().id),
           value("target_type", comment.getTarget().type),
           value(
               "add_to",
               comment.getAddTo() != null
                   ? StringHelper.join(comment.getAddTo().getIds(PeopleId.USER), ",")
                   : ""))
       .toString();
 }