public void importAllContacts() throws IOException, ServiceException {
    // import contacts
    setService();

    URL feedUrl = new URL("https://www.google.com/m8/feeds/contacts/[email protected]/full");
    Query myQuery = new Query(feedUrl);
    myQuery.setMaxResults(10);

    ContactFeed resultFeed = myService.query(myQuery, ContactFeed.class);
    // Print the results
    System.out.println(resultFeed.getTitle().getPlainText());
    for (int i = 0; i < resultFeed.getEntries().size(); i++) {
      ContactEntry entry = resultFeed.getEntries().get(i);
      // Determine if this contact entry already exists in database (check Google ID):
      System.out.println(entry.getEtag());
      System.out.println(entry.getId());
      // if individual exists with Google ID, check to see if that invididual has all the emails
      // listed:
      //   People tryPerosn = peopleRepo.findByPropertyValue("googleId", "googleId", entry.getId());
      if (peopleRepo.findByPropertyValue("googleId", "googleId", entry.getEtag()) != null) {

        System.out.println(
            peopleRepo
                    .findByPropertyValue("googleId", "googleId", entry.getId())
                    .getNodeId()
                    .toString()
                + " He exists!");
      } else {
        importContact(entry);
      }
      entry.getEmailAddresses();
    }

    // If entry exists, check to see if entry
  }
 public List<T> namedQueryListResult(
     String namedQuery, int maxSize, Map<String, Object> parameters) {
   Session session = openSession(true);
   List<T> results = Lists.newArrayList();
   try {
     Query query = namedQuery(namedQuery);
     for (Map.Entry<String, Object> entry : parameters.entrySet()) {
       query.setParameter(entry.getKey(), entry.getValue());
     }
     if (maxSize != -1) {
       query.setMaxResults(maxSize);
     }
     results = query.list();
     for (T result : results) {
       if (result != null) {
         result.init();
       }
     }
     commitTransaction(session, true);
   } catch (Exception e) {
     rollbackTransaction(session, true);
   } finally {
     closeSession(session);
   }
   return results;
 }
Exemple #3
0
  public <E extends BaseEntity> List<E> findWithPaging(
      String ql, int maxResults, int firstResult, Object... args) {
    Query query = createQuery(ql, args);
    query.setMaxResults(maxResults).setFirstResult(firstResult);

    @SuppressWarnings("unchecked")
    List<E> resultList = query.getResultList();
    return resultList;
  }
  @Override
  public <T extends GettableById> List<T> get(Class<T> tClass, int offset, int limit) {
    validateTransaction();
    String fullClassName = tClass.getName();
    fullClassName =
        fullClassName.substring(fullClassName.lastIndexOf(".") + 1, fullClassName.length());

    Query query = getSession().createQuery("from " + fullClassName);
    if (offset > 0) query.setFirstResult(offset);
    if (limit > 0) query.setMaxResults(limit);

    return query.list();
  }
 @Override
 public void open() {
   currentRecordNumber = 0;
   Query hibernateQuery = session.createQuery(query);
   hibernateQuery.setReadOnly(true);
   if (maxResults >= 1) {
     hibernateQuery.setMaxResults(maxResults);
   }
   if (fetchSize >= 1) {
     hibernateQuery.setFetchSize(fetchSize);
   }
   scrollableResults = hibernateQuery.scroll(ScrollMode.FORWARD_ONLY);
 }
  @Override
  public <T> List<T> executeNamedQueryWithParams(
      String queryName, HashMap<String, Object> params, int offset, int limit) {
    validateTransaction();
    Query query = getSession().getNamedQuery(queryName);
    if (params != null) {
      for (String name : params.keySet()) {
        query.setParameter(name, params.get(name));
      }
    }
    query.setFirstResult(offset);
    if (limit > 0) query.setMaxResults(limit);

    return query.list();
  }
 private List<Usuario> findUsuarioEntities(boolean all, int maxResults, int firstResult) {
   EntityManager em = getEntityManager();
   try {
     CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
     cq.select(cq.from(Usuario.class));
     Query q = em.createQuery(cq);
     if (!all) {
       q.setMaxResults(maxResults);
       q.setFirstResult(firstResult);
     }
     return q.getResultList();
   } finally {
     em.close();
   }
 }
  public void printAllContacts() throws ServiceException, IOException {
    // Request the feed

    setService();
    URL feedUrl = new URL("https://www.google.com/m8/feeds/contacts/[email protected]/full");
    Query myQuery = new Query(feedUrl);
    myQuery.setMaxResults(8);
    myQuery.setStringCustomParameter("group", "Business Contacts");
    ContactFeed resultFeed = myService.query(myQuery, ContactFeed.class);
    // Print the results
    System.out.println(resultFeed.getTitle().getPlainText());
    for (int i = 0; i < resultFeed.getEntries().size(); i++) {
      ContactEntry entry = resultFeed.getEntries().get(i);

      Name test = entry.getName();
      FullName namee = test.getFullName();
      People person =
          peopleRepo.save(
              new People(23, entry.getTitle().getPlainText(), entry.getTitle().getPlainText()));
      System.out.println(person.getNodeId().toString());
      System.out.println("\t" + entry.getTitle().getPlainText());

      System.out.println("Email addresses:");
      for (com.google.gdata.data.extensions.Email email : entry.getEmailAddresses()) {
        System.out.print(" " + email.getAddress());
        if (email.getRel() != null) {
          System.out.print(" rel:" + email.getRel());
        }
        if (email.getLabel() != null) {
          System.out.print(" label:" + email.getLabel());
        }
        if (email.getPrimary()) {
          System.out.print(" (primary) ");
        }
        System.out.print("\n");
      }

      System.out.println("IM addresses:");
      for (Im im : entry.getImAddresses()) {
        System.out.print(" " + im.getAddress());
        if (im.getLabel() != null) {
          System.out.print(" label:" + im.getLabel());
        }
        if (im.getRel() != null) {
          System.out.print(" rel:" + im.getRel());
        }
        if (im.getProtocol() != null) {
          System.out.print(" protocol:" + im.getProtocol());
        }
        if (im.getPrimary()) {
          System.out.print(" (primary) ");
        }
        System.out.print("\n");
      }

      System.out.println("Groups:");
      for (GroupMembershipInfo group : entry.getGroupMembershipInfos()) {
        String groupHref = group.getHref();
        System.out.println("  Id: " + groupHref);
      }

      System.out.println("Extended Properties:");
      for (ExtendedProperty property : entry.getExtendedProperties()) {
        if (property.getValue() != null) {
          System.out.println("  " + property.getName() + "(value) = " + property.getValue());
        } else if (property.getXmlBlob() != null) {
          System.out.println(
              "  " + property.getName() + "(xmlBlob)= " + property.getXmlBlob().getBlob());
        }
      }

      String photoLink = entry.getContactPhotoLink().getHref();
      System.out.println("Photo Link: " + photoLink);

      System.out.println("Contact's ETag: " + entry.getEtag());
    }
  }
 public static List getCustomers(EntityManager entityManager, int max, int index) {
   Query query = entityManager.createQuery("from Customer c");
   return query.setMaxResults(max).setFirstResult(index).getResultList();
 }