use of com.google.appengine.api.datastore.Query.Filter in project java-docs-samples by GoogleCloudPlatform.
the class QueriesTest method ancestorQueryExample_kindlessKeyFilter_returnsMatchingEntities.
@Test
public void ancestorQueryExample_kindlessKeyFilter_returnsMatchingEntities() throws Exception {
// Arrange
Entity a = new Entity("Grandparent", "a");
Entity b = new Entity("Grandparent", "b");
Entity c = new Entity("Grandparent", "c");
Entity aa = new Entity("Parent", "aa", a.getKey());
Entity ba = new Entity("Parent", "ba", b.getKey());
Entity bb = new Entity("Parent", "bb", b.getKey());
Entity bc = new Entity("Parent", "bc", b.getKey());
Entity cc = new Entity("Parent", "cc", c.getKey());
Entity aaa = new Entity("Child", "aaa", aa.getKey());
Entity bbb = new Entity("Child", "bbb", bb.getKey());
datastore.put(ImmutableList.<Entity>of(a, b, c, aa, ba, bb, bc, cc, aaa, bbb));
// Act
Key ancestorKey = b.getKey();
Key lastSeenKey = bb.getKey();
// [START kindless_ancestor_key_query_example]
Filter keyFilter = new FilterPredicate(Entity.KEY_RESERVED_PROPERTY, FilterOperator.GREATER_THAN, lastSeenKey);
Query q = new Query().setAncestor(ancestorKey).setFilter(keyFilter);
// [END kindless_ancestor_key_query_example]
// Assert
List<Entity> results = datastore.prepare(q.setKeysOnly()).asList(FetchOptions.Builder.withDefaults());
assertThat(results).named("query results").containsExactly(bc, bbb);
}
use of com.google.appengine.api.datastore.Query.Filter in project java-docs-samples by GoogleCloudPlatform.
the class QueriesTest method propertyFilterExample_returnsMatchingEntities.
@Test
public void propertyFilterExample_returnsMatchingEntities() throws Exception {
// Arrange
Entity p1 = new Entity("Person");
p1.setProperty("height", 120);
Entity p2 = new Entity("Person");
p2.setProperty("height", 180);
Entity p3 = new Entity("Person");
p3.setProperty("height", 160);
datastore.put(ImmutableList.<Entity>of(p1, p2, p3));
// Act
long minHeight = 160;
// [START property_filter_example]
Filter propertyFilter = new FilterPredicate("height", FilterOperator.GREATER_THAN_OR_EQUAL, minHeight);
Query q = new Query("Person").setFilter(propertyFilter);
// [END property_filter_example]
// Assert
List<Entity> results = datastore.prepare(q.setKeysOnly()).asList(FetchOptions.Builder.withDefaults());
assertThat(results).named("query results").containsExactly(p2, p3);
}
use of com.google.appengine.api.datastore.Query.Filter in project java-docs-samples by GoogleCloudPlatform.
the class QueriesTest method queryRestrictions_compositeFilter_returnsMatchedEntities.
@Test
public void queryRestrictions_compositeFilter_returnsMatchedEntities() throws Exception {
// Arrange
Entity a = new Entity("Person", "a");
a.setProperty("birthYear", 1930);
Entity b = new Entity("Person", "b");
b.setProperty("birthYear", 1960);
Entity c = new Entity("Person", "c");
c.setProperty("birthYear", 1990);
datastore.put(ImmutableList.<Entity>of(a, b, c));
// Act
long minBirthYear = 1940;
long maxBirthYear = 1980;
// [START inequality_filters_one_property_valid_example_1]
Filter birthYearMinFilter = new FilterPredicate("birthYear", FilterOperator.GREATER_THAN_OR_EQUAL, minBirthYear);
Filter birthYearMaxFilter = new FilterPredicate("birthYear", FilterOperator.LESS_THAN_OR_EQUAL, maxBirthYear);
Filter birthYearRangeFilter = CompositeFilterOperator.and(birthYearMinFilter, birthYearMaxFilter);
Query q = new Query("Person").setFilter(birthYearRangeFilter);
// [END inequality_filters_one_property_valid_example_1]
// Assert
List<Entity> results = datastore.prepare(q.setKeysOnly()).asList(FetchOptions.Builder.withDefaults());
assertThat(results).named("query results").containsExactly(b);
}
use of com.google.appengine.api.datastore.Query.Filter in project java-docs-samples by GoogleCloudPlatform.
the class QueriesTest method queryRestrictions_inequalitySortedFirst_returnsMatchedEntities.
@Test
public void queryRestrictions_inequalitySortedFirst_returnsMatchedEntities() throws Exception {
// Arrange
Entity a = new Entity("Person", "a");
a.setProperty("birthYear", 1930);
a.setProperty("lastName", "Someone");
Entity b = new Entity("Person", "b");
b.setProperty("birthYear", 1990);
b.setProperty("lastName", "Bravo");
Entity c = new Entity("Person", "c");
c.setProperty("birthYear", 1960);
c.setProperty("lastName", "Charlie");
Entity d = new Entity("Person", "d");
d.setProperty("birthYear", 1960);
d.setProperty("lastName", "Delta");
datastore.put(ImmutableList.<Entity>of(a, b, c, d));
long minBirthYear = 1940;
// [START inequality_filters_sort_orders_valid_example]
Filter birthYearMinFilter = new FilterPredicate("birthYear", FilterOperator.GREATER_THAN_OR_EQUAL, minBirthYear);
Query q = new Query("Person").setFilter(birthYearMinFilter).addSort("birthYear", SortDirection.ASCENDING).addSort("lastName", SortDirection.ASCENDING);
// [END inequality_filters_sort_orders_valid_example]
// Assert
List<Entity> results = datastore.prepare(q.setKeysOnly()).asList(FetchOptions.Builder.withDefaults());
assertThat(results).named("query results").containsExactly(c, d, b).inOrder();
}
use of com.google.appengine.api.datastore.Query.Filter in project java-docs-samples by GoogleCloudPlatform.
the class StartupServletTest method doGet_emptyDatastore_writesPresidents.
@Test
public void doGet_emptyDatastore_writesPresidents() throws Exception {
servletUnderTest.doGet(mockRequest, mockResponse);
Filter nameFilter = new FilterPredicate("name", FilterOperator.EQUAL, "George Washington");
Query q = new Query("Person").setFilter(nameFilter);
Entity result = datastore.prepare(q).asSingleEntity();
assertThat(result.getProperty("name")).named("name").isEqualTo("George Washington");
}
Aggregations