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

The following examples show how to use org.springframework.data.r2dbc.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: R2dbcBookRepository.java    From spring-data-dev-tools with Apache License 2.0 4 votes vote down vote up
@Query(BY_TITLE)
Mono<Book> findByTitle(String title);
 
Example #2
Source File: AuthorRepository.java    From spring-data-examples with Apache License 2.0 4 votes vote down vote up
@Query("SELECT a.* FROM AUTHOR a"
    + " JOIN BOOK_AUTHOR ba ON a.ID = ba.AUTHOR"
    + " WHERE ba.BOOK = :bookId"
    + " ORDER BY ba.ID")
Flux<Author> findByBook(long bookId);
 
Example #3
Source File: CategoryRepository.java    From spring-data-examples with Apache License 2.0 4 votes vote down vote up
@Query("SELECT c.* FROM CATEGORY c"
    + " JOIN BOOK_CATEGORY bc ON c.ID = bc.CATEGORY"
    + " WHERE bc.BOOK = :bookId"
    + " ORDER BY bc.ID")
Flux<Category> findByBook(long bookId);
 
Example #4
Source File: BookRepository.java    From spring-data-examples with Apache License 2.0 4 votes vote down vote up
@Query("SELECT COUNT(*) FROM BOOK WHERE TITLE LIKE CONCAT('%', :title, '%')")
Mono<Integer> countByTitleContains(String title);
 
Example #5
Source File: BookRepository.java    From spring-data-examples with Apache License 2.0 4 votes vote down vote up
@Query("SELECT * FROM BOOK WHERE TITLE LIKE CONCAT('%', :title, '%')"
    + " ORDER BY PUBLICATION_DATE"
    + " OFFSET :start"
    + " FETCH NEXT :rowCount ROWS ONLY")
Flux<Book> findByTitleContains(String title, int start, int rowCount, Sort sort);
 
Example #6
Source File: PlayerRepository.java    From tutorials with MIT License 4 votes vote down vote up
@Query("select * from player where age = $1")
Flux<Player> findByAge(int age);
 
Example #7
Source File: PlayerRepository.java    From tutorials with MIT License 4 votes vote down vote up
@Query("select id, name, age from player where name = $1")
Flux<Player> findAllByName(String name);
 
Example #8
Source File: CustomerRepository.java    From spring-data-examples with Apache License 2.0 4 votes vote down vote up
@Query("select id, firstname, lastname from customer c where c.lastname = :lastname")
Flux<Customer> findByLastname(String lastname);
 
Example #9
Source File: PostRepository.java    From POC with Apache License 2.0 4 votes vote down vote up
@Query("select id, title, content from reactive_posts p where p.content = :content")
Flux<ReactivePost> findByContent(String content);
 
Example #10
Source File: R2dbcBookRepository.java    From spring-data-dev-tools with Apache License 2.0 4 votes vote down vote up
@Transactional(readOnly = true)
@Query(BY_TITLE)
Mono<Book> findTransactionalByTitle(String title);
 
Example #11
Source File: ServiceInstanceBindingStateCrudRepository.java    From spring-cloud-app-broker with Apache License 2.0 4 votes vote down vote up
@Query("select * from service_instance_binding " +
		"where service_instance_id = :service_instance_id " +
		"and binding_id = :binding_id")
Mono<ServiceInstanceBinding> findByServiceInstanceIdAndBindingId(
		@Param("service_instance_id") String serviceInstanceId,
		@Param("binding_id") String bindingId);
 
Example #12
Source File: PostRepository.java    From spring-reactive-sample with GNU General Public License v3.0 4 votes vote down vote up
@Query("SELECT * FROM posts WHERE title like $1")
Flux<Post> findByTitleContains(String name);
 
Example #13
Source File: PostRepository.java    From spring-reactive-sample with GNU General Public License v3.0 4 votes vote down vote up
@Query("SELECT * FROM posts WHERE title like $1")
Flux<Post> findByTitleContains(String name);
 
Example #14
Source File: PostRepository.java    From spring-reactive-sample with GNU General Public License v3.0 4 votes vote down vote up
@Query("SELECT * FROM posts WHERE title like $1")
Flux<Post> findByTitleContains(String name);
 
Example #15
Source File: PostRepository.java    From spring-reactive-sample with GNU General Public License v3.0 4 votes vote down vote up
@Query("SELECT * FROM posts WHERE title like $1")
Flux<Post> findByTitleContains(String name);
 
Example #16
Source File: PostRepository.java    From spring-reactive-sample with GNU General Public License v3.0 4 votes vote down vote up
@Query("SELECT * FROM posts WHERE title like $1")
Flux<Post> findByTitleContains(String name);
 
Example #17
Source File: PostRepository.java    From spring-reactive-sample with GNU General Public License v3.0 4 votes vote down vote up
@Query("SELECT * FROM posts WHERE title like @name")
Flux<Post> findByTitleContains(String name);
 
Example #18
Source File: ServiceInstanceStateCrudRepository.java    From spring-cloud-app-broker with Apache License 2.0 4 votes vote down vote up
@Query("delete from service_instance where service_instance_id = :service_instance_id")
Mono<Void> deleteByServiceInstanceId(@Param("service_instance_id") String serviceInstanceId);
 
Example #19
Source File: ServiceInstanceStateCrudRepository.java    From spring-cloud-app-broker with Apache License 2.0 4 votes vote down vote up
@Query("select * from service_instance where service_instance_id = :service_instance_id")
Mono<ServiceInstance> findByServiceInstanceId(@Param("service_instance_id") String serviceInstanceId);
 
Example #20
Source File: ServiceInstanceBindingStateCrudRepository.java    From spring-cloud-app-broker with Apache License 2.0 4 votes vote down vote up
@Query("delete from service_instance_binding " +
		"where service_instance_id = :service_instance_id " +
		"and binding_id = :binding_id")
Mono<Void> deleteByServiceInstanceIdAndBindingId(
		@Param("service_instance_id") String serviceInstanceId,
		@Param("binding_id") String bindingId);