Changeset 43a1688 for src/main/java/com/example/moviezone/repository/CustomerRatesFilmRepository.java

Timestamp:

02/06/23 15:13:02 (22 months ago)

Author:

DenicaKj <dkorvezir@…>

Branches:

master

Children:

f9cc555

Parents:

f8ef9bd

Message:

I CALLED A PROCEDURE FROM SPRING

File:

• src/main/java/com/example/moviezone/repository/CustomerRatesFilmRepository.java (modified) (1 diff)

src/main/java/com/example/moviezone/repository/CustomerRatesFilmRepository.java

@@ -4 +4 @@
 import com.example.moviezone.model.manytomany.CustomerRatesFilmId;
 import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.query.Procedure;
+import org.springframework.data.repository.query.Param;
 import org.springframework.stereotype.Repository;
 
 @Repository
 public interface CustomerRatesFilmRepository extends JpaRepository<CustomerRatesFilm, CustomerRatesFilmId> {
+@Procedure("project.avg_rating1")
+    double avg_rating(int id);
+
 }