@Override public Set<String> call() { Set<String> pipelines = new LinkedHashSet<>(); for (Entity entity : preparedQuery.asIterable()) { pipelines.add((String) entity.getProperty(JobRecord.ROOT_JOB_DISPLAY_NAME)); } return pipelines; } });
Query query = new Query("entityname"); PreparedQuery preparedQuery = dataStore.prepare(query); // the 200 should be less than 1000 FetchOptions options = FetchOptions.Builder.withChunkSize(200); for (Entity result : preparedQuery.asIterable(options)) { ... }
DatastoreService ds = DatastoreServiceFactory.getDatastoreService(); Query q = new Query(entityKind); PreparedQuery pq = ds.prepare(q); for (Entity e : pq.asIterable()) { String longtext = ((Text)e.getProperty("somelongdescription")).getValue();}
// Use class Query to assemble a query Query q = new Query("Post"); // Use PreparedQuery interface to retrieve results PreparedQuery pq = datastore.prepare(q); for (Entity result : pq.asIterable()) { String postName = (String) result.getProperty("PostName"); }
public Entity fetchResult(PreparedQuery preparedQuery) { return preparedQuery.asIterable().iterator().next(); } });
Query query = new Query("Issue"); List<String> list = Arrays.asList("NEW", "OPEN", "ACCEPTED"); query.addFilter("status", FilterOperator.IN, list); DatastoreService datastore = DatastoreServiceFactory.getDatastoreService(); PreparedQuery preparedQuery = datastore.prepare(query); for (Entity entity : preparedQuery.asIterable()) { // should iterate over 'NEW', 'OPEN' and 'ACCEPTED' issues }
DatastoreService datastore = DatastoreServiceFactory.getDatastoreService(); Query q = new Query("Entity"); PreparedQuery pq = datastore.prepare(q); for (com.google.appengine.api.datastore.Entity result : pq.asIterable()) { String content = (String) result.getProperty("content"); if (content != null) { result.setProperty("content", new com.google.appengine.api.datastore.Text(content)); datastore.put(result); } }
DatastoreService datastore = DatastoreServiceFactory.getDatastoreService(); Query q = new Query("Users").addFilter("value", Query.FilterOperator.EQUAL, 1); PreparedQuery pq = datastore.prepare(q); if(pq!=null) { for (com.google.appengine.api.datastore.Entity result : pq.asIterable()) { nodeID = result.getProperty("nodeId").toString(); result.setProperty("value",0); datastore.put(result); break; } }
@Override public List<String> listNamespaces() { DatastoreService ds = DatastoreServiceFactory.getDatastoreService(); Query query = new Query("__namespace__").setKeysOnly(); PreparedQuery pq = ds.prepare(query); List<String> namespaces = new ArrayList<>(); for (Entity entity : pq.asIterable()) { namespaces.add(entity.getKey().getName()); } return namespaces; }
DatastoreService datastore = DatastoreServiceFactory.getDatastoreService(); Filter keyFilter = new FilterPredicate(Entity.KEY_RESERVED_PROPERTY, FilterOperator.GREATER_THAN, 0); Query q = new Query("Gift").setFilter(keyFilter); PreparedQuery pq = datastore.prepare(q); for (Entity result : pq.asIterable()){ String title = (String) result.getProperty("title"); String description = (String) result.getProperty("description"); Blob bmp = (Blob) result.getProperty("bmp"); //new Object using variables above }
DatastoreService ds = DatastoreServiceFactory.getDatastoreService(); Query q = new Query("Items"); PreparedQuery pq = ds.prepare(q); for (Entity result : pq.asIterable()) { if (longDescription isinstanceof Text) Text longDescription = (Text)result.getProperty("longDescription"); else log.severe("Unexpected datatype: longDescription is a " + result.getProperty("longDescription").getClass().toString()); }
DatastoreService datastore = DatastoreServiceFactory.getDatastoreService(); PreparedQuery global = datastore.prepare(new Query("__Stat_Kind__")); for( Entity globalStat : global.asIterable() ) { Long totalBytes = (Long) globalStat.getProperty("bytes"); Long totalEntities = (Long) globalStat.getProperty("count"); String kindName = (String) globalStat.getProperty("kind_name"); resp.getWriter().println("[" + kindName + "] has " + totalEntities + " entities and takes up " + totalBytes + "bytes<br/>"); }
@Test public void testAsIterable() throws Exception { Iterable<Entity> iterable = preparedQuery.asIterable(); assertNotNull(iterable); assertNotNull(iterable.iterator()); assertTrue(iterable.iterator().hasNext()); assertEquals(john, iterable.iterator().next()); }
private void clearTestData() { DatastoreService ds = DatastoreServiceFactory.getDatastoreService(); Query query = new Query("XmppMsg"); List<Key> msgs = new ArrayList<>(); for (Entity e : ds.prepare(query).asIterable()) { msgs.add(e.getKey()); } ds.delete(msgs); }
@Override public void clearData(String kind) { List<Key> elist = new ArrayList<>(); Query query = new Query(kind); for (Entity readRec : service.prepare(query).asIterable()) { elist.add(readRec.getKey()); } service.delete(elist); sync(sleepTime); } }
@Before public void clearData() { asyncService = DatastoreServiceFactory.getAsyncDatastoreService(); List<Key> elist = new ArrayList<Key>(); Query query = new Query(ASYNC_ENTITY); for (Entity readRec : service.prepare(query).asIterable()) { elist.add(readRec.getKey()); } service.delete(elist); }
private void checkCount(String statsKind) { FetchOptions fo = FetchOptions.Builder.withDefaults(); Query query = new Query(statsKind); assertTrue(service.prepare(query).countEntities(fo) > 0); for (Entity readRec : service.prepare(query).asIterable()) { assertTrue((Long) readRec.getProperty("count") > 0); } } }
public void purgeTestRunRecords() { DatastoreService datastoreService = DatastoreServiceFactory. getDatastoreService(); FilterPredicate testRunFilter = new FilterPredicate(TEST_RUN_ID, FilterOperator.EQUAL, testRunId); Query query = new Query(entityName).setFilter(testRunFilter).setKeysOnly(); for (Entity readRec : datastoreService.prepare(query).asIterable()) { datastoreService.delete(readRec.getKey()); } }
@Test public void testAncestor() { Key pKey = getParent().getKey(); Query query = new Query(CHILDKIND, pKey); assertEquals(2, service.prepare(query) .countEntities(FetchOptions.Builder.withDefaults())); for (Entity cRec : service.prepare(query).asIterable()) { assertEquals(pKey, cRec.getParent()); } }
@Test public void testAncestorKey() { Key pKey = getParent().getKey(); Query query = new Query(CHILDKIND, pKey); query.addSort("__key__"); assertEquals(2, service.prepare(query) .countEntities(FetchOptions.Builder.withDefaults())); for (Entity cRec : service.prepare(query).asIterable()) { assertEquals(pKey, cRec.getParent()); } }