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; }
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(); }