org.springframework.data.gemfire.repository.Query Java Examples

The following examples show how to use org.springframework.data.gemfire.repository.Query. You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example #1
Source File: ProductRepository.java    From geode-demo-application with Apache License 2.0 4 votes vote down vote up
@Query("SELECT * FROM /Product p WHERE p.stockOnHand > 0")
Collection<Product> findAllWithStock();
 
Example #2
Source File: OrderProductSummaryRepository.java    From spring-data-examples with Apache License 2.0 4 votes vote down vote up
@Hint("emailAddressIndex")
@Query("select orderSummary.value from /OrderProductSummary.entrySet orderSummary where orderSummary.key = $1")
List<OrderProductSummary> findAllForProductID(long l);
 
Example #3
Source File: CustomerRepository.java    From spring-data-examples with Apache License 2.0 4 votes vote down vote up
@Trace
@Limit(100)
@Query("select * from /Customers customer where customer.firstName = $1")
List<Customer> findByFirstNameUsingIndex(String firstName);
 
Example #4
Source File: CustomerRepository.java    From spring-data-examples with Apache License 2.0 4 votes vote down vote up
@Trace
@Limit(100)
@Hint("emailAddressIndex")
@Query("select * from /Customers customer where customer.emailAddress.value = $1")
List<Customer> findByEmailAddressUsingIndex(String emailAddress);
 
Example #5
Source File: CustomerRepository.java    From spring-data-examples with Apache License 2.0 4 votes vote down vote up
@Trace
@Limit(100)
@Query("select * from /Customers customer where customer.firstName = $1")
List<Customer> findByFirstNameUsingIndex(String firstName);
 
Example #6
Source File: CustomerRepository.java    From spring-data-examples with Apache License 2.0 4 votes vote down vote up
@Trace
@Limit(100)
@Hint("emailAddressIndex")
@Query("select * from /Customers customer where customer.emailAddress.value = $1")
List<Customer> findByEmailAddressUsingIndex(String emailAddress);
 
Example #7
Source File: ProductRepository.java    From geode-demo-application with Apache License 2.0 4 votes vote down vote up
@Query("SELECT * FROM /Product p WHERE p.\"type\" LIKE $1 and p.stockOnHand > 0")
Collection<Product> findAllWithStockByBrand( String brand) ;
 
Example #8
Source File: ProductRepository.java    From geode-demo-application with Apache License 2.0 4 votes vote down vote up
@Query("SELECT * FROM /Product p   WHERE  p.brand = $1 and  p.\"type\" = $2 and  p.gender = $3 and  p.stockOnHand > 0")
Collection<Product> findAllWithStockByBrandTypeGender(String brand,String type, String gender);
 
Example #9
Source File: ProductRepository.java    From geode-demo-application with Apache License 2.0 4 votes vote down vote up
@Query("SELECT * FROM /Product p WHERE p.brand = $1 and p.\"type\"= $2 and p.gender = $3")
Collection<Product> findAllByBrandTypeGender(String brand, String type,
		String gender);
 
Example #10
Source File: TemperatureReadingRepository.java    From spring-boot-data-geode with Apache License 2.0 4 votes vote down vote up
@Query("SELECT count(*) FROM /TemperatureReadings WHERE temperature >= 212")
Integer countBoilingTemperatureReadings();
 
Example #11
Source File: TransactionRepository.java    From geode-demo-application with Apache License 2.0 4 votes vote down vote up
@Query("SELECT count(*) FROM /Transaction t where t.orderStatus = 'open'")
Integer getCount();
 
Example #12
Source File: TransactionRepository.java    From geode-demo-application with Apache License 2.0 4 votes vote down vote up
@Query("SELECT * FROM /Transaction t where (t.orderStatus = 'open' or t.orderStatus = 'shipped') and t.customerId = $1")
Collection<Transaction> findCompletedOrders(String id);
 
Example #13
Source File: TransactionRepository.java    From geode-demo-application with Apache License 2.0 4 votes vote down vote up
@Query("SELECT * FROM /Transaction t where t.orderStatus = 'open'")
Collection<Transaction> findOpenOrders();
 
Example #14
Source File: TransactionRepository.java    From geode-demo-application with Apache License 2.0 4 votes vote down vote up
@Query("SELECT * FROM /Transaction t WHERE t.customerId = $1")
Collection<Transaction> findByCustomer(String id);
 
Example #15
Source File: CustomerRepository.java    From geode-demo-application with Apache License 2.0 4 votes vote down vote up
@Query("SELECT * FROM /Customer t WHERE t.emailAddress LIKE $1")
Collection<Customer> searchCustomers(String email);
 
Example #16
Source File: CustomerRepository.java    From geode-demo-application with Apache License 2.0 4 votes vote down vote up
@Query("SELECT * FROM /Transaction t WHERE t.customerId = $1")
Collection<Transaction> findByCustomer(@Param("customerId") String id);
 
Example #17
Source File: TemperatureReadingRepository.java    From spring-boot-data-geode with Apache License 2.0 4 votes vote down vote up
@Query("SELECT count(*) FROM /TemperatureReadings WHERE temperature <= 32")
Integer countFreezingTemperatureReadings();