From fa34f76ad8ebccb96012b45a4207532846cfa03f Mon Sep 17 00:00:00 2001
From: Szymon Szukalski <szymon@skas.io>
Date: Tue, 23 Jul 2024 23:19:45 +1000
Subject: Define JPA entities and repositories and H2 DB

---
 .../markr/repository/StudentRepository.java           | 10 ++++++++++
 .../markr/repository/TestRepository.java              | 10 ++++++++++
 .../markr/repository/TestResultRepository.java        | 19 +++++++++++++++++++
 3 files changed, 39 insertions(+)
 create mode 100644 src/main/java/com/stileeducation/markr/repository/StudentRepository.java
 create mode 100644 src/main/java/com/stileeducation/markr/repository/TestRepository.java
 create mode 100644 src/main/java/com/stileeducation/markr/repository/TestResultRepository.java

(limited to 'src/main/java/com/stileeducation/markr/repository')

diff --git a/src/main/java/com/stileeducation/markr/repository/StudentRepository.java b/src/main/java/com/stileeducation/markr/repository/StudentRepository.java
new file mode 100644
index 0000000..2d27644
--- /dev/null
+++ b/src/main/java/com/stileeducation/markr/repository/StudentRepository.java
@@ -0,0 +1,10 @@
+package com.stileeducation.markr.repository;
+
+import com.stileeducation.markr.entity.Student;
+import org.springframework.data.jpa.repository.JpaRepository;
+
+import java.util.Optional;
+
+public interface StudentRepository extends JpaRepository<Student, Long> {
+  Optional<Student> findByStudentNumber(String studentNumber);
+}
diff --git a/src/main/java/com/stileeducation/markr/repository/TestRepository.java b/src/main/java/com/stileeducation/markr/repository/TestRepository.java
new file mode 100644
index 0000000..f30ae0b
--- /dev/null
+++ b/src/main/java/com/stileeducation/markr/repository/TestRepository.java
@@ -0,0 +1,10 @@
+package com.stileeducation.markr.repository;
+
+import com.stileeducation.markr.entity.Test;
+import org.springframework.data.jpa.repository.JpaRepository;
+
+import java.util.Optional;
+
+public interface TestRepository extends JpaRepository<Test, Long> {
+  Optional<Test> findByTestId(String testId);
+}
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);
+}
-- 
cgit v1.2.3