1 files changed, 17 insertions, 0 deletions
diff --git a/src/test/java/DNPM/DNPMHelperTest.java b/src/test/java/DNPM/DNPMHelperTest.java
index 188d97a..a66ed01 100644
--- a/src/test/java/DNPM/DNPMHelperTest.java
+++ b/src/test/java/DNPM/DNPMHelperTest.java
@@ -228,6 +228,23 @@ class DNPMHelperTest {
             verify(onkostarApi, times(1)).getSessionFactory();
         }
 
+        @Test
+        void testShouldCreateSqlQueryWithPatientId() {
+            var sessionFactory = mock(SessionFactory.class);
+            var session = mock(Session.class);
+            var query = mock(SQLQuery.class);
+
+            when(onkostarApi.getSessionFactory()).thenReturn(sessionFactory);
+            when(sessionFactory.getCurrentSession()).thenReturn(session);
+            when(session.createSQLQuery(anyString())).thenReturn(query);
+
+            dnpmHelper.getVerweise(Map.of("ProcedureId", 1, "PatientId", 2));
+
+            var argumentCaptor = ArgumentCaptor.forClass(String.class);
+            verify(session, times(1)).createSQLQuery(argumentCaptor.capture());
+            assertThat(argumentCaptor.getValue()).contains("WHERE patient_id = 2 AND geloescht = 0");
+        }
+
     }
 
 }