4 files changed, 77 insertions, 0 deletions
diff --git a/src/test/java/org/berzerkula/builddb/repositories/AppUserRepositoryTest.java b/src/test/java/org/berzerkula/builddb/repositories/AppUserRepositoryTest.java
new file mode 100644
index 0000000..58ca267
--- /dev/null
+++ b/src/test/java/org/berzerkula/builddb/repositories/AppUserRepositoryTest.java
@@ -0,0 +1,31 @@
+package org.berzerkula.builddb.repositories;
+
+import org.assertj.core.api.Assertions;
+import org.berzerkula.builddb.models.AppUser;
+import org.junit.jupiter.api.Test;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.boot.test.autoconfigure.jdbc.AutoConfigureTestDatabase;
+import org.springframework.boot.test.autoconfigure.orm.jpa.DataJpaTest;
+
+@DataJpaTest
+@AutoConfigureTestDatabase(replace = AutoConfigureTestDatabase.Replace.NONE)
+class AppUserRepositoryTest {
+
+    @Autowired AppUserRepository appUserRepository;
+
+    @Test
+    public void testCreateReadDelete() {
+
+        AppUser appUser = new AppUser("John", "Doe", "john.doe@test.com", "", "",
+                "password","client");
+
+        appUserRepository.save(appUser);
+
+        Iterable<AppUser> appUsers = appUserRepository.findAll();
+        Assertions.assertThat(appUsers).extracting(AppUser::getFirstName).containsOnly("John");
+
+        appUserRepository.deleteAll();
+        Assertions.assertThat(appUserRepository.findAll().isEmpty());
+    }
+
+}
+\ No newline at end of file
diff --git a/src/test/java/org/berzerkula/builddb/repositories/PkgRepositoryTest.java b/src/test/java/org/berzerkula/builddb/repositories/PkgRepositoryTest.java
new file mode 100644
index 0000000..0203fb0
--- /dev/null
+++ b/src/test/java/org/berzerkula/builddb/repositories/PkgRepositoryTest.java
@@ -0,0 +1,32 @@
+package org.berzerkula.builddb.repositories;
+
+import org.assertj.core.api.Assertions;
+import org.berzerkula.builddb.models.Pkg;
+import org.junit.jupiter.api.Test;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.boot.test.autoconfigure.jdbc.AutoConfigureTestDatabase;
+import org.springframework.boot.test.autoconfigure.orm.jpa.DataJpaTest;
+
+@DataJpaTest
+@AutoConfigureTestDatabase(replace = AutoConfigureTestDatabase.Replace.NONE)
+class PkgRepositoryTest {
+
+    @Autowired
+    PkgRepository pkgRepository;
+
+    @Test
+    public void testCreateReadDelete() {
+
+        Pkg pkg = new Pkg(123, "Test", "1.2.3", "",
+                "", "", "", "", "");
+
+        pkgRepository.save(pkg);
+
+        Iterable<Pkg> pkgs = pkgRepository.findAll();
+        Assertions.assertThat(pkgs).extracting(Pkg::getSequence).containsOnly(123);
+
+        pkgRepository.deleteAll();
+        Assertions.assertThat(pkgRepository.findAll().isEmpty());
+    }
+
+}
+\ No newline at end of file
diff --git a/src/test/java/org/berzerkula/builddb/repositories/TestH2AppUserRepository.java b/src/test/java/org/berzerkula/builddb/repositories/TestH2AppUserRepository.java
new file mode 100644
index 0000000..7473119
--- /dev/null
+++ b/src/test/java/org/berzerkula/builddb/repositories/TestH2AppUserRepository.java
@@ -0,0 +1,7 @@
+package org.berzerkula.builddb.repositories;
+
+import org.berzerkula.builddb.models.AppUser;
+import org.springframework.data.jpa.repository.JpaRepository;
+
+public interface TestH2AppUserRepository extends JpaRepository<AppUser, Integer> {
+}
diff --git a/src/test/java/org/berzerkula/builddb/repositories/TestH2PkgRepository.java b/src/test/java/org/berzerkula/builddb/repositories/TestH2PkgRepository.java
new file mode 100644
index 0000000..5916ff2
--- /dev/null
+++ b/src/test/java/org/berzerkula/builddb/repositories/TestH2PkgRepository.java
@@ -0,0 +1,7 @@
+package org.berzerkula.builddb.repositories;
+
+import org.berzerkula.builddb.models.Pkg;
+import org.springframework.data.jpa.repository.JpaRepository;
+
+public interface TestH2PkgRepository extends JpaRepository<Pkg, Integer> {
+}