Ejemplo n.º 1
0
  private void loadYouTubeThumbnails(Viewpoint viewpoint, ExternalAccountView accountView) {
    ExternalAccount account = accountView.getExternalAccount();

    if (account.getAccountType() != ExternalAccountType.YOUTUBE)
      throw new IllegalArgumentException("should be a YouTube account here");

    if (account.getSentiment() != Sentiment.LOVE)
      throw new IllegalArgumentException("YouTube account is unloved =(");

    if (account.getHandle() == null) return;

    try {
      youTubeUpdater.getCachedStatus(account);
    } catch (NotFoundException e) {
      logger.debug("No cached YouTube status for {}", account);
      return;
    }

    List<? extends YouTubeVideo> videos = youTubeVideosCache.getSync(account.getHandle());
    if (videos.isEmpty()) {
      logger.debug("Empty list of videos for {}", account);
      return;
    }

    accountView.setThumbnailsData(
        TypeUtils.castList(Thumbnail.class, videos),
        videos.size(),
        videos.get(0).getThumbnailWidth(),
        videos.get(0).getThumbnailHeight());
  }
  public List<FacebookPhotoDataView> queryExisting(
      String key, Set<FacebookPhotoDataStatus> photos) {
    List<FacebookPhotoDataView> results = new ArrayList<FacebookPhotoDataView>();
    StringBuilder sb = new StringBuilder();
    sb.append(
        "SELECT photo FROM CachedFacebookPhotoData photo WHERE photo.userId = :userId"
            + " AND photo.facebookPhotoId IN (");
    boolean facebookPhotoIdsAvailable = false;
    for (FacebookPhotoDataStatus photoStatus : photos) {
      if (photoStatus.getFacebookPhotoId() != null) {
        sb.append(photoStatus.getFacebookPhotoId());
        sb.append(",");
        facebookPhotoIdsAvailable = true;
      }
    }

    // no need to do the query if we don't have a single id
    if (!facebookPhotoIdsAvailable) {
      return results;
    }

    sb.setLength(sb.length() - 1); // chop comma
    sb.append(")");
    Query q = em.createQuery(sb.toString());
    q.setParameter("userId", key);
    List<CachedFacebookPhotoData> entities =
        TypeUtils.castList(CachedFacebookPhotoData.class, q.getResultList());
    for (CachedFacebookPhotoData entity : entities) {
      results.add(resultFromEntity(entity));
    }
    return results;
  }
 @Override
 public List<CachedFacebookPhotoData> queryExisting(String key) {
   Query q =
       em.createQuery(
           "SELECT photo FROM CachedFacebookPhotoData photo WHERE photo.userId = :userId");
   q.setParameter("userId", key);
   List<CachedFacebookPhotoData> results =
       TypeUtils.castList(CachedFacebookPhotoData.class, q.getResultList());
   return results;
 }
  @Override
  protected List<FacebookPhotoDataView> fetchFromNetImpl(String key) {
    FacebookWebServices ws = new FacebookWebServices(REQUEST_TIMEOUT, config);
    FacebookAccount facebookAccount = lookupFacebookAccount(key);
    // this facebookAccount is detached
    List<FacebookPhotoData> photos = ws.getTaggedPhotos(facebookAccount);

    // we don't want to call facebookTracker.handleExpiredSessionKey(facebookAccount.getId());
    // here because we'll handle that when we are updating tagged photos and we also
    // need to drop the photos cache for the user in that case, which we do there
    if (photos == null) return null;
    else return TypeUtils.castList(FacebookPhotoDataView.class, photos);
  }
Ejemplo n.º 5
0
  private void loadFlickrThumbnails(Viewpoint viewpoint, ExternalAccountView accountView) {
    ExternalAccount account = accountView.getExternalAccount();

    if (account.getAccountType() != ExternalAccountType.FLICKR)
      throw new IllegalArgumentException("should be a flickr account here");

    if (account.getSentiment() != Sentiment.LOVE)
      throw new IllegalArgumentException("Flickr account is unloved");

    if (account.getHandle() == null) return;

    FlickrPhotosView photos = flickrUserPhotosCache.getSync(account.getHandle());
    if (photos == null) {
      logger.debug("No public photos for {}", account);
      return;
    }

    accountView.setThumbnailsData(
        TypeUtils.castList(Thumbnail.class, photos.getPhotos()),
        photos.getTotal(),
        FlickrPhotoSize.SMALL_SQUARE.getPixels(),
        FlickrPhotoSize.SMALL_SQUARE.getPixels());
  }
Ejemplo n.º 6
0
  public void validateAll() {
    logger.info("Administrator kicked off validation of all ExternalAccount rows in the database");
    Query q =
        em.createQuery("SELECT ea.id, ea.accountType, ea.handle, ea.extra FROM ExternalAccount ea");
    List<Object[]> results = TypeUtils.castList(Object[].class, q.getResultList());

    logger.info("There are {} ExternalAccount rows to validate", results.size());

    List<Long> invalidHandles = new ArrayList<Long>();
    List<Long> invalidExtras = new ArrayList<Long>();

    for (Object[] row : results) {
      // logger.debug("row is: {}", Arrays.toString(row));
      Long id = (Long) row[0];
      ExternalAccountType accountType = (ExternalAccountType) row[1];
      String handle = (String) row[2];
      String extra = (String) row[3];
      if (accountType == null) {
        logger.info("Row has null accountType: {}", Arrays.toString(row));
      } else {
        try {
          String c = accountType.canonicalizeHandle(handle);
          if (handle != null && !c.equals(handle)) {
            logger.info(
                "Row is not canonicalized: {}: '{}' vs. '{}'",
                new Object[] {Arrays.toString(row), handle, c});
          }
        } catch (ValidationException e) {
          logger.info("Row had invalid 'handle': {}: {}", Arrays.toString(row), e.getMessage());
          invalidHandles.add(id);
        }
        try {
          String c = accountType.canonicalizeExtra(extra);
          if (extra != null && !c.equals(extra)) {
            logger.info(
                "Row is not canonicalized: {}: '{}' vs. '{}'",
                new Object[] {Arrays.toString(row), extra, c});
          }
        } catch (ValidationException e) {
          logger.info("Row had invalid 'extra': {}: {}", Arrays.toString(row), e.getMessage());
          invalidExtras.add(id);
        }
      }
    }

    if (!invalidHandles.isEmpty()) {
      StringBuilder sb = new StringBuilder();
      sb.append("UPDATE ExternalAccount SET handle = NULL WHERE id IN (");
      for (Long id : invalidHandles) {
        sb.append(id);
        sb.append(",");
      }
      sb.setLength(sb.length() - 1); // chop comma
      sb.append(");");
      logger.info("Possible query to null invalid handles: {}", sb);
    }

    if (!invalidExtras.isEmpty()) {
      StringBuilder sb = new StringBuilder();
      sb.append("UPDATE ExternalAccount SET extra = NULL WHERE id IN (");
      for (Long id : invalidHandles) {
        sb.append(id);
        sb.append(",");
      }
      sb.setLength(sb.length() - 1); // chop comma
      sb.append(");");
      logger.info("Possible query to null invalid extras: {}", sb);
    }

    logger.info(
        "ExternalAccount validation complete, {} invalid handles {} invalid extras",
        invalidHandles.size(),
        invalidExtras.size());
  }