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

@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

@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

@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

@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

@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

@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

@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

@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

@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

@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

@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