Define JPA entities and repositories and H2 DB

1 files changed, 19 insertions, 0 deletions

diff --git a/src/main/java/com/stileeducation/markr/repository/TestResultRepository.java b/src/main/java/com/stileeducation/markr/repository/TestResultRepository.java
new file mode 100644
index 0000000..5810f8e
--- /dev/null
+++ b/src/main/java/com/stileeducation/markr/repository/TestResultRepository.java
@@ -0,0 +1,19 @@
+package com.stileeducation.markr.repository;
+
+import com.stileeducation.markr.entity.Student;
+import com.stileeducation.markr.entity.Test;
+import com.stileeducation.markr.entity.TestResult;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.Query;
+import org.springframework.data.repository.query.Param;
+
+import java.util.List;
+import java.util.Optional;
+
+public interface TestResultRepository extends JpaRepository<TestResult, Long> {
+
+  Optional<TestResult> findByStudentAndTest(Student student, Test test);
+
+  @Query("SELECT tr FROM TestResult tr WHERE tr.test.testId = :testId")
+  List<TestResult> findAllByTestId(@Param("testId") String testId);
+}