Examples with Query com.google.appengine.api.datastore.Query used on opensource projects

Example 56 with Query

use of com.google.appengine.api.datastore.Query in project java-docs-samples by GoogleCloudPlatform.

the class QueriesTest method queryRestrictions_compositeFilter_isInvalid.

@Test
public void queryRestrictions_compositeFilter_isInvalid() throws Exception {
    long minBirthYear = 1940;
    long maxHeight = 200;
    // [START inequality_filters_one_property_invalid_example]
    Filter birthYearMinFilter = new FilterPredicate("birthYear", FilterOperator.GREATER_THAN_OR_EQUAL, minBirthYear);
    Filter heightMaxFilter = new FilterPredicate("height", FilterOperator.LESS_THAN_OR_EQUAL, maxHeight);
    Filter invalidFilter = CompositeFilterOperator.and(birthYearMinFilter, heightMaxFilter);
    Query q = new Query("Person").setFilter(invalidFilter);
// [END inequality_filters_one_property_invalid_example]
// Note: The local devserver behavior is different than the production
// version of Cloud Datastore, so there aren't any assertions we can make
// in this test.  The query appears to work with the local test runner,
// but will fail in production.
}

Example 57 with Query

use of com.google.appengine.api.datastore.Query in project java-docs-samples by GoogleCloudPlatform.

the class QueriesTest method retrievePersonWithLastName.

private Entity retrievePersonWithLastName(String targetLastName) {
    // [START single_retrieval_example]
    Query q = new Query("Person").setFilter(new FilterPredicate("lastName", FilterOperator.EQUAL, targetLastName));
    PreparedQuery pq = datastore.prepare(q);
    Entity result = pq.asSingleEntity();
    // [END single_retrieval_example]
    return result;
}

Example 58 with Query

use of com.google.appengine.api.datastore.Query in project java-docs-samples by GoogleCloudPlatform.

the class TransactionsTest method usesForTransactions_readSnapshot.

@Test
public void usesForTransactions_readSnapshot() throws Exception {
    String boardName = "my-message-board";
    Entity b = new Entity("MessageBoard", boardName);
    b.setProperty("count", 13);
    datastore.put(b);
    // [START uses_for_transactions_3]
    DatastoreService ds = DatastoreServiceFactory.getDatastoreService();
    // Display information about a message board and its first 10 messages.
    Key boardKey = KeyFactory.createKey("MessageBoard", boardName);
    Transaction txn = datastore.beginTransaction();
    Entity messageBoard = datastore.get(boardKey);
    long count = (Long) messageBoard.getProperty("count");
    Query q = new Query("Message", boardKey);
    // This is an ancestor query.
    PreparedQuery pq = datastore.prepare(txn, q);
    List<Entity> messages = pq.asList(FetchOptions.Builder.withLimit(10));
    txn.commit();
    // [END uses_for_transactions_3]
    assertThat(count).named("board.count").isEqualTo(13L);
}

Example 59 with Query

use of com.google.appengine.api.datastore.Query in project java-docs-samples by GoogleCloudPlatform.

the class MetadataPropertiesTest method printPropertyRange.

// [START property_filtering_example]
void printPropertyRange(DatastoreService ds, PrintWriter writer) {
    // Start with unrestricted keys-only property query
    Query q = new Query(Entities.PROPERTY_METADATA_KIND).setKeysOnly();
    // Limit range
    q.setFilter(CompositeFilterOperator.and(new FilterPredicate(Entity.KEY_RESERVED_PROPERTY, Query.FilterOperator.GREATER_THAN_OR_EQUAL, Entities.createPropertyKey("Employee", "salary")), new FilterPredicate(Entity.KEY_RESERVED_PROPERTY, Query.FilterOperator.LESS_THAN_OR_EQUAL, Entities.createPropertyKey("Manager", "salary"))));
    q.addSort(Entity.KEY_RESERVED_PROPERTY, SortDirection.ASCENDING);
    // Print query results
    for (Entity e : ds.prepare(q).asIterable()) {
        writer.println(e.getKey().getParent().getName() + ": " + e.getKey().getName());
    }
}

Example 60 with Query

use of com.google.appengine.api.datastore.Query in project java-docs-samples by GoogleCloudPlatform.

the class GreetingTest method createSaveObject.

@Test
public void createSaveObject() throws Exception {
    Greeting g = new Greeting("default", TEST_CONTENT);
    ObjectifyService.ofy().save().entity(g).now();
    Query query = new Query("Greeting").setAncestor(new KeyFactory.Builder("Guestbook", "default").getKey());
    PreparedQuery pq = ds.prepare(query);
    // Should only be one at this point.
    Entity greeting = pq.asSingleEntity();
    assertEquals(greeting.getProperty("content"), TEST_CONTENT);
}